by Crispo Mwangi | Jan 27, 2017 | BASIC EXCEL, INTERMEDIATE EXCEL
Finding the Nth or the Last value in a sorted or unsorted list can pose a challenge if you do not understand which functions to use. This article will show you different ways to carry out this sort of find and retrieve an item in a sorted list. How to handle the...
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 | Jul 23, 2016 | BASIC EXCEL
A Wildcard is a symbol used to replace or represent one or more characters. Excel wildcards are either an asterisk (*) which represents one or more characters, a question mark (?) which represents a single character or a tide (~) used to distinguish between normal...
by Crispo Mwangi | Jul 8, 2016 | BASIC EXCEL
The human being cannot consciously generate random numbers sequences as they tend to avoid/favor picking specific numbers yet there is so much application of randomness in life. Random numbers are useful in a number of ways, such as generating data encryption...
Recent Comments