• Home
  • Statistical Data Analysis Training with Excel

Statistical Data Analysis Training with Excel

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 Courses - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Courses.

Statistical Data Analysis Training with Excel

Course Code: C201

62 Review(s) | Add Your Review

What's This Course About

Embrace the power of Excel in the realm of statistical data analysis with our specialized training. This course covers a wide array of topics from fundamental statistical concepts, hypothesis testing, to advanced methods like Bayesian probability analysis and simulation. With hands-on experience, learners will become proficient in using the Excel Data Analysis Tool, enabling them to handle large data sets efficiently and with precision.

Additionally, topics like correlation analysis, analysis of variance, and regression are meticulously explained, ensuring participants are well-equipped to draw meaningful conclusions from complex datasets. Whether you're an analyst, student, or a professional looking to enhance your data interpretation skills, this training is a pivotal step in your journey to becoming a data-driven decision maker.

Funding Options

For WSQ funding, please checkout the details at WSQ - Statistical Data Analysis with Excel for Beginners

Course Fee

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

Course Date

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

Why Statistics Matter

Types of Data

Descriptive Statistics

Probability and Conditional Probability

Probability Distributions

Install Excel Data 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

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: 21-65 years old

Minimum Software/Hardware Requirement

Software:

You can download and install the following software:

Hardware: Windows and 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 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.

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.

Liew Sing Loon is a ACTA certified trainer. Liew Sing Loon graduated from the National University of Singapore (NUS) in 1992 with a Second Upper Honors Degree in Electrical Engineering. He started his career as an Electronic Product Design Engineer for four years in a Multinational Company which sell the products worldwide. The job provided him practical knowledge in various aspects of manufacturing operations ranges from Design, Quality, Production and Procurement. He then spent fifteen years in Information Technology Sector as a Key Account Manager in selling IT solutions to Banking, Telecommunications and Government clients. The job provided him the opportunities to propose IT solutions, integrating software, hardware and services, to solve customers’ problems to achieve their strategic business objectives. He joint a German Product Test company to develop its business in providing product Safety, Immunity, Electromagnetic Compatibility (EMC) Certification test. While working in the industry, Liew Sing Loon obtained a Master of Science (MSc) in Technology Management from NUS.
In the last decade, Liew Sing Loon has been Adjunct Lecturer in several Institutes of high learning, transferring his knowledge on Quantitative & Statistical Analysis, Operations, Project & Quality Management to learners ranging from Diploma, full time undergraduates and working adults.Liew Sing Loon has a Certificate of Completion in Education Psychology Course and Teaching & Learning in Higher Education Program conducted by National Institute of Education (NIE).

Review

Customer Reviews (62)

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/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
Free refreshement (Posted on 9/14/2022)
Dr Alvin Ang was very good teaching this course and taught alot of application of the skills 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
Dr Alvin Ang was very good teaching this course and taught alot of application of the skills (Posted on 6/9/2022)
Too 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
Alvin is a great trainer with a wide spectrum of knowledge and experiences to share. He made everything simple and easier to understand. He made learning fun again. We need more trainers like Alvin. Looking forward to attending more training by Alvin. (Posted on 5/4/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 1/7/2022)

Items 6 to 10 of 62 total

per page
Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. ...
  7. 13

Write Your Own Review

You're reviewing: Statistical Data Analysis Training with 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