Excel University Blog
Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.
Functions
Welcome to our tutorial on how to count and sum negative numbers in Excel! We will cover three exercises where we will learn how to utilize COUNTIF, SUMIF, and conditional formatting to count, sum, and identify negative transactions. By the end, you will have multiple techniques to operate on negative numbers in Excel. Let’s jump…
Read More
The objective of this tutorial is to show how to use wildcards with the XLOOKUP and FILTER functions in Excel. We will learn how to perform partial matches and search for specific patterns within a dataset. Video Walkthrough Let’s take it one exercise at a time, starting with our XLOOKUP warm-up. Exercise 1: XLOOKUP warm-up…
Read More
The objective of this tutorial is to learn how to write formulas in Excel that can identify specific text strings within cells. We will start by using the SEARCH function to find cells that contain a specific word, then convert the results into TRUE / FALSE values, and finally apply conditional formatting to highlight these…
Read More
In this tutorial, we will explore different methods of rounding values in Microsoft Excel. We will learn how to use various rounding functions and understand the difference between rounding through formulas and changing the displayed value through formatting. We will round by the number of decimals or whole numbers as well as to the nearest…
Read More
The goal of this tutorial is to provide step-by-step instructions on how to use various methods to extract or identify the smallest values in a list. We will cover three exercises that include the SMALL function, the SEQUENCE function, and conditional formatting. Video Walkthrough Let’s take each of these methods one at a time. We’ll…
Read More
This tutorial shows how to use the SUMIFS function to sum the amounts for records that fall between two dates. By the end of this tutorial, you will be able to enter the desired date range into two input cells, and have Excel immediately sum the values that fall between these dates, even if the…
Read More
This tutorial demonstrates how to count the number of date cells that fall between two specific dates using COUNTIFS. We will start with a simple exercise using a single condition and gradually progress to more complex exercises involving multiple conditions and comparison operators. By the end of this tutorial, you will be able to perform…
Read More
In this tutorial, we will learn about dynamic array formulas in Excel, which allow us to write a single formula that returns multiple results and spills them into adjacent cells. We will cover various exercises, exploring array creation, dynamic array functions, and combining functions for powerful data manipulation. By the end, you’ll have a solid…
Read More
Welcome to this tutorial on combining text in Excel! In this post, we will explore three different ways to join or combine text values in Excel. Whether you want to use Flash Fill, concatenation, or the TEXTJOIN function, we will cover them all. So let’s get started! Video Step-by-step Tutorial The objective of this tutorial…
Read More
If you need to calculate the age in years based on a list of birth dates in Excel, fear not! In this short tutorial, we’ll cover a few functions that will help, as well as a method to count the number of rows in each age group. Specifically, we’ll explore the YEARFRAC, TRUNC, DATEDIF, and…
Read More