Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Master Excel PivotTables for Sales Data Insights
Introduction to the Course
Source Files
Welcome! (3:43)
Why Learn Pivot Tables (3:17)
Meet Your Instructor (3:17)
What You'll Need (6:10)
PivotTables Fundamental Projects
Source Files
1. What We Learn In This Section (1:21)
2. What Is A Pivot Table (2:01)
3. Pivottables Basics (2:52)
4. Pivottable Compliant Data Sources (2:12)
5. Build A Basic Pivottable (4:17)
6. Section Summary (2:13)
7. Challenge (1:23)
Format PivotTables
Source Files
1. What Will We Learn In This Section (1:01)
2. Introduction To Formatting Pivottables (3:30)
3. Build An Expense Report (6:03)
4. Format The Expense Report Pivottable (4:18)
5. Finalize The Expense Report Pivottable (5:41)
6. Section Summary (2:12)
7. Challenge (1:04)
Excel Tables
Source Files
1. What Will We Learn In This Section (8:46)
2. What Are Excel Tables (7:23)
3. Sales Report Analysis With Pivottables (9:22)
4. Modify Source Data (3:58)
5. Format The Sales Report (8:38)
6. Complete The Sales Report Analysis (3:38)
7. Section Summary (3:03)
8. Challenge (1:47)
Slice and Dice Your Data
Source Files
1. What Will We Learn In This Section (1:23)
2. What Is Slicing Data (3:41)
3. Slicing Data Project (5:40)
4. Data Slicer Tools (14:09)
5. Link Slicers To Multiple Pivottables (8:03)
6. Section Summary (2:32)
7. Challenge (2:04)
Connect to Databases
Source Files
1. What Will We Learn In This Section (2:30)
2. Connect To Databases (2:06)
3. Import Data Sources (3:58)
4. Use Pivottables To Refine Data (4:41)
5. Consolidate Your Data Table (3:17)
6. Format Large Data Sets (4:51)
7. Slicer And Timeline In Large Data Sets (4:36)
8. Refresh And Drill Down From Databases (4:46)
9. Section Summary (4:01)
10. Challenge (2:02)
2. What Is Slicing Data
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock