Login
Excel Yourself/Pivot Tables from Start to Finish
Buy now

Pivot Tables from Start to Finish

Pivot Tables allow you to summarise large data tables into reports using just your mouse. No formulas required.

Pivot Tables are powerful, but they are not hard. If you have tried and failed with Pivot Tables in the past then now is the time to try again. The secret with Pivot Tables is getting the data right. Then Pivot Table reports are easy and quick to create.

This course is split between two videos. The Essentials gets you started and then the Advanced finishes building your skills to build even better reports.

There are two detailed pdf manuals plus over 2 hours of video. You also receive the before and after Excel files. There are two quizzes to test your knowledge.

Level: Intermediate
Duration: 2 hours
Price: AU$25 
Pivot Tables Course AU$25

  • $25

Pivot Tables from Start to Finish

Pivot tables allow you to summarise large data sets with a few clicks.
Buy now

Contents

Pivot Table Essentials

This session will cover the basics of pivot table creation as well as solving some common frustrations. Topics covered include
  • pivot cache what it is and why it is important
  • data rules that make creating pivot tables easier
  • format as table and why you need to use it
  • populating missing entries in the data – manually and with Power Query
  • the basics of creation
  • pivot charts
  • filtering with slicers
  • grouping
As always, I will share a few general tips along the way.
Excel PivotTable Essentials 2020.pdf
Excel_PivotTables_Essentials_2020.xlsx
Pivot Table Essentials Video
Excel_PivotTables_Essentials_2020_completed.xlsx
Pivot Table Essentials: Quiz

Advanced Pivot Tables

This session expands on the essential section.
Topics covered include
  • Calculated Fields – what they are and how and why to use them
  • Calculated Items – what they are and how and why to use them
  • Advanced filtering
  • Useful Report Layouts
  • Conditional Formatting
  • Adding relationships so you can report on two tables as once
  • Data normalisation and variance analysis example using Power Query
  • Two handy macros that can speed up pivot table creation
As always, I will share a few general tips along the way.
Advanced PivotTables 2020.xlsm
Excel Advanced PivotTables 2020.pdf
Advanced Excel Pivot Tables Video
Advanced PivotTables 2020 20200618 completed.xlsm
Advanced Pivot Tables: Quiz