ONLINE SKILLS PROGRAMME

Microsoft Excel - Advanced

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

Overview

This course is designed to provide learners with advanced abilities to work with Excel. It will allow learners to be able to perform functions such as pivot tables, lookups, as well as advanced formulas. The course will also provide learners with the ability to organise and manage their activities responsibly and effectively by using a spreadsheet application.

Duration

Delivery Method

Who Should Attend

Duration

This course is intended for people who need to enhance spreadsheet appearance using a Graphical User Interface (GUI)-based spreadsheet application, either as a user of computers or as basic knowledge for a career needing this competency, like the ICT industry. This course is also intended for people who work with spreadsheets and for whom the reliability of the data produced is critical.

Prerequisites

Unit Standards

Using a Graphical User Interface (GUI)-based Spreadsheet Application, Enhance the Functionality and Apply Graph / Charts to a Spreadsheet NQF 4 (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.

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.

Course Content

List of Lessons

• Sparklines
• Charts creation
• Chart design
• Chart formatting
• Screenshots and screen clipping
• Shapes
• SmartArt
• Themes
• Proofing tools
• Tracking changes
• Comments
• Managing multiple windows
• Splitting worksheets into panes
• Workbook views
• Header and footer
• Page setup
• Microsoft account
• File properties
• Workbook protection
• Workbook inspection
• File AutoRecovery
• Using templates
• Compatibility issues
• Saving a workbook to the Web
• Introduction to macros
• Macro recording
• Macro editing
• Macro security
• Digitally signed macros