Contact
Info
- Privacy Policy
- Terms of Use
Company
B-23A-3, The Ascent Paradigm, No. 1, Jalan SS7/26A, Kelana Jaya, 47301 Petaling Jaya, Selangor, Malaysia
Excel Dashboard
Overview
Dashboard reports allow managers to get high-level overview of the business and help them make quick decisions. This course teaches you to create well-designed Excel dashboards so you and your colleagues can see trends and make quick decisions informed by data.
This Microsoft Excel Dashboard course comes with templates, tools and checklists that can be applied directly to your Excel reports.
Duration
2 Days
Audience Profile
Any professional who wants to analyze and extract value from business data using sophisticated data visualization and interactive dashboards that convey insights with clarity
Pre-requisite
Participants must know how to use Microsoft Excel
Course Outlines
- What is a dashboard?
- Type of dashboard for businesses
- Process for dashboards
- Understand the basics in report creation
- Steps before you get started
- Understand your data (source & format)
- Clean & organize data before using
- Choose the right display to communicate information effectively
- Make your dashboard attractive
- Apply form controls
- Dynamic Excel charting
- Business dashboard examples (KPI, Sales, Financial& HR related metrics
- Application walkthrough
Outcome
- Participants understand what makes an effective dashboard.
- Participants are able to describe the importance of understanding the basics and fundamentals in report creation.
- Participants will learn about data source and formatting it before the usage in developing a dashboard.
- Participants will learn how to visualize data and deploy the concept of pre-attentive attributes like size, color and position to strategically help direct their audience attention to where you want them to focus.
- Participants will enhance the dashboard making it interactive that allow user to manipulate the data parameter.
- Participants will work on real case by applying the concepts and skills from the previous modules.
RM
1399
HRDC Claimable
-
Certification
-
Real Case Application
Click Here
Please contact us for In-House Training