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
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…
Read More
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…
Read More
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…
Read More
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…
Read More
Hello, and welcome to this guide on using Copilot in Excel! This post explores how to use Copilot in Excel to execute commands and automate tasks directly within your workbook. We’ll dive into several exercises that show how Copilot can assist us in creating calculated columns, extracting values, and much more. Let’s get started! Video…
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
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