Advanced PivotTables in Excel

4.0 Average Customer Rating

Teach you how to make the most of this powerful data analysis function

  • 51 Videos
  • 7 hours 31 minutes
  • 128 Happy Students

About the course

In this Advanced PivotTables in Excel course, we teach you how to make the most of this powerful data analysis function.

In this course, we give a PivotTable refresher before moving onto some of the advanced features of this tool. Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting are just a few of the subjects included in this PivotTable deep-dive.

This course is perfect for intermediate users of Excel who are comfortable using the PivotTable function. We don’t recommend this course for people brand new to Excel.

In this course, you will learn:

  • How to do a PivotTable (a quick refresher)
  • How to combine data from multiple worksheets for a PivotTable
  • Grouping, ungrouping and dealing with errors
  • How to format a PivotTable, including adjusting styles
  • How to use the Value Field Settings
  • Advanced Sorting and Filtering in PivotTables
  • How to use Slicers, Timelines on multiple tables
  • How to create a Calculated Field
  • All about GETPIVOTDATA
  • How to create a Pivot Chart and add sparklines and slicers
  • How to use 3D Maps from a PivotTable
  • How to update your data in a PivotTable and Pivot Chart
  • All about Conditional Formatting in a PivotTable
  • 51 Videos
  • 7 hours 31 minutes
  • 128 Happy Students

Courses Outline

Lesson 1: Introduction
Free
Introduction to Advanced PivotTables
3:49
PivotTables Recap
12:42
Examples
Lesson 2: Importing Data
Importing data from a text file
9:57
Importing data from Access
8:20
Exercise 01
4:46
Lesson 3: Preparing Data for Analysis
Cleaning Data
17:40
Tabular Data
16:05
Exercise 02
3:18
Lesson 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
Lesson 5: Formatting PivotTables
PivotTable Styles
11:39
Custom Number Formatting
16:25
Exercise 04
1:44
Lesson 6: Value Field Settings
Summarizing Values
11:25
Show Values As
9:12
Exercise 05
1:46
Lesson 7: Sorting and Filtering
Advanced Sorting
8:40
Advanced Filtering
14:04
Exercise 06
2:16
Lesson 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
Lesson 9: 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
Lesson 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
Lesson 11: Conditional Formatting
Highlighting Cell Rules
9:32
Graphical Conditional Formats
10:06
Conditional Formatting and Slicers
6:28
Exercise 10
2:26
Lesson 12: Dashboards
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
Lesson 13: Course Close
Course Close
0:37
Lesson 14: Quiz
Quiz
  • 51 Videos
  • 7 hours 31 minutes
  • 128 Happy Students