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.


November 24th, 2021


1000 Waverley St, Winnipeg


1:00pm to 4:00pm


Snacks and coffee provided

Member Pricing:


Student Pricing:


Non-member Pricing:



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
Photographs and/or videos could possibly be taken at this event. By taking part in this event, you grant Bioscience Association Manitoba (BAM) full rights to use the images resulting from the photography/filming of this event, and any reproductions or adaptations of the images for marketing, publicity or other purposes to help achieve our vision (to cultivate a vital bioscience community that drives economic growth for Manitoba.) This might include (but is not limited to) the right to use them in printed format, digital publications, social media, marketing materials and press releases.
If you do not wish to be photographed/filmed, please contact us at

Excel - Introduction to Pivot Tables - Nov 24, 2021

  • $100.00 (Members pay $50.00)