Microsoft Excel

Duration

This programme is run over 4 days.

Delivery Method

Training times can be arranged according to your date and times requirements, delivered virtually or on-site at your premises by one of our professional facilitators.

Prerequisites

The learner must be competent in Communication and Mathematical Literacy at NQF Level 3.

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.

Use a Graphical User Interface (GUI)-Based Spreadsheet Application to Solve a Given Problem NQF 3 (6 credits)
(116940)

Learning outcomes:

• Prepare and produce a spreadsheet to provide a solution to a given problem.
• Adjust settings to customize 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.

Using a Graphical User Interface (GUI)-based spreadsheet application, enhance the functionality and apply graph /charts to a spreadsheet NQF4 (3 credits)
(116943)

Learning outcomes:

• Create and edit a graph.
• Load data from an external data source to produce a given spreadsheet result.
• Insert and edit objects into a spreadsheet.

Change the appearance of a spreadsheet NQF 3 (3 credits)
(258879)

Learning outcomes:

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

Ensure spreadsheet integrity to enhance reliability NQF 4 (3 credits)
(258878)

Learning outcomes:

• Set up a spreadsheet.
• Apply security.
• Check input data.
• Check formulas and totals.
• Check output data.
• Audit spreadsheets.
• Validate and sort data in a spreadsheet.