Introduction to Excel for HR practitioners
EXCEL FUNDAMENTALS – FOR HR PRACTITIONERS
Are you looking to build your data skills using Excel?
When: Wednesday 11 June 2025
Time: 10.00am - 3.00pm (AEST)
Where: Online Workshop
Course Overview
Introduction to Excel for HR Practitioners is designed specifically for HR practitioners that need a refresher or want to know how to use Excel to improve their capability when it comes to analysing HR data and information. Delivered by experienced facilitators in an online classroom, the course includes content specifically tailored to HR practitioners. Whether you are in recruitment, workplace health and safety, workplace relations or learning and development, the course will equip participants with practical Excel skills that can be applied immediately to the workplace, to improve effectiveness when it comes to using data in your HR role. The course empowers participants with technical skills to collect, store and analyse data in Excel. No matter if you are new or experienced to using Excel, this course will build your skills, knowledge and confidence to more effectively work with HR data in Excel.
Course Learning Outcomes
-
Navigating Excel interface
-
Understand fundamental functions and features in Excel
-
Understand Excel for data collection (i.e. forms or exit surveys)
-
Organising data in Excel
-
Learn basic data analytics
Who should attend
-
![]()
✓
HR LEADERS
-
![]()
✓
WORK HEALTH AND SAFETY PROFESSIONALS
-
![]()
✓
LEARNING AND DEVELOPMENT PROFESSIONALS
-
![]()
✓
RECRUITMENT SPECIALISTS
-
![]()
✓
INDUSTRIAL RELATIONS SPECIALISTS
-
![]()
✓
HR PRACTITIONERS
COURSE MODULES
Each module in this course is tailored to participant’s context to make the learning experience contextual, relevant and valuable. Using examples tailored to HR, this course steps participants through data in Excel in a manner that brings to life the work they complete each day.
The following areas will be covered in each course:
-
Understanding Excel interface and features
-
Basics of how Excel functions
-
Viewing data in Excel
-
Understand formulas in Excel
-
Specific formulas that are useful for HR practitioners
-
Understand how to use conditional formatting
-
Learn how to use in-cell data validations when collecting information
-
Understand how to use tables and named ranges
COURSE RESOURCES
HR Excel cheat sheet
Access to course recording after the course to go back at any time.
HR Toolkit after the course – only useful for those attending the 2nd session
Includes an Excel case study guide and Excel checklist for creating reports or completing data analytics.
Meet your facilitator
Jonathan Feng
FACILITATOR AND FOUNDER AT POWRUP EXCEL TRAINING
Jonathan delivers this course drawing on his significant real-world experience and technical expertise in data analytics in a number of areas including Human Resources. Jonathan leads a team of data analysts specialising in workers' compensation and workplace incidents, so he is familiar with contemporary HR practice and the importance of using data to support business outcomes. During this course, Jonathan focuses on providing HR focused examples, supporting HR Practitioners who attend this course to become more aware of the practical techniques specific to their roles working with people data and information. Jonathan holds a Bachelor of Actuarial Studies/Bachelor of Finance from the Australian National University.
This course is designed specifically for HR practitioners that need a refresher or want to know use Excel. Delivered by experienced facilitators in an online classroom, the course includes content specifically tailored to HR practitioners. Whether you are in recruitment, workplace relations or learning & development, the course will equip participants with practical Excel skills that can be applied right away.
Still have Questions?
Please contact our team with any questions you have about this workshop. If the date of this workshop doesn’t suit your needs and you have a group who require training, contact us at hello@humanifyhr.com.au to find out how we can deliver the workshop tailored to your organisation.
Ready to enhance your capability to analyse HR data by improving your Excel skills?
Don't miss out on this opportunity to gain valuable skills and knowledge in Excel, that will put you on the path to becoming a HR Data Ninja!