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 16, 2022 | ADVANCED EXCEL
Most lookup functions by default return either the 1st or the last match item. How do you return all matching multiple results in a lookup? How do you return all the customers who bought the product below? USING VLOOKUP TO RETURN MULTIPLE RESULTS...
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...
Recent Comments