Microsoft® Office Excel® 2016 Intermediate

Key Focus Areas:

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

Charts
• 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

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

Validation
• 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

Duration:

Two Days

Date(s) Programme Fee
26th September 2019 R1 500
Course by:

UKZN Extended Learning