Microsoft Excel Mastering

Pre-requisites

Prior knowledge and skills to:

  • Mathematical literacy and communication skills at least at NQF level 2
  • ID 117902: Use generic functions in a Graphical User Interface (GUI)-environment, NQF level 1
  • ID 116937 Use a Graphical User Interface (GUI)-based spreadsheet application to create and edit spreadsheets, NQF level 2
  • Computer Literacy at NQF Level 2.

Level

Intermediate

Modules

Prepare and produce a spreadsheet

Planning and designing the Worksheet

Customise the view and preferences

Minimising the Ribbon
Customising the Quick Access Toolbar
Changing the size of the screen display
Freezing panes
Splitting the screen
Change the default file location
Setting document properties
Create a spreadsheet using a template
Create a template from an existing spreadsheet

Work with Multiple Worksheets

Multiple Sheets
Renaming Sheets
Insert and Delete Sheets
Copy and Move Sheets
Worksheet Groups
Using the Clipboard Group
Using Paste Special

Apply formulas to worksheets

Entering Formulas
Relative or Absolute Cell Addressing
Link Formulas between worksheets
Interpret and Correct Formula Error Messages
Auditing Commands
Error Checking

Apply built-in functions

What is a built-in function
Creating Formulas Using Functions
Date and Time Functions
Financial Functions
Statistical Functions
Math and Trig Functions

Apply formatting to a spreadsheet

Formatting Rows and Columns
Format Styles
Format as Table
Copy formats
Conditional Formatting
Protection
Comments

Print a Spreadsheet

Previewing the spreadsheet
Using the Page Break Preview
Page Layout
Printing a worksheet

Working with Data

Sorting data
Filtering data
Subtotals
Outlining

Evaluate a Spreadsheet
Contact Details

Contact Person: 

Thandi
Course Details

Unit Standard: 

116940;258879

NQF Level: 

Level 3

Credits: 

9

Course Delivery Method: 

In Class In Class

Course Duration: 

1 Day

Cost: 

R1400 Excluding VAT