You are here:

Microsoft Office Excel 2016: Data Analysis with PivotTables

Instructor Led, in person

Course Objectives:

Upon successful completion of this course, you will be able to use Excel 2016 advanced PivotTable functionality to analyze your raw data.

You will:

  • Prepare data for PivotTable reporting and create PivotTables from various data sources.
  • Analyze Data Using PivotTables.
  • Work with PivotCharts.


To ensure your success in this course, you should have experience working with Excel 2016 and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables. You can obtain this level of skill and knowledge by taking the following Logical Operations courses:

Microsoft® Office Excel® 2016: Part 1

Microsoft® Office Excel® 2016: Part 2

Lesson 1: Preparing Data and Creating PivotTables

Lesson 2: Analyzing Data Using PivotTables

Lesson 3: Working with PivotCharts

Course Fee: $229 plus 5% GST

*Contact us for discounts for groups of 4 or more people

Ask about Broadview Academy, a flexible training membership that enables you to choose how you manage your annual training plan.

Microsoft Excel 2013


July 20th, 2018

Time: 09:00 AM to 12:30 PM

Broadview Networks INC.
1-1530 Taylor Avenue
Winnipeg, MB R3N 1Y1

Who should attend:

Experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables.