Module 1 Before We Dive In
Unit 1 Course Materials & Outline
Unit 2 Downloading the Course Resources
Unit 3 Resource Files and Datasets
Unit 4 Getting to Know the IMDb Movie Database
Unit 5 Setting Expectations
Module 2 – PivotTable 101
Unit 1 Why PivotTables?
Unit 2 Structuring Your Source Data
Unit 3 Inserting Your First PivotTable
Unit 4 Navigating the Field List
Unit 5 PivotTable Options: "Analyze" & "Design"
Unit 6 Selecting, Clearing, Moving & Copying Pivots
Unit 7 Refreshing & Updating Pivots
Unit 8 PRO TIP: Dealing with Growing Source Data
Unit 9 How PivotTables ACTUALLY Work
Module 3 PivotTable Formatting
Unit 1 Number Formatting
Unit 2 PRO TIP: Automatically Formatting Empty Cells
Unit 3 Table Layouts & Styles
Unit 4 PRO TIP: Using Tabular Tables to Create New Source Data
Unit 5 Customizing Headers & Labels
Unit 6 Conditional Formatting
Unit 7 PRO TIP: Data Bars with Invisible Text
Module 4 Sorting, Filtering & Grouping
Unit 1 Sorting Options
Unit 2 PRO TIP: Why is my Alphabetical Sorting Wrong?
Unit 3 Label Filters & Manual Selections
Unit 4 PRO TIP: Using Label Filters with Wildcards
Unit 5 Value Filters
Unit 6 PRO TIP: Enabling Multiple Filters
Unit 7 Grouping Data
Unit 8 PRO TIP: Automatic Date Grouping
Unit 9 Using Slicers & Timelines to Filter Data
Unit 10 Breaking Out Report Filter Pages
Module 5 Calculated Values, Fields & Items
Unit 1 "Summarize Values By" Options
Unit 2 PRO TIP: Avoiding the "Count Of" Trap
Unit 3 "Show Values As" Calculations
Unit 4 Show Values As: % of Column/Row
Unit 5 Show Values As: % of Parent
Unit 6 Show Values As: Difference From
Unit 7 Show Values As: Running Total
Unit 8 Show Values As: Rank
Unit 9 Show Values As: Index
Unit 10 Inserting Calculated Fields
Unit 11 Calculations in Pivots vs. Raw Data
Unit 12 PRO TIP: Calculating Using Counts
Unit 13 PRO TIP: Calculating Using Counts (part 2)
Unit 14 Inserting a Calculated Item (not recommended!)
Unit 15 The Solve Order & List Formulas Tools
Module 6 PivotCharts
Unit 1 Intro to PivotCharts
Unit 2 PivotChart Demo: Column Chart
Unit 3 PivotChart Demo: Pie/Donut Chart
Unit 4 PivotChart Demo: Clustered Bar Chart
Unit 5 PRO TIP: Prevent Charts from Resizing with Cells
Unit 6 Changing Chart Types on the Fly
Unit 7 PivotChart Demo: Stacked Area Chart
Unit 8 PivotChart Layouts & Styles
Unit 9 Moving PivotCharts to New Sheets
Unit 10 Applying Slicers & Timelines to Multiple Charts
Unit 11 Building a Dynamic Dashboard
Module 7 PivotTable Case Studies
Unit 1 Setting Expectations
Unit 2 U.S. Voters (2012)
Unit 3 San Francisco Salaries
Unit 4 Shark Attack Records
Unit 5 Stock Market Data
Unit 6 Baseball Team Stats
Unit 7 San Diego Burrito Ratings
Unit 8 Daily Weather Conditions
Unit 9 Spartan Race Facebook Posts
Module 8 Wrapping Up
Unit 1 Resources & Next Steps
Powered By WP Courseware

Data Analysis with Excel Pivot Tables


Course Description

Pivot Tables are an absolutely essential tool for anyone working with data in Excel.

Pivots allow you to quickly explore and analyze raw data, revealing powerful insights and trends otherwise buried in the noise. In other words, they give you answers. Whether you're exploring product sales, analyzing which marketing tactics drove the strongest conversion rates, or wondering how Boston condo prices have trended over the past 15 years, Excel Pivot Tables provide fast, accurate and intuitive solutions to even the most complicated questions.

This course gives you a deep, 100% comprehensive understanding of Excel Pivot Tables and Pivot Charts. I'll show you when, why, and how to use Pivot Tables, introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and exercises every step of the way.

We'll start by covering everything you need to know to get up and running with Excel Pivot Tables, including:

  • Raw data structure
  • Table layouts & styles
  • Design & formatting options
  • Sorting, filtering, & grouping tools
  • Calculated fields, items & values
  • Pivot Charts, slicers & timelines
  • Interactive dashboards

We'll then explore and analyze datasets from a number of real-world case studies, including:

  • San Diego burrito ratings
  • Shark attack records from 1900-2016
  • Facebook Post data from Spartan Race
  • Major League Baseball team statistics
  • San Francisco employee salaries
  • Daily stock market data
  • IMDb movie ratings
    And more…

Whether you're looking for a quick primer, trying to diversify your Excel skill set, or hoping to step up your analytics game in a major way, you've come to the right place. In today's increasingly data-driven world, analytics skills are in short supply and incredibly high demand, and those with the ability to transform data into insight are leading the charge. I'm here to help you become an analytics ROCK STAR.