Master Excel PivotTables for Sales Data Insights
Created by Team Mammoth
·
49 lectures
01
Skill level
All levels
02
Sections
6
03
Lectures
49
04
Instructor
Team Mammoth
What's inside
This course includes.
✓
6
Sections
✓
Certificate of completion
Included
✓
Mobile and desktop access
Included
✓
AI learning assistance
Included
Unlock all courses with our Subscription Bundle! Get unlimited access to entire course library, books and assets. Learn more and subscribe today!
Course content
Curriculum & lectures.
+ 01. Introduction to the Course 5 lectures Preview
1.1 Introduction To The Course New
Locked
1.2 Why Should You Learn Pivottables New
Locked
1.3 Introduction Of The Instructor New
Locked
1.4 Course Requirements (what Software, Experience) New
Locked
01 Source Files
Locked
+ 02. PivotTables Fundamental Projects 8 lectures
2.1 What We Learn In This Section
Locked
2.2 What Is A Pivot Table
Locked
2.3 Pivottables Basics
Locked
2.4 Pivottable Compliant Data Sources
Locked
2.5 Build A Basic Pivottable
Locked
2.6 Section Summary
Locked
2.7 Challenge
Locked
02 Source Files
Locked
+ 03. Format PivotTables 8 lectures
3.1 What Will We Learn In This Section
Locked
3.2 Introduction To Formatting Pivottables
Locked
3.3 Build An Expense Report
Locked
3.4 Format The Expense Report Pivottable
Locked
3.5 Finalize The Expense Report Pivottable
Locked
3.6 Section Summary
Locked
3.7 Challenge
Locked
03 Source Files
Locked
+ 04. Excel Tables 9 lectures
4.1 What Will We Learn In This Section
Locked
4.2 What Are Excel Tables
Locked
4.3 Sales Report Analysis With Pivottables
Locked
4.4 Modify Source Data
Locked
4.5 Format The Sales Report
Locked
4.6 Complete The Sales Report Analysis
Locked
4.7 Section Summary
Locked
4.8 Challenge
Locked
04 Source Files
Locked
+ 05. Slice and Dice Your Data 8 lectures
5.1 What Will We Learn In This Section
Locked
5.2 What Is Slicing Data
Locked
5.3 Slicing Data Project
Locked
5.4 Data Slicer Tools
Locked
5.5 Link Slicers To Multiple Pivottables
Locked
5.6 Section Summary
Locked
5.7 Challenge
Locked
05 Source Files
Locked
+ 06. Connect to Databases 11 lectures
6.1 What Will We Learn In This Section
Locked
6.2 Connect To Databases
Locked
6.3 Import Data Sources
Locked
6.4 Use Pivottables To Refine Data
Locked
6.5 Consolidate Your Data Table
Locked
6.6 Format Large Data Sets
Locked
6.7 Slicer And Timeline In Large Data Sets
Locked
6.8 Refresh And Drill Down From Databases
Locked
6.9 Section Summary
Locked
6.10 Challenge
Locked
06 Source Files
Locked
Instructors
Taught by people who ship.
Team Mammoth
Instructor
Produced by a team of Mammoth Club industry experts. Over 14 years, Mammoth Club has built a global student community in 190+ countries with 9+ million courses sold, releasing over 1,000+ courses and 5,000+ hours of video content.
Ready to start building?
Join Mammoth Club and move through the course with structured lessons, previews, and certificates.