[go: up one dir, main page]
Scribd
Upload
250 views2 pages

Data Visualisation With Excel Dashboards

This one-day course aims to teach participants how to create effective dashboards in Microsoft Excel to present data visually. The course covers dashboard fundamentals, design considerations, customizing chart elements, advanced chart types including box plots and gauges, reporting with pivot tables and pivot charts, conditional formatting, and obtaining data with functions. Participants will learn through mini lectures and hands-on activities. The target audience is working adults and no certification or assessment is provided upon completion.

Uploaded by

farah aqeel
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
250 views2 pages

Data Visualisation With Excel Dashboards

This one-day course aims to teach participants how to create effective dashboards in Microsoft Excel to present data visually. The course covers dashboard fundamentals, design considerations, customizing chart elements, advanced chart types including box plots and gauges, reporting with pivot tables and pivot charts, conditional formatting, and obtaining data with functions. Participants will learn through mini lectures and hands-on activities. The target audience is working adults and no certification or assessment is provided upon completion.

Uploaded by

farah aqeel
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Data Visualisation with Excel Dashboards

Course Type : Non-Funded

Course Objective

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

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

Customising Chart Elements


• Format axia
• Display/format data labels

Advanced Chart Types


• Box & whisker chart
• Gauge or Speedometer chart
• Histogram

Reporting with Pivot Table and Pivot Chart


• Insert and populate a PivotTable and PivotChart
• Using Slicer
• Update PivotTable data

Conditional Formatting
• Create, edit, delete rules
• Use data bars, color scales and Icon Sets

Advanced Excel Tools


• 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


• Column/Bar charts
• Line charts
• Pie charts
• Combination chart
• Sparkline

Methodology

Mini lectures and practical activities

Target Audience

working adult

Trainer

To be assigned by SNEF :
Contact us at 6827 6927 or trg@snef.org.sg to find out more.

FAQ

Course Fee Subsidy? Absentee Payroll Funding? Any Assessment(s)?


No No No

Any Certification? Refreshments Provided? Lunch Provided?


E-Certificate from SNEF Yes No

Complimentary Parking?
No

Course details
Timing : 09:00 AM - 06:00 PM
Format: On-site
Location: 150 Orchard Road
06-14,Orchard Plaza Type Full Fee (inclusive 8% GST)
Singapore 238841
Duration: 1 day Course Fee $ 345.60

Course Runs: 04 Oct 2023 - 04 Oct 2023,


03 Nov 2023 - 03 Nov 2023,
01 Dec 2023 - 01 Dec 2023

Register by visiting www.snef.org.sg > Training > Programmes & Courses >

ENQUIRIES :
Training Officer's Name : Christopher Oh
Training Officer's Email : christopher_oh@snef.org.sg
Training Officer's DID : +65 68276919
Training Email : trg@snef.org.sg
Training Hotline : +65 68276927

You might also like