Advanced Excel 2021 and Data Analytics – level 2

Course Objectives

Able to use intermediate to advanced Excel functions, formulas and charts. Able to get from different data source and combine into useful dataset. Able to remove duplicates data, unpivot data, and keep relevant data for analysis. Able to group data into category and using Pareto analysis to problem solve and improve processes.

Course Duration

24 Hours

Mode of Training

Classroom

Target Audience

Design for learners who want to learner to use intermediate to advanced Excel functions

Certification

Successful trainees will receive a Statement of Attainment (SOA) issued by SSG

At the end of the course participants will be able to:

• Empower learner to use intermediate to advanced excel formulas and functions, to handle company’s data
• Get data from data source and prepare dataset for analysis
• Clean, transform, and shape data for analysis
• Identify root cause for problems, Categorise problems, Pareto Analysis to improve processes

Entry Requirement

  • Minimum 1 year of working experience (with preference in using Excel)

  • Speak, listen and read English at a proficiency level not lower than the WPL Level 4, and manipulate numbers at a not lower than the WPN Level 4.

  • Minimal education qualification is GCE ‘O’ Level, GCE ‘N’ Level or ITE certificate.

Eligible for Claim Period: 14 Feb 2023 – 13 Feb 2027

All fees are subject to prevailing GST of 9% (2024)

Visit the SkillsFuture Credit website Proceed to submit a claim.

Participant need to pass the test to get subsidy

SSG Advice:
Student must achieve 75% course attendance, and also pass the assessment to be eligible for SSG Funding.

All Singaporean aged 25 and above can use their $500 SkillsFuture Credit to pay for a wide range of approved skills-related courses.

Please refer to the below link for the Refund Table for SkillsFuture Courses:

https://www.genetic.edu.sg/refund-for-skillsfuture-courses/

PSEA Funding is available for student aged 18-30 years old (Please call PSEA Hotline 62600777 to check your balance).

We are pleased to share the the following information on the new PSEA Ad hor Withdrawal FormSG Application:

Using only own PSEA:

http://go.gov.sg/psea-withdrawal-tp

Using Sibling’s PSEA:

http://go.gov.sg/psea-withdrawal-tps

Advanced Excel 2021 and Data Analytics – level 2

Enroll Classes

Our staff will contact you on admission matters afterwards.