Introduction to Pivot Tables in Excel Part 3: Advanced, Real-World Case Studies

Chris Dutton, Founder, Excel Maven

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
10 Videos (1h 49m)
    • S7L1 Expectations

      1:45
    • U.S. Voters

      10:33
    • San Francisco Salaries

      13:06
    • Shark Attack Records

      10:31
    • Stock Market Data

      12:25
    • Baseball Team Stats

      14:16
    • San Diego Burrito Ratings

      16:40
    • Daily Weather Conditions

      12:41
    • Spartan Race Facebook Posts

      14:37
    • Wrapping Up & Next Steps

      2:27

About This Class

This class is Part 3 of a three-part series (Microsoft Excel - Data Analysis with PivotTables) covering data analysis with Excel PivotTables and PivotCharts.

PivotTables are an absolutely essential tool for anyone working with data in Microsoft Excel. Pivots allow you to quickly explore and analyze raw data, reveal powerful insights and trends otherwise buried in the noise, and provide fast, accurate and intuitive solutions to even the most complicated questions.

Part 3 is the final section of the course, where we'll tie together everything we've learned in Part 1 and Part 2 and apply it to advanced, real-world case studies!

We'll explore and analyze actual datasets from a number of case studies, including:

  • U.S. voter demographics (2012)
  • San Francisco salaries
  • Shark attack records from 1900-2016
  • Daily stock market performance
  • Baseball team stats
  • San Diego burrito ratings
  • Daily weather conditions
  • Spartan Race Facebook posts

Requirements: 

  • Microsoft Excel (2010, 2013, 2016), ideally for PC
  • Mac users are welcome, but note that the PivotTable interface varies across platforms
  • Basic experience with Excel functionality (charts & formulas a plus!)

3 of 3 students recommendSee All

Great!! this will not disappoint you. He is a great teacher and the examples are beyond helpful. Thank you

14

Students

--

Projects

Chris Dutton

Founder, Excel Maven

Chris Dutton is a Certified Microsoft Expert and Analytics Consultant with more than a decade of experience in the B.I and data science fields. His work has been featured by Microsoft, the Society of American Baseball Research (SABR) and the New York Times.

Excel Maven provides high-quality online analytics training, hands-on workshops, and project-based consulting services to clients and students across 130+ countries.

See full profile