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 this deep dive into the fascinating world of Excel’s XLOOKUP function—specifically using it with RegEx (Regular Expressions). In this post, we’ll cover the basics of XLOOKUP, explore the new RegEx match mode, and demonstrate some practical examples. Whether you’re already familiar with XLOOKUP or just starting out, there’s something here for…
In this post, I’ll walk through the steps for how to allow users to edit specific cells in an Excel worksheet and lock down other cells. This is a useful feature when you want to protect certain data while still allowing users to make changes to other parts of your sheet. Ready? Let’s dive in!…
I recently discovered that you can upload an Excel file to ChatGPT, ask it to perform tasks on the file, and then download the updated file. In this post, I wanted to share what I discovered and demonstrate it with a few examples including unprotecting a worksheet, writing formulas, and creating a chart. Microsoft’s Copilot…
Hello and welcome! Today, we’re diving into XLOOKUP with multiple conditions. This topic is incredibly handy when working with datasets where you need to match data across multiple columns. We’ll explore three different approaches: using concatenation, Boolean arrays, and the FILTER function to retrieve data based on multiple criteria. Let’s jump right in! Video Table…
In this tutorial, we’re going to learn how to create a dynamic weekly calendar in Excel that shows which programs or events are running on any given day. This technique is perfect for managing schedules where events have different start and end dates and may only occur on certain weekdays. Objective We are trying to…
Hello, and welcome to our latest Excel tutorial! I was recently asked the following question: how do I see the max date for each vendor assuming each vendor has multiple dates? So, in this post, we’ll learn how to find the maximum date for each category — in this case, each vendor with multiple transactions.…
Hello, Excel enthusiasts! Welcome back! Today, we’re diving into an interesting question I received recently: “How do I count occurrences between two dates in Excel?” As with most things in Excel, there are multiple ways to accomplish this task. In this post, I’ll focus on how to achieve our goal with a PivotTable. If you’re…
Today, I’ll tackle a question I received recently about checkboxes. The question was essentially about how to add two values in Excel when a checkbox is checked. I’ll walk though the answer with you in this short post. Let’s jump right in! Video Step-by-Step Guide Exercise 1: Getting Started with Checkboxes To get started, we…
This is the third post in the Copilot in Excel series. In this series, we’re diving into some exciting features of Excel’s Copilot and how it can help us streamline our workbooks. If you’ve ever found yourself needing assistance with editing or wanting to ask Excel a quick question, Copilot has your back. In this…
How to Use Excel Copilot to Understand Your Data Welcome to the second post in the Copilot in Excel series. In this post, we’re diving into the world of Excel Copilot to help us understand and analyze our data. In this post, we’ll explore how Copilot can help us make sense of the data in…