Excel PivotTables: Real-World Case Studies
2h 22mBeginner2022-03-23
Authors

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