Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel PivotTables: Real-World Case Studies

via LinkedIn Learning

Overview

Take your PivotTable skills to the next level. Review practical case studies that showcase how this powerful data analysis tool is used in the real world.

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.

Syllabus

Introduction
  • Part 2: Introduction
1. 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
2. Wrapping Up
  • Part 2: Conclusion

Taught by

Chris Dutton

Reviews

Start your review of Excel PivotTables: Real-World Case Studies

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.