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:
Post a Comment