Welcome

- [Voiceover] Hi, I'm Curt Frye. Welcome to Excel 2016 for Mac: Pivot Tables in Depth. In this course, I'll show you how to use Pivot Tables to gain valuable insights from your organization's data. I'll begin by showing you how to create a Pivot Table from data already in your Excel workbooks. Then, using that knowledge as a base, I'll demonstrate how to create Pivot Tables using data from an external source. Next, I will enhance your ability to analyze your data by showing you how to reorganize, or pivot, a Pivot Table.

After you've organized your Pivot Table's data, you can sort and filter its contents to develop useful insights into your business. I'll also show you how to change your Pivot Table's summary operations, add calculated fields to enhance understanding of your data, and drill down from a Pivot Table value to view the data behind the summary. Finally, I'll show you how to format your Pivot Table using Styles, apply conditional formats to summarize your data visually, and share your Pivot Tables as printed, and PDF, documents.

In short, I'll show you how to summarize and analyze data using one of Excel's most powerful and overlooked features. Thanks again for spending time with Excel 2016, for Mac, Pivot Tables in Depth. Dive right in.