Excel 2010 PivotTables & PivotCharts
ISBN: 978-1-55374-266-1
PivotTables and PivotCharts are powerful tools used to rearrange and present spreadsheet information. PivotTables allow you to select data fields to compare, or ‘pivot’, against each other, paring down large quantities of info into specific, useful summaries with sorting and filtering options. PivotCharts are a visual representation of PivotTable results, displaying summaries in a variety of graph formats so you can identify important trends and present data to others. New in Excel 2010 are Slicers: visual control panels used to quickly and dynamically filter PivotTables, which can be very effective in a presentation or meeting.