2 days – Data Analytics using Excel 365, 2021 – Level 3 (TGS-2023019361) |
Course Objectives
Able to use Excel to do correlation, regression analysis on variables, for prediction. Using moving average and forecast functions to project forecast.
Course Duration
16 Hours
Mode of Training
Classroom
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