REPT IMAGE

7 WAYS TO USE EXCEL REPT FUNCTION

Crispo Mwangi | 29-Jun-17 | 7 Comments

When is the last time you used 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. =REPT(“Text”, Number of times) Here are 7 ways you can start using REPT function. ADD LEADING ZEROS CREATE INLINE […]

daverage-functions

DAVERAGE vs AVERAGEIF & DCOUNT vs COUNTIF

Crispo Mwangi | 4-Dec-16 | Leave a Comment

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 functions prevail in terms of speed over their IFS equivalent? DAVERAGE vs AVERAGEIFS For example using below data compute the […]

dsum

EXCEL DSUM FUNCTION

Crispo Mwangi | 9-Nov-16 | 2 Comments

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; 2 way lookup Summarizing Results based on criteria 2 Way […]

database-functions

EXCEL DATABASE FUNCTION

Crispo Mwangi | 5-Nov-16 | Leave a Comment

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, DMAX, DMIN, DGET, DPRODUCT, DSTDEV, DSTDEVP, DVAR, DVAR. All these functions works basically the same way and have […]

WEEKDAY function

Excel’s WEEKDAY Function In depth

Crispo Mwangi | 8-Jun-16 | Leave a Comment

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 of WEEKDAY function: Summarize by weekday or weekend Count-if by […]