HR ANALYTICS 101: FOCUS ON EMPLOYEE TURNOVER
What is Employee Turnover? Simply put, employee turnover,...
How to Highlight Non-Sequential Numbers
Sequential numbers can be used as unique identifiers and an easy way to maintain a count. Below is...
How to Highlight Duplicates in Rows
Duplicates can be a mess in data analysis. Here is an easy way to conditionally highlight...
HOW TO COUNT WITH MULTIPLE CRITERIA (AND OR LOGIC)
COUNTIFS is a very important function when you want to count items with criteria. By default,...
HOW TO SUM THE TOP or BOTTOM n VALUES; 5 Methods
Learning how to sum the top or bottom n values in excel requires one to first be familiar with the...
WHY FOCUS ON HR ANALYTICS? HERE ARE 9 REASONS
HR analytics is becoming an indispensable tool for organizations to make better decisions.
That’s why every HR professional must have a good level of data literacy to help their organizations reap the benefits of HR analytics.
How To Create a Dynamic Waterfall Chart in Excel
Waterfall charts are used to explain the +ve and -ve components of a change in value between two...
How to Allow Only UPPERCASE, lowercase Or Proper case Entries in Excel
Accurate data entry saves tonnes of time in data clean up & analysis. Below is how to Allow...
How To SUMIF Excluding Weekends & Holidays
Summing data based on weekdays or weekends is easy, but what if you are required to SUMIF...
FREE TRAINING CALENDAR IN EXCEL
Having a dynamic training calendar is a MUST for all HR professionals. How it Works: Type the...
HOW TO SUMIFS EXACT MATCH IN EXCEL
By default, the SUMIFS function is not case-sensitive. To make it case-sensitive and do an exact...
17 Ways to Use RANDARRAY Function in Excel
Though not a popular dynamic array function, there are many ways to use the RANDARRAY function in...