Data Analytics with Excel (Advanced): Master Complex Data Challenges
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 perform statistical analysis of data
• Equip learners within the knowledge to use Excel in order to make informed decisions and improve productivity by looking at patterns and trends.
• Identify suitable Excel functions and features to address business issues.
• Be well-versed in Excel function syntax and features to perform what-if analysis using scenarios
This course is for advanced level learners and is suitable for working professionals with at least intermediate knowledge of Excel and is keen to expand their knowledge to enhance their data analysis skills at the work for effective decision making..
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 perform statistical analysis of datasets
• Acquire the knowledge to apply functions and features to identify data trends and patterns to support decision making
• Understand how to use functions and features perform what-if analysis using scenarios and data tables.
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 to 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.