Course Information

  • Sessions 1 day
  • Duration 8 hrs
  • Level Beginner
  • Assessment 1 hr

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.

Skills Framework

TSC Title
Data and Statistical Analytics
TSC Code
PTP-BIN-4055-1.1

Funding Validity

The last SSG support period ran from 1 Sep 2020 to 31 Aug 2026. Registration is closed until SSG confirms a current support period and publishes a future course run.

Learning Outcomes

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

  • LO1: Perform data analysis with descriptive statistics, probability theory and probability distributions.
  • LO2: Perform data analysis with sampling theory and hypothesis tastings.
  • LO3: Perform data analysis with regression and correlation analysis.

Course Brochure

Certification

  • Certificate of Achievement from Tertiary Infotech Academy Pte Ltd - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Achievement from Tertiary Infotech Academy Pte Ltd.
  • 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 - Statistical Data Analysis with Excel for Beginners

Course Code: TGS-2020505317
Registration temporarily unavailable This course renewal is being processed by SkillsFuture Singapore. Registration will reopen after approval and a new course run is published.
Share

What's This Course About

Kickstart your journey into the world of data analytics with our WSQ-endorsed course on Statistical Data Analysis with Excel for Beginners. This course is tailored for those who are new to data analysis, covering foundational topics like basic statistical formulas, data sorting, and introductory data visualization. Through practical exercises and real-world case studies, you’ll learn how to use Excel to process and interpret data in a meaningful way.

Upon completing the course, you’ll have the basic skills needed to handle datasets and perform statistical analysis in Excel. You’ll be equipped to create basic charts, apply statistical formulas, and interpret data for decision-making purposes. This course serves as a stepping stone for anyone looking to make more informed decisions based on data, be it in a professional setting or for personal projects.

Course FeeBefore Funding

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

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: Basic Statistics

Why Statistics Matter

Types of Data

Descriptive Statistics

Probability and Conditional Probability

Probability Distributions

Install Excel Statistical Analysis ToolPak

Topic 2: Sampling and Hypothesis Testing

Sampling

Central Limit Theorem

Sampling Distribution and Standard Errors of Sample Mean

Confidence Interval

Z and T Statistics

Overview of Hypothesis Testing

Types of Hypothesis Testing

Type 1 and Type 2 Errors

Analysis of Variance (ANOVA)

Topic 3: Regression and Correlation Analysis

Regression Modeling

Residues and Mean Square Error

Covariance and Correlation Analysis

Assessment

  • Practical Exam
  • Oral Questioning

Course Info

Minimum Entry Requirement

Knowledge and Skills

  • Able to operate using computer functions with minimum Computer Literacy Level 2 based on ICAS Computer Skills Assessment Framework
  • 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 18 years old

Minimum Software/Hardware Requirement

Software:

You will need the following for this course:

Hardware: Windows PC or Mac laptop

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

Dr. Alvin Ang is a data scientist and data science educator with a PhD in Operations Research, an MSc in Logistics and a BEng in Mechatronics, Robotics and Automation Engineering, all from Nanyang Technological University. Operations research is the mathematics of better decisions, and his published work on Kanban production-control systems at IEEE conferences reflects the quantitative rigour he brings to every class. He has served as an IBM Data Science Instructor, a Research Fellow at NUS, a Principal Consultant in data science and an Assistant Professor of Mathematics at SP Jain School of Global Management, where he was named Mathematics Professor of the Year, and he lectured undergraduates in statistics and quantitative methods at SUSS. Since 2021 he has trained professionals at Tertiary Infotech in Python, R, SQL, statistics, Excel analytics, Tableau, Power BI, Apache Spark, machine learning and deep learning, and he founded DataFrens.sg, a community for data scientists in Singapore. An ACLP-certified adult educator, he is known for connecting technical concepts to practical, real-world applications, a strength echoed in hundreds of learner recommendations.

In WSQ - Statistical Data Analysis with Excel for Beginners, Dr. Ang draws on years of lecturing statistics and quantitative methods to make statistical analysis approachable in Excel. Learners describe data, apply probability and sampling, run hypothesis tests, correlation and regression, and visualise results, with clear explanations of what each result means for a business decision.

Tan Khiang Meng is a seasoned data analytics and business intelligence professional with extensive experience in applying statistical methods for performance tracking and operational optimization. With a strong background in Microsoft Excel, data modeling, and visualization, he has guided organizations in using descriptive and inferential statistics to make informed decisions. Over the past two decades, he has trained professionals across industries on data literacy, reporting automation, and analytical thinking, emphasizing clarity and precision in data interpretation.
Jim Gan Chiu Liang is an experienced software developer and data automation specialist with over 15 years of experience in designing and implementing Microsoft Excel VBA solutions for business process optimization. His expertise lies in developing automated workflows, interactive dashboards, and complex financial models that reduce manual workload and improve data accuracy. Jim has worked with organizations across finance, logistics, and education sectors, helping them leverage Excel’s advanced programming capabilities to drive efficiency and decision-making.
Dwight Nuwan Fonseka is Head of Data Science at Plano Pte. Ltd. and an ACLP-certified trainer with deep expertise in data analytics, machine learning, and AI applications. He has extensive hands-on experience developing predictive models, RShiny dashboards, and deep learning solutions using R, Python, TensorFlow, and Keras. With a strong professional background in healthcare, finance, and customer analytics, Dwight brings an applied perspective to teaching AI, focusing on both the opportunities and risks of emerging technologies.

Liew Sing Loon is an ACLP-certified trainer with strong expertise in adult education, workplace learning, and applied quantitative methods. With years of experience designing and delivering WSQ-aligned programs, he has trained professionals across diverse sectors in the application of statistical and analytical tools. His background in instructional design enables him to simplify complex statistical concepts, making them approachable and practical for beginners.
In his Excel-based statistical training, Liew focuses on building learner confidence in using spreadsheets for data analysis. He covers descriptive statistics, data visualization, hypothesis testing, and regression analysis using Excel’s built-in functions and add-ins. By emphasizing hands-on practice and workplace applications, Liew ensures participants gain both the conceptual understanding and the practical skills to apply statistical techniques effectively in business and decision-making contexts.

Review

Customer Reviews (74)

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/8/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
Concise and easy to understand (Posted on 4/25/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 activities (Posted on 3/31/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
Need to make sure course slide examples and Google Classroom content sync (Posted on 3/31/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 3/4/2021)

Items 66 to 70 of 74 total

per page
Page:
  1. 1
  2. ...
  3. 11
  4. 12
  5. 13
  6. 14
  7. 15

Write Your Own Review

You're reviewing: WSQ - Statistical Data Analysis with Excel for Beginners

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