Data Analytics with Excel (Intermediate): Turning Numbers into Insights
About This Course
This course is designed to equip learners with the knowledge and skills to effectively utilize Excel in order to support business efficiency and support decision making. As we navigate through this course, learners will gain understanding of the syntax and parameters to apply Excel functions.
The benefits of completing this course for the learners:
• Gain a competitive advantage over their peers by being able to apply Excel functions and features to effectively manipulate data for efficiency
• Equip learners within the knowledge to use Excel in order to make informed decisions and improve productivity.
• Identify suitable Excel functions and features to address business issues.
• Be well-versed in Excel function syntax and features to maintain data integrity
• Understand how to collaborate securely using Excel features
This course is for intermediate to advanced level and is suitable for working professionals with little knowledge of Excel and is keen to expand their knowledge to enhance their productivity at the work.
What You'll Learn
In this course, learners will learn the following:
• Grasp the basic logic, syntax and execution of various Excel functions and features to effectively manage data
• Acquire the knowledge to apply functions and features to securely collaborate Excel spreadsheets.
• Understand how to use functions and features for data validation to ensure data integrity
Entry Requirements
• Be able to listen and speak English at a proficiency level equivalent to the Employability Skills Workforce Skills Qualifications (“ES WSQ”) Workplace Literacy (“WPL”) level 3.
• Be able to read and write English at a proficiency level equivalent to ES WSQ WPL level 3.
• Be able to manipulate numbers at a proficiency level equivalent to ES WSQ Workplace Numeracy (“WPN”) level 3.
• Learners have minimum GCE ‘O’ level or ITE certificate education or equivalent.
• Learners should have at least 1 year’s working experience in any industry.
• Be able to operate a computer.