Building Interactive Reports and Dashboard using Microsoft Excel (HRD Corp Claimable)

Course Overview

Description

Excel Dashboard is a page that allows managers and business leaders to track key KPIs or indicators and to decide appropriately. It includes diagrams / tables / views supported by facts. Nevertheless, not all reports are dashboards. Dashboard reports provide administrators with a high-level company summary. Excel is an excellent tool for producing powerful dashboards which allow managers to evaluate, inspect and alert on time.

Learning Outcome and Goals

• Understanding the Dashboard and its specifications
• Use data and formatting to present data accurately so that the report is easily understood.
• Show the advanced formula to make the report interactive
• Create sophisticated chart such as Speedometer chart & Thermometer Chart

Course Requirement

• Participants should be able to use a PC at the beginner level
• Basic knowledge and functionality of Microsoft Excel
• Microsoft Office 2013 and above

Duration

2 Days (16 Hours)

HRD Corp Training Programme No: 10001266513