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.
Jeff Lenning
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…
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…
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…
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…
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…
How to Insert Images into Excel Cells with Data Types and Use Them in PivotTables Welcome to the final post in the Pictures in Excel series! In this tutorial, we will insert images into Excel cells using data types and then incorporate these images into PivotTables. By the end of this post, you’ll learn how…
How to Use Pictures and PivotTables in Excel Introduction Welcome to the next post in our Pictures in Excel series. In this tutorial, we’ll explore how to use pictures as cell values and incorporate them into PivotTables. So, let’s jump right in! Note: the capabilities presented in this post are not available in all Excel…
I am excited to announce this year’s Excel University scholarship winners! This scholarship is supported by the Excel University Alumni Association, so thanks to all of you who have helped make these awards possible over the past 8 years. This was the most competitive scholarship year with more applicants than ever! Thanks to all of…
Retrieving and Displaying Online Pictures in Microsoft Excel Introduction Hello and welcome to the next post in our Pictures in Excel series, where we are exploring applications of inserting images into cells. In the previous videos, we focused on inserting pictures from our local devices into cells on the worksheet. Today, we will learn how…
Using Pictures as Cell Values in Excel Formulas Overview Welcome to the second post in the Pictures in Excel series! In this tutorial, we will learn how to insert pictures as cell values in Microsoft Excel and utilize these pictures in formulas. By the end of this tutorial, you will be able to store images…