Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Advanced PivotTables in Excel
Section 1: Introduction
Introduction to Advanced PivotTables (3:49)
Course Exercise Files
Course Support Files
PivotTables Recap (12:43)
Section 2: Importing Data
Importing data from a text file (9:57)
Importing data from Access (8:20)
Exercise 01 (4:46)
Section 3: Preparing Data for Analysis
Cleaning Data (17:40)
Tabular Data (16:05)
Exercise 02 (3:18)
Section 4: Creating and Manipulating PivotTables
Creating and Manipulating a PivotTable (12:27)
Combining Data from Multiple Worksheets (12:02)
Grouping and Ungrouping (11:01)
Report Layouts (10:53)
Formatting Error Values and Empty Cells (8:26)
Exercise 03 (1:35)
Section 5: Formatting PivotTables
PivotTable Styles (11:39)
Custom Number Formatting (16:25)
Exercise 04 (1:44)
Section 6: Value Field Settings
Summarizing Values (11:25)
Show Values As (9:12)
Exercise 05 (1:46)
Section 7: Sorting and Filtering
Advanced Sorting (8:40)
Advanced Filtering (14:04)
Exercise 06 (2:16)
Section 8: Interacting with PivotTables
Inserting and formatting Slicers (13:51)
Inserting and formatting Timelines (7:06)
Connecting Slicers to multiple PivotTables (8:10)
Using Slicers in Protected Workbooks (5:36)
Exercise 07 (2:20)
Calculations
Creating a Calculated Field (8:25)
Creating a Calculated Item (8:09)
Solve Order and List Formulas (10:38)
GETPIVOTDATA (9:25)
Exercise 08 (6:41)
Section 10: Pivot Charts
Creating a Pivot Chart (11:30)
Formatting a Pivot Chart - Part 1 (15:43)
Formatting a Pivot Chart - Part 2 (15:28)
Creating a Map Chart using Pivot Data (12:01)
Dynamic Chart Titles (13:50)
Include a Sparkline with your PivotTable (10:40)
Exercise 09 (7:45)
Conditional Formatting
Highlighting Cell Rules (9:32)
Graphical Conditional Formats (10:06)
Conditional Formatting and Slicers (6:28)
Exercise 10 (2:26)
Section 12: Dashboards
Creating an Interactive Dashboard - Part 1 (23:12)
Creating an Interactive Dashboard - Part 1 (13:54)
Updating Pivot Charts and PivotTables (4:24)
Exercise 11 (3:26)
Section 13: Course Close
Course Close (0:37)
Course Quiz and Certificate of Completion
Course Quiz
Exercise 09
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock