by Crispo Mwangi | Sep 3, 2016 | ADVANCED EXCEL
In my research and tutoring excel, I have found that many people find the 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...
by Crispo Mwangi | Jun 24, 2016 | ADVANCED EXCEL
A strong password should be at least 16 characters long, include special characters, Numbers, uppercase letters and lowercase letters. A mix of all these characters makes it hard for the password to crack. Most people find it hard to create a strong password but with...
by Crispo Mwangi | Jun 18, 2016 | ADVANCED EXCEL
The 3 wildcard characters (?*~) used in other excel formulas do not work with sumproduct. However, SUMPRODUCT utilizes other functions (LEFT, RIGHT, FIND and MID) to give you the same results. Using below example showing  Cost Codes and Total Cost, ►Find the Sum of...
by Crispo Mwangi | Jun 8, 2016 | ADVANCED EXCEL
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...
Recent Comments