by Crispo Mwangi | Dec 4, 2016 | BASIC EXCEL
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 | BASIC EXCEL
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 | BASIC EXCEL
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,...
by Crispo Mwangi | Oct 8, 2016 | ADVANCED EXCEL
Having done a series on Verticle lookup, it is only fair to touch on the Horizontal lookup. HLOOKUP function is the most popular function for this kind of lookup but it has a number of limitations and thus one may need to know a few other ways you can carry out a...
by Crispo Mwangi | Sep 11, 2016 | ADVANCED EXCEL
This is the last article in the series of reverse lookup in excel. Unless you are already versed with Reverse Lookup, consider checking below 2 articles first; Reverse Lookup & Reverse Lookup with duplicates Now using VBA we are going to look up the date, time and...
Recent Comments