19 EXCEL FUNCTIONS EVERY HR PROFESSIONAL SHOULD KNOW
In our everyday life as Human Resources professionals, we encounter large volumes of data that...
How to Analyse Multiple Choice Survey Data In Excel
Knowing how to Analyse Multiple Choice Survey Data In Excel is a must-have skill since Multiple...
24 WAYS TO USE FILTER Function EXCEL
Why all the fuss with FILTER function? Is it the future of Lookup functions?
Here are 18 things you can do with FILTER Function.
How to Find and Replace ANYTHING in Excel
Data cleaning takes up to 80% of the time for a data analyst. To save time use the below tricks to...
Extracting the Last Word In Excel
Assume you have below data and you need to get the last name as Surname & the rest as Other...
XLOOKUP Two-way approximate match multiple criteria
This post is inspired by Dave Bruns's post on Two-way approximate match multiple criteria. Having...
What’s The Fuss with XLOOKUP Function
NEVER has there been so much noise (fuss) in the Excel Community as it was during the introduction...
Excel Flash Fill: 15 Things You Can Do In a Flash. Part 1
"Excel Flash Fill Is A Brilliant Time Saver," writes Life hacker Australia. "In fact, it’s so good...
4 ways to lookup items not matching a list
There are times when you want to look up and retrieve values based on a list. Normal filtering can...
5 Ways to Lookup Unique Values in Excel
Duplicates can be a pain in data analysis leading to the wrong conclusion. This is why knowing how...
4 WAYS TO SUM DATA BY WEEK NUMBER
Every organization requires weekly summaries to monitor peak and off-peak periods. This is mostly...
VLOOKUP IS DEAD–OR IS IT?
In the year 1882, a German philosopher, Friedrich Nietzsche made a claim that has...