This recorded webinar will demonstrate how to create a whole of organisation dashboard report which is fully interactive by business group.
- 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.
- 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
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.