Microsoft Excel 2016 – Using PivotTables and PowerPivot

If you have been using Excel for some time now and have looked at PivotTables but don’t really know how to use them or take them further, then this one-day course covers features for experienced users of Microsoft Excel. It looks specifically at how to get the best from Excel’s PivotTables . It also looks at how to use PowerPivot, which is the add-in now included with Microsoft Excel.

You will learn how to

  • Create dashboards
  • Understand the difference the difference between an Excel Table and an Excel Range
  • Create row formulas in tables
  • Create PivotTables and PivotCharts
  • Work with slicers and timelines to filter information
  • Define table relationships
  • Create PivotTables connected to multiple tables
  • Work with Data Models
  • Use date tables for grouping pivot data
  • Invoke the RELATED and CALCULATE DAX functions
  • Create PivotTables hierarchies
  • Use Key Performance Indicators in PivotTables

Who would benefit from this Microsoft Excel 2016 course?

This course is designed for people who are looking to use PivotTables and PowerPivot to process large amounts of data into meaningful information for business intelligence and analysis. If you want to learn how to work with macros then the Automating Excel using Macros and VBA course would be more beneficial.

Pre-requisites

A good understanding of Microsoft Excel 2016 is required, or attendance on the Microsoft Excel Advanced User course.