25 – 5 Secrets to Understanding PivotTables – Jon Acampora

About this tutorial:

Video duration: 00:48:10
5 Secrets to Understanding PivotTables

1. PivotTables help us quickly summarise and analyse data
• PivotTables are a great alternative to building reports with complex formulas

2. The four areas of the PivotTable are not created equal

3. PivotTables filter and calculate the source data for each cell in the Values area
• The Rows and Columns areas create a unique list of items in the PivotTable

4. The most critical step to using a PivotTable is getting the source data in the correct layout
• The process of transforming the data into a tabular layout is called normalising or…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads