Microsoft® Office Excel® Intermediate

Key Focus Areas:

Working with tables
• Learn how to create, edit and work with tables and make use of the Table Tools Tab

• Learn how to work with data in charts, insert and modify charts to visualise data

Protecting your worksheet
• Understand and make use of the protection options within a worksheet

SmartArt Graphics
• Learn all about using SmartArt graphics in your document

What-If analysis
• Learn how to use what if analysis to interrogate your data
– Goal Seek
– Data Tables
– Scenario Manager

• Learn the various functions and formulas within Excel
– Lookup functions
– Date and time functions
– Logical functions
– Text functions
– Mathematical functions
– Statistical functions

• Learn how to control the input of data using validation rules

Working with Pivot Tables
• Learn how to summarise your data in Pivot Tables

Entrance requirements:

Delegates are advised to bring their own laptops, with relevant programmes installed to class, in order to complete the training


One Day

* This programme is only available for a full cohort of a minimum of 20 delegates

Start Date Programme Fee
Available on Request The programme fee will be determined based on the requirements
Course by:

UKZN Extended Learning