Video: The Great Pivot Table Treasure Hunt
For the business user, Pivot Tables are one of the most powerful tools in Excel's data analysis armoury.
With just a few clicks you can quickly and easily summarise and analyse large amounts of raw data and answer questions like "What is the revenue for each product by region?" and "How much revenue has each customer generated per month?"
In this 1 hour training session, you'll learn how to optimise your raw data , how to create and manipulate Pivot Tables, use Slicers and Timelines to interactively filter your data and graphically represent the data in a Pivot Table. The examples use Excel 2013 for Windows and Excel 2011 for Mac