Training & Events
Excel - Introduction to 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: Create a PivotChart; Manipulate PivotChart Data; Format a PivotChart
Course Instructor: Claudette Craig
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.
Date:
November 24th, 2021
Location:
1000 Waverley St, Winnipeg
Time:
1:00pm to 4:00pm
Food:
Snacks and coffee provided
Member Pricing:
$50
Student Pricing:
$40
Non-member Pricing:
$100
COVID-19 Protocols required by attendees:
- Practice social distancing with 6 ft separation
- All training attendees are required to wear masks
- Upon entry into the building, hands must be sanitized before signing in
- When gathering food, attendees are instructed to go one at a time to allow for social distancing
- Frequent hand-washing
- If you are feeling ill, please do not attend and let BAM know as soon as possible