Study Method
Blended
Start Date
Feb 24 2022
Length of Course
TBA
Fees
195 per person
Location
TBA
Designing Powerful Excel Dashboards
EXCEL FOR REWARD – MASTERCLASS #4
Designing Powerful Excel Dashboards
Part of our Excel for Reward Masterclass series: click here for more details about the five afternoon sessions.
Date: Thursday 24 February 2022
Time: 1pm to 4pm (UK)
Duration: Three hours including two 10-minute breaks
Venue: Your PC
This three-hour lesson will demonstrate and teach you how to create beautiful HR or rewards dashboards that stand out from the herd, tell a powerful story and can be updated with only two clicks. (Not to mention, impress the boss!)
Dianne will show you the wonders of Power Pivot:
- Cover important dashboard design principles.
- Provide a brief introduction to Power Query and Power Pivot and Macros.
- Demonstrate how to create an interactive gender equity analysis dashboard using Power Query, Power Pivot, icons, text boxes, elegant uncluttered colour coded charts, customised 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.
- Dianne will give you a marvelous starting template along with instructions for replication of everything she will be demonstrating, and the finished dashboard to polish it all off.
- The gender equity analysis dashboard is used for illustration, but the techniques demonstrated can be used for any type of HR or rewards dashboards.
- Power Pivot and Power Query are standard from Excel 2016 onwards, and they can be added into 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.
“Excel April 2015: 'Valuable course, fantastic knowledge of the trainer. Very helpful, small group, learnt lots of quick short cuts and extremely valuable time-saving techniques.' ”
“ Annual conference 2014: ‘Very good conference, good opportunity to network and see what’s going on in reward in other organisations’ . . . ‘Fantastic and informative day – thank yo”
“Compensation Software Showcase 2014: ‘There was a lot that I could take away and share with my HR Team. In addition, I appreciated having a bit of one-to-one time with the vendors. ”
“ Annual conference 2015: ‘Many thanks to you and the team for delivering a really worthwhile conference. It certainly has provided food for thought.’”
“ Annual conference 2015: ‘A very relevant day’ . . . ‘An excellent conference’ . . . ‘A really good, interesting day.’”
“ Annual conference 2015: ‘The topics of the event were very, very interesting. Overall a truly valuable event.’”