Excel: Analysing your spreadsheet data with pivot tables

  • Excel 2010 Icon course pack | Oxford only | v. 2010

As a data analysis tool it is hard to see past pivot tables. The pivot table tool allows you to create a summary structure from a list of data by dragging and dropping fields graphically.  Learn how easy it is to create multiple views, calculated fields and items just by dragging and dropping. Want to create a pivot chart from an external data source or filter data with Slicers? Easy.