This course will teach you how to better analyze and visually display your data with Pivot Tables and Charts. This course covers extensive techniques in using these powerful, but underutilized, Excel tools. 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.