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


EXCEL BIBLE

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

www.cpearson.com

and

www.ozgrid.com
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.


Tags

Share