Excel Pivot Tables: The Power of PivotTables… Made Easy

Quickly calculate, summarize and analyze large data sets with Microsoft Excel Pivot Tables

Created by: Kyle Pew
Microsoft Certified Trainer - 1.8 Million+ Students

Created by: Office Newb
Software Trainer

What Will I Learn?

• Prepare Microsoft Excel data for PivotTable reporting
• Connect PivotTables to various data sources
• Create and manage PivotTable calculations
• Format PivotTables for presentations
• Update PivotTable source data
• Create and manage Excel Data Models to pull in data from multiple sources
• Create and manage data relationships
• Create Dashboard elements in a PivotTable

Requirements

• Familiar with working in Microsoft Excel

Target audience

• This course is intended for users familiar with working in Microsoft Excel but wish to master working with Excels PivotTable feature.
• Microsoft Excel users who want to become more efficient in summarizing and reporting on large datasets within Excel