Excel level two - Office 2010 and 2013
This one-day workshop offers delegates a transitional walkthrough of the Excel tools. The training course applies the basic toolkit taught in Excel Level One. All topics are comprehensively covered and clearly presented, using a guided, step-by-step training methodology.
What will be covered on this one-day workshop?
Templates
Opening a template
Creating a template
Modifying a template
Functions
The IF function
How the IF function works
Lookup functions
How the VLOOKUP function works
The HLOOKUP function
PMT and FV
Date and time functions
DSUM function
Linking cells
Comments and web features
Comments
Using Hyperlinks
Publish a worksheet to the web
Working with data
Sorting data
Multiple level sorts
Filtering data
Subtotals
Creating and modifying charts
Insert a chart
Modify charts
Printing charts
Working with graphic objects
Adding a shape
Resizing an AutoShape
Modifying an AutoShape
Change the order of objects
Grouping objects
Named range
Creating a named range
Removing a name form a cell
Using named ranges in a calculation
Import and export data
Exporting data from Excel
Importing data from Excel
Time: 08:30 - 16:30
Venue: Birchwood Hotel and OR Tambo Conference Centre, Boksburg
Cost: R2,350 excl. VAT
Date: 10 February 2016
Time: 08:30 - 16:30
Venue: Benvenuto Conference Centre, Johannesburg
Cost: R2,350 excl. VAT
Date: 02 March 2016
Time: 08:30 - 16:30
Venue: Birchwood Hotel and OR Tambo Conference Centre, Boksburg
Cost: R2,350 excl. VAT
Date: 09 March 2016
Time: 08:30 - 16:30
Venue: Benvenuto Conference Centre, Johannesburg
Cost: R2,350 excl. VAT