Excel Pivot Tables and Charts July 26, 2010

Goal - Learn how to better and analyze and visually display your data with Pivot Tables and Charts. This course covers extensive techniques in using these powerful, but underutilized, Excel tools.

Outline - PivotTables: Creating, sorting and filtering data, Formatting styles, numbers, and layouts, grouping data, comparison and total options, calculated fields and items, combining multiple data sources, conditional formatting PivotCharts. Charts: creating, modifying Design, Layout and Format, creating charts from non-consecutive data, drop-lines, axis formatting, replacing chart series with pictures or shapes, analysis tools, trending tools, using secondary axis, highlighting relationships differences with charts, combining 2 charts into 1.

Prerequisite - understanding of Excel fundamentals including formatting, navigation, basic formulas and Autosum.