by Crispo Mwangi | Aug 4, 2017 | ADVANCED EXCEL
On Linkedin, a user commented on how he has been struggling to recreate the Federal Reserve dot Plot. After being puzzled for almost 2 years, he came to realize how REPT function in excel can be of great help. After searching the web, I have found there is no...
by Crispo Mwangi | Jun 29, 2017 | ADVANCED EXCEL, INTERMEDIATE EXCEL
When is the last time you used the REPT function in Excel? REPT is one of excel’s little-known, overlooked, and underutilized function, yet very useful. Generally, REPT returns a specific text string a specified number of times....
by Crispo Mwangi | Jun 16, 2017 | ADVANCED EXCEL, INTERMEDIATE EXCEL
IF function is one of the most used functions in Excel. In my opinion, it is the foundation of all programming and Excel formulae mastery. However, it is also one of the most misused functions, especially Nested IF. Especially now with Excel 2007 and beyond,...
by Crispo Mwangi | Oct 8, 2016 | ADVANCED EXCEL
Having done a series on Verticle lookup, it is only fair to touch on the Horizontal lookup. HLOOKUP function is the most popular function for this kind of lookup but it has a number of limitations and thus one may need to know a few other ways you can carry out a...
by Crispo Mwangi | Sep 11, 2016 | ADVANCED EXCEL
This is the last article in the series of reverse lookup in excel. Unless you are already versed with Reverse Lookup, consider checking below 2 articles first; Reverse Lookup & Reverse Lookup with duplicates Now using VBA we are going to look up the date, time and...
by Crispo Mwangi | Sep 7, 2016 | ADVANCED EXCEL
It is good to be able to do a Reverse Lookup but it is Awesome if you know how to return Multiple Items. Before you continue with the current article, Please revisit the Previous Article on reverse lookup as this is a continuation. Suppose you are managing a project...
Recent Comments