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

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

HR
May 22, 2022

## How to return Multiple Items using DATEDIF

The DATEDIF function is a must-learn function if you want to do date calculations. Generally, it is used to get the difference between two dates. Here is what you need to know to use the function properly: It is not a document, so it will not populate among Excel...

INTERMEDIATE EXCEL
Jul 7, 2023

## 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 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 only trick here is to remember, Pivot tables lack the Week grouping. A way around this issue is to group 7 days together. See the below Video for steps to follow:...

BASIC EXCEL
May 23, 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

## 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 criteria. This is because the SUMIF function does not ignore hidden rows. The solution comes from using a combination of SUBTOTAL & OFFSET functions to return only...

Mar 8, 2023

## 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 function in Data Validation. Given the below data, how do you ensure staff is awarded only salaries within their job grade scale? Here are the 4 steps: Select the...

INTERMEDIATE EXCEL
Feb 9, 2023

## 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 you split and sum below multiple sales? The easiest way to solve this is by using the FILTERXML function FILTERXML function returns specific data from XML text using...

Feb 1, 2023

## 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 There are many ways of doing this but I find it easy to use below Power Query M code let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], clean =...

Jan 22, 2023

## 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 text?" I thought...that is easy! Just go to condition formatting and select the in-built rule of highlighting duplicate rules. WRONG! Hardly did I know Excel has a...

INTERMEDIATE EXCEL
Jan 20, 2023

## 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 you look up the appointment date and time for a patient in the below data? The below video explains the steps Note: ⭐ It is possible to create an array of Date and...

INTERMEDIATE EXCEL
Jan 8, 2023