Module 1: Advance Excel Chart Techniques - 1.5 Hour
- Chart Overview: When to use which excel charts
- Add total values to stacked Excel column charts
- Add dynamic series label inside Excel charts
- Secret: Excel bar for Additional control
- Info-graphics in Excel: Impressive Bar chart
- Dynamic Excel Map chart with dynamic drop-down (only in Excel 365)
Module 2: KPI Excel Dashboard - 1 Hour
- Dashboard wire-frame in Excel
- Spreadsheet setup
- Setup raw data sheet
- Setup excel calculation sheet
Module 3: KPI Excel Dashboard: Scrolling Tables & Bars - 1 Hour
- Setup combo box to ease selection
- Complete lookup with Index & match
- Scrolling data table in Excel
- Conditionally formatted data bars
- Arrows for deviation in Excel
Module 4: KPI Dashboard Dynamic headers - 1 Hour
- Conditional comment in header
- Adding shapes and text box in Excel
Module 5: KPI Dashboard Top/Bottom KPI based on selection - 1 Hour
- Top 6 matches with unique identifiers
- List box to select KPI for top 6 matches
- Option button to toggle top or bottom 6
- Actual to Budget comparison
- Finalize top/bottom report in Dashboard
Module 6: Scrolling Line chart with check Boxes - 1.5 hours
- Complex Excel lookup to prepare data for scrolling chart
- Scroll-able line chart
- Trick to avoid crashing lines in Excel line chart
- Check Box to Control Series Visibility in Excel
- Excel Line Series Tweaks for Better Readability
- Finalize Profit Comparison Section on Dashboard
Module 7 - 1 Hour
- Restrict Excel Dashboard Area and Format for Printing
- Excel Dashboard Protection, Hyperlinks and Final Touches