Tell better stories with visually appealing, efficiently updated HR/Rewards dashboards. Join Dianne Auld for an overview of dashboard design principles and an introduction to tools like Power Query, Power Pivot and Macros. Gain hands-on experience building a dashboard with these tools in real time! Prerequisites include intermediate to advanced Excel skills, comfort creating/editing pivot tables and charts, Excel 2016 (or a later version), and the ability to add the Power Pivot tab to Excel.
- Understand effective dashboard design principles.
- Learn to use speciality tools and specific techniques to create a dashboard in real time.
- Recognize how this approach can be used for any type of HR or Rewards dashboard.
Please note:
- Delegates should have intermediate to advanced Excel skills and be comfortable creating and editing pivot tables and charts.
- All attendees must bring a laptop containing Microsoft Office Excel 2016 or later version with add in Power Pivot tab to Excel, power cables for your laptop and an external mouse. Excel for Mac and Google Sheets will not suffice for this course.