Training & Events

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

REGISTER TODAY

Date: July 5, 2023

Time: 8:30am -12:00pm

Location: 1000 Waverley

Pricing

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.