fomc

FOMC Dot Plot Chart Using REPT Function

Crispo Mwangi | 4-Aug-17 | 2 Comments

On Linkedin, a user commented on how he has been struggling to recreate 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 comprehensive article on how to recreate this […]

REPT IMAGE

7 WAYS TO USE EXCEL REPT FUNCTION

Crispo Mwangi | 29-Jun-17 | 7 Comments

When is the last time you used 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. =REPT(“Text”, Number of times) Here are 7 ways you can start using REPT function. ADD LEADING ZEROS CREATE INLINE […]

NESTED IF

7 ALTERNATIVES TO NESTED IF FUNCTION

Crispo Mwangi | 16-Jun-17 | 13 Comments

IF function is one of the most used functions in Excel. In my opinion, it is the foundation of all programming and Excel’s formulae mastery.  However, it is also one of the most misused functions, especially Nested IF. Especially now with Excel 2007 and beyond, you can nest up to 64 IF functions to form complex, […]