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.
Features
The objective of this tutorial is to demonstrate three different methods to change the case of text in Microsoft Excel: Flash Fill, formulas, and Power Query. By the end of this tutorial, you will be confident in using these techniques to convert text to upper case, lower case, and proper case. Video Walkthrough Let’s walk…
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…
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…
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…
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…
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…
Inserting Pictures into Cells in Microsoft Excel: A Step-by-Step Guide Overview Hello and welcome to the first post in the Pictures in Excel series! In this first post, we will explore a new feature in Microsoft Excel that allows you to insert pictures directly into cells. This feature provides a range of benefits, and we…