This quick reference guide is a valuable resource for any user looking to master the ultimate data analysis tool in Excel: PivotTables. Also discussed in this guide are sorting features as well as data analysis using filters. Topics include: sorting data using various techniques, using chronological sorting, adding data filters to extract data, applying filters to drill-down and locate data sets, using advanced filters to extract and analyze data and combining filters and sorting to create unique data sets. In addition, this guides offers extensive details on creating PivotTable reports to analyze and understand complex data. You will learn how to establish PivotTable guidelines, setup a PivotTable report, using drop-zones to compose the report, grouping and ungrouping data, using filters within a PivotTable, adding calculated items and fields, exploring layout options and creating effective PivotCharts.
The guide is also structured to be a companion for hands-on training or self-paced training. It includes step by step instructions and downloadable exercise files