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.

Learning 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.

365

365 Days

loading...