About the ‘Pivot Tables in Excel Course’

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