Microsoft Excel Advanced Pivot Tables

This course has been developed for people wanting to use more complex functionality of PivotTables within Microsoft Excel, including the PowerPivot add-in which allows you to analyse multiple files. Secure your spot in our course in Brisbane, Sydney or Melbourne by booking online today.

1 day course
5.00  (1 reviews)
What you will learn:
  • Create and modify existing PivotTables
  • Work with calculated fields and summary tools
  • Analyse multiple data sources with the PowerPivot add-in
  • Create simple dashboards
What you'll get:
Capped class sizes
Course prerequisites

Participants will need to have attended or be familiar with all the topics covered in the Microsoft Excel Intermediate course, including working with named ranges. A basic knowledge of how to create a simple PivotTable will be advantageous.

Do I need to bring my own laptop?

Participants are not required to bring their own laptops as our dedicated computer training labs are equipped with the programs and files you will need access to on your training day.

  • What is a PivotTable?
  • Prepare your data
  • Filtering data
  • Formatting values
  • PivotTable value field properties
  • Produce multiple PivotTables
  • Grouping date data
  • PivotTable format and display
  • Classic view
  • Create PivotCharts
  • Dynamic data ranges
  • Use tables as data sources
  • Dealing with zeros
  • Data drill down
  • Refresh PivotTable data
  • Change the data source
  • Move a PivotTable
  • Manually sort data
  • Group fields
  • Work with slicers
  • Work with timelines
  • Conditional Formatting
  • Manipulate display of totals
  • Advanced value field settings
  • Calculated fields
  • Calculated field limitations
  • Calculated items
  • GETPIVOTDATA function
  • Install PowerPivot
  • Activate PowerPivot
  • Understand PowerPivot
  • Import a text file into PowerPivot
  • Copy data into PowerPivot
  • Create relationships between data
  • Create a PivotTable from your data model
  • Collect and link data
  • Create PivotCharts
  • Create a slicer connected to multiple sources
  • Link slicer values to cells
    Reset options
- +

Need your training approved? Get a quote

Need your training approved? Get a quote
from 1 reviews
“I think it was all good.”
R, May 2020
“Good insight to Power BI”
Leigh, May 2020
“Learn't how to do many things I couldn't previously do”
Kevin, May 2020
“Little tricks and ways of using tools that I didn't know before”
Juanita, May 2020