Excel 2010: Pivot Tables

- [Voiceover] Hi, I'm Curt Frye. Welcome to Excel 2010. In this course I'll show you how to use pivot tables to make sense of 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. We'll 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 create conditional formats that highlights subsets of your data to control your pivot table using macros and to summarize huge data sets using the new power pivot add-in. In short, I'll show you how to summarize and analyze data using one of Excel's most powerful and overlooked features.