Go from beginner to power PivotTable user. Learn how to use Excel PivotTables and PivotCharts for powerful data analysis. Chris Dutton leads this practical guide, filled with lots of hands-on exercises and real-world use cases. He shows how to structure your data; change table layouts and styles; leverage design controls; perform sorting, filtering, and grouping; and create interactive dashboards. Use the PDF cheat sheets and the Excel solution file to follow along as you learn.

Learning objectives

• Customizing a PivotTable field list
• Grouping dates and values
• Enabling multiple filters
• Conditional formatting
• Refreshing source data
• Adding custom sort lists