Excel Masterclass: Creating Powerful Dashboards with Dianne Auld - 12 Oct 2021

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 finished 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 in creating 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 in to Excel 2013.   But 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.


Registration is now closed for this event

Date: 12 October 2021
Presenter: Dianne Auld 
Time: 09:00 – 12:00
Venue: Your PC (Via Zoom)
Cost: SARA Paid-Up members: R975 / Non-members: R1 975 

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

About our Presenter

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.