2 days – Office 365 – Excel 2021 and Data Analytics – level 1(TGS-2023018777) |
Course Objectives
Able to understand how Excel functions manage data, and out-put data reports and charts. Able to collect data, gather data from system and external sources. Identify the Dataset that can provide the necessary information to answer the business questions. Understand how business statistics helps in business decisions.
Course Duration
16 Hours
Mode of Training
Classroom Learning
Target Audience
Design for learners who want to learn how Excel functions manage data, and out-put data reports and charts.
Certification
Successful trainees will receive a Statement of Attainment (SOA) issued by SSG
Entry Requirement
- Minimal education qualification is PSLE with 1 year of relevant working experience
- Speak, listen and read English at a proficiency level not lower than the WPL Level 3, and
manipulate numbers at a not lower than the WPN Level 3.
At the end of the course participants will be able to:
• Work with Excel environment and save them in different file formats
• Enter data into cells, understand data types, apply basic formatting to numbers and text
• Apply formulas to compute, Understanding how Cell Reference is used in formulas
• Lookup functions to find values in a dataset, work in Excel Tables
• Charts, Page Layout, Views, Report Output
• Types of Errors and how to handle them
• Data Analysis, Data Types, Business Statistics