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
When working with drop down lists in Excel, creating dependent drop downs that dynamically adapt based on a primary choice is both powerful and time-saving. This post walks through setting up rows of dependent drop downs and concludes with a method to notify users when a secondary choice becomes invalid. Let’s dive in! Video Step-by-step…
Read More
Hello, Excel enthusiasts! Today, we’re diving into a neat trick: automatically formatting input cells based on whether they meet specific criteria. The goal? Identify and format cells where the first digit of the input is a “4.” But, you can apply this same technique to other criteria. By the end of this post, you’ll have a clear…
Read More
Have you ever wondered how to set up checkboxes in Excel that check themselves automatically based on the value of another cell? Whether you’re tracking tasks, orders, or reviews, Excel’s checkbox feature can streamline your process. In this blog post, we’ll walk through step-by-step examples to create self-checking checkboxes. Let’s dive in! Video Step-by-step Tutorial…
Read More
Hi there! Today, we’re diving into the following Excel question: How do I highlight incorrect answers in a worksheet? It’s a great topic because conditional formatting is such a powerful tool for visualizing data in real time. Whether you’re creating a quiz, a workbook for training, or just need to check values against an answer…
Read More
Removing duplicates in Excel is a common task, but what if you want more control than the Remove Duplicates command provides? Maybe you need a formula to handle duplicates dynamically. In this guide, we’ll cover how to remove duplicates from a single column, handle multiple columns, and use formulas for various scenarios like summing, finding…
Read More
In this post, we’ll dive into the following Excel question: How do you sum positive values between two dates? Using the SUMIFS function, we’ll walk through three exercises to build a solution step by step. By the end, you’ll have a clear understanding of how to sum data based on multiple conditions. Let’s get started!…
Read More
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…
Read More
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…
Read More
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!…
Read More
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…
Read More