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.

Note: The instructor uses Office 365 ProPlus. Some features may not be available in all versions of Excel.

Topics include:

Customizing a PivotTable field list

Grouping dates and values

Enabling multiple filters

Conditional formatting

Refreshing source data

Adding custom sort lists

HOMEPAGE

https://www.lynda.com/Excel-tutorials/Excel-PivotTable-Tips/5040387-2.html