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
Date: 08 June 2016
Time: 08:30 - 16:30
Venue: Benvenuto Conference Centre, Johannesburg
Cost: R2,350 excl. VAT
Date: 14 June 2016
Time: 08:30 - 16:30
Venue: Benvenuto Conference Centre, Johannesburg
Cost: R2,350 excl. VAT
Date: 06 July 2016
Time: 08:30 - 16:30
Venue: Birchwood Hotel and OR Tambo Conference Centre, Boksburg
Cost: R2,350 excl. VAT
Date: 13 July 2016
Time: 08:30 - 16:30
Venue: Benvenuto Conference Centre, Johannesburg
Cost: R2,350 excl. VAT