Would you like to create HR or Rewards dashboards that tell a powerful story, are interactive and can be easily updated? Have you spent hours manually calculating medians or percentiles for each employee category? If so, this course is for you, we’ll tackle that and more.
Join International Excel Guru, Dianne Auld, Master Reward Specialist, for this 3-hour Excel course for advanced users to learn how to create powerful dashboards using Power Pivot and Power Query in less time. Attendees will have access to a comprehensive learning video for 120 days post-course including detailed instructions on replicating all the functions demonstrated during the session, so you don’t miss a beat.
During This Course, You Will:
- Learn important dashboard design principles.
- Receive a brief introduction to Power Query, Power Pivot and Macros.
- See how to create an interactive analysis dashboard using Power Query, Power Pivot, icons, text boxes, elegant, uncluttered color-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.
- Obtain a starting template, instructions for replication of everything demonstrated, and the completed dashboard.
Who Will Benefit from This Course?
This course is ideal for HR professionals, compensation specialists or anyone seeking to create a dashboard to help tell a story regarding HR-related metrics.
Course Requirements
The course requires an advanced knowledge of Excel. Participants should have access to a computer with Excel 2013 or newer. Power Pivot and Power Query are standard from Excel 2016 onward, 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 super-efficient tools for transforming data and merging different tables for use in analysis. You should already work with HR, Reward or payroll data in Excel regularly, and be experienced with writing Excel formulas and creating charts.
Related Courses
This learning experience is part of WorldatWork’s suite of Excel mastery courses, which include:
- Advanced Excel Skills for Compensation Professionals
- Analyzing & Automating Rewards Data with Excel
- Creating a Dynamic Incentive Modeling Tool
- Dynamic Arrays: Excel Turbo Charged
- Excel Skills for Compensation Professionals
- Hello Excel Power Query, My New BFF
- Job Titles & Grades: Creating an Interactive Matrix in Excel
- Regression Analysis Made Easy with Excel
- Working Smarter & Faster with Excel Formulas
Recertification Credits
By successfully completing this course you will earn 2 WorldatWork recertification credits.
Based in India? Contact india@worldatwork.org for India-special course pricing.
Policies
View our Return/Cancellation policies and more here.
Members can register for this course at a special rate and gain exclusive access to research, publications and more!
Please consider a different learning method or contact our Customer Experience Team to learn about other classes and schedules.
Phone
877-951-9191 (United States and Canada)
+1 480-951-9191 (other countries)
Monday-Friday: 8:00 a.m. - 7:00 p.m. EST
Email
Email our Customer Experience Team: customerexperience@worldatwork.org
