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 this post, where we’ll dive into Excel’s TRIMRANGE function and its companion Trim Refs operators. These recent additions make working with dynamic ranges and calculated columns more efficient and intuitive. Note: as of the time of this post, these are in limited release and not all versions of Excel have them. For availability…
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…
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.…
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…
Hello, Excel enthusiasts! Welcome to another tutorial where we dive into some of Excel’s most intriguing functions. Today, we’re exploring three fantastic Excel functions that can help you translate text, detect languages, and convert units of measurement right within your spreadsheet. These functions are TRANSLATE, DETECTLANGUAGE, and CONVERT. Let’s jump right in! Video Step-by-Step Guide…
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…
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…
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,…