Average Functions

  • How to Use The AVERAGEIFS Function - The need to find the average of a range of numbers is fairly common. For instance, imagine you want to know the average grade in a selection of exam results, or the average order value for a customer. Thankfully, Excel has some built-in functions that can provide this information quickly. The AVERAGEIFS function is one ...

Count Functions

  • How to Use The COUNTIF Function - In this blog post, we're going to look at how to use the COUNTIF function. The COUNTIF function counts the number of cells in a range that match a certain criterion. For example, imagine you have a range of cells that contains sales data, and you want to know how many times you have achieved ...

Date Functions

  • Introduction to Excel Date Functions Part 1 - In this series of blog posts, I am going to show you how to output dates in different formats and walk you through some of the most commonly used date functions in Excel. In the first blog post, we're going to come to grips with how to format dates differently and have a look at ...
  • Introduction to Excel Date Functions Part 2 - In this blog post, we're going to look at some more date functions that enable you to identify the day, month, and year number in a date. We will also look at functions like the WEEKDAY, WORKDAY and NETWORKDAYS that can be used to calculate dates and the number of days between two dates, taking ...
  • Introduction to Excel Date Functions Part 3 - This is the final post in a three-part series of blog posts introducing Excel date functions. In this final post, we look at a few of the less used, but still very useful date functions such as YEARFRAC and WEEKNUM, the DATEDIF function which is maintained for backwards compatibility reasons with Lotus 1-2-3. Additionally, for ...

Logical Functions

  • How to Use the Excel Logical Functions - In this blog post, I'll use examples to show you how to use some of the Excel logical functions, including the IF, OR, and AND functions, to name a few. Logical functions enable you to choose the outcome of a formula based on various criteria that you define.

Lookup Functions

  • How to Use the INDEX MATCH Functions to Find Data - In this blog post, we are going to take a look at how we can use a combination of the INDEX and MATCH functions, commonly referred to as INDEX MATCH, to find data in a range of cells. Chances are that you are familiar with the VLOOKUP function. VLOOKUP is my favourite function. It can ...
  • How to Perform a Two-Way LOOKUP Using INDEX MATCH MATCH - In this blog post, you will learn how to perform a two-way lookup using the functions INDEX MATCH MATCH. No, that's not a typo; you will use the MATCH function twice. You’ll learn what a two-way lookup is, why it is useful, how to manage some of the error messages you may receive, and work ...
  • How to Use the VLOOKUP Function - The VLOOKUP function is one of the most commonly used and asked about Excel functions. The VLOOKUP function enables you to perform a very useful method of finding data in a worksheet known as a lookup. In this post, you'll learn the difference between VLOOKUP exact and approximate matching. You'll see how to use the ...

Math Functions

  • How to Use The SUMIFS Function - Hello and welcome to this blog post on the Excel function SUMIFS. In this blog post, I’ll show you how the SUMIFS function works, explain its syntax and provide you with some examples of how it can be used.