About the ‘Pivot Tables in Excel Course’

Free Preview

The Pivot Tables in Excel course covers understanding and using Excel’s in built pivot tables to generate management reports.

Pivot Tables in Excel Course Details

  • 43 lessons
  • 90 video clips
  • 31 example exercises with detailed video solutions explaining exactly how you should have got to the answer.
  • Aimed at Intermediate and above Excel users, based on our free Excel skills assessments
  • Equivalent of attending a 1 day live course
  • Lifetime access
  • Start/ stop as required and repeat when necessary

Examples of what you will be able to do

After the lessons and exercises you will be able to:

Connect Pivots together
Interrogate multiple Pivot Tables and Pivot Charts at the same time


Turn data into reports (in seconds)


Calculations within the pivot
Enhance your data with % of, cumulative balances and difference from calculations


Normalise the data for use elsewhere


Create a dashboard type feel for your spreadsheets


Pull key information out of the Pivot, no matter where it moves to


Build your own formulas INSIDE the Pivot Table


Chart Pivot Tables
Identify trends by ‘playing’ with your reports


Groupings in Pivot Tables
Create custom groupings within the Pivot Table without changing the data


Generate multiple pivots
Generate multiple custom Pivot Tables out of a single pivot table


Conditional Format Pivot Tables
Visualise the information in a Pivot Table

and much, much more!

For the full list of contents go back to the Pivot Tables in Excel Course contents main page.

Buy the course now to get immediate access!

Back to: Pivot Tables in Excel > Introduction to Pivot Tables