Call +65 6100 0613 Email: enquiry@tertiaryinfotech.com

Enhance Your Employability with Certified Skills and Courses in Singapore - WSQ , IBF-STS, Skills Certification

Creating an Interactive Excel Dashboards for Business Analytics

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.

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

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 Code: C507

Course Booking

The course fee listed below is before subsidy/grant, if applicable. We will apply for the grant and send you the invoice with nett fee.

$300.00 (GST-exclusive)
$327.00 (GST-inclusive)

Course Date

Course Time

* Required Fields

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 and get back to you asap.

Course Cancellation/Reschedule Policy

We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
Note the venue of the training is subject to changes due to class size and availability of the classroom.
Note the minimal class size to start a class is 3 Pax.


Course Details

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

  1. Data analysis using Excel pivot tables and charts
  2. 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

Nil

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

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.

Dwight Nuwan Fonseka: Dwight Nuwan Fonseka is a ACLP certified trainer. He have a degree in Biotechnology from NUS, Advanced diploma in Pharmaceutical management from MDIS and Masters in Education from NTU. He have 8 years experience of teaching biology at O and A levels/ IB level in international schools in Singapore and overseas.

Dr. Alvin Ang: Dr. Alvin Ang is a ACTA certified trainer. Dr. 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.

Grace Saw: Grace Saw is an ACTA certified trainer and a Fellow member of ACCA with more than ten years of accounting experience including auditing, financial and management accounting, reporting, consolidation, budgeting, forecasting, taxation as well as financial planning and analysis in diverse industries such as manufacturing, technology, retail, services and hospitality. I am familiar with the FRS framework for Singapore and Malaysia. Besides, I hold a Master of Science in Professional Accountancy from the University of London, and can fluently read and write English, Chinese and Malay. I am an excellent team player and have good project management, problem-solving, multitasking, and interpersonal skills.

Customer Reviews (15)

Ms saw show passion in sharing more tips Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
more time is better (Posted on 8/21/2022)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Hope to have an advanced course that goes through how to create dashboards using local data for local context like Singapore Map (Posted on 8/30/2021)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
More exercises in the class I have attended a similar course earlier. Please don't repeat the course with different names (Posted on 8/30/2021)
I enjoyed my one to one class today :D Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
I am quite blessed in the way that I am the only student in the class and I have one to one customised training rather than going through the areas I already know. Today’s class I go in depth to incorporated vba into dashboard and helps me a lot. (Posted on 5/11/2021)
might recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Spend more time on topic 4 (Posted on 4/13/2021)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 4/13/2021)
Useful Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
More practices (Posted on 4/13/2021)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
The quiz at the end of the course and recap of the tenets is helpful to reinforce what has been learnt throughout the day. Good course. (Posted on 1/11/2021)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Data used for hands on can be more corporate oriented. More time for hands - on on what was taught. (Posted on 4/26/2020)
Trainer v good Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Trainer v good n willing stretch to complete course material

No basic necessity like water. An old jug with no water. No blinds n the evening sun pierce in classroom making eyes pain looking at screen (Posted on 4/5/2020)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 6/11/2019)
Too ambitious for 1-day training Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Training is useful for its intended purpose. However, it is far too ambitious to fit all contents within 1 day with hands on practice.

In addition, the training center can be better prepared with the necessary software/hardware for the participants since this is an Excel training.

Finally, the refreshment and training environment is lackluster. (Posted on 11/16/2018)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Nil (Posted on 3/26/2018)
Might Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
More hands on of Dashboard and the designing (Posted on 9/12/2017)
Might Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Please print correct slides next time :D (Posted on 9/12/2017)

Write Your Own Review

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

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
  • Reload captcha
    Attention: Captcha is case sensitive.

You May Be Interested In These Courses

WSQ – Data Visualisation with Tableau

WSQ – Data Visualisation with Tableau

176 Review(s)
$688.00 (GST-exclusive)
$749.92 (GST-inclusive)
WSQ - Statistical Data Analysis with Excel for Beginners

WSQ - Statistical Data Analysis with Excel for Beginners

56 Review(s)
$350.00 (GST-exclusive)
$381.50 (GST-inclusive)
WSQ - Data Analytics and Visualization with Power BI

WSQ - Data Analytics and Visualization with Power BI

147 Review(s)
$800.00 (GST-exclusive)
$872.00 (GST-inclusive)
WSQ - Data Storytelling with Tableau

WSQ - Data Storytelling with Tableau

27 Review(s)
$688.00 (GST-exclusive)
$749.92 (GST-inclusive)
WSQ – Software Automation with Excel VBA Programming

WSQ – Software Automation with Excel VBA Programming

30 Review(s)
$688.00 (GST-exclusive)
$749.92 (GST-inclusive)
WSQ - Create Interactive Dashboard Using Excel

WSQ - Create Interactive Dashboard Using Excel

32 Review(s)
$350.00 (GST-exclusive)
$381.50 (GST-inclusive)