Microsoft Excel 2016 Level 4.2 Analyzing Data by Using Pivot Tables

  • E-Learning

This course takes a deeper look at how to analyze data by using PivotTables in Excel 2016. You must be able to organize your data, so it is easy to understand and interpret. You can also filter the data found in a PivotTable or change the format of the PivotTable itself to ensure you have provided enough functionality without cluttering the overall experience. 

This course shows you how to accomplish these tasks. A PivotTable is a powerful feature in Excel. It allows you to extract specific pieces of information from a larger set of data, in short, it allows you to focus on what you determine to be the important parts of that data. Utilize the information presented here and understand how to better sort, analyze, and present your data through PivotTables.

It is best to complete this course in one sitting, if you do need to stop the training midway, please enable cookies for our website and allow popups (turn off your popup blocker) so that you don't lose progress for the course.


Topics Covered

  • Summarize PivotTable Data
  • Organize PivotTable Data
  • Filter PivotTable Data
  • Format a PivotTable
  • Refresh and Change PivotTable Data


0.48 hours


Best Practices


As Needed

Who Should Attend:

Excel 2016 Users