On course for success

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.

▲ Top