by Crispo Mwangi | Jun 8, 2016 | INTERMEDIATE 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...
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...
by Crispo Mwangi | Jun 7, 2016 | BASIC EXCEL, INTERMEDIATE EXCEL
In Over 450 functions in Excel, MOD function is one of the highly overlooked. Generally, MOD function returns the remainder of two numbers after division. Functions like IF, SUM, COUNT, AVERAGE are well known by all excel users. Yet there are some functions...
by Crispo Mwangi | Jun 7, 2016 | INTERMEDIATE EXCEL
Looks matter both in life and data visualization—you never get a second chance to make a first impression. Numbers in excel constitute the largest data type and knowing how to format them either on Charts or on tables is a big plus towards quicker decision making....
by Crispo Mwangi | Jun 5, 2016 | BASIC EXCEL, INTERMEDIATE EXCEL
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....
Recent Comments