Microsoft Excel - Level 2 Pivot Tables, Pivot Charts and Macros
Laptops are provided to use with on-site, classroom training
Everyone receives a physical workbook, 8 hours, $225 per person

1. Charts:
Filter/Sort, make tables out of data
Column, Bar, Line, Waterfall, Gantt, Pareto, Scatter, Control Charts
Excel templates, chart templates, snapshot in time charts
Sparklines
3D Maps
Labels
Data callouts
KPI (Key Performance Indicators)
Forecast sheet
Goal seek
Scenario Manager
Password Protection

2. PivotTables and Pivot Charts:
Tables: how to make, naming, formatting
PivotTables: KPIs, filling in headings, clearing filters, copying
Cube functions: pointing to other Pivot Tables
Sum, count, average, min, max of data in PivotTables
Pivot Charts, Slicers, Date Slicer

3. Macros:
Developing a macro, macro enabled workbooks
Absolute vs Use Relative References in Macros
Macros to copy, paste, filter, sort, make charts
Macro shortcuts, Writing simple VBA code, Debugging VBA
Using macros in different Excel files