Advanced PivotTables in Excel

Lesson 1, Step 1: Introduction to Advanced PivotTables

Courses Outline

Free
Introduction to Advanced PivotTables
3:49
PivotTables Recap
12:42
Examples
Importing data from a text file
9:57
Importing data from Access
8:20
Exercise 01
4:46
Cleaning Data
17:40
Tabular Data
16:05
Exercise 02
3:18
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
PivotTable Styles
11:39
Custom Number Formatting
16:25
Exercise 04
1:44
Summarizing Values
11:25
Show Values As
9:12
Exercise 05
1:46
Advanced Sorting
8:40
Advanced Filtering
14:04
Exercise 06
2:16
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
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
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
Highlighting Cell Rules
9:32
Graphical Conditional Formats
10:06
Conditional Formatting and Slicers
6:28
Exercise 10
2:26
Creating an Interactive Dashboard - Part 1
23:12
Creating an Interactive Dashboard - Part 2
13:55
Updating Pivot Charts and PivotTables
4:24
Exercise 11
3:26
Course Close
0:37
Quiz

Advanced PivotTables in Excel

Lesson 1, Step 1: Introduction to Advanced PivotTables

Welcome message and introduction to the course.