Excel level three - Office 2010 and 2013
Our Excel level three workshop aims to take you on to the next level of Excel functionality with an intensive one-day course offering. This is your opportunity to learn how to make the most of everything Excel has to offer - everyday.
What will be covered in this workshop?
Automating worksheets
Create a macro
Edit a macro
Create a macro button
Assign a macro to the Quick Access Toolbar
Adjust macro settings
Create and apply digital signatures
File collaboration
Apply File Protection
Protect a worksheet
Share a workbook
Set revision tracking
Review tracked eevisions
Merge workbooks
Data analysis
Apply a trend line to a chart
Create scenarios
Perform What-If Analysis with Goal Seek
Perform What-If Analysis with Solver
Create a PivotTable© Report
Create a PivotChart© Report
Perform statistical analysis with the Analysis ToolPak
Data Import With XML
Import XML data/maps
Export XML data
Data structure and default settings
Apply conditional formatting
Add Data Validation criteria
Locate invalid data and formulas
Group and outline data
Update a workbook's properties
Modify Excel's default settings
Auditing features
Trace cell precedents
Trace cell dependents
Locate errors in formulas
Add a watch and evaluate formulas
Working with multiple workbooks
Create a workspace
Consolidate data
Link different workbooks
Edit links between workbooks
Time: 08:30 - 16:30
Venue: Birchwood Hotel and OR Tambo Conference Centre, Boksburg
Cost: R2,350 excl. VAT
Date: 11 February 2016
Time: 08:30 - 16:30
Venue: Benvenuto Conference Centre, Johannesburg
Cost: R2,350 excl. VAT
Date: 03 March 2016
Time: 08:30 - 16:30
Venue: Birchwood Hotel & OR Tambo Conference Centre, Boksburg
Cost: R2350 (excl vat)
Date: 10 March 2016
Time: 08:30 - 16:30
Venue: Benvenuto Conference Centre, Randburg
Cost: R2,350 excl. VAT