Excel for the Workplace
Description:
About this course: 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. Take note: This short learning programme is self-paced. Work on your terms at the times and speeds that are most convenient for you. The course is designed to be completed in about 50 hours. For example, you can complete it over five weeks by engaging in the course for ten hours per week or complete it over eight weeks by spending about six hours per week. A digital certificate will be issued upon successful course completion and may be viewed and shared with third parties or possible employers through the UJ Digital Certificate platform.
Admission Requirements:
18 years of age and above.
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:
