Excel PivotTables: Real-World Case Studies

Excel PivotTables: Real-World Case Studies

2h 22mBeginner2022-03-23

Authors

Chris Dutton

Chris Dutton

Certified Microsoft Excel Expert, Analytics Consultant

Course details

Once you grasp the basics of Excel PivotTables, you're ready to see how this powerful data analysis tool can add value in real-world situations. In this course— the final installment in a two-part series—instructor Chris Dutton dives into ten real-world case studies that showcase how PivotTables can be leveraged to explore and analyze data in a variety of situations. While the previous installment in this series dove into theory and the general ins and outs of PivotTables, this course helps expand your knowledge by looking at practical applications of the tool. Chris covers case studies on San Diego burrito ratings, historical shark attack records, major league baseball statistics, stock market data, and more.

Skills covered

SpreadsheetsMicrosoft ExcelBusiness Software and ToolsMicrosoftOne-Off

Concepts

Introduction

  • Part 2 - Introduction

PivotTable Case Studies

  • U.S. voters
  • San Francisco salaries
  • Shark attack records
  • Stock market data
  • Baseball team statistics
  • San Diego burrito ratings
  • Weather conditions
  • Spartan Race Facebook posts
  • Apple app ratings
  • Wine tasting results

Wrapping Up

  • Wrapping up
80,000 Toman