Hands On Workshop (HOW):Building Interactive Dashboards with MS Excel (Beginners)
Overview
This 2-day programme teaches participants to start building Dashboards straight away. Participants do not need previous experience building Dashboards but are expected to have some Excel knowledge
Objectives
- Introduction to Dashboard Creation in Excel:
Equip participants with the skills to build dashboards from scratch. - Essential Excel Features for Dashboard Development:
Guide participants through the Key Excel functionalities necessary for creating effective dashboards. - Layout and Color Theory for Dashboard Design:
Equip participants with the skills on the principles of layout and color theory to enhance the structure and visual appeal of their dashboards.
Who Should Attend
Suited for any personnel that uses Microsoft Excel to analyse and prepare management reports, especially administrative, operational and middle management staff.
Learning Outcomes
- Create interactive dashboards using data from tables.
- Develop interactive dashboards utilising data from PivotTables.
- Incorporate interactivity through Slicers to dynamically update dashboard data.
- Manage the position and size of dashboard elements to indicate relationships and highlight importance.
- Choose a consistent color palette for the dashboard.
Programme Delivery
- 20 – 21 January 2025
- 12 – 13 February 2025
- 23 – 24 April 2025
Your Investment
Categories | Stakeholder | Non-stakeholder |
Normal Price | $600.o0 | $700.00 |
Download Brochure Here