by Crispo Mwangi | Sep 9, 2022 | BASIC EXCEL
The SEARCH and FIND functions in excel both return the position of a text in a text string. For example, what is the position of the text “Air” in “American Airlines Group”? Both functions return 10 which means the text “Air” starts...
by Crispo Mwangi | Sep 2, 2022 | INTERMEDIATE EXCEL
The first step to conditional formatting a date or time in a DateTime is understanding how Excel stores dates and times. Date is stored as an integer with 1/1/1900 = 1 therefore 9/2/2022 is stored as ► 44806 Time is stored as a fraction of 24 hours therefore 4:30:00...
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...
Recent Comments