01 day - Data Visualisation with Excel Dashboards
TGS-2017501009
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.
Training Type
Full Time
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
Dashboard Fundamentals
- What is a dashboard
- Key characteristics of a dashboard
Planning Considerations
- Define information needs
- Acquire and arrange data
Dashboard Design Consideration
- Dashboard Dos and Don’ts
- Selecting appropriate tools
- Determine chart elements and colour selection
- Histogram
Reporting With PivotTable And PivotChart
- Insert and populate a PivotTable and PivotChart
- Update PivotTable data
- Using Slicer
Advanced Excel Tools
- Conditional formatting
- Using Range Names
- Create Drop-down list with data validation
Obtain Data With Excel Functions
- Use Lookup and Reference functions
- Use INDEX and MATCH functions
- Database functions
Create Excel Chart
- Create standard charts
- Combination chart
- Sparkline
Customising Chart Elements
- Format axis
- Display/format Data Labels
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.
