Excel for the Workplace
Description:
The purpose of this short learning programme on Microsoft Excel for the workplace is to enable you to proficiently use Microsoft Excel in the workplace to organise, sort, filter, analyse, and present data. This includes the basic and some advanced functions in MS Excel that are typically used in the workplace.
Admission Requirements:
You must be 18 years and older.
You must have access to an internet-enabled device.
You must communicate clearly in English.
No prior knowledge of the topic is required.
Curriculum:
This course comprises five units, namely:
• Getting started with Excel (such as navigating, types of documents, basic operational commands, entering data in cells, using auto-fill, viewing and printing a workbook and worksheet).
• Organise data (such as basic formatting, cell styles and themes, sorting and filtering data, and data validation lists).
• Basic functions (such as basic formulas and calculations, absolute and relative cell referencing, logical operators, and concatenate).
• More advanced functions (such as key lookup, IF, Vlookup, scenario manager, charts, and macros).
• Using Excel for data analysis (including conditional formatting, pivot tables and charts, sparklines, presenting with dashboards, and graphs and charts to visualise data).
Course Instructors:
CAT SLP team
InstructorDates
- Enrollment Opens: Wednesday, 15 Jan 2025
- Enrollment Closes: Sunday, 30 Nov 2025
- Course Starts: Friday, 07 Feb 2025
- Course Ends: Monday, 08 Dec 2025
