ONLINE SKILLS PROGRAMME

Microsoft Excel - Intermediate

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

Overview

The course is designed to assist learners with the ability to apply text, lookup, date, and calculation functions in a spreadsheet. The learners will be able to work on a range of cells and apply formulae to worksheets to provide alternative solutions to the given problem. They will learn how to apply simple built-in functions of the spreadsheet application, as well as perform calculation functions. Learners will be taught methods of automatically formatting a spreadsheet and using special effects to improve the presentation of the spreadsheet.

Duration

Delivery Method

Who Should Attend

Prerequisites

Unit Standards

Use a Graphical User Interface (GUI)-based Spreadsheet Application to Solve a Given Problem NQF3 (6 credits)

(116940)

Learning outcomes:

Prepare and produce a spreadsheet to provide a solution to a given problem.
Adjust settings to customise the view and preferences of the spreadsheet application to suit the solution created for the given problem.
Work with multiple worksheets to suit the solution to the given problem.
Apply formulae to worksheets to provide alternative solutions to the given problem.
Apply simple built-in functions of the spreadsheet application to the given problem.
Apply formatting to a spreadsheet applicable to the given problem.
Use special effects to improve the presentation of the spreadsheet.
Evaluate a spreadsheet to comply with the given problem.

Course Content

List of Lessons

• Customisation of the Quick Access Toolbar
• Customising the Ribbon
• Manipulation with sheets of multiple workbooks
• Advanced paste options
• Copying multiple items
• Pasting external data into Excel
• Advanced number formats
• Custom number format
• Worksheet protection
• Advanced work with Excel tables
• Using references in formulas
• Comparing and connecting values using operators
• Cell and range references
• Conditional formatting rules
• Conditional formatting based on a formula
• Function library
• Text functions
• Advanced text functions
• Math functions
• Statistical functions
• Date and time functions
• Logical functions and conditional calculations
• Nested functions
• Errors in cells and their checking
• Naming cell ranges
• Data validation
• Advanced fill series
• Advanced sorting
• Data filtering
• Using slicers to filter data
• Finding and replacing specific values
• Removing duplicate data
• Splitting text into columns
• Flash Fill
• Outline