University of Johannesburg
About Course
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. Course 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).
Apply directly on the employer website. It only takes a few minutes.
Prepare your CV
Make sure your CV is up to date, includes your full name, contact details, qualifications, and any work or volunteer experience. Keep it to 2-3 pages.
Check the closing date
Applications submitted after the closing date are not considered. Apply as early as possible ā do not wait until the last day.
Government jobs require a Z83 form
All South African government applications require a completed Z83 form. Download it from the DPSA website and complete it fully before submitting.
Never pay to apply
Legitimate employers never ask for payment to process your application. If anyone asks you to pay for a job opportunity, it is a scam.
Important: FirstJobly verifies listings before publishing but always confirm details directly with the employer. We will never ask you to pay for a job application. If you are asked to pay, report it immediately.
Excel for the Workplace
University of Johannesburg