Overlooked uses MOD function

7 Overlooked Uses of Excel MOD Function

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

Sumproduct Vs Other Functions

SUMPRODUCT–EXCEL’S MOST POWERFUL FUNCTION

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

Have you ever looked for an Excel function that is extremely powerful, flexible and has multiple uses? The ONE function that will solve most of your daily array of problems? The ONE function that will open doors to advanced Excel skills? Well! This is it—SUMPRODUCT. SUMPRODUCT can be used to: One way lookup  with multiple […]