reverse LOOKUP

REVERSE LOOKUP IN EXCEL

Crispo Mwangi | 3-Sep-16 | 2 Comments

In my research and tutoring excel, I have found that many  people find Reverse lookup concept to be among the top 10 complicated things in excel. This article hopes to shed more light than heat in demystifying the Reverse Lookup in excel. In the normal lookup, we use the Column and/or Row header to return the value that […]

excel's OVERLOOKED AND UNDERUTILIZED

Excel’s Most Overlooked & Underutilized Function Part 1

Crispo Mwangi | 7-Jun-16 | 10 Comments

In Over  450 functions in excel, there are  some powerful but highly underutilized functions and some overly popular functions too. Functions like IF,SUM,COUNT,AVERAGE are well known by all excel users. Yet there are some functions like MOD, WEEKDAY, WORKDAY, CHOOSE, DATEDIF, DELTA, SUBSTITUTE, HYPERLINK are rarely used. This is part 1 of a series in which […]