Brushing up on my skills [Book recommendations]

Horus

Hello everyone,


I want to improve, learn and stay competitive in my skills. So I come here to H/A for recommendations. I would have gone to Graphic Designer forums but ..... they are all Mac Fan boys who annoy me (coming from a mac user).

Anyway following areas I am looking for book recommendations and magazines

Color Theory: not on painting but understanding of how colors work with each other. Amazon has long list of books but I would like to get a reputable author who knows their stuff.

Video Editing: I have After Effects and Premier CS3 and I hardly touch them. I want to get a foundation in video production. If anyone remembers After Effects book that

Good excel book on how to setup elaborate spreadsheets... like adding complex formulas etc.

I got a bunch of borders coupons I want to take advantage of so any help is appreciated.

thanks