Advanced PivotTables in Excel

In this Advanced PivotTables in Excel course, we teach you how to make the most of this powerful data analysis function. PivotTables are ideal if you are looking to perform data analysis tasks quickly and efficiently in Excel.

• Introduction 18:31

  • 1: Introduction to Advanced Pivot Tables Preview 03:49
  • 2: Pivot Tables Recap Preview 12:42
  • 3: IMPORTANT: PLEASE READ 01:00
  • 4: Section 1: Introduction 01:00

• Importing Data 25:04

  • 5: Importing Data from a text file Preview 09:58
  • 6: Importing Data from access 08:20
  • 7: Exercise 1 04:46
  • 8: Section 2: Importing Data 02:00

• Preparing Data for Analysis 39:04

  • 9: Cleaning Data 17:40
  • 10: Tabular Data 16:06
  • 11: Exercise 2 03:18
  • 12: Section 3: Preparing Data for Analysis 02:00

• Creating and Manipulating PivotTables 58:26

  • 13: Creating a PivotTable 12:27
  • 14: Combining Data from Multiple Worksheets 12:02
  • 15: Grouping and Ungrouping 11:02
  • 16: Report Layouts 10:53
  • 17: Formatting Error Values 08:27
  • 18: Exercise 3 01:35
  • 19: Section 4: Creating and Manipulating PivotTables 02:00

• Formatting PivotTables 31:48

  • 20: PivotTable Styles 11:39
  • 21: Custom Number Formatting 16:25
  • 22: Exercise 4 01:44
  • 23: Section 5: Formatting PivotTables 02:00

• Value Field Settings 24:23

  • 24: Summarizing Values 11:25
  • 25: Show Values As 09:12
  • 26: Exercise 5 01:46
  • 27: Section 6: Value Field Settings 02:00

• Sorting and Filtering 26:01

  • 28: Advanced Sorting 08:40
  • 29: Advanced Filtering 14:04
  • 30: Exercise 6 02:17
  • 31: Section 7: Sorting and Filtering 01:00

• Interacting with PivotTables 38:05

  • 32: Inserting and Formatting Slicers 13:52
  • 33: Inserting and Formatting Timelines 07:06
  • 34: Connecting Slicers 08:10
  • 35: Locking Workbooks but not Slicers 05:36
  • 36: Exercise 7 02:21
  • 37: Section 8: Interacting with PivotTables 01:00

• Calculations 46:20

  • 38: Creating a Calculated Field 08:25
  • 39: Creating a Calculated Item 08:10
  • 40: Solve Order 10:38
  • 41: Get Pivot Data 09:26
  • 42: Exercise 8 06:41
  • 43: Section 9: Calculations 03:00

• Pivot Charts 1:29:01

  • 44: Creating a Pivot Chart 11:31
  • 45: Formatting a Pivot Chart 15:43
  • 46: Formatting a Pivot Chart Part 2 15:29
  • 47: Map Charts 12:02
  • 48: Dynamic Chart Titles 13:50
  • 49: Sparklines 10:40
  • 50: Exercise 9 07:46
  • 51: Section 10: Pivot Charts 02:00

• Conditional Formatting 30:35

  • 52: Highlighting Cell Rules 09:33
  • 53: Graphical Conditional Formats 10:07
  • 54: Control Conditional Formatting with Slicers 06:29
  • 55: Exercise 10 02:26
  • 56: Section 11: Conditional Formatting 02:00

• Dashboards 47:57

  • 57: Creating an Interactive Dashboard Part 1 23:12
  • 58: Creating an Interactive Dashboard Part 2 13:55
  • 59: Updating data 04:24
  • 60: Exercise 11 03:26
  • 61: Section 12: Dashboards 03:00

• Course Close 00:38

  • 62: Course Close 00:38

In this course, we give a PivotTable refresher before moving onto some of the advanced features of this tool including Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting.

This course is aimed at intermediate users of Excel who are comfortable using the PivotTable function. We don’t recommend this course for people brand new to Excel. If you are new to Excel, try out one of the Beginner Excel courses also available on Stream Skill.

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
• How to create a basic macro to refresh PivotTable data

Course Format

This is a video-led course. This course includes practice exercises so you can practice as you learn. This course is suitable for Windows users and was recorded in Excel 365 but is suitable for 2013, 2016, and 365 Excel users.

Course Certificate Included

This course includes an optional online quiz that will generate a course certificate upon completion.

Why Trust Us?

Stream Skill is part of the Simon Sez IT family and has been in business 10+ years and taught over 400,000 students in that time. We’ve created over 90 software training courses, 5,000+ video tutorials, and we’ve helped thousands of people around the world learn how to use Microsoft Office.

We’ve now created hundreds of hours of Microsoft Excel courses and continue to help people understand how to get the most from MS Excel.

Data Analysts, Business Analysts, Accountants, Financial Services Employees

Currently there are no Q&As for this course. Be the first to ask a question.

Reed courses certificate of completion

Digital certificate - Included