Excel Metrics for HR Pros

Registration for this course is now closed

Excel Metrics for HR Pros



Excel Metrics for HR Professionals

Registration for this course is now closed. Contact Kelly McInnis if you have any questions KMcInnis@AIMHRSolutions.com 

Businesses are becoming more data-driven in their decision-making, and HR is a huge part of that equation. Do you know how to track employee turnover? Can you quickly report the average pay of men and women in your organization to ensure pay equity? Are you able to calculate company demographics for your next open enrollment? Join us for this three-part course where we’ll discuss general functions such as conditional formatting, flash fill, and using minimum, maximum, average, and count formulas. We’ll also explore pivot tables and creating a simple HR dashboard. Excel users at all levels will learn something new.

Who Should Attend?

  • Ideal for professionals in human resources, such as HR managers, HR specialists, talent acquisition specialists, HR analysts, and anyone who manages employee data
  • Suitable for business analysts, data analysts, and professionals who work with data and need to use Excel for data analysis and reporting
  • Anyone interested in learning new techniques and functions for data management and analysis
Classes & Dates

Registration for this course is now closed

Excel Metrics for HR Professionals

This 3-part series runs on Thursdays from 3:00-4:00 PM.

Class
1
Thu, Jul 20

Formatting, Conditional Formatting, Use of Basic Formulas

3:00 PM - 4:00 PM
More
Class
2
Thu, Jul 27

Advanced Formulas & Pivot Tables

3:00 PM - 4:00 PM
More
Class
3
Thu, Aug 3

HR Metrics and Creating a Dashboard

3:00 PM - 4:00 PM
More

Register Excel Metrics for HR Professionals

Registration for this course is now closed

Pricing

Excel Metrics for HR Professionals


AIM Members
Non Members
Price for Course
$525
Course Name

Excel Metrics for HR Pros

Registration for this course is now closed

Classes Begin

Thursday, Jul 20, 2023

Registration Deadline

Thursday, Jul 20, 2023



If you need help registering or applying for a grant, please contact Kallee McGraw or schedule a call.

Fewer than 100 Employees?

Learn how you can access this course at no cost through the Massachusetts Workforce Training Fund Program by viewing our Training Catalog. Over 100 employees? Attend at half cost.

FAQs

Excel Metrics for HR Professionals


What is the difference between “Training Just for You” and “Training for Your Company”?
See More

“Training Just for You” is a training program that any individual from any company can sign up to attend. You’ll join a group of peers from other companies for weekly training sessions. AIM HR Solutions holds these sessions virtually; you can view our calendar of upcoming “Training Just for You” events here. “Training for Your Company” means that we will work with you to deliver training to your company, virtually or onsite. Contact Kelly McInnis if you want to learn more about holding training for your company.

Are these courses available in virtual and in-person formats?
See More

All of our Training Just For You programs are currently virtual only. If you are interested in AIM HR Solutions offering this program virtually or onsite for your company, contact Kelly McInnis.

Is this course eligible for a grant?
See More

This course is eligible for the Express Program or the General Grant through the Workforce Training Fund Program. To learn more about this grant and how we can help, you can download our Learning & Development Catalog. If you still have more questions, you can contact Kelly McInnis.

Do you offer in-person training outside of Massachusetts?
See More

All of our “Training Just for You” programs are held virtually and therefore can be attended by individuals anywhere in the world! Training for your company can also be offered in a virtual format to employees located anywhere. We currently do not offer in-person training outside of Massachusetts. To talk about how we may be able to support you, please contact Kelly McInnis.

Not a Member?

We invite you to join 3,400 fellow employers as a member of Associated Industries of Massachusetts. We are building a better state of business.

Learn More