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

Course Information

Course Outline

About DASHBOARD

• Introduction to Dashboard
• Visual interface – at-a-glance
• Consists of 3 key attributes
• Excel Dashboards
• Magazine-Quality Reporting
• Flexibility
• Analytical Power
• Error Handling
• What Makes A Good Dashboard?
• Proper Visualizations
• Themes
• Tables
• Charts
• What do you need?
• Data
• Strong Knowledge
• Final Question

Understanding Data & Format

• What is Data Type?
• How does Data Type affect our formulas or calculations?
• Number Formatting
• Excel Date Format
• Excel Number Custom Format
• Enhance Reports with Conditional Formatting
• Using Excel’s Camera Tool
• Where Is the CAMERA TOOL?
• Use Camera Tool as easy as 1,2 3… Smiles

About Functions

• About Excel References
• Use Name Range as Absolute Reference
• Indirect Function
• Offset Function
• VLOOKUP Functions
• Database Function
• SUMIFS
• SUMPRODUCT Function

Presenting Data using CHART

• Select Data
• Chart Elements
• Type of Charts
• Cluster Column Charts
• Bar Chart
• Thermometer Chart
• Pie Chart
• Speedometer Chart (Background)
• Speedometer Chart (Needle)

Building Dashboard

• Building Dashboard with Formula & Formatting
• Visualizing Dashboard using Chart