• Home
  • Creating an Interactive Excel Dashboards for Business Analytics

Creating an Interactive Excel Dashboards for Business Analytics in Singapore

Course Information

  • Sessions 1 day
  • Duration 7.5 hrs
  • Level Intermediate
  • Assessment NA

Venue

12 Woodlands Square #07-85/86/87 Woods Square Tower 1, Singapore 737715. 5 mins walk from Woodlands (NS9) MRT station.

The venue is disabled-friendly.

Download Course Brochure

Certification

  • Certificate of Completion from Tertiary Infotech - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Infotech.

Additional Information

Duration

2 months (Full Time)

Assessment

3 hours online assessment after each module

Class (No of teacher : student): 1:20

Intake

  • 3 Nov 2025 to 29 Sep 2026
  • 4 May 2026 to 26 June 2026
  • 2 Jan 2026 to 2 Mar 2026
  • 2 Mar 2026 to 27 Apr 2026

Enrolment Requirement

  • Age: 21 years old and above
  • Language Proficiency: At least C6 for GCE "O" Level English
  • Academic: At least C6 for GCE "O" Level in any 3 subjects

Graduation Requirement

  • Attendance: 75%
  • Assessment: Passed

Creating an Interactive Excel Dashboards for Business Analytics

Course Code: C507

Be the first to review this product

What's This Course About

Elevate your proficiency in business analytics by mastering the creation of interactive Excel dashboards. This comprehensive course guides participants from the initial stages of defining requirements and setting up data, to more intricate processes such as importing data, inserting slicers, and diving into the intricacies of VBA code. Emphasizing hands-on learning, participants will delve into practical exercises, ensuring they become adept in tailoring dashboards that resonate with their organizational needs.

Enhance the visual appeal of your dashboards through a nuanced understanding of color, typography, and hierarchy, while ensuring an intuitive user experience. The course also introduces participants to the analytical prowess of Excel through Goal Seek and Solver, thereby cementing their capabilities in data-driven decision making. Whether you're looking to optimize your existing dashboards or craft one from scratch, this training offers all the tools you need for analytical success.

WSQ Funding

Full Fee $350.00 Before GST
GST $31.50 9% of fee
Baseline Nett $206.50 SG/PR age 21+ · 50% funded
MCES / SME Nett $136.50 SG age 40+ · 70% funded
Funding and Grant Applications

Click the links below to apply. Note that you need to register the course first.

For WSQ funding, please checkout the details at NICF - Create Interactive Dashboard Using Excel

Course Fee

$350.00 (GST-exclusive)
$381.50 (GST-inclusive)

Course Date

Course Time

* Required Fields

Additional Note

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts.

Cancellation & Reschedule Policy

  • You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commences.
  • We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
  • Note the venue of the training is subject to changes due to availability of the classroom.

Course Details

Course Details

What You'll Learn

Topic 1 Data Visualization and Display using Excel Pivot Tables and Charts

Data analysis using Excel pivot tables and charts

Organize and visualize data to show trends and correlation

Topic 2: Create Basic Excel Dashboard and Scorecards

Sketch your dashboard layout

Link to Excel pivot tables

Incorporate appropriate dashboard elements such as gauge chart, KPI

Topic 3 Create Interactive Excel Dashboard

Form control, value-based formatting and dynamic series selection

Animating changes over time

Limitations of data and Interpretation of findings

Course Info

Promotion Code

Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.

Minimum Entry Requirement

Knowledge and Skills

  • Able to operate using computer functions
  • Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude

  • Positive Learning Attitude
  • Enthusiastic Learner

Experience

  • Minimum of 1 year of working experience.

Target Age Group: 18-65 years old

Minimum Software/Hardware Requirement

Software:

TBD

Hardware: Window or Mac Laptops

Job Roles

Job Roles

  • Data Analyst
  • Business Analyst
  • Financial Analyst
  • Operations Manager
  • Marketing Analyst
  • HR Metrics Specialist
  • Sales Operations Specialist
  • Report Developer
  • Project Manager
  • Management Accountant
  • Product Manager
  • Supply Chain Analyst
  • Performance Metrics Specialist
  • Market Researcher
  • Business Intelligence Coordinator

Trainers

Trainers

Jim Gan Chiu Liang: Jim Gan Chiu Liang is a ACTA certified trainer. Jim Gan Chiu Liang obtained his Master of Technology (M.Tech Knowledge Engineering) from National University of Singapore (NUS) Institute of System Science He is currently working as adjunct trainer at PACE (Professional Adult Continuing Education) Academy, Singapore Polytechnic. His past experience included being a chief instructor for Kumon Education. Ken Hiong: Ken Hiong is a ACTA certified trainer. Ken has over 20 years of work experience in the healthcare and pharmaceutical industry, having assumed various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning. With an interest and experience in scripting, Ken has worked on projects using HTML, CSS, PHP, MySQL, WordPress, MS Office, VBA, Power BI, etc. Notably, Ken is a proven expert Excel user at work who has made efficient many work processes, improved data analysis and enhanced the quality of business planning and reporting for organizations. Ken graduated with a Pharmacy degree, holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide. An ardent advocate of lifelong learning, Ken is ACTA trained and seeks to continually upgrade his IT skills through various channels of learning and Microsoft certifications. With MS Office Master qualification, Ken looks forward to assisting individuals and corporations improve their computer skills, productivity and business outcomes. Dr Alvin Ang: Dr Alvin Ang is a ACTA certified trainer. Alvin Ang did his Ph.D., Masters and Bachelors from NTU, Singapore. Previously he was a Principal Consultant (Data Science) as well as an Assistant Professor. He was also 8 years SUSS adjunct lecturer. His focus and interest is in the area of real world data science. Though an operational researcher by study, his passion for practical applications outweigh his academic background. He owns a startup externally

Review

Write Your Own Review

You're reviewing: Creating an Interactive Excel Dashboards for Business Analytics