From the course: Excel PivotTables: Real-World Case Studies

Part 2: Introduction - Microsoft Excel Tutorial

From the course: Excel PivotTables: Real-World Case Studies

Start my 1-month free trial

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.

Contents