# 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

## Translating Text and Converting Units

| September 3, 2024 |

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…

## 2024 Scholarship Winners

| August 30, 2024 |

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…

## Match Text Patterns with REGEX

| August 27, 2024 |

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…

## Any value in A also in B

| August 20, 2024 |

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…

## Split Amount into Annual Columns

| August 13, 2024 |

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…

## Format Items Found in a List

| August 6, 2024 |

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,…

## Formatting Condition is a Calculated Value

| July 30, 2024 |

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…

## Last Date in Column

| July 23, 2024 |

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…

## Turn a Table of Events into a Graphical Calendar

| July 16, 2024 |

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…