On course for success

Building Interactive Dashboards with MS Excel (Advanced)

OVERVIEW

A 3-day programme introduces participants to more Excel functions for use in their Dashboards. This programme requires participants to continue generating summarised data for their Dashboards and introduces a technique to display a lot of data within a limited space. Participants will also learn Excel features that can be used to clean and prepare data for use in Dashboards. The programme culminates in a role-play exercise where participants take on the role of describing a Dashboard for others to build.

OBJECTIVES

  • Teach participants a way to display a lot of data within a limited space.
  • Teach participants more Excel functions that can be used to generate data for Dashboards.
  • Teach participants Excel features that can be used to clean data for use in 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.


▲ Top