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 |
|
|
|
SkillsFuture Credit:
PSEA:
|
Absentee Payroll (AP) Funding:
SFEC:
|
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
- 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.
Customer Reviews (233)
- will recommend Review by Course Participant/Trainee
-
/ (Posted on 3/19/2023)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 - will recommend Review by Course Participant/Trainee
-
. (Posted on 3/19/2023)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 - will recomend Review by Course Participant/Trainee
-
Appreciate with thanks (Posted on 3/19/2023)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 - will recommend Review by Course Participant/Trainee
-
can give more data sample as reference (Posted on 2/19/2023)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 - will recommend Review by Course Participant/Trainee
-
. (Posted on 2/19/2023)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 - will recommend Review by Course Participant/Trainee
-
This course gives a good overall of the power of excel. 2 days courses are very pack and tight so if want to go detail, need more time and practices. So it is a good start and you decide whether go deeper (Posted on 2/19/2023)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 - will recommend Review by Course Participant/Trainee
-
. (Posted on 2/19/2023)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 a great trainer. V Review by Course Participant/Trainee
-
Dr. Alvin Ang was a great trainer. Very knowledgeable & class was conducted in an interesting way. A bit too short to cover all the topics. Could be split into basic or advance data analytics class. (Posted on 2/19/2023)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 is very knowledgeable, friendly & very clear in deliver his explanation Review by Course Participant/Trainee
-
Dr. Alvin is very knowledgeable, friendly & very clear in deliver his explanation. Totally not feel bored at all attending his class, as he also put a lot of efforts to let us always engage & participate in the class. (Posted on 2/19/2023)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 trainer, Alvin is good and conduct very valuable training Review by Course Participant/Trainee
-
The trainer, Alvin is good and conduct very valuable training (Posted on 2/19/2023)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 - might recommend Review by Course Participant/Trainee
-
Understand the knowledge level across the students before putting them into the same class so that it will not slow down the progression of the lesson (Posted on 2/19/2023)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 - will recommend Review by Course Participant/Trainee
-
Overall, good class and teachings.It would be great if this can be spread into three days (Posted on 2/19/2023)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 - might recommend Review by Course Participant/Trainee
-
, (Posted on 2/8/2023)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 instructor is good and patient to teach us, Review by Course Participant/Trainee
-
I think this course is not at all suitable for a 2 days period. Trainer tried his best to squeeze in everything in these 2 days. That resulting in a very tiring long Day!!! We only had literally 5 mins break in the morning and another 5 mins break in the afternoon. Followed by 1 hour lunch that also at the 50th minute, trainer wanted to start first. I think this course is not suitable for virtual and face-face session at one go, as it waste time of the participants. I also do not know why the instructor needs to do one on one session which participant and end up I only just ended at 6.53pm and 2 more participants are still waiting to be assessed one by one. This is not practical. Day 1 also the class ended at 6.20pm. The instructor is good and patient to teach us, but please do not squeeze this lesson into 2 Days, it is totally so tiring, draining and not practicable!!!!!!! (Posted on 2/7/2023)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 - will recommend Review by Course Participant/Trainee
-
Make it longer as too may tools to digest within short period of time. (Posted on 2/7/2023)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 - might recommend Review by Course Participant/Trainee
-
The break is not sufficient. Courses are naturally tiring.... We only have 5 mins break in the morning half, 1 hour lunch and another 5 mins break for the afternoon half. (Posted on 2/6/2023)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 - will recommend Review by Course Participant/Trainee
-
Increase training to more days (Posted on 1/11/2023)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 - will recommend Review by Course Participant/Trainee
-
Increase training to more days (Posted on 1/10/2023)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 - will recommend Review by Course Participant/Trainee
-
. (Posted on 1/10/2023)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 - will recommend Review by Course Participant/Trainee
-
. (Posted on 1/10/2023)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








