Training & Events

Excel Pivot Tables

Learning Objectives

  • Prepare data for PivotTable reporting and create PivotTables from various data sources, including local and external
  • Analyze raw data by using PivotTables, Slicers and Timelines
  • Work with PivotCharts

Course Outline

  • Preparing Data and Creating PivotTables: Prepare Data;
  • Create a PivotTable from a Local Data Source;
  • Create a PivotTable from Multiple Local Data Sources;
  • Create a PivotTable from an External Data Source
  • Analyzing Data by Using PivotTables: 
  • Summarize PivotTable Data; Organize PivotTable Data;
  • Filter PivotTable Data;
  • Format a PivotTable;
  • Refresh and Change PivotTable Data
    Filtering Lists: C
  • reate a PivotChart;
  • Manipulate PivotChart Data;
  • Format a PivotChart


Date: July 5, 2023

Time: 8:30am -12:00pm

Location: 1000 Waverley


Member: $75.00 plus gst| Non-Member: $125.00 plus gst

Course Instructor

Claudette Craig is the owner of CD Consulting. She has more than 25 years of experience coordinating and facilitating courses, with a primary focus on the design and instruction of various Microsoft products. She has her Microsoft Office Specialist (MOS) certification at the Master Level. Her background includes working with a wide client-base in all business sectors, developing and implementing database applications and designing user reference materials and online training videos.