excel's OVERLOOKED AND UNDERUTILIZED 2

Excel’s Most Overlooked & Underutilized Function Part 2

Crispo Mwangi | 8-Jun-16 | Leave a Comment

Today we shall have an in-depth look at another underutilized yet powerful function especially when analyzing dates–WEEKDAY. I hope Part 1 of this series made you get acquainted with MOD function and it has become a favorite for you. Below are some of the uses of WEEKDAY function: Summarize by weekday or weekend Countif by […]

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 […]