Whole of organisation dashboard in Excel - Recorded Webinar

Overview

This recorded webinar will demonstrate how to create a whole of organisation dashboard report which is fully interactive by business group.

Key topics:                  

• A holistic view of the organisation - display interactive data from operations, finance, human resource.
• Create some active x combo boxes to let users choose different metrics to display in the report.
• Create analysis by region or team/department.
• Build summary tables and create trends in the charting which can be turned on or off depending on user preference.

Objectives

• Create calculations for the dashboard
• Build an Active X and Form Control combo box
• Create some conditional formatting to highlight a given metric (year)
• Work through detailed tasks accompanying the webinar to test knowledge acquired

Audience

Professionals working in SME or Corporate entities in specialist or analyst and mid-level career roles working in job functions such as external reporting, financial control and management accounting.