Log in


Microsoft Training: Excel Lists and PivotTables

  • 16 Jul 2024
  • 2:00 PM - 4:00 PM (AEST)
  • Microsoft Teams


Registration is closed

Grasp the critical rules and useful tools required to manage your lists and Excel. Then learn to transfer your data collection into data analysis by converting your lists into PivotTables and PivotCharts.

Course Outline:


  • What is a List?
  • Lists Creation Rules
  • Sort Data in Lists
  • Filter Data in Lists
  • Add Subtotals to Data in Lists
  • Add Data Validation Criteria
  • Apply Conditional Formatting
  • Why and when to use the Format Table feature
  • How and when to unFormat as Table

  • What is a PivotTable and when to use them
  • Create a PivotTable
  • Filter a PivotTable
  • Modify a PivotTable
  • Refresh a PivotTable
  • Change a PivotTable’s Data Source
  • PivotTable Format Options
  • Insert and Format PivotTable Slicers
  • Link Slicers to Multiple PivotTables
  • Create a PivotChart

What you need to know:

  • Microsoft Teams will be used for this training session. You will receive a Teams Meeting link prior to the training date. 
  • We recommend you log in ten minutes before the training session starts to ensure there are no tech issues.
  • Please note the times are in Australian Eastern Standard Time (AEST) which is two hours behind New Zealand Standard Time (NZST).

For any questions, please contact

Powered by Wild Apricot Membership Software