Excel macro/ pivot table help
March 16, 2007 8:48 AM   Subscribe

Need help coming up with a basic training/ presentation in Excel macros and pivot tables for my boss and his second in command! Can someone recommend a book- well written, concise? I use Excel a lot, had advanced training (paid for by my boss) , but I don't use macros or pivot table functions because there has been no need in my line of duty......

It has been almost a year since I had the training and I have to come up with something fast, plus I am burdened with several other competing demands....

Any pointers much appreciated....
posted by mistsandrain to Computers & Internet (6 answers total) 7 users marked this as a favorite
No book recommendations, I'm afraid - I'm purely self taught... but there's one website (and the community there) that has helped immensely: Mr. Excel - check out the message board, and search through the questions (and answers) to pretty much everything you need.
posted by Chunder at 9:15 AM on March 16, 2007

I have the , it also comes with a CD in the back. I have found this book to be an great tool and I use it several times a week (that is, when it is at my desk, people always borrow iti, and bring it back after they have gotten their own)...
posted by Jenny is Crafty at 10:25 AM on March 16, 2007


OOPS, no link above. Sorry
posted by Jenny is Crafty at 10:26 AM on March 16, 2007

Juice Analytic's blog is my Excel Bible for cool advanced stuff. Taking a quick look, there's this article on pivot tables. They also have a big tutorial workbook you can download.
posted by dripdripdrop at 11:05 AM on March 16, 2007

The MS Excel website has a good tutorial on pivot tables.
posted by verisimilitude at 11:06 AM on March 16, 2007

2nd excel bible, it's excellent. Even more useful to me has been another book by the same author:

Excel Power Programming

Which is very good on how to programme with macros (vba)

Other good websites (apart from Mr Excel, referred to above) are




posted by Touchstone at 8:06 PM on March 16, 2007

« Older Crazy Cat Ladies   |   Creating a video games industry event in NYC Newer »
This thread is closed to new comments.