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.
Excel
Hello and welcome to an exciting dive into the world of Regular Expressions (regex) in Excel! Today, we’re going to explore three powerful new functions in Excel: REGEXTEST, REGEXEXTRACT, and REGEXREPLACE. If you’re not familiar with regex, don’t worry—we’ll start from the basics and work our way up. Note: these are new functions and are…
Read More
I recently received a question: “I have two columns of numbers and want one cell at the top to tell me if any values in column A exist in column B.” In this blog post, we’ll walk through how to accomplish this using some essential Excel functions. Video Objective The question asked how to write…
Read More
Hello and welcome to our guide on how to split amounts into annual columns! We will tackle this using a built-in tool called Power Query. If you’ve never used Power Query in Excel before, no worries, I’ll guide you through the process one step at a time! Video Objective We are trying to split a…
Read More
In this post, we’ll learn how to format a range to automatically highlight any items found in a list. In other words, we will learn how to highlight transactions that have a status value that matches any of the status values in a specific list, such as Pending or Processing. This illustration uses status values,…
Read More
Hello and welcome to this tutorial on how to use conditional formatting with a calculated value in Excel! Today, we’re going to dive into the following question: How do you conditionally format a cell when the condition is based on a calculated value? Let’s jump right in! Video Tutorial Let’s work through the concepts sequentially…
Read More
Hello and welcome to our latest tutorial! Today we’re diving into a common Excel challenge: finding the last date in a column. This is especially useful if you add rows to your data regularly. Let’s explore three different exercises to solve this problem. Video Tutorial Exercise 1: Using the TAKE Function in a Table Step-by-Step…
Read More
Today, we’re tackling the following question: How do you create a calendar that can show multiple events per day in Excel? We’re going to transform a simple table of events into a dynamic, graphical calendar. Let’s dive right in! Objective In summary, we have a list of events stored in a Table named Table1, like…
Read More
Today we will tackle a common question: “How can we combine numerous tables that are in the same workbook?” Let’s dive right in and learn how to easily combine tables, even if they have different column orders! Video Step-by-step Process In this guide, we’ll explore how to use Power Query to combine several tables from…
Read More
Have you ever wondered how you could work some magic in your Excel sheet such that you could include formulas, yet your cell appears empty? Have you pondered on making your Excel worksheets more secure by protecting your formulas from being changed or seen? If so, this blog post is for you! We will dive…
Read More
This article will help you navigate the waters of common XLOOKUP errors and issues. We’ll first begin by identifying errors, issues, and unexpected results. Then we’ll talk about specific ways to avoid and address each one. I hope this article will help you be able to use this wonderful function more effectively in your workbooks!…
Read More