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.