Pivot Tables

Current Status
Not Enrolled
Price
£30
Get Started
Pivot Tables Course, advert image

Do Pivot Tables look a bit too hard? Not sure you can master them? Yes, you can!
This 3-lesson short course takes you from zero to hero on Pivot Tables.

Lesson 1:

  • What Pivot Tables actually do
  • Creating your first Pivot Table (yay!)
  • Slicing-and-dicing the data
  • Showing different functions of values
  • Style and formatting basics

Lesson 2:

  • Multiple layer slicing-and-dicing
  • Multiple values
  • Useful Pivot Table options
  • Filtering

Lesson 3:

  • Drilldown
  • Groups
  • Calculated Fields
  • Report Filter Pages
  • Slicers and Timelines
  • Pivot Charts
As always, each lesson has a practical exercise so that can have a go at the techniques learnt in the lesson.

Excel Version
You will need Excel for Office365 to take this course.