Pivot Tables- covered in Intermediate course

Below a listing of what you would have learnt in the Intermediate course which feeds into this Advanced course.

Please check that you are comfortable with these items.

  • Required data format for Pivot tables
  • Create a Pivot Table- Step by Step
  • Inserting Values into a Pivot Table
  • Enhancing the values e.g. percentage of another column
  • Show the details of a number in the Pivot Table
  • Laying out the Pivot Report in completely separate columns
  • Working with the rows in a Pivot Table- dropdown
  • Working with the rows in a Pivot Table- field settings
  • Normalize Pivot Reports to use elsewhere as a copy paste
  • Working with the Columns in a Pivot Table
  • Working with the Filter in a Pivot Table
  • Automatically duplicate your Pivot Tables with different selections
  • Slicers in a Pivot Table
  • Control all Pivot Tables and Charts at once
  • Timelines in a Pivot Table
  • Grouping Dates into days, months, quarters and years in a Pivot Table
  • Grouping Dates into weeks in a Pivot Table
  • Grouping Text in a Pivot Table
  • Grouping Numbers in a Pivot Table
  • Pivot Charts in Excel
  • Problems with grouping in Pivot Tables
     
Back to: Advanced Excel Course > Pivot Tables