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.
Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of four delegates. We remain committed to offering training that is fast, focused and effective.
|Delivery Method||Duration||Price (excl. VAT)|
|Webinar||2 days||R 5,998.00|
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
1. Conditional Formatting
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: