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, 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
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…
Read More
I am excited to announce this year’s Excel University scholarship winners! This scholarship is supported by the Excel University Alumni Association, so thanks to all of you who have helped make these awards possible over the past 9 years. This was a very competitive scholarship year with many applicants! Thanks to all of the students…
Read More
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…
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