Call +65 61000613 Email: enquiry@tertiaryinfotech.com https://wa.me/6588666375

WSQ , IBF, SkillsFuture, PEI Approved Training Provider

Currency: SGD  
Menu

WSQ - Create Interactive Dashboard Using Excel

WSQ - Create Interactive Dashboard Using Excel

75 Review(s) | Add Your Review

Master the art of dashboard creation with our WSQ-endorsed course focused on using Excel for interactive data visualization. The course covers essential skills such as utilizing pivot tables, incorporating various data sources, and applying advanced Excel functions. With hands-on exercises and real-world examples, you'll gain practical know-how that can be immediately applied in your work or business.

Upon completing the course, you’ll be well-equipped to build interactive dashboards that provide a dynamic and user-friendly way to interpret complex data sets. Whether you're a business professional, data analyst, or someone interested in improving data presentation skills, this course sets the foundation for effective data visualization and decision-making through Excel dashboards.

Course Objectives

Learners will be able to develop basic develop dashboards to reflect data trends and findings using Excel

Learning Outcomes

By the end of the course, learners will be able to 

    • LO1: Perform data analysis and create visualization using Excel
    • LO2: Develop basic dashboards and scoreboards by incorporating appropriate visual elements.
    • LO3: Create interactive dashboard and communicate limitation of findings.

    Course Brochure

    Download WSQ - Create Interactive Dashboard Using Excel Course Brochure

    Skills Framework

    This course follows the guideline of Data Visualisation ICT-DIT-3006-1.1 TSC under ICT Skills Framework

    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.

    • OpenCerts from SkillsFuture Singapore - After passing the assessment(s) and achieving at least 75% attendance, participants will receive a OpenCert (aka Statement of Achievement) from SkillsFuture Singapore, certifying that they have achieved the Competency Standard(s) in the above Skills Framework.

    WSQ Funding

    WSQ funding is only applicable to Singaporeans and PR. Subject to eligibility, the funding support is subjected to funding caps.

    Effective for courses starting from 1 Jan 2024
    Full Fee GST Nett Fee after Funding (Incl. GST)
    Baseline MCES / SME
    $350 $31.50 $206.50 $136.50

    Baseline: Singaporean/PR age 21 and above
    MCES(Mid-Career Enhanced Subsidy): S'porean age 40 & above

    Upon registration, we will advise further on how to tap on the WSQ Training Subsidy.

    You can pay the nett fee (after the WSQ training subsidy) by the following :

    SkillsFuture Enterprise Credit (SFEC)

    Eligible Singapore-registered companies can tap on $10000 SFEC to cover out-of-pocket expenses.Click here to submit SkillsFuture Enterprise Credit

    SkillsFuture Credit (SFC)

    Eligible Singapore Citizens can use their SFC to offset course fee payable after funding but the $4,000 Additional SFC (Mid-Career Support) cannot be used. Click here for SkillsFuture Credit submission

    UTAP

    Eligible NTUC members can apply for 50% of the unfunded fee from UTAP, capped up to $250/year and for members aged 40 and above, capped up to $500/year. Click here to submit UTAP

    Course Code: TGS-2021010195

    Fee

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

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

    Course Date

    Course Time

    * Required Fields

    Course Information

    • Session (days): 1
    • Duration (hrs): 8
    • Level: Beginner
    • 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.
    • Venue:

      All courses except hydroponics courses:

      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.


      Hydroponics courses:

      MEOD Farm 13 Neo Tiew Harvest Ln, Singapore 719838

    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.

    Course Cancellation/Reschedule Policy

    • You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commerce.
    • 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

    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

    Final Assessment

    • Practical Performance (PP)
    • Oral Questioning (OQ)

    Course Info

    Promotion Code

    Promo or discount cannot be applied to WSQ courses

    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.

    Minimum Software/Hardware Requirement

    Software:

    You can download and install the following software:

    Hardware: Windows and Mac Laptops

    About Progressive Wage Model (PWM)

    The Progressive Wage Model (PWM) helps to increase wages of workers through upgrading skills and improving productivity. 

    Employers must ensure that their Singapore citizen and PR workers meet the PWM training requirements of attaining at least 1 Workforce Skills Qualification (WSQ) Statement of Attainment, out of the list of approved WSQ training modules.

    For more information on PWM, please visit MOM site.

    Funding Eligility Criteria

    Individual Sponsored Trainee Employer Sponsored Trainee
    • Singapore Citizens or Singapore Permanent Residents of age 21 and above
    • From 1 October 2023, attendance-taking for SkillsFuture Singapore's (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses.​
    • Trainee must pass all prescribed tests / assessments and attain 100% competency.
    • We reserves the right to claw back the funded amount from trainee if he/she did not meet the eligibility criteria.
    • Singapore Citizens or Singapore Permanent Residents who are DIRECT EMPLOYEE of the sponsoring company.
    • From 1 October 2023, attendance-taking for SkillsFuture Singapore's (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses.​
    • Trainee must pass all prescribed tests / assessments and attain 100% competency.
    • We reserves the right to claw back the funded amount from the employer if trainee did not meet the eligibility criteria.

     SkillsFuture Credit: 

    • Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding.

     PSEA:

    • To check for Post-Secondary Education Account (PSEA) eligibility, goto mySkillsFuture portal and search for this course code.
    • Scroll down to "Keyword Tags" to verify for PSEA eligibility.
    • If there is “PSEA” under keyword tags, the course is eligible for PSEA.  
    • And if there is no “PSEA” under keyword tags, the course is ineligible for PSEA. 
    • Not all courses are eligible for PSEA funding.

     Absentee Payroll (AP) Funding: 

    • $4.50 per hour, capped at $100,000 per enterprise per calendar year.
    • AP funding will be computed based on the actual number of training hours attended by the trainee.

     SFEC:

    • If the Training Provider has submitted an enrolment for course fee grant claim in Training Partners Gateway (TPGateway), SSG would be able to derive SFEC funding based on this record. There is no need for enterprise to submit any claim request and the SFEC claim will be automatically generated and disbursed.
    • Where there is no such record, eligible employers are required to submit an SFEC claim after course completion via the SFEC microsite.
    • SkillsFuture Enterprise Credit (SFEC) Microsite 

     

    Steps to Apply Skills Future Claim

    • The staff will send you an invoice with the fee breakdown.
    • Login to the MySkillsFuture portal, select the course you’re enrolling on and enter the course date and schedule.
    • Enter the course fee payable by you (including GST) and enter the amount of credit to claim.
    • Upload your invoice and click ‘Submit’

    SkillsFuture Level-Up Program

    The  SkillsFuture Level-Up Programme provides greater structural support for mid-career Singaporeans aged 40 years and above to pursue a substantive skills reboot and stay relevant in a changing economy. For more information, visit SkillsFuture Level-Up Programme

    Get Additional Course Fee Support Up to $500 under UTAP

    The Union Training Assistance Programme (UTAP) is a training benefit provided to NTUC Union Members with an objective of encouraging them to upgrade with skills training. It is provided to minimize the training cost. If you are a NTUC Union Member then you can get 50% funding (capped at $500 per year) under Union Training Assistance Programme (UTAP).

    For more information visit NTUC U Portal – Union Training Assistance Program (UTAP)

    Steps to Apply UTAP

    • Log in to your U Portal account to submit your UTAP application upon completion of the course.

    Note

    • SSG subsidy is available for Singapore Citizens, Permanent Residents, and Corporates.
    • All Singaporeans aged 25 and above can use their SkillsFuture Credit to pay. For more details, visit www.skillsfuture.gov.sg/credit
    • An unfunded course fee can be claimed via SkillsFuture Credit or paid in cash.
    • UTAP funding for NTUC Union Members is capped at $250 for 39 years and below and at $500 for 40 years and above.
    • UTAP support amount will be paid to training provider first and claimed after end of class by learner.

    Appeal Process

    1. The candidate has the right to disagree with the assessment decision made by the assessor.
    2. When giving feedback to the candidate, the assessor must check with the candidate if he agrees with the assessment outcome.
    3. If the candidate agrees with the assessment outcome, the assessor & the candidate must sign the Assessment Summary Record.
    4. If the candidate disagrees with the assessment outcome, he/she should not sign in the Assessment Summary Record.
    5. If the candidate intends to appeal the decision, he/she should first discuss the matter with the assessor/assessment manager.
    6. If the candidate is still not satisfied with the decision, the candidate must notify the assessor of the decision to appeal. The assessor will reflect the candidate’s intention in the Feedback Section of the Assessment Summary Record.
    7. The assessor will notify the assessor manager about the candidate’s intention to lodge an appeal.
    8. The candidate must lodge the appeal within 7 days, giving reasons for appeal 
    9. The assessor can help the candidate with writing and lodging the appeal.
    10. he assessment manager will collect information from the candidate & assessor and give a final decision.
    11. A record of the appeal and any subsequent actions and findings will be made.
    12. An Assessment Appeal Panel will be formed to review and give a decision.
    13. The outcome of the appeal will be made known to the candidate within 2 weeks from the date the appeal was lodged.
    14. The decision of the Assessment Appeal Panel is final and no further appeal will be entertained.
    15. Please click the link below to fill up the Candidates Appeal Form.

    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

    Terence Ee – Terence Ee is an experienced IT leader and ACLP-certified trainer with over 25 years of expertise in information systems, digital transformation, and enterprise technology. He has served as Chief Information Officer at the Supreme Court of Singapore and Vice President of Information Systems at Senoko Energy, where he implemented large-scale IT systems and streamlined data-driven workflows. As an independent consultant and trainer, Terence leverages his strong background in data management and reporting to help learners translate business data into actionable insights using Excel.

    In his Excel dashboard training, Terence focuses on practical, real-world applications. He guides learners in designing dynamic dashboards, applying advanced Excel functions, and using visualization techniques to support data-driven decision-making. With his wealth of executive-level experience, he ensures participants not only master technical Excel skills but also understand how to align dashboards with organizational reporting needs.

    Dr. Alvin Ang – Dr. Alvin Ang is an ACLP-certified trainer with a Ph.D. in Operations Research from Nanyang Technological University and extensive expertise in analytics, data science, and business intelligence. He has delivered courses in data visualization, Excel analytics, and dashboarding at universities and training institutions, alongside his work as a Data Science/AI trainer at Tertiary Infotech. With multiple IBM certifications in data analysis, Python, R, and visualization, Alvin brings a research-driven yet practical approach to data presentation.

    In his Excel dashboard training, Alvin emphasizes building interactive dashboards that combine statistical rigor with business relevance. He trains learners to use pivot tables, charts, and advanced Excel features to transform raw data into intuitive dashboards. By integrating case studies and hands-on exercises, he equips participants with the ability to design professional dashboards that support business insights and performance monitoring.

    Dwight Nuwan Fonseka – Dwight Fonseka is an ACLP-certified trainer and Head of Data Science at Plano Pte. Ltd., specializing in data visualization, predictive analytics, and dashboard creation. He has extensive teaching experience as a lecturer at LSBF and associate trainer at Tertiary Courses, delivering courses in R, Tableau, and interactive dashboarding. His expertise spans machine learning, R Shiny, and big data, giving him a strong foundation in presenting complex datasets through effective visual interfaces.

    In his Excel training, Dwight focuses on practical dashboard design for business and analytics applications. He teaches learners how to use Excel’s data management, pivot tables, and visualization tools to create clear, interactive dashboards. With his background in data science and visualization, he ensures participants learn both the technical skills and design principles needed to communicate insights effectively.

    Ken Hiong – Ken Hiong is an ACLP-certified trainer and Microsoft Office Specialist Master with advanced expertise in Excel, Access, and Power BI. With more than 15 years of experience as a trainer and business analyst in leading pharmaceutical and healthcare companies, Ken has mastered using Excel for financial modeling, P&L analysis, and interactive dashboard creation. His training experience includes delivering Excel and data analysis workshops for professionals across industries.

    In his Excel dashboard training, Ken emphasizes a structured, hands-on approach. He guides learners through data cleaning, pivot tables, VBA, and visualization techniques to build dynamic dashboards. With his strong corporate background, Ken ensures participants gain the skills to not only use Excel effectively but also to design dashboards that enhance reporting, performance tracking, and business decision-making.

    Customer Reviews (75)

    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 5/17/2024)
    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 5/1/2024)
    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/28/2024)
    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
    . (Posted on 2/28/2024)
    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 2/28/2024)
    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
    . (Posted on 2/28/2024)
    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 2/28/2024)
    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
    . (Posted on 2/28/2024)
    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
    Very rushed. (Posted on 5/15/2023)
    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/28/2023)
    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 practice to be provided (Posted on 4/28/2023)
    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
    Have details instruction manual (Posted on 4/28/2023)
    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
    . (Posted on 4/24/2023)
    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/24/2023)
    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
    Include simple project management dashboard as a case study (Posted on 4/24/2023)
    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 1/31/2023)
    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 12/7/2022)
    might recomend 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
    No comments. Satisfied with what i have learnt with a physical trainer. (Posted on 12/6/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
    . (Posted on 11/7/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
    I attended Dr Alvin Ang's NICF - Create Interactive Dashboard Using Excel. He was able to break things down so that they are understandable, and always keeping it light and engaging. He adjusted the pace of the class according to the students' abilities. (Posted on 11/1/2022)

    Items 41 to 60 of 75 total

    per page
    Page:
    1. 1
    2. 2
    3. 3
    4. 4

    Write Your Own Review

    You're reviewing: WSQ - Create Interactive Dashboard Using Excel

    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

    You May Be Interested In These Courses

    WSQ - Data Visualisation with Tableau

    WSQ - Data Visualisation with Tableau

    375 Review(s)
    $750.00 (GST-exclusive)
    $817.50 (GST-inclusive)
    WSQ - Data Analytics and Visualization with R

    WSQ - Data Analytics and Visualization with R

    42 Review(s)
    $750.00 (GST-exclusive)
    $817.50 (GST-inclusive)
    WSQ - Statistical Data Analysis with Excel for Beginners

    WSQ - Statistical Data Analysis with Excel for Beginners

    71 Review(s)
    $350.00 (GST-exclusive)
    $381.50 (GST-inclusive)
    WSQ - Data Storytelling with Tableau

    WSQ - Data Storytelling with Tableau

    41 Review(s)
    $750.00 (GST-exclusive)
    $817.50 (GST-inclusive)
    WSQ - Software Automation with Excel VBA Programming

    WSQ - Software Automation with Excel VBA Programming

    89 Review(s)
    $750.00 (GST-exclusive)
    $817.50 (GST-inclusive)
    About Us

    Tertiary Infotech Academy, established in 2012, is a leading skills-based training provider dedicated to supporting Singapore’s Industry 4.0 transformation. We are a registered Private Education Institute (PEI), offering Diploma and Advanced Certificate programs in Cyber Security and Artificial Intelligence.

    As a strong advocate for professional and lifelong learning, we are a WSQ and IBF Approved Training Organisation (ATO). We also serve as an Authorized Training Partner for major global technology and certification bodies, including Microsoft, CompTIA, AWS, Pearson VUE, Autodesk, Linux Foundation.

    In addition, our academy is both a Pearson VUE, Kryterion, PSI Authorized Test Centers enabling learners to access industry-recognized examinations in a convenient and professional environment.

    Training Grants and Subsidies

    WSQ: Company and Singaporeans/PR can apply WSQ 70-90% funding depending on eligibility
    SkillsFuture Enterprise Credit (SFEC) - Eligible Singapore-registered companies can tap on $10000 SFEC to cover up to 90% of out-of-pocket expense
    SkillsFuture Credit: All Singaporeans aged 25 and above can use their $500 SkillsFuture Credit from the government to pay for a wide range of approved skills-related courses.
    IBF-STS Companies and Singaporeans/PR can apply IBF-STS 70-90% funding depending on eligibility
    UTAP: NTUC members enjoy 50% subsidy for unfunded course fee support for up to $250 each year when you sign up for courses supported under UTAP
    PSEA: Individual can pay using using their Post Secondary Education Account

    Authorised Training Partners
    1

    Microsoft Learning Partner

    2

    CompTIA Authorised Delivery Partner

    3

    Linux Foundations Authorised Training Partner

    4

    AWS Authorised Training Partner (Reseller)

    5

    Autodesk Authorised Training Center

    6

    Pearson Vue Authorised Training Partner

    Authorized Testing Centers
    1

    Pearson VUE Authorised Test Center

    2

    Kryterion Authorized Testing Center

    3

    PSI Authorized Testing Center

    Approved Training Organizations
    1

    WSQ Approved Training Organization

    2

    Institute of Banking & Finance (IBF) Approved Training Provider

    3

    Singapore Chartered Accountant (SAC) Accredited Training Organisation

    4

    Approved Private Educational Insitutes (PEI)

    Approved Suppliers
    1

    GeBiz Registered Supplier

    Regional Training Centers
    1

    Singapore (Headquarter)

    2

    Malaysia Kuala Lumpur and Penang

    3

    Bhutan

    4

    India

    5

    Ghana Accra

    6

    Nigeria Lagos

    Contact Us Information

    +65 6100 0613

    whatsapp

    https://wa.me/6588666375

    Tertiary Courses SG Telegram

    Telegram

    Tertiary Courses SG AI Chatbot

    AI Chatbot

    Tertiary Courses SG GPT

    Tertiary Courses SG GPT

    enquiry@tertiaryinfotech.com

    Training Centers venue :
    12 Woodlands Square, #07-85/86/87, Woods Square Tower 1, Singapore 737715 (Disabled-Friendly) .

    Mailing address:
    12 Woodlands Square, #07-86, Woods Square Tower 1, Singapore 737715

    Information
    Enquires
    Training Grant and Subsidy
    Our Websites
    Certified Trainers

    Copyright © 2025. Tertiary Infotech Academy Pte Ltd. ROC/GST #: 201200696W. All Rights Reserved.