Introduction & Scope
  • Course Introduction & Scope
  • Download Excel Files HERE
  • Cheat Sheets - Step by Step Guide to Create Powerful Excel Charts
Effectively Communicate & Present Data Trends
  • Effective Presentation of Quantitative Data - Overview
  • Table Design - Best Practices
  • Excel Chart Design - Best Practices
  • Understanding the Chart Tools Environment
  • Simple Shortcuts to Save Time
  • Best Practice & Chart Options
Behind-the-Scenes Secrets of Dynamic Charts
  • Never Manually update your Excel Charts again!
  • Top Excel Functions that will save you time
Behind-the-Scenes Secrets - Excel Chart Updates When New Data is Added
  • Excel Tables are a Time Saver
  • When Tables fail Use this Function
  • Excel Name Manager & OFFSET as a Great Team
  • OFFSET without Name Manager to Update your Excel Chart
  • Exercise - Dynamic Excel Charts
Behind-the-Scenes Secrets - Getting the Interactive Dashboard Effect
  • Index and Match for an Interactive Chart that shows Different Views
  • Index & Match - The Index Part
  • Index & Match - The Match Part
  • The Dream Team - INDEX & MATCH
  • Mix it all for Major Time Saving - Yes it becomes a Dashboard!
  • Exercise - Function for Interactive Charts
Behind-the-Scenes Secrets - Automatic Sorting of Bars in Excel Charts
  • Automatic Sorting of the Bars in an Excel Bar Chart - Overview
  • Automatic Sorting in Excel - The RANK Function
  • Automatic Sorting in Excel - Unique RANK
  • Exercise - Automatic Sorting of Bars
Behind-the-Scenes Secrets - Automatic Legend Positioning
  • Perfect Positioning of Series Labels
  • Excel Chart Series Label Positioning - Simple Line Series
  • Excel Chart Series Label Positioning - Changing Line Series
  • Excel Chart Series Label Positioning - Stacked Column Chart
  • Exercise - Automatic Legend Positioning
Secret Techniques that Bring Attention to Key Chart Elements
  • Highlight key Areas for Faster & Easier Readability
  • Excel Conditional Format Column Colors for Best Impact
  • Excel Conditional Format Bar Colors
  • Conditionally Color Neg/Pos Columns & Data Labels
  • Better Alternative for Variance Charts in Excel
  • Vertical Lines to Create Dividers
  • Error bars as Dividers
  • Use Dynamic Annotations to Direct Reader Attention
  • Exercise - Bring Attention to Key Chart Elements
Design Tables that Highlight & Impress
  • Conditional Formatting for Easy-to-Read Tables - Overview
  • The Conditional-Formatting-Free method - Use Symbols
  • Highlight Table Rows Based on Values
  • Using Smart Color Coding in Tables
  • Use Symbols or Bars for Easier Readability
  • Exercise - Design Tables with Focus
Measuring Performance - Actual Versus Budget/Target
  • Measuring Performance, doing Comparisons & predicting the Future
  • Excel Column Chart Combinations
  • Using Line Series in Excel - Make Sure you do this to Avoid Crashing Lines
  • Variances With a Bar Chart - The Professional Method #1
  • Variances With Two Bar Charts - Professional Method #2
  • Measuring Performance - Bullet Charts Overview
  • Vertical Bullet Chart with Percentages in Excel
  • Vertical Bullet Chart with Absolute Values in Excel
  • Horizontal Bullet Chart in Excel
  • Horizontal Bullet Chart - The Easy Method
  • Exercise - Effective Charts to Measure Actual to Budget Performance
Effective Comparisons - Actual Versus Previous Year
  • Use Symbols in Excel Charts - The Simple Method
  • Use Symbols in Excel Charts - The Impressive Method
  • Include a Reference Region
  • Learn how to Create a Pin Chart for Variances
  • Exercise - Effective Excel Chart to Compare Actual to Previous Year
Predictive Analysis - Showing Outlook Development
  • Use Continuous Line Series to show Outlook Development
  • Great trick - Add a Divider to emphasise where Outlook Starts
  • Exercise - Show Outlook Development
Most Effective Chart Combinations to Enhance your Reports
  • Effective Chart Combinations - Overview
  • Scatter & Bubble Charts
  • KPI by Geography
  • Comparing Distributions with Box Plots
  • Parts-to-whole Chart - It's Not the Pie Chart
  • Pareto Chart - 80-20 rule
  • Panel Charts - Showing Many Variables at Once
  • Sparklines for Compact Charts
  • Quick & Simple Gantt Chart
  • Fully Featured Gantt Chart (incl. % completion & comparison to plan)
  • Exercise - Effective Chart Combinations
Waterfall / Bridge Chart in Excel
  • Waterfall Chart Overview
  • Easiest Method for the Most Flexible Waterfall Chart in Excel
  • Waterfall Chart in Excel - Step by Step
  • Exercise - Waterfall Chart in Excel
Final Words
  • Final words
  • ** Next Steps - BONUS