Getting to know Pivot tables!

(Get stuck into this exercise after completing this weeks VBA warmup!)

Sometimes the Excel chart wizard just doesn't cut it...

When you want to do something more complicated with your spreadsheet data, such as displaying a graph of the number of people playing each intstrument, or a graph indicating the number of Fords and Holdens in your stockyard you've got two options:

1. Write some really complicated VBA macro that counts the items in your spreadsheet and then creates a graph of this new information, or
2. Get Pivot tables and Pivot charts to do all the work for you!

So we're going to go with option 2! Microsoft have a great Pivot table tutorial that includes a file to download and follow on with, that will help you to de-mystify this advanced feature of Excel.... and if you get stuck, Brigitte's become quite an expert on Pivot tables :)

Remember, creating your own Pivot report in your 2nd Assignment forms part of the Credit/Distinction criteria!

Note: In case you weren't here last week, I won't be sitting with you this week, but I will be in and out of the lab... so if you see me around and need help, please don't hesitate to ask!