Introduction to Excel for HR practitioners

EXCEL FUNDAMENTALS – FOR HR PRACTITIONERS

Are you looking to build your data skills using Excel?

Registrations for the public course now closed. Please contact us at hello@humanifyhr.com.au for more information about how we can deliver this course tailored to your work group or organisation.

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, employee relations or learning and development, this course will equip participants with practical Excel skills that can be applied immediately to the workplace, to improve effectiveness when it comes to using and interpreting 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

  • Outline of a closed book with a ribbon bookmark at the bottom, on a dark background.

    Navigating Excel interface

  • Outline of a closed book with a pink ribbon bookmark.

    Understand fundamental functions and features in Excel

  • Outline of a closed book with a pink bookmark ribbon.

    Understand Excel for data collection (i.e. forms or exit surveys)

  • A closed black book with a pink bookmark ribbon sticking out, set against a dark background.

    Organising data in Excel

  • Outline of a closed black book with a pink ribbon bookmark.

    Learn basic data analytics

Who should attend

  • Four businessmen in formal suits collaborating around a table with papers and charts in a white office

    ✓

    HR LEADERS

  • A man dressed in a dark suit with a white shirt and a blue striped tie, adjusting his suit jacket in a modern setting with stairs and glass walls in the background.

    ✓

    WORK HEALTH AND SAFETY PROFESSIONALS

  • Smiling woman with shoulder-length dark hair, wearing a blue top, in a greenhouse surrounded by green plants.

    ✓

    LEARNING AND DEVELOPMENT PROFESSIONALS

  • A woman in a tan blazer with decorative gold buttons, holding glasses in her left hand. Behind her is a blurred desktop with a laptop and books.

    ✓

    RECRUITMENT SPECIALISTS

  • Two men sitting at a table, looking at a tablet, smiling, with sunlight and curtains in the background.

    ✓

    INDUSTRIAL RELATIONS SPECIALISTS

  • Three women sitting at a white conference table in an office, engaged in discussion with one woman facing the wall, a laptop in front of her, while the other two women listen. There is a large flat screen TV on the wall behind them, and windows showing a cityscape.

    ✓

    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 relevant to contemporary HR practice, this course steps participants through data in Excel in a manner that brings to life the work they undertake each day. Download the Excel Cheat Sheet prepared to provide you with some of the key formulas that are workshopped during the course.

The following areas will be covered in each course:

  • A closed book with a pink bookmark ribbon.

    Understanding Excel interface and features

  • Outline of a closed book with a pink bookmark ribbon.

    Basics of how Excel functions

  • Outline illustration of a closed black book with a pink ribbon bookmark.

    Viewing data in Excel

  • Minimalist illustration of a closed book with a pink bookmark.

    Understand formulas in Excel

  • Outline of a closed book with a pink bookmark ribbon

    Specific formulas that are useful for HR practitioners

  • Outline of a closed book with a pink ribbon bookmark over a dark background.

    Understand how to use conditional formatting

  • Simple illustration of a closed book with a pink ribbon bookmark.

    Learn how to use in-cell data validations when collecting information

  • Illustration of a closed black book with a pink bookmark ribbon.

    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:

    • 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 Feng

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 decision making and 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.

Close-up of a smartphone screen displaying Microsoft Office, Microsoft Teams, Outlook, and other productivity app icons in a folder named 'Microsoft'.
Introduction to Excel for HR Practitioners

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 course. If the date of this workshop doesn’t suit your needs and you have a group who require training, please contact us at hello@humanifyhr.com.au to find out how we can deliver the course 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!