Microsoft Excel Expert

Pre-requisites

Prior knowledge and skills to:

  • Mathematical Literacy at NQF Level 3
  • Communication at NQF Level 3
  • Computer Literacy at application NQF Level 3.
  • Use generic functions in a Graphical User Interface (GUI)-environment (ID 117902 - NQF level 1)
  • Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem" (ID 116940 - NQF level 3)

Level

Advanced

Modules

Prepare and produce a spreadsheet

Work with Multiple Worksheets
Multiple Sheets
Renaming Sheets
Insert and Delete Sheets
Copy and Move Sheets
Worksheet Groups
Applying formulas across sheets
Prepare and produce a spreadsheet
Naming ranges
Working with named ranges
Deleting a named range
Creating names from a selection
Using the Clipboard Group
Using Paste Special
Working with Links
Editing Links
Worksheet Protection

Data commands

Sorting and filtering data
Validation
Subtotals
Grouping and Outlining
Using the Consolidate command
Working with Advanced Filters
Working with External Data
Importing data from a text file
Converting Text to Columns
Working with a data form

Advanced Functions

Database Functions
Lookup Functions
Logical Functions
Text Functions

Customising Microsoft Excel

Setting Excel Options
Excel Add-ins
Customising the Quick Access toolbar

Pivot Tables

Understanding Pivot tables
Creating a Pivot table
Add, copy, rearrange, and remove fields
Add a calculated field
Using the Pivot table filters
Changing Pivot table data
Modifying the Pivot Table placement
Change Active Field settings
Change Pivot Table options
Change the Pivot Table layout
Change the Pivot Table design
Change the Pivot Table Tools design style options
Insert Slicers for your Pivot table
Creating Pivot Charts

Working with Charts

Why do we use charts/graphs
Chart terminology
Creating a chart
Setting or changing the chart type
Chart Titles
Chart Location
Moving, Resizing and Deleting charts as Objects
Formatting a chart
Printing charts
Working with Sparklines
Using the Drawing Tools and Pictures

Macros

Understanding Macros
Developer Tab
Macro Security levels
Trusted locations
Recording a macro
Running Macros
Assigning Macros to Objects

Contact Details

Contact Person: 

Thandi
Course Details

Unit Standard: 

258876 ;116943

NQF Level: 

Level 4

Credits: 

8

Course Delivery Method: 

In Class In Class

Course Duration: 

1 Day

Cost: 

R1400 Excluding VAT

Advertisement