Analysing Data with Excel
Azure Fundametals
Data Modelling with M and Power Query
DAX Programming
Excel Boot Camp
Excel Dashboards & Power Pivot: Building Interactive Data Solutions
Excel for Statistical Analysis
Excel Productivity
Excel VBA
Microsoft Access
Microsoft Azure Administrator
Microsoft Excel Fundamentals
Microsoft Excel: Advanced
Microsoft Excel: Intermediate
Microsoft Office 365 Overview
Microsoft OneNote Fundamentals
Microsoft Outlook Level 1
Microsoft Power Automate
Microsoft Power BI Bootcamp
Microsoft Power BI Desktop Advanced
Microsoft Power Query
Microsoft PowerApps
Microsoft PowerBI Dashboard User Course
Microsoft PowerPoint Level 1
Microsoft PowerPoint Level 2
Microsoft Project
Microsoft SharePoint User
Microsoft Teams
Microsoft Visio
Microsoft Word Level 1
Microsoft Word Level 2
MS Office Level 1
OneDrive Training
HR Data Analytics is a growing field in an increasingly data-driven world. Excel has tools to organize HR data and HR professionals need to know how to add these skills to their toolset to drive insight into HR metrics and deliver results to the business. This course covers the Excel tools and skills an HR professional will need to analyze HR data into meaningful presentations.
Over the two days, delegates will learn about the functions in Excel that assist in the cleaning up of text and time/date data generated in the activities of administering human resources, as well as functions that facilitate relevant and accurate analysis of the data, leading to a presentation of worthwhile and applicable information.
This course will also include the demonstration and application of appropriate shortcut keys, workbook and worksheet design specifically for large amounts of text data as experienced in the administrating of human resources, as well as the generation of dashboard elements such as charts and pivot tables.
Delivery Method | Duration | ||
---|---|---|---|
Live Virtual Training | 2 days | Get a Quote |
This course is for professionals working in Human Resources for organizations who need to represent, analyze or organize HR data visually using Excel.
Excel Advanced knowledge is required and having completed the Excel for Data Analytics course with Leading Training would be beneficial.
1. Inserting Sheets
2. Referencing external Sheets
3. Linking to published sources
1. Information Functions
2. Statistical Functions
3. Data Tools
1. Text Functions
2. Date and Time Functions
3. Named Ranges
1. Look & Reference Functions
2. Logical Functions
3. Tables
1. Conditional Formatting
2. Sparklines
3. Slicers
1. Charts
2. Pivot Tables
3. Pivot Charts
There are currently no scheduled dates.
Please note that this course needs a minimum of 6 delegates to schedule a course. You can choose to be added to the waiting list by clicking the button below, and we will contact you when we have enough delegates interested. Should we not get enough delegates, we will refund or credit your paid booking.
Should you need this course urgently, the following options are available: