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.
(tranquil instrumental music) - [Chris] Hey, everyone, Chris Dutton here, and welcome to Excel PivotTables, Part 2: Real-world Case Studies. This course is all about taking the skills developed in Part 1 and applying them to a variety of brand-new real-world datasets. We'll build PivotCharts to plot the relationship between wine price and quality, we'll use conditional formats to find the best burritos in San Diego, and apply sorting and filtering rules to explore more than 5,000 shark attack records over the past hundred years.
Now keep in mind, this is Part 2 of a two-part series. We'll be picking up right where we left off in Part 1, Mastering PivotTables & PivotCharts, so I'd recommend working through that section first to make sure that you're comfortable with the core tools and techniques. Ready to get started? Let's dive in.