Take this course today and free up your time for years to come by learning to use Excel to set up a nearly maintenance-free, interactive matrix of job titles and grades. In just two hours, you’ll learn to easily convert a list of job titles and grades into an interactive matrix that displays job titles by grade (vertically) and job functions (horizontally) — always with the perfect number of rows for the data.
Get step-by-step instructions showing how to set up your matrix. Once complete, you can paste your jobs and grades into the Excel file — even straight from your payroll or HRIS system. Click the Macro button and all the linked job grading matrices will be automatically updated with just the right number of rows. The result: Multiple views of the data all feeding from one source, with no errors, omissions, or duplications, and almost no maintenance.
Your matrix also can be used to audit job grades, determine where jobs are positioned in each function, and view career paths. Update it easily as new jobs and employees come online.
Additional Information
This course is ideal for compensation professionals seeking to efficiently and accurately manage job matrices. The course requires an intermediate to advanced knowledge of Excel. Participants also should have access to a computer with Excel 2013 or newer.
Based in India? Contact india@worldatwork.org for India-special course pricing.
Related Courses
This learning experience is part of WorldatWork’s eight-part 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
- Designing Powerful HR Dashboards
- Dynamic Arrays: Excel Turbo Charged
- Excel Skills for Compensation Professionals
- Hello Excel Power Query, My New BFF
- Regression Analysis Made Easy with Excel
- Working Smarter & Faster with Excel Formulas
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!
WorldatWork Recertification
By successfully completing this course you will earn 2 WorldatWork recertification credits.
Please consider a different learning method or contact our Customer Experience Team to learn about other classes and schedules. Click here to check our global course schedule for availability. Click here to check our global course schedule for availability.
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
