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

## The Pain of Losing Data and a quick way to recover it – Stellar Repair for Excel Review

There are three unforgettable pains; these are pains you feel both psychologically and physicallyâ€”toothache, childbirth and losing your Excel data. Data loss looms ominously in the fast-paced world of data management and analytics, where Excel is the backbone for...

BASIC EXCEL
Mar 15, 2024

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