How to Analyse HR Data Using Microsoft Excel
Learn how to make more informed data driven decisions by analysing and interpreting your HR data
What will I learn in this Tech Bite?
In this Tech Bite led by Heather Whiteman you’ll learn how you can leverage Microsoft Excel to analyse and interpret your HR data so that as a HR Business Partner you can make more informed data driven decisions.
Heather will walk you through a variety of different formulas that you can use in Excel to clean and manipulate your data, as well as:
The steps involved in running a pivot table
How to find correlations in your data
How to do simple linear regression
How to conduct and interpret an output regression
This end-to-end example, that you can follow along with using our dummy data set, really helps you understand the benefit that this type of analysis can have on the insights you generate as you look to solve the different business questions you face.
Who should take this Tech Bite?
This tech bite is designed for anyone in a HR Business Partner, People Analytics or Data Analysis role and anyone who is looking to better understand the data manipulation and analytical capabilities that Excel has to offer so that they can easily derive insights and translate those insights into recommendations for their audience.
By the end of this tech bite, you will have learned:
1. How to use clean and manipulate data
2. How to use pivot tables
3. How to find correlations in your data
4. How to do simple linear regression
5. How to analyse and interpret an output regression
What are Tech Bites?
Our tech bites are short, sharp, technical how-to videos that help you build practical skills and knowledge that can be applied immediately on the job, so that you can work smarter and press PLAY on your Career.
Earn your Tech Bite Badge
Not only will this tech bite help you build hands on skills while providing real life context to what you’ve learnt, but you’ll also be awarded a myHRfuture SHRM recognised certification, that you can share with your network at the click of a button.
So what are you waiting for? Sign up to myHRfuture today and Press PLAY on your Career.
myHRfuture is recognised by the Society for Human Resource Management to offer Professional Development Credits (PDCs) for the SHRM-CPSM or SHRM-SCPSM.
What skills will you build in this Tech Bite?
Other Tech Bites in this Series
Why join myHRfuture?
Learn from Industry Experts
Get access to exclusive bitesized courses taught by leading HR experts
Develop the HR Skills of the Future
Upskill in the knowledge you need to be successful in your HR career
Create Your Own Learning Playlist
Customise your learning experience by focusing on what you want to learn
500+ Curated Resources
Access training, articles, research, videos, podcasts and MORE
Frequently Asked Questions
When do courses start and finish? +
Access to courses starts now and never ends! All of our online training courses are completely self-paced - you decide when you start and when you finish.
How long do I have access to courses? +
After enrolling, you have unlimited access to all of our courses for as long as you have a subscription to the academy - across any and all devices you own.
How long does each course last? +
Our courses vary from 45 minutes long to just over 2 hours long and each course is broken down into bitesized modules, so you can watch and learn whenever you want and wherever you are.
Can I watch the courses on my mobile? +
Yes! Our website is mobile optimised so you can watch videos and access content on the go, just visit our site via your mobile and all of the courses will be available for you to watch wherever you are.
Do I get a certificate for completing a course? +
Yes, upon completing any course on the myHRfuture Academy, you will receive a digital badge and a PDF certificate to show that you have completed all of the course content.