Chairing & Conducting Labour Law Hearings
Closing the Generation Gap
Coach Managers SAQA US252035
Communicating Across Cultures
Conducting Effective Performance Reviews
Creating A Top Notch Talent Management
Cultural Intelligence (CQ)
Dealing With Sexual Harassment
Developing Your Training Program
Diversity & Conflict Management
Emotional Intelligence SAQA US252031
Employee Dispute Resolution
Employee Orientation: Mediation through Peer Review
Employment Equity & Skills Development
Hiring for Success
HR Training for the Non-HR Manager
Initiating a Hearing & Preparing the Company Case
Intro to Labour Relations in the Workplace
Introduction to Labour Law
Knowledge Management SAQA US252044
Leading With Emotional Intelligence
Manage Organisational Culture SAQA US252042
Manage Recruitment SAQA US12140
Managing Diversity SAQA US252043
Managing Workplace Relationships SAQA US252027
POPIA PAIA Compliance
Sexual Harassment Awareness for Employees
Sexual Harassment Awareness for Supervisors
Skills Development Facilitator
Tough Topics: Talking to Employees about Personal Hygiene
Kirstin S Bosworth
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 six 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||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
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: