Menu
Log in
Forgot password


Log in
Contact Us

ALGIM Training Session: Excel Lists and PivotTables

  • 1 Feb 2024
  • 2:00 PM - 4:00 PM

Registration

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.

This online session will cover;

Lists 

  • 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

PivotTables
  • 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


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. If you have any concerns, please contact events.coordinator@algim.org.nz

Powered by Wild Apricot Membership Software