by Crispo Mwangi | Sep 30, 2022 | BASIC EXCEL
This is part 1 of the 4 part series on What if analysis. This blog will cover the Goal Seek feature. What is the Goal Seek feature? Goal seek enables you to see how a change in one value in a model can change the final result. Instead of guessing what impact a value...
by Crispo Mwangi | Sep 23, 2022 | BASIC EXCEL
If you are not using the excel fill series in your day-to-day tasks you are wasting a lot of time You can quickly enter sequential numbers or numbers following a pattern using the Autofill options. And since excel stores Dates & Times as numbers, these can also be...
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 | 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 | Jun 17, 2022 | BASIC EXCEL
Duplicates can be a mess in data analysis. Here is an easy way to conditionally highlight duplicates in rows The only trick here is knowing how to COUNTIF function to count data using a criteria
by Crispo Mwangi | Jun 10, 2022 | BASIC EXCEL
COUNTIFS is a very important function when you want to count items with criteria. By default, COUNTIFS criteria are related using AND logic. For example, the below function will count all “Furniture” Products whose Sales Currency is “KES” i.e...
Recent Comments