Introduction to PivotTables in Excel

This is the agenda for Table of Contents
Table of Contents


PivotTables basics

• What We Will Cover
• PivotTables Basics
• PivotTable Compliant Data Sources
• Creating a Basic PivotTable
• Creating a Basic PivotTable - Part 2

Formatting PivotTables

• Formatting PivotTables
• Creating an Expense Report
• Formatting the Expense Report PivotTable
• Finalizing the Expense Report PivotTable

Excel tables

• Excel Tables
• Sales Report Analysis with PivotTables
• Modifying Source Data
• Formatting the Sales Report
• Completing the Sales Report Analysis

Slicing and dicing your data

• Intro to Slicing Data
• Slicing Data
• Data Slicer Tools
• Linking Slicers to Multiple PivotTables

Connecting to databases

• Connecting to Databases
• Importing Data Sources
• Using PivotTables to Refine Data
• Consolidating Your Data Table
• Formatting Large Data Sets
• Slicing Large Data Sets
• Refreshing and Drilling Down from Databases


• In Review
• Conclusion
• Final Quiz


Jointly presented by CPA Canada and CPA Ontario, The ONE is the must-attend, multi-track event of the year, designed for all CPAs who want to be at the top of their game.

Our Firm Directory allows you to search for Canadian CPA firms using our interactive map as well as other criteria.

You’re in the eye of the storm amid a swirl of slips, forms and receipts. Chart your way through tax-time turbulence with these updates and resources.