Part II

PivotTables and PivotCharts

image

webextra Head to www.dummies.com/extras/exceldataanalysis to find an article about handy PivotTable Tools available on the Analyze tab.

In this part …

check.png Use PivotTables to cross-tabulate data and gain new insights into your information.

check.png Extend the power of Excel’s PivotTables by creating your own customized formulas.

check.png Display cross-tabulated data in a chart for new perspectives on opportunities and problems.

check.png Customize PivotCharts to make sure your graphical information communicates the right messages.

Get Excel Data Analysis For Dummies now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.