Advanced Excel and Dashboards

Enhance your Excel skills

Course Features

Course schedule: 
2 sessions
Date One: 
Tuesday, 12 June, 2018
Date Two: 
Tuesday, 23 October, 2018
South Africa; Johannesburg
2 days
Presented by: 
Dianne Auld
Cost of Training: 
R 11,890.00 (Including VAT) per person

Detailed Descriptions

Target Audience: Remuneration Specialists or Managers, who already have good Excel skills, and would like to learn advanced Excel techniques, and how to use these to create powerful interactive Excel dashboards for viewing and analysing remuneration data. 

Course details: Content covered in the course includes some of the following:

Advanced Excel Techniques

  • Lookup Formulas 1 - Vlookup, Hlookup, Index, Match formulas
  • Lookup Formulas 2 -  Indirect, Choose, Offset formulas
  • If formulas – If, If (And), If (Or), Nested If, Countif, Countifs, Sumif, Sumifs, Averageif, Averageifs formulas
  • Array Formulas – Single-cell and multi-cell array formulas, application of array formulas together with other Excel formulas
  • Macros – Recording, running and editing macros, macro security settings
  • Data Validation and Protection – Creating forms and input documents using data validation tools, hiding sheets, protecting worksheets and workbooks

For any workshop enquiries, please click here to contact us...