ONLINE SKILLS PROGRAMME

Microsoft Excel - Beginners

Overview Duration Delivery Method Who Should Attend Prerequisites Unit Standards Course Content

Overview

This course is designed to assist learners with the ability to use spreadsheet applications to perform calculations. After completing the course, the learner will be able to organise and manage their activities responsibly and effectively by using a spreadsheet application to organize information into rows and columns for a specific purpose. They will be able to collect, analyse, organise, perform calculations, and critically evaluate information by using a spreadsheet application. Learners will be able to communicate effectively using visual, mathematical and/or language skills in the modes of oral and/or written persuasion when engaging with the subject by using a spreadsheet application to organize information into rows and columns for a specific purpose.

Duration

Delivery Method

Who Should Attend

Prerequisites

Unit Standards

Use a Graphical User Interface (GUI)-Based Spreadsheet Application to Create and Edit Spreadsheets NQF 2 (4 credits)
(116937)

Learning outcomes:

Demonstrate an understanding of the principles of spreadsheets.
Create, open and save spreadsheets.
Produce a spreadsheet from a given specification.
Edit a spreadsheet.
Format a spreadsheet.
Check spelling and grammar in a spreadsheet.
Print a spreadsheet using features specific to spreadsheets.

Change the Appearance of a Spreadsheet (3 credits)
(258879)

Learning outcomes:

Outline data in a spreadsheet.
Modify the display of spreadsheet data.
Apply conditional formatting to data.
Create and use templates.
Work with comments.

Course Content

List of Lessons

• Introduction to the practical use of Excel
• Excel window
• Ribbon
• Excel workbook
• Creation and saving of a workbook
• Opening an existing workbook
• Manipulating worksheets
• Navigation within a worksheet
• Cell range selection methods
• Adjusting rows and columns
• Data entry into cells
• Numeric values in cells
• Moving and copying cell values
• Copying and moving using the Clipboard
• Font formatting
• Alignment of data in cells
• Borders and fill
• Basic number formats
• Date, time and percentage number formats
• Cell styles
• Copying formatting
• Excel table
• Conditional formatting
• Basic formulas
• AutoSum
• Number and date fill series
• Text series and custom lists
• Sorting
• Recommended charts
• Instant data analysis
• Pictures in Excel
• Printing
• Customisation of the program settings
• Getting help with Excel