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.
Posts
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
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
Hello and welcome to our latest tutorial! Today we’re diving into a common Excel challenge: finding the last date in a column. This is especially useful if you add rows to your data regularly. Let’s explore three different exercises to solve this problem. Video Tutorial Exercise 1: Using the TAKE Function in a Table Step-by-Step…
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
Today we will tackle a common question: “How can we combine numerous tables that are in the same workbook?” Let’s dive right in and learn how to easily combine tables, even if they have different column orders! Video Step-by-step Process In this guide, we’ll explore how to use Power Query to combine several tables from…
Read More