Excel for Mac 3: Pivot Tables Intro & Masterclass

Overview

This course covers one of the most useful, but scariest-sounding, functions in Microsoft Excel; PIVOT TABLES.

Syllabus

• Introduction to Pivot Tables
What is a Pivot Table?
Benefits of Using Pivot Tables
Overview of Pivot Table Components: Rows, Columns, Values, and Filters
• Preparing Your Data
Data Organization Best Practices
Understanding Data Types and Formatting
Cleaning and Structuring Data for Pivot Tables
• Creating Your First Pivot Table
Step-by-Step Guide to Inserting a Pivot Table
Navigating the Pivot Table Fields Pane
Setting Up Rows, Columns, and Values
• Customizing Pivot Tables
Sorting and Filtering Data Within Pivot Tables
Grouping Data: Dates, Numeric Ranges, and Categories
Using the Pivot Table Options Tab
• Advanced Pivot Table Features
Calculated Fields and Calculated Items
Creating Multiple Pivot Tables from One Data Source
Using Slicers and Timelines for Interactive Filtering
• Analyzing Data with Pivot Tables
Summation Functions: Sum, Average, Count, and More
Using Pivot Tables for Cross-Tabulation
Visualizing Data with Pivot Charts
• Troubleshooting and Best Practices
Common Pivot Table Errors and How to Fix Them
Tips for Optimizing Pivot Table Performance
Best Practices for Continual Learning and Mastery
• Conclusion and Course Wrap-Up
Review of Key Concepts
Additional Resources for Further Learning
Q&A Session and Feedback

Taught by

Phillip Burton • 800,000+ students so far and I Do Data Limited

Subjects

Data Science