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.

FILTER

XLOOKUP Multiple Column Match

By Jeff Lenning | October 29, 2024 |

Hello and welcome! Today, we’re diving into XLOOKUP with multiple conditions. This topic is incredibly handy when working with datasets where you need to match data across multiple columns. We’ll explore three different approaches: using concatenation, Boolean arrays, and the FILTER function to retrieve data based on multiple criteria. Let’s jump right in! Video Table…

Read More

Weekly Calendar

By Jeff Lenning | October 22, 2024 |

In this tutorial, we’re going to learn how to create a dynamic weekly calendar in Excel that shows which programs or events are running on any given day. This technique is perfect for managing schedules where events have different start and end dates and may only occur on certain weekdays. Objective We are trying to…

Read More

Turn a Table of Events into a Graphical Calendar

By Jeff Lenning | 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…

Read More

Highlight Values Found Multiple Times

By Jeff Lenning | February 27, 2024 |

Today, we’ll highlight recurring values within a dataset in order to answer a recent question. I was asked the following “I’m trying to get it to recognize if a specific letter, like X, is in a column at least three times. What could the formula look like?” And I’ll answer that question in this post.…

Read More

XLOOKUP and FILTER with Wildcard

By Jeff Lenning | November 21, 2023 |

The objective of this tutorial is to show how to use wildcards with the XLOOKUP and FILTER functions in Excel. We will learn how to perform partial matches and search for specific patterns within a dataset. Video Walkthrough Let’s take it one exercise at a time, starting with our XLOOKUP warm-up. Exercise 1: XLOOKUP warm-up…

Read More

How to Filter in Excel

By Jeff Lenning | May 2, 2023 |

Hello there! Are you looking to learn how to filter in Excel? You’ve come to the right place! Filtering is an incredibly useful feature in Excel that allows you to quickly and easily sort through large amounts of data to find exactly what you’re looking for. In this article, we’ll explore: Let’s get to it!…

Read More
Man sitting at a computer with an hourglass trying to learn how to get better at Excel

How to Get Better at Excel (Without Wasting Time)

By Excel University | April 25, 2022 |

Wondering how to get better at Excel? Whether you’re a new user or a pro, these are some easy steps to help you quickly master new skills.

Read More

These Are the Top 9 Most Useful Advanced Excel Functions

By Excel University | March 15, 2022 |

Looking to make work easier? Instead of trying to do it all, focus on learning these nine useful advanced Excel functions.

Read More

PivotTable Text Values Alternative with FILTER

By Jeff Lenning | October 12, 2021 |

This is the third and final post in the PivotTable Text Values Alternative series, where we are discussing alternatives to displaying text values in PivotTables. In the first post, we used Power Query as an alternative. In the second post, we combined multiple text values. In this post, we’ll use the FILTER function as an…

Read More

Mapping Table without a Helper Column

By Jeff Lenning | September 7, 2021 |

A mapping table is a handy way to automatically translate labels between systems and reports. As with just about anything in Excel, there are many ways to implement a mapping table. For example, we could create a helper column to store the amounts with the SUMIFS function as I discussed in this Journal of Accountancy…

Read More