Data Visualisation with Excel Dashboards
Course Overview
This course aims to equip learners with the necessary skills and knowledge to create insightful and impressive management reports using the various tools in Microsoft Excel.
Who Should Attend
This course is aimed at participants who have attended the basic Microsoft Excel course or have some working knowledge of Microsoft Excel.
Course Duration
1 Day
Total Training Duration (Hour)
8
Course Outline
Learning Unit 1:Dashboard Fundamentals
- What is a dashboard
- Key characteristics of a dashboard
Learning Unit 2:Planning Considerations
- Define information needs
- Acquire and arrange data
Learning Unit 3:Dashboard Design Consideration
- Dashboard Dos and Don’ts
- Selecting appropriate tools
- Determine chart elements and colour selection
- Histogram
Learning Unit 4:Reporting With PivotTable And PivotChart
- Insert and populate a PivotTable and PivotChart
- Update PivotTable data
- Using Slicer
Learning Unit 5:Advanced Excel Tools
- Conditional formatting
- Using Range Names
- Create Drop-down list with data validation
Learning Unit 6:Obtain Data With Excel Functions
- Use Lookup and Reference functions
- Use INDEX and MATCH functions
- Database functions
Learning Unit 7:Create Excel Chart
- Create standard charts
- Combination chart
- Sparkline
Learning Unit 8:Customising Chart Elements
- Format axis
- Display/format Data Labels
Learning Unit 9:Advanced Chart Types
- Pareto chart
- Box & whisker chart
- Gauge or Speedometer chart
Pre-requisites
- Learners must be able to read, write, speak and listen to English at secondary school level
- Learner should have working knowledge of Microsoft Excel
Course Pre-Requisites
Price
| Course Fee Payable | ||
|---|---|---|
| Original Fee | Before GST | With GST (9%) |
| Course Fee | $320.00 | $348.80 |
Please note that prices are subjected to change.
