Excel Masterclass on Creating Powerful Dashboards - with Dianne Auld

Would you like to create visually appealing HR or Reward dashboards that stand out from the herd, tell a powerful story, are interactive and can be updated with two clicks?

Have you heard about Power Pivot and wondered how it worked?

Have you spent hours calculating medians or percentiles for each employee category?


Join International Excel Guru, Dianne Auld (Master Reward Specialist), for this 3-hour Excel masterclass for advanced Excel users where she will: 

  • Cover important dashboard design principles.
  • Provide a brief introduction to Power Query, Power Pivot and Macros; and
  • Demonstrate how to create an interactive gender equity analysis dashboard using Power Query, Power Pivot, icons, text boxes, elegant, uncluttered colour coded charts, customized slicers to drill down by level, department or location, Power Pivot median measures and three simple macro buttons that allow alternate pay base views of the data.  

Attendees will be provided with the starting template, instructions for replication of everything demonstrated, and the completed dashboard.  Plus, you will have access to the recording for 30 days, so that you can replay at your leisure and practise the various steps to create your own powerful dashboards.

While a gender equity dashboard will be used for illustration, the techniques demonstrated can be used for any type of HR or Reward dashboards. 

Power Pivot and Power Query are standard from Excel 2016 onwards, and they can be added into Excel 2013.   The dashboard design principles taught can be used with any version of Excel and can be used with standard employee data and pivot tables.  Power Query and Power Pivot are simply super-efficient tools for transforming data and merging different tables for use in analysis.

Attendees are not required to follow along on their computers in this masterclass.  They will have access to the video for 30 days after the masterclass and will receive detailed instructions on how to replicate all functions demonstrated.

We would like attendees to leave the class thinking: “Wow I didn’t know this was possible, but after the demonstration and with the resources supplied, I feel confident enough to apply the learnings to my own work”.

To maximise the learning experience and value add, delegates should already have an intermediate to advanced knowledge of Excel. They should work with HR, Reward or Payroll data in Excel regularly, and be experienced with writing Excel formulas, creating charts, and using pivot tables.

Date: 1 September 2022
Time: 09:00 – 12:00
Presenter:  Dianne Auld
Venue: Zoom
Cost: SARA Professionalised Members: R900 | Paid-Up Members: R1250 | Non-SARA Members: R2 400

CPD: 3 points

To ensure the session is as interactive and focussed as possible for the delegates, there is a limited number of seats available.

About Dianne Auld

  Dianne Auld is the founding member of Auld Compensation Consulting, an honorary life member of SARA, a SARA GRP faculty member, a member of SARA’s Western Cape Committee and a designated Master Reward Specialist.
She consults globally across all areas of reward and runs a wide range of reward training courses. She is renowned for her Excel Tips columns, and for conducting advanced Excel skills training for compensation professionals across four continents.



Cancellation: Please note that members and non-members will be held liable for the full fee if registration is not cancelled by 26 August 2022 or if the delegate is a 'no show'.