From the course: Excel PivotTables: Real-World Case Studies
Part 2: Introduction - Microsoft Excel Tutorial
From the course: Excel PivotTables: Real-World Case Studies
Part 2: Introduction
(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.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.