by Crispo Mwangi | Jun 5, 2021 | Advanced Excel
Data cleaning takes up to 80% of the time for a data analyst. To save time use the below tricks to clean mixed digits and letters in a string Find and Replace ALL Numbers in Excel Given below data, find and replace all number digits NB: the Trick is using the...
by Crispo Mwangi | May 27, 2021 | Advanced Excel
Assume you have below data and you need to get the last name as Surname & the rest as Other Names. If only One name exists extract it as the Surname. Here are the Steps to follow: Find the position of the last word in the name.To do this you need to count the...
by Crispo Mwangi | May 25, 2020 | Advanced Excel
This post is inspired by Dave Bruns’s post on Two-way approximate match multiple criteria. Having read Dave’s article I thought… “Is there an easy way of doing this using XLOOKUP instead of INDEX/MATCH?” 🤔 Option 1: Using IF Function...
by Crispo Mwangi | May 14, 2020 | Advanced Excel
NEVER has there been so much noise (fuss) in the Excel Community as it was during the introduction of the XLOOKUP FUNCTION. Excel experts called it “Functions Killer”, “Ultimate Lookup Function”, “Single Most Important function”,...
by Crispo Mwangi | Apr 12, 2019 | Advanced Excel
“Excel Flash Fill Is A Brilliant Time Saver,” writes Life hacker Australia. “In fact, it’s so good it feels like magic,” says Tech Radar “Flash Fill brings the power of text manipulation to the hands of common, non-technical, everyday...
