Building Interactive Dashboards with MS Excel (Intermediate)
OVERVIEW
The Intermediate syllabus introduces using powerful Excel functions and form controls on your Dashboard. This overcomes the limitations of PivotTables while also opening up the possibility of unique Dashboard interactions.
OBJECTIVES
- Create dashboards using advanced Excel functions and logic.
- Introduce participants to generating their own summarised data for use in Dashboards by using Excel functions.
- Incorporate interactivity through Form Controls and conditional visual elements.
- Apply the use of Data Bars and Sparklines in Dashboards.
- Apply design techniques for clean, functional dashboards that update automatically
WHO SHOULD ATTEND
This programme is designed for professionals who already use Microsoft Excel for data analysis and reporting and want to advance their skills in creating dynamic, interactive dashboards.
Ideal participants include:
- Administrative and operational staff preparing regular management reports
- Analysts and officers responsible for tracking KPIs and performance metrics
- Middle management staff who need to present data-driven insight.
Brunei Institute of Leadership & Islamic Finance
Level 3, ILIA Building,
Universiti Brunei Darussalam Campus,
Jalan Tungku Link, BE1410,
Negara Brunei Darussalam
+673 2461 221
+673 2461 223
+673 8271 140
+673 2461 224
https://bilif.com.bn