Excel

Issue, Log and Report Disciplinary Matters – all in one Workbook

image

Need to shorten time spent on endless reporting? Using multiple systems to manage discipline within your organization? Stop!! Grab a copy of our free Disciplinary Management Template here: Free_Template and manage all your Disciplinary Matters in one place. ———————————————————————————————————- A few notes on using the Template: Step 1: Ensure that your Employee Data is up to date …

Employment Equity – EEA2 with PivotTables

image

Before we get started: You can download the Excel source data for this tutorial here: EE_Source_Data If you are not familiar with Employment Equity documents, legislation or processes you can find more information from the links below: Employment Equity Act EEA 2 – Employment Equity Report EEA4 – Income Differential Statement  EEA9 – Occupational Levels    Disclaimer: All information contained …

People Analytics – Randomized HR Data with “=randbetween” and “=vlookup”

image

Whether you’re a novice in the field of people analytics, or a seasoned expert with countless years of experience, the one thing you’ll need to show off your exceptional skillset in data analytics is Data. I’ve compiled a free Excel Workbook that contains prepopulated, randomized Human Resource (HR) data for the following categories: Organizational Structures (Finance, HR, Production, etc.); Generic Employee Data – for …

Data Analytics – The Human Resource Approach – Part 2/2 [Free Templates]

image

Measuring employee turnover doesn’t have to be a nuisance. This post provides you with two free templates and a short tutorial on how to measure a few aspects associated with employee turnover. ———————————————————————————————————- In Part 1 of this 2-part series we had a brief discussion about the definition and application of Data Analytics, especially in …

Data Analytics – The Human Resource Approach – Part 1/2

image

Data is everywhere. In your pocket, on your phone, your laptop, your watch, heck, even your car. But what to do with all this information? The simplest answer, Analyze it. The more complex answer, Analyze it. ———————————————————————————————————- Disclaimer: This is not an in-depth post on every aspect of Data Analytics, purely due to the large scope of Data Analytics. My aim with this post …

Jesse makes her Pivots talk

image

I’m clearly a one hit wonder fan… (A little side note: You might have to zoom in and out a bit every now and again.  Some of the images in this tutorial contain quite a bit of data) Whenever I mention the words Pivot Table a deafening silence tends to fills the room with eerie echos bouncing of …

The Multi-Graph Conundrum

image

“Susan” works for the Learning and Development Department at her Company as a Learning Database Administrator. As part of her daily duties she is required to not only track daily progress of learning interventions, but also supply various Senior Managers with a range of different reports. “Susan’s” predicament is that she uses only a single …