Excel for HR Analytics
December 31 - December 30, 2025, 11:00 PM - 11:00 PM
Your Office
HR & People Analytics
Note: The training is available in-company on request.
Do you have multiple Excel sheets with employee data but struggle to consolidate them efficiently? Are you frequently copying and pasting HR data just to conduct an analysis? Do you spend time every month on data-cleaning tasks to prepare reports? Would you like to create a clear, automated dashboard? If so, this training is perfect for you!
In this course, you will gain practical tools to extract more value from Excel with ease. You’ll learn how to make your Excel data more insightful and create interactive visual dashboards that highlight complex relationships at a glance. Even experienced users will discover new techniques. After completing this training, you’ll be equipped to use Excel more effectively and efficiently in your daily work. This 3-day training will significantly enhance your Excel skills.
The real advantage lies in some (often hidden) Excel add-ins. This course will teach you how to automate data processing with Power Query, so you no longer need to manually clean data each month. You’ll also learn to work with advanced formulas that aren’t possible in regular pivot tables but can be achieved with Power Pivot (Super Pivot Tables). After this training, you’ll be amazed at the possibilities this extended version of Excel offers for your daily work.
You'll be able to use Excel as a database for all your HR data, build dynamic dashboards, and automatically update them with new data. Excel is excellent for providing deeper insight into your data. Conclusion: with this course you will have the tools to analyze your own HR data: What are the trends? And what are the projections for the coming months?
Marc Veldkamp, HR Advisor
"Irma has an exceptional ability to share her vast knowledge of Excel’s applications in an accessible way. This training offers a wealth of opportunities to seriously implement Excel in your organization in a short time."
Target Audience
This course is ideal for HR professionals who regularly create reports and analyses—or simply want to make better use of Excel. Basic Excel knowledge is required. All examples and data used in the course come from real HR practice.
After completing this training, you can take additional masterclasses, such as:
- 3-day training in Basic Statistics
- Strategic Workforce Planning Masterclass
- Data-Driven Diversity, Equity & Inclusion (DEI) Masterclass
If you haven't taken the HR Analytics introductory course yet, we recommend checking it out as well.
Good to Know
To participate, you’ll need a laptop with Excel 2016 (or later) with PowerPivot (or Office 365) and a basic understanding of Excel.
Our training programs balance theory and practice optimally. Our instructors have extensive real-world experience and effectively convey knowledge. After the training, you can immediately apply what you've learned.
At Highberg, we keep our groups small (maximum of 12 participants) to ensure personal attention.
We offer the flexibility to attend our trainings partially or fully online. Whether you choose to join remotely or need to attend a session digitally due to personal circumstances, we guarantee an interactive experience equal to that of in-person participants.
Our training courses and masterclasses are also available as in-company sessions, tailored to your organization's specific needs.
Learning Objectives
Using a practical case study, you will learn how to:
- Import data from multiple sources and merge them
- Automate manual data-cleaning tasks
- Adjust data formats for compatibility
- Work with dates in Excel
- Aggregate data effectively
- Create new variables
- Build data models
- Develop KPIs and complex metrics
- Design interactive dashboards in Excel
Program
DAY 1
09.30 – 16.30
Perform calculations on data
- Creating formulas to calculate values
- Summarize data meeting specific conditions
Defining tables
Using filters to display specific data
- Limit the amount of data on the screen
- Filtering table data with slicers
- Manipulating worksheet data
- Finding unique values in a data set
Reorganizing and summarizing data
- Sorting worksheet data
- Vertical Search
Charts
- Creating column, bar, line and scatter diagrams
- Editing/formatting charts
- Sparklines
Using pivot tables and pivot graphs
- Analyze data dynamically with pivot tables
- Filter, display and hide pivot table data
- Editing pivot tables (including calculated fields/columns)
- Formatting pivot tables
- Using pivot charts to create dynamic graphs
DAY 2
09.30 – 16.30
Reading data in Power Query
- Editing files and variables
- Adding and linking files
- Preparing data for better dashboards and analysis
- Getting started with PowerPivot
Enabling PowerPivot
- Reading data from various data sources
- Creating a first dashboard with PowerPivot
- Creating relationships in PowerPivot
- Creating hierarchies in PowerPivot
- Creating Pivot Tables
- Creating Pivot Charts
- Convert pivot tables to formulas
Preparing data for better dashboards and analysis
- Importing data into Power Query
- Editing files and variables
- Adding and linking files
- Creating a dynamic dashboard
DAY 3
09.30 – 16.30
- Continued data preparation and automation
- More complex analysis and dashboards with table formulas
- Calculating unique values
- More complex formulas
- Other useful features in Power Pivot
- Analyzing data with 'data analysis
- Visual analysis
- Statistical analyses
- Analyzing data using “solver”
Costs & Terms
The In-company training is customized to the client's requirements and a proposal will be issued based on that.
At Highberg we use terms and conditions for all our training courses. When registering you must agree to these, so please read them carefully.
