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 Sort Data from Right to Left
Excel sorts data from top to bottom by default, but there is an easy way to sort it from right to...
The Pain of Losing Data and a quick way to recover it – Stellar Repair for Excel Review
There are three unforgettable pains; these are pains you feel both psychologically and...
How to return Multiple Items using DATEDIF
The DATEDIF function is a must-learn function if you want to do date calculations. Generally, it...
When The TRIM Function Doesn’t Work
Invisible characters are a great threat to accurate results when working with texts. Trim...
How to SUM Data Per Week Using Pivot Table
If you love low-code solutions then sum data per week using a pivot table is the way to go. The...
How to Lookup Items in a List
Looking up items in a list is easy when we use the COUNTIF function. COUNTIF function returns a...
How to SUMIF Data Ignoring Hidden Rows in Excel
SUMIF Data Ignoring Hidden Rows in Excel is not as simple as other types of summation using...
How to Use SUMIFS Function in Data Validation
Analysts spend between 60% to 80% cleaning data. Here is how to cut that time by using the SUMIFS...
How to Split and Sum Text numbers using FILTERXML
If you do not have Office365, the easiest option you have for splitting text is FILTERXML How do...
How To Clean & Split Dirty Data In PowerQuery
Surendra Reddy on Linked posed a challenge on how to Clean & Split Dirty Data as shown below...
How to condition format duplicates for Long Numbers formatted as text
A friend recently asked me, "How do I condition format duplicates for Long Numbers formatted as...
How to Reverse Lookup Numbers and Text In Excel
Reverse lookup of numbers is easier than that of texts. Reverse Lookup Numbers For example, how do...
