You might also be interested in
Replies (6)
Please login or register to join the discussion.
Formulas in Excel 2007
Jean, thanks for the kind comment; I hope to be updating this tutorial to Excel 2007 soon.
At the top of your screen there is a bar called Pivot Table Tools. Click on it. Then choose Formulas in the Tools section at the right (next to Pivot Chart). David
brilliant tutorial
Tutorial - sales analysis with excel pivot tables
although I frequently use excel I haven't used pivot tables before. I thought this tutorial was brilliant and I managed to translate most of it into excel 2007 - but I simply couldn't get to grips with paragraph 17 - using formulas - can anyone translate that into excel 2007 for me
Useful - but misses the first step
Having being confused as to how to create pivot tables in practice I discovered on another site that they work only when the data is in lists or tables, not in report format.
This made your tutorials crystal clear from then on.
Although I may be the only one confused in this way, I think specifically stating the requirement for having the data in the right format at the beginning of the tutorial would be useful.
For 2007?
Hi David,
Just to check, do you have any time frame by which you would be able to help with Excel 2007?
Sales Analysis tutorial for Excel 2007
Re the Excel 2007 version of this tutorial, I've moved into the video age, so there's now a video of this tutorial for Excel 2007 on Youtube. Link here:
http://www.youtube.com/watch?v=PrfrVxAixH8
or just go into Youtube and search on MrDatamart (I've got 4 or 5 up altogether including a couple on the new breed of Excel-based report writers which do all the things you can't do with pivot tables).
Thanks
You were right: at the beginning, the best way to learn is just doing it, and this tutorials are excellent tools. Besides learning Pivot Tables one gets involved in logical way of accounting thinking. Pure and simple applied knowledge.