Microsoft Excel: Data Analysis with Excel Pivot Tables

126 Enrolled
6 Hours
$11.99$175.00
You save 93% -

82 Lessons (6h)

  • Getting Started
    Course Structure & Outline3:26
    Getting to Know the IMDb Movie Database2:21
    Setting Expectations1:14
  • PivotTable 101
    Why PivotTables?4:10
    Structuring the Source Data2:00
    Inserting Your First PivotTable3:13
    Navigating the Field List7:43
    Analyze & Design Options1:33
    Selecting, Clearing, Moving & Copying Pivots5:14
    Refreshing & Updating Pivots7:30
    PRO TIP: Dealing with Growing Source Data6:49
    How PivotTables ACTUALLY Work3:39
    QUIZ: PivotTable 101
    HOMEWORK: PivotTable 101
  • PivotTable Formatting
    Number Formatting2:12
    PRO TIP: Formatting Empty Cells1:41
    Table Layouts & Styles5:30
    PRO TIP: Using Tabular Layouts to Create New Tables2:20
    Customizing Headers & Labels1:16
    Adding Conditional Formats6:51
    PRO TIP: Data Bars with Invisible Text2:13
    QUIZ: PivotTable Formatting
    HOMEWORK: PivotTable Formatting
  • Sorting, Filtering & Grouping
    Basic Sorting Options5:01
    PRO TIP: Incorrect Alphabetical Sorting2:01
    Label Filters & Manual Selections8:15
    PRO TIP: Label Filters with Wildcards3:15
    Value Filters3:10
    PRO TIP: Enabling Multiple Filters2:42
    Grouping Data3:23
    Automatic Date Grouping4:25
    Filtering with Slicers & Timelines4:51
    Breaking Out Report Filter Pages4:13
    QUIZ: Sorting, Filtering & Grouping
    HOMEWORK: Sorting, Filtering & Grouping
  • Calculated Values & Fields
    Summarizing Values4:45
    PRO TIP: Avoiding the "Count Of" Trap3:49
    "Show Values As" Calculations3:35
    Show Values As: % of Column/Row3:47
    Show Values As: % of Parent3:02
    Show Values As: Difference From4:41
    Show Values As: Running Total2:44
    Show Values As: Rank2:36
    Show Values As: Index8:06
    Inserting Calculated Fields6:30
    Calculations in Pivots vs. Raw Data4:32
    Calculating Using Counts (Part 1)7:20
    Calculating Using Counts (Part 2)4:19
    Calculated Items (NOT RECOMMENDED)6:11
    Solve Order & List Formula Tools4:54
    QUIZ: Calculated Values & Fields
    HOMEWORK: Calculated Values & Fields
  • PivotCharts
    Intro to PivotCharts2:26
    DEMO: Column Chart4:13
    DEMO: Pie & Donut Charts5:46
    DEMO: Clustered Bar Chart3:25
    PRO TIP: Prevent Charts from Resizing with Cells4:45
    Changing Chart Types on the Fly3:18
    DEMO: Stacked Area Chart5:46
    PivotChart Layouts & Styles4:03
    Moving PivotCharts to New Sheets2:09
    Applying Slicers & Timelines to Multiple Charts5:01
    DEMO: Building a Dynamic Dashboard13:22
    QUIZ: PivotCharts
    HOMEWORK: PivotCharts
  • PivotTable Case Studies
    Setting Expectations1:45
    U.S. Voters (2012)10:33
    HOMEWORK: U.S. Voters (2012)
    San Francisco Salaries13:06
    HOMEWORK: San Francisco Salaries
    Shark Attack Records10:31
    HOMEWORK: Shark Attack Records
    Stock Market Data12:25
    HOMEWORK: Stock Market Data
    Baseball Team Statistics14:16
    HOMEWORK: Baseball Team Statistics
    San Diego Burrito Ratings16:40
    HOMEWORK: San Diego Burrito Ratings
    Daily Weather Conditions12:41
    HOMEWORK: Daily Weather Conditions
    Spartan Race Facebook Posts14:37
    HOMEWORK: Spartan Race Facebook Posts
  • Wrapping Up
    Resources & Next Steps2:27

Master Excel Pivot Tables & Pivot charts with Hands-On Demos

EM
Excel Maven

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization.

He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

Description

Pivot Tables are an essential tool for anyone who works with data in Excel. Pivots allow you to explore and analyze raw data quickly, revealing powerful insights and trends otherwise buried in the noise. In other words, they give you answers. Whether you're exploring product sales, analyzing marketing tactics, or wonder 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 will give you a deep, 100% comprehensive understanding of Pivot Tables and Pivot Charts.

  • Access 82 lectures & 6 hours of content 24/7
  • Cover raw data structure, table layouts & styles
  • Explore design & formatting options
  • Understand sorting, filtering, & grouping tools
  • Anaylze data from a number of real-world case studies including San Diego burrito ratings, shark attack records, MLB team statistics, & more

Specs

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • You need a version of Excel that is compatible with Power Pivot (Excel 2013/2016 Standalone, Office 365 Pro Plus, Enterprise E3/E5, Office Professional 2016, etc.)

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Your cart is empty. Continue Shopping!
Processing order...