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: 15 June 2016
Time: 08:30 - 16:30
Venue: Benvenuto Conference Centre, Johannesburg
Cost: R2,350 excl. VAT
Date: 07 July 2016
Time: 08:30 - 16:30
Venue: Birchwood Hotel & OR Tambo Conference Centre, Boksburg
Cost: R2350 (excl vat)
Date: 14 July 2016
Time: 08:30 - 16:30
Venue: Benvenuto Conference Centre, Randburg
Cost: R2,350 excl. VAT