Introduction to MS Excel Dashboard
Programme Overview
Excel Dashboard is a page that allows managers and business leaders to track key KPIs or indicators and to decide appropriately. It includes diagrams / tables / views supported by facts. Nevertheless, not all reports are dashboards. Dashboard reports provide administrators with a high-level company summary. Excel is an excellent tool for producing powerful dashboards which allow managers to evaluate, inspect and alert on time.
Programme Objectives
By the end of the programme, participants will be able to:
- Understand the Dashboard and its specifications;
- Use data and formatting to present data accurately so that the report is easily understood;
- Show the advanced formula to make the report interactive; and
- Create sophisticated chart such as Speedometer chart & Thermometer Chart
Who Should Attend
This course is suited for any personnel that uses Microsoft Excel to analyse and prepare management reports, especially administrative, operational and middle management staff.
Methodology
- Lecture
- Skill-practices
- Hybrid learning mode
Programme Outline
Modules | Programme Description |
About Dashboard |
|
Understanding Data |
|
Effective Presentation with Cell Number Format |
|
Conditional Formatting |
|
Basic PivotTable |
|
Basic Charts |
|
Excel Camera Tool |
|
Present Calculated Data in a Dashboard |
|
Final Touches |
|
Programme Delivery
Date | Time |
24 – 25 October 2022 | 8:30 am – 12:00 pm & 1:30 pm – 5:00 pm |
Your Investment
Categories | Stakeholder | Non-stakeholder |
Normal Price | $550.00 (20% SBS) | $650.00 |
Download Brochure Here