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.

XLOOKUP

Replace 25+ Nested IFs with a Single Simple Lookup

By Jeff Lenning | June 11, 2024 |

I was recently asked the following question: “I have a drop-down with 25+ categories that determines the fee percentage. Can I use an IF function to compute the fee based on the selected category?” I answer this question in this post. Video Objective Let’s begin by understanding the objective and the question. There is an…

Read More

Create a Dynamic Month List for Reports or KPIs

By Jeff Lenning | January 30, 2024 |

In this tutorial, we will learn how to create a dynamic list of months in Excel using various functions including TAKE, EOMONTH, and SEQUENCE. This list can be used for reporting or pulling key performance indicators (KPIs) with lookup functions such as XLOOKUP. If you create the same basic report each month, and would like…

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

Pictures in Excel 3: Pictures with URLs

By Jeff Lenning | August 29, 2023 |

Retrieving and Displaying Online Pictures in Microsoft Excel Introduction Hello and welcome to the next post in our Pictures in Excel series, where we are exploring applications of inserting images into cells. In the previous videos, we focused on inserting pictures from our local devices into cells on the worksheet. Today, we will learn how…

Read More

Excel How To VLOOKUP Left (3 ways)

By Jeff Lenning | April 4, 2023 |

If you’ve used the VLOOKUP function before, you know that the lookup column is expected to be in the leftmost column within the range. Meaning, it’s going to look for a value in the leftmost column within the range and once it finds its match, it will shoot to the right to return the related…

Read More

Excel How To Get the Last Row and Column Value

By Jeff Lenning | March 28, 2023 |

In this blog post, we are going to learn how to use two Excel functions, TAKE and XLOOKUP, to retrieve data from the very last row of a table. Knowing how to use these two functions can be incredibly handy when you add a new data row every day, week, or month and want your…

Read More
Woman sitting in front of laptop with a cup of coffee while learning the top Excel skills

These Top Excel Skills are Surprisingly Easy to Learn

By Excel University | May 24, 2022 |

You don’t need to be a spreadsheet pro to master these top Excel skills! See our list of easy-to-learn Excel skills with hands-on tutorials.

Read More
Holding an Excel formulas cheat sheet in one hand and a pencil in the other

Excel Formulas Cheat Sheet for Beginners

By Excel University | May 17, 2022 |

Excel is one of the most powerful accounting software tools out there, and most of that power comes from the ability to use Excel formulas to automate your work. When you’re first learning how to use them, it’s easy to get a little overwhelmed – luckily, this Excel formulas cheat sheet is here to help…

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

Easily Create and Update Excel Reports from QuickBooks

By Trevor Lee | March 22, 2022 |

In this article, we’ll show how to easily create and update Excel reports from QuickBooks. But, let’s back up a second. When QuickBooks has the report you want, awesome! But, when it doesn’t, we often turn to Excel. This can happen when QuickBooks doesn’t have all of the data you need for the report, for…

Read More