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
Creating an interactive Excel dashboard doesn’t have to be complicated. With just a few steps, we can transform raw data into a dynamic, easy-to-read report that updates automatically as new data comes in. In this guide, we’ll walk through the process of building an Excel dashboard using pivot tables, pivot charts, and a timeline filter.…
Read More
Are you ready to save hours of manual work each week? In this guide, we’ll explore how to automate your workflow in Excel using tools like Power Query, Pivot Tables, and Pivot Charts. Best of all, you don’t need to be a coding wizard to get started. By the end, you’ll know how to effortlessly…
Read More
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, 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
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.…
Read More