Workplace Productivity using Excel – Advanced Level
About This Course
Microsoft Excel skills have been mentioned numerous times as a crucial requirement for organisations that use Microsoft Excel to record important data and perform related data analysis to help the organisation to perform effectively and efficiently. Those who work in an organisation that uses Microsoft Excel on their daily tasks need to master advanced-level of Microsoft Excel skills as such they can perform the required analysis and reporting in a short time.
In this course, we will equip the learners with the skills and knowledge needed to understand common statistical techniques used in the workplace, understand the types of statistical software suitable for their organisation, perform data visualisation, apply PivotTables and PivotCharts, work in collaboration with multiple worksheets & workbooks, and automate workbook functionalities to improve the learners’ data management, data analysis, and reporting for efficient operation management. These competencies will improve learners' data management, data analysis, and reporting for more efficient operations management, helping them deliver better data insights and visualisations to support their career progression.
What You'll Learn
1. Implement Basic Operations of Statistical Techniques in Microsoft Excel.
2. Analyse Data using Data Visualisation Techniques to identify trends and patterns.
3. Implement Regression Analysis to identify trends and patterns.
4. Apply PivotTables and PivotCharts to improve data analysis to identify trends and patterns.
5. Collaborate with various stakeholders by working with multiple worksheets and workbooks to identify data for further analysis.
6. Collaborate with various stakeholders by implementing workbook automation to identify data for further analysis.
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 Intermediate level Microsoft Excel functionalities.
Working Experience:
• Recommended to have some working experience.