Excel for HR Professionals

August 11, 2021

Susan Strayer describes HR as “the glue that holds people and an organization together”. It is so common to be overwhelmed by the number of Excel related tasks you need to do on a daily basis e.g. employee attendance tracking, data analysis, and key performance indicator. So to help you in your work, I've put together a bunch of useful Excel functions, HR use cases, and a downloadable Excel spreadsheet of the examples mentioned.

Spotlight

Portfolio Creative

Portfolio Creative is the nation's fastest-growing creative recruiting and staffing agency. We connect clients with exceptional creative talent in all areas of marketing, design, retail, advertising, and digital roles. We provide both temporary staffing and full time recruiting. Whether you are looking to fill a full-time, temporary or executive search creative position, we know what you need to succeed and we can recommend just the right person. We take the time to get to know our talent - their personalities, goals, and creative abilities. And if you are top-notch creative talent we'd love to hear from you.

Other Infographics
news image

6 amazing things you can do with HR analytics

Infographic | January 6, 2020

Pay for performance: Identify the best payment schemes to motivate your staff. With HR analytics, you can compare different pay elements and tie them with performance to see which produces the greatest results. Did you know that for senior roles, a higher commission rate is most effective in producing results while a higher base rate is preferred for more junior positions.

Read More
news image

Is the need for employer branding greater than you think?

Infographic | December 11, 2019

A company's ability to differentiate and promote its identity to desired candidates in order to effectively attract, recruit, and retain employees better than competitors. 75% of job seekers consider employer brand before applying for a job. The best candidates are off the market within 10 days.

Read More
news image

The Right to Disconnect: A Timeline

Infographic | January 28, 2022

A set of laws upholding people’s right to disconnect from work-related obligations outside of working hours. “An employee shall not be reprimanded, punished, or otherwise subjected to disciplinary action if he or she disregards a work-related communication sent after work-hours.”

Read More
news image

Information management for HR

Infographic | February 4, 2020

45% of H.R. managers want to automate workflows and processes. 51% of employees onboarding documents are paper. 58% have not digitised the administration of policies and procedures different types of documents in the average employee file. 48% of H.R.managers require a highly secure way of managing employee files.

Read More
news image

HR Trends 2020: What Matters Most to HR Teams?

Infographic | February 3, 2020

As the workforce evolves, HR roles continue to be some of the most important in business. To understand how HR and small business owners are coping with the challenges of the changing nature of work, we surveyed them, as we do every year, at our HR Virtual Conference, the world’s largest virtual HR conference. From their most pressing concerns to what truly matters most, here are our findings in HR trends for 2020.

Read More
news image

What Recruiters Think

Infographic | February 5, 2020

Monster 2019 Global State of the Recruiter Survey. We surveyed 1700 recruitment professionals worldwide to better understand what keeps them up at night. Here's what they had to say about the ongoing skills gap, the emerging Gen Z workforce, and key hiring goals around the globe. 11% of recruiters struggle to fill positions because of candidate skills gaps and questionable social media profiles.

Read More

Spotlight

Portfolio Creative

Portfolio Creative is the nation's fastest-growing creative recruiting and staffing agency. We connect clients with exceptional creative talent in all areas of marketing, design, retail, advertising, and digital roles. We provide both temporary staffing and full time recruiting. Whether you are looking to fill a full-time, temporary or executive search creative position, we know what you need to succeed and we can recommend just the right person. We take the time to get to know our talent - their personalities, goals, and creative abilities. And if you are top-notch creative talent we'd love to hear from you.

Events