by Crispo Mwangi | Aug 26, 2022 | ADVANCED EXCEL, HR
On Linkedin, after sharing my article on 7 Ways to Calculate Income tax, I got a question on how to calculate income tax in Pakistan. Below are their tax brackets USING SUMPRODUCT Step 1: Summarise the above brackets to a table like below Step 2: Use the below formula...
by Crispo Mwangi | Aug 16, 2022 | HR, INTERMEDIATE EXCEL
Benjamin Franklin once said, “in this world, nothing can be said to be certain, except death and taxes”. There is nothing else as certain as these two, (except Failure), yet there are many who are not prepared for them. The question is, given below Tax...
by Crispo Mwangi | Aug 10, 2022 | BASIC EXCEL
The first step in counting distinct, unique, and Duplicates is knowing the difference between distinct and Unique. ⭐ Distinct refers to a count of items in a list after removing duplicates ⭐ Unique refers to a count of items in a list that appears ONLY ONCE. Distinct...
by Crispo Mwangi | Aug 5, 2022 | ADVANCED EXCEL
The ability to clean data is one of the most valuable skills for any data analyst. Below are 3 ways how to clean any special character from a string. Using a Formula...
Recent Comments