by Crispo Mwangi | Feb 8, 2018 | INTERMEDIATE EXCEL
Every organization requires weekly summaries to monitor peak and off-peak periods. This is mostly so when you are in the production section. Excel has a beautiful but overlooked...
by Crispo Mwangi | Oct 5, 2017 | BASIC EXCEL
The ability to lookup number values in excel is a must-have for all data analysts. Some Excel users just know the basic VLOOKUP function but there are 7 more functions to lookup...
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...
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...
by Crispo Mwangi | Feb 3, 2017 | BASIC EXCEL, INTERMEDIATE EXCEL
In the previous article, we looked at 6 ways to find the last or Nth occurrence in a Sorted list in excel. Unsorted list poses a challenge since you need to find the...
Recent Comments