Monday, February 25, 2008

Excel: get a high level summary with pivot tables

If at work, you're using lots of data in excel, and need quick summaries, a pivot table is the way to go. You can use it to filter down your data to a high-level summary, using tables and charts.

However, it can be a bit tricky to learn.

But Microsoft has made its own nifty video tutorial on how to use pivot tables. I found it quite useful.

Oh and a site benefit - people will be impressed when you tell them you know how to use Excel's pivot tables! (esp. your boss)

No comments: