The Complete Excel Pivot Table: Data Analysis and Reporting

Overview of Excel as a Data Analysis Tool

Key Excel Features for Analysts

What Is a Pivot Table and Why Use It?

Creating Your First Pivot Table (Step-by-Step)

Understanding Pivot Table Interface: Rows, Columns, Values, Filters

Best Practices for Structuring Raw Data

Cleaning Data Using Excel Tools

Removing Duplicates and Handling Blanks

Using Tables as Dynamic Pivot Data Sources

Formatting Data for Analysis

Sorting and Filtering Pivot Data

Grouping Data by Dates, Numbers, or Text

Value Summarization: Sum, Count, Average, etc.

Using the Field List and Pivot Table Settings

Adding and Using Calculated Fields

Creating Custom Calculations with % of Total, Difference, Running Total

Using Show Values As for Advanced Comparisons

Managing Grand Totals and Subtotals

Introduction to Pivot Charts

Creating Interactive Dashboards with Slicers and Timelines

Linking Pivot Tables to Charts

Formatting and Customizing Charts for Reports

Using Multiple Pivot Tables from the Same Data Source

Connecting Slicers Across Multiple Tables

Consolidating Multiple Data Ranges

Drill-Down and Exploring Underlying Data

Sales Analysis Dashboard

Financial Reporting with Pivot Tables

From basics to advanced techniques in Pivot Tables

Skills used by analysts, managers, and consultants worldwide

No prior experience with Pivot Tables required