Thank You For  Subscribing / Contacting Us.

We are in this together now! 😊

We have the expertise to assist you 🎓

And the honesty to refer you to another expert where we are unable to.

Twende Kazi

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

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 left. For example, how do you alphabetically sort the below sets of meals from right to left? Here are the steps to follow: Select all the data, including the column...

BASIC EXCEL
Jun 28, 2024

When The TRIM Function Doesn’t Work

Invisible characters are a great threat to accurate results when working with texts. Trim functions work well to remove Char(32) [spaces] but not Char(160) [non-break space] characters. The solution to cleaning non-break spaces is using the SUBSTITUTE function....

BASIC EXCEL
Jun 2, 2023

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 count of number of times a criterion appears in a dataset. =COUNTIF(dataset, criterion) For example, in the image below, we are counting if the currencies appear in our...

INTERMEDIATE EXCEL
May 12, 2023
Share This