Data Visualisation With Excel
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
- ClarityQualitySimplicityStructure
Working with Source Data
- Setting Up Source DataUse of Auxiliary Data Columns/Rows
Advanced Charting Techniques
- Choosing the right ChartFont SelectionCreating Chart TemplatesWorking with 3-D ChartsSnap to GridUse of Symbols and EnhancementsAlternate Plot Area with Different Colours
Special Charts
- GANTT ChartsWaterfall Charts‘Vertical’ Line ChartsTornado ChartsSpecial Effect Pie Charts‘Square’ Pie ChartsDynamic Charts
Dashboard Design
- Dashboard Layout/ArrangementPre-formatting the WorksheetCreating the DashboardChart Formatting Techniques (Chart Area, Plot Area, Axis, Legend, etc.)Using TablesColour SchemesChart LayoutsWorking with TablesHow to use Excel’s Camera toolMagazine-Quality Colours and ThemesAutomating Charts with Form Controls:
- Spin buttonOption boxCombo boxLink Excel Charts to MS Word/MSmPowerPoint (with automatic update)Sample Visualisation with Dynamic Maps
Upcoming events
We offer discounts for group bookings (i.e group of delegates attending the same course at the same time) as follows:
-
3-5 participants - 5% discount
6-9 participants - 7.5% discount
10 or more participants - 10% discount