2 days – Data Analytics using Excel 365, 2021 – level 3

2 days – Data Analytics using Excel 365, 2021 – Level 3 (TGS-2023019361)

Course Duration

16 Hours

Target Audience

Design for learner to use Excel to do correlation, regression analysis on variables, for prediction. Using moving average and forecast functions to project forecast.

Certification

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

Entry Requirement

Minimum 1 year of working experience (know how to use Excel pivot tables, basic excel graphs)
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.

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

• Practical Statistics functions
• Combine data from different sources, into a useful dataset
• Use Power Query functions to extract files, formulas
• Manage data with Pivot Table and Advanced Pivot Table e.g. average, StdDev, Show value as
• Histogram, Boxplot, IQR
• Correlations, Linear Regression, Moving Average, Forecast

Price: 520

Duration: 16

Visit the SkillsFuture Credit website Proceed to submit a claim.

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

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

MOE will be replacing the hardcopy “Adhoc Application for use of Post-Secondary Education (PSE) Account” with FormSG by 15^th March 2023. visit the website https://form.gov.sg/62ac035f3c3b210013f6cd90 to apply for PSEA Funding or If you intend to also use sibling’s PSEA, please go to https://go.gov.sg/psea-so-sibling

All Courses

Course Finder

2 days – Data Analytics using Excel 365, 2021 – level 3

Main Office

Bedok Branch

Jurong Branch