Ultimate Pivot Table Mastery For Excel 2016

Shafiq Marediya

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
24 Videos (1h 25m)
    • 02 Overview of What Pivot Tables Are

      0:15
    • 03 What Is A Pivot Tables

      7:47
    • 04 Creating Your Own Pivot tables

      7:47
    • 05 Using Tables as a Data Source

      5:04
    • 06 Overview to Customizations and Calculations

      0:46
    • 07 Summarizing Data Using Average and Count

      4:07
    • 09 Formatting Pivot Tables

      2:57
    • 10 Creating percentages, difference, and running totals

      8:00
    • 11 Calculated Fields

      3:43
    • 12 recap

      0:34
    • 13 Overview of Sorting,Filtering, and using slicers

      0:50
    • 14 Sorting Pivot Tables

      3:02
    • 15 Filtering Pivot Tables

      5:10
    • 16 Slicers

      6:55
    • 17 recap

      0:18
    • 18 overview of data visualization

      0:42
    • 19 Sparklines

      3:34
    • 20 People Graph Infographics

      3:15
    • 21 Overview of Dashboards

      1:15
    • 22 Creating Summary Blocks

      4:58
    • 23 creating a line chart with pivot tables

      1:32
    • 24 creating a sparkline chart

      3:41
    • 25 Adding additional data to pivot line chart

      3:32
    • 26 adding slicers to dashboards

      4:50

About This Class

Become an advanced pivot table master!

This course covers one of the most used functions in Microsoft Excel. We look at how we can use pivot tables to analyze and summarize data in different ways to gain insight using a real world retail dataset. This course starts off at a very basic level and dives deep into all the capabilities of using a pivot table on a Mac computer. All the lessons are applicable to a windows machine as well.

In each easy to follow video, you will uncover new concepts, techniques, and other powerful features of excel. You will be able to follow along each step of the way, and at the end of each module, you will use another superstore data set to analyze customer payment data.

In this course, we will cover the following:

  • What is a pivot table
  • How to create your own pivot tables
  • Using Excel tables as a data source
  • Summarize data using average and count
  • Formatting pivot tables
  • Creating percentages, difference from, and running totals
  • Sorting and filtering pivot tables using the slicer tool
  • Creating interactive visualizations with sparklines
  • Building infographics with Excel's new plugin
  • Creating interactive dashboards backed with multiple pivot tables