Home
WSQ - Data Analytics with Excel

WSQ - Data Analytics with Excel

Unleash the power of Excel in data analytics with our comprehensive, WSQ-endorsed course. From basic data manipulation and formulas to advanced techniques like pivot tables and data visualization, this course offers a full spectrum of skills. Practical exercises and real-world case studies ensure that your learning is rooted in applicability, equipping you with the tools to analyze large datasets and generate actionable insights.

By the end of this course, you’ll be proficient in using Excel for various data analytics tasks. You'll know how to clean, analyze, and visualize data, and you'll be adept at using Excel's advanced features to streamline your analytics process. Whether you're a business analyst, a data enthusiast, or someone aiming to make better data-driven decisions, this course prepares you for the challenges of today’s data-centric world.

Learning Outcomes

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

LO1: Extract and validate data using Excel and Power Query
LO2: Apply basic data analytical techniques using Excel
LO3: Generate reports to identify trend and risk using Excel
LO4: Apply advanced data analytical tools available in Excel
LO5: Perform hypothesis testing using Excel

Skills Framework

This course follows the guideline of Data Analytics ACC-ICT-3003-1.1 TSC under Accountacny Skills Framework

Course Brochure

Download WSQ - Data Analytics with Excel 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.
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
$720	$64.80	$424.80	$280.80

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 up 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

PSEA

To check for Post-Secondary Education Account (PSEA) eligibility for this course, Visit SkillsFuture (course code: TGS-2022014978)

Scroll down to “Keyword Tags” to verify for PSEA eligibility.
If there is “PSEA” under keyword tags, the course is eligible for PSEA.

Once you are eligible for PSEA, please download and fill up the PSEA Withdrawal Form and email to us.

Course Code: TGS-2022014978

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: Getting Started with Excel

Explore Excel user interface
Enter and validate data for analysis using Excel Power Query
Data management with Excel
Use formulas and functions

Topic 2: Basic Data Analysis using Excel

Use LOOKUP and REFERENCE functions to integrate information
Use IF functions to analyse data
Basic statistics and use statistical functions

Topic 3: Basic Data Visualisation using Excel

Create chart and reports to identify trends in data
What is regression?
Create reports on regression and risk analysis

Topic 4: Advanced Data Analysis using Excel

Use PivotTables and PivotCharts to identify patterns across multiple datasets
Perform what-if analysis using Scenario Manager, Goal Seek and Data Table
Data governance and security with Excel

Topic 5: Hypothesis Testing with Excel

What is hypothesis testing?
Apply hypothesis testing techniques in Excel

Final Assessment

Written Assessment - Short Answer Questions (WA-SAQ)
Practical Performance (PP)

Course Info

Promo or discount cannot be applied to WSQ courses

Prerequisite

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

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

The candidate has the right to disagree with the assessment decision made by the assessor.
When giving feedback to the candidate, the assessor must check with the candidate if he agrees with the assessment outcome.
If the candidate agrees with the assessment outcome, the assessor & the candidate must sign the Assessment Summary Record.
If the candidate disagrees with the assessment outcome, he/she should not sign in the Assessment Summary Record.
If the candidate intends to appeal the decision, he/she should first discuss the matter with the assessor/assessment manager.
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.
The assessor will notify the assessor manager about the candidate’s intention to lodge an appeal.
The candidate must lodge the appeal within 7 days, giving reasons for appeal
The assessor can help the candidate with writing and lodging the appeal.
he assessment manager will collect information from the candidate & assessor and give a final decision.
A record of the appeal and any subsequent actions and findings will be made.
An Assessment Appeal Panel will be formed to review and give a decision.
The outcome of the appeal will be made known to the candidate within 2 weeks from the date the appeal was lodged.
The decision of the Assessment Appeal Panel is final and no further appeal will be entertained.
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

Liew Sing Loon: Liew Sing Loon is an ACLP-certified trainer with strong expertise in data analysis, reporting, and business operations. With years of professional and training experience, he has taught a wide range of WSQ and corporate courses, focusing on data handling, visualization, and analytics for decision-making. His combined background in technical training and business applications allows him to make Excel analytics practical and industry-relevant for learners.

In his Excel training, Liew emphasizes the use of core Excel functions, pivot tables, charts, and formula-based analysis to transform raw data into meaningful insights. He ensures beginners and professionals alike can build confidence in using Excel for day-to-day reporting and business decision support. By combining hands-on exercises with real-world examples, he equips learners with the tools to apply analytics in their own workplace contexts.

Ken Hiong: Ken Hiong is an ACLP-certified trainer and Microsoft Office Specialist Master with deep expertise in Excel, Access, and Power BI. With over 15 years of corporate experience as a Business Analyst in the pharmaceutical industry (Pfizer, SciGen), he has used Excel extensively for financial modeling, P&L analysis, forecasting, and interactive dashboards. His training background includes delivering advanced Excel and analytics workshops for professionals across industries.

In his Excel training, Ken emphasizes a structured, hands-on approach. He guides learners through advanced Excel functions, pivot tables, VBA, and dashboard design, ensuring they can automate tasks and analyze data effectively. By blending technical depth with his corporate background, Ken helps participants develop practical Excel skills that improve productivity and reporting accuracy in their workplace.

Dwight Nuwan Fonseka: Dwight Fonseka is an ACLP-certified trainer and Head of Data Science at Plano Pte. Ltd., with extensive teaching experience in R, Tableau, and data visualization. As an adjunct lecturer at LSBF and a course coordinator for the Diploma in Data Analytics, he has taught both technical and business audiences to apply data analytics effectively. His expertise in predictive modeling and dashboard creation translates into a practical, analytics-driven approach to Excel training.

In his Excel analytics courses, Dwight focuses on using Excel as a stepping stone to advanced analytics. He trains learners in data preprocessing, formula application, and visualization techniques, ensuring they can derive insights and communicate findings clearly. With his strong background in data science, he equips participants to use Excel not only for reporting but also as a foundation for deeper analytics workflows.

Dr. Alvin Ang: Dr. Alvin Ang is an accomplished data analytics and artificial intelligence expert with over 20 years of experience in data-driven decision-making, automation, and business intelligence. As CTO and Chief Instructional Designer at Tertiary Infotech, he has led the development of over 500 accredited programs in AI, data analytics, and emerging technologies. His strong background in data visualization, predictive analytics, and quantitative modeling enables him to bridge technical expertise with practical business applications. Dr. Ang has trained professionals across finance, manufacturing, and education sectors, empowering them to leverage analytics for performance improvement and strategic insight.

In “Data Analytics with Excel,” Dr. Ang focuses on helping learners transform raw data into actionable insights using Excel’s advanced analytical tools. His sessions cover data cleaning, visualization, pivot analysis, and statistical modeling, emphasizing real-world applications across industries. By combining analytical theory with practical techniques, he equips participants to use Excel as a powerful decision-support tool for reporting, forecasting, and business optimization.

Jim Gan Chiu Liang: Jim Gan is a data analytics and business intelligence specialist with extensive experience in financial reporting, process automation, and dashboard development. With a strong foundation in Excel, Power BI, and SQL, he has designed and implemented analytics solutions that improve data accuracy, reporting efficiency, and business performance tracking. His corporate experience spans roles in financial analysis, data visualization, and systems integration, where he has worked with organizations to enhance their data literacy and analytical capabilities.

In “Data Analytics with Excel,” Jim teaches participants how to apply Excel’s analytical functions to organize, interpret, and visualize business data effectively. His sessions emphasize hands-on learning in areas such as dynamic charting, Power Query, and data modeling. By focusing on workflow efficiency and problem-solving, he helps learners develop the analytical mindset and technical proficiency needed to make data-driven decisions confidently in their professional environments.