Workplace Productivity using Excel – Intermediate Level
About This Course
In the current competitive era, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. The world runs on data more than ever before and that’s a trend not likely to change, or even slow down anytime soon. Therefore the ability to make sense of data becomes more critical and challenging with every passing day.
This course builds upon the foundational knowledge presented in Workplace Productivity using Excel (Basic level) and will help start you down the road to creating intermediate and advanced level workbooks and worksheets that can help deepen your understanding of organisational intelligence. The ability to analyse massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organisation that is able to compete at a high level.
What You'll Learn
1. Use Microsoft Excel Functionalities.
2. Apply lists functionalities to interpret data categorization into areas for process improvement.
3. Use Conditional Formatting to enhance quality data collected by scrubbing and removing duplicates.
4. Implement Lookup Functions and Formula Auditing to enhance the quality collected data.
Entry Requirements
Education Level:
• Minimum: Primary Level
• Language: Workplace Literacy and Numeracy Level 2 (WPLN: Speaking, Writing, Listening, reading, and Numeracy at ESS level 2).
Pre-requisites:
• Basic understanding in using Microsoft Excel.
Working Experience:
• Recommended to have some working experience.