Advanced excel and dashboards

Practical training on the nuances of Excel’s advanced functions and statistics dashboard

Course features

Course schedule: 2 sessions
Date one: Tuesday, 20 August 2019 (JHB)
Date two: Tuesday, 27 August 2019 (CT)
Venue: South Africa, Johannesburg and Cape Town
Duration: 2 days
Presented by: Dianne Auld
Cost of training: R12,857.00 (Including VAT) per person
Two people sitting in an office smiling

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.

 

Contact us

Puseletso Matsheng

Senior Manager, PwC South Africa

Tel: +27 (0) 11 287 0436

Follow us