Email Us

Follows

Thank You For Contacting Me

We are in this together now!

I have the expertise to assist you ðŸŽ“

And the honesty to refer you to another expert where I am unable to.

Twende Kazi

Let Us Connect
Know Someone Who Would Enjoy My Work? Please Share

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 choice questions are the most popular questions. For example, a Bank has requested it, customers, to rate 3 of its department's services from Very Unsatisfied (-100%) to...

Oct 29, 2021

20 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.

Oct 16, 2021

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 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...

Jun 5, 2021

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 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...

May 27, 2021

XLOOKUP Two-way approximate match multiple criteria

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 filter exact data Option...

May 25, 2020

WTF with XLOOKUP Function

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", "Excel Chicken Soup of the Soul"...

May 14, 2020

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 it feels like magic," says Tech Radar "Flash Fill brings the power of text manipulation to the hands of common, non-technical, everyday users. Even people who...

Apr 12, 2019

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 only take up a maximum of two items and limited criteria conditions. In this article, you shall learn 4 ways to look up items not matching a list. For example, below...

Aug 17, 2018

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 to lookup unique values is very important. This article shows 5 ways to tackle duplicate data menace and create a dynamic lookup table with unique values. The task is...