by Crispo Mwangi | Aug 17, 2018 | Advanced Excel, Beginner, Excel Beginner
There are times when you want to look up and retrieve values based on a list. Normal filtering can only take up a maximum of two items and limited criteria conditions. In this article, you shall learn 4 ways to lookup items not matching a list. For example, below we...
by Crispo Mwangi | Feb 8, 2018 | Advanced Excel, Beginner, Excel Beginner, TEMPLATES
Every organization requires weekly summaries to monitor peak and off-peak periods. This is mostly so when you are in the production section. Excel has a beautiful but overlooked function (WEEKNUM) that returns an integer representing the week in the year (1 to 53)....
by Crispo Mwangi | Jun 29, 2017 | Beginner, TEMPLATES, Tutorials
When is the last time you used the REPT function in Excel? REPT is one of excel’s little-known, overlooked, and underutilized function, yet very useful. Generally, REPT returns a specific text string a specified number of times....
by Crispo Mwangi | Dec 4, 2016 | Beginner, Tutorials
We have been exploring on database functions for the last two articles ( EXCEL DATABASE FUNCTION and EXCEL DSUM FUNCTION.) This article will examine DAVERAGE & DCOUNT and how they compare with their equivalent AVERAGEIFS & COUNTIFS. Will the Database...
by Crispo Mwangi | Nov 9, 2016 | Beginner, Tutorials
If you are new to Database Functions, read this Introduction to Database Functions first before you continue. In this article, we shall look into the uses of DSUM function which is one of the EFFICIENT Excel sum functions with criteria. Below are some of its uses;...
by Crispo Mwangi | Nov 5, 2016 | Beginner, Tutorials
Since their introduction in Excel 2007, DataBase functions have remained Overlooked & Underutilised. This is an Introduction in a Series of articles whose aim is to demystify these Database functions. Database functions include; DSUM, DAVERAGE, DCOUNT, DCOUNTA,...