Course Detail()

Programme Objective
At the end of the course, attendees should be able to:

▪ Use Excel to create powerful charts
▪ Understand, prepare & analyze data using appropriate chart types
▪ Creatively integrate excel functions to create dynamic charts
▪ Learn useful tips and tricks to build charts efficiently

Programme Outline

Introduction: Get to know the chart

Smart techniques to overcome data problems like time, spaces, different data series
Leverage on design to get the most impact out of your charts
The Do's and Don'ts when creating charts - avoid common chart making mistakes

Creative Charting: Turn standard charts into dynamic reports

Learn to creatively transform standard charts into meaning reports like cluster & stack chart, bridge/waterfall chart, 'conditional format' chart, pareto, histogram, gauge chart, etc

Interactive Charts: Be in control of what you want to analyze

Learn to control a series using spinners, scroll bar, etc
Leverage on formulas & excel features to plot the chart by selecting a specific date range with a simple button click, enabling user to quickly switch perspectives

Interactive Charts: Interactive KPI Scorecard

Learn to build Company Scorecard with one click interactive button allowing rolling 12 months data presentation

Training Methodology

Lecture
Group Discussion
Hands On Exercise

Closing Date for Registration
1 week before programme or until full enrolment.

Intended For

Accountants and finance professional who have to prepare monthly / weekly dashboards and KPI reports.

Schedule & Fees

Testimonial

Past Participant

Funding

1] NTUC Union Training Assistance Programme (UTAP)

NTUC members enjoy 50% *unfunded course fee support for up to $250 each year when you sign up for courses supported under UTAP. NTUC members aged 40 and above can enjoy higher funding support up to $500 per individual each year, capped at 50% of unfunded course fees, for courses attended between 1 July 2020 to 31 December 2025.

*Unfunded course fee refers to the balance course fee payable after applicable government subsidies. This excludes material fees, registration fees, misc. fees etc.

This course is approved for UTAP support for intakes conducted between 08 February 2024 – 31 March 2025.

As UTAP is given on calendar year basis, and calculated based on year of training taken, it cannot be accumulated.

Maintained paid-up NTUC membership before course, throughout course duration and at the point of claim and;
Course by training provider must be supported under UTAP and training must commence within the supported period and;
Unfunded course fee must not be fully sponsored by company or other types of funding
Unfunded course fee must be S$20.00 and above, and;
Member must achieve a minimum of 75% attendance for each application and sat for all prescribed examination(s), if any and;
UTAP application must be made within 6 months after course ends.

For more information on UTAP Funding and to submit for UTAP claims, please visit https://www.ntuc.org.sg/uportal/programmes/union-training-assistance-programme. Terms and conditions apply.

Programme Facilitator(s)