In this course, you will learn to develop visualization tools/dashboards to see where your organisation has been and where it’s going. Learn to develop powerful tools that help to track trends, gain insight, see opportunities and take action!

Rules of Visualisation

• Clarity
• Quality
• Simplicity
• Structure

Working with Source Data

• Setting Up Source Data
• Use of Auxiliary Data Columns/Rows

Advanced Charting Techniques

• Choosing the right Chart
• Font Selection
• Creating Chart Templates
• Working with 3-D Charts
• Snap to Grid
• Use of Symbols and Enhancements
• Alternate Plot Area with Different Colours

Special Charts

• GANTT Charts
• Waterfall Charts
• ‘Vertical’ Line Charts
• Tornado Charts
• Special Effect Pie Charts
• ‘Square’ Pie Charts
• Dynamic Charts

Dashboard Design

• Dashboard Layout/Arrangement
• Pre-formatting the Worksheet
• Creating the Dashboard
• Chart Formatting Techniques (Chart Area, Plot Area, Axis, Legend, etc.)
• Using Tables
• Colour Schemes
• Chart Layouts
• Working with Tables
• How to use Excel’s Camera tool
• Magazine-Quality Colours and Themes
• Automating Charts with Form Controls:

  • Spin button
  • Option box
  • Combo box
  • Link Excel Charts to MS Word/MSmPowerPoint (with automatic update)
• Sample Visualisation with Dynamic Maps