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.
Jeff Lenning
Inserting Pictures into Cells in Microsoft Excel: A Step-by-Step Guide Overview Hello and welcome to the first post in the Pictures in Excel series! In this first post, we will explore a new feature in Microsoft Excel that allows you to insert pictures directly into cells. This feature provides a range of benefits, and we…
Welcome to this tutorial on how to pull QuickBooks exports into Excel with Power Query. In this tutorial, we will run a QuickBooks report, download it to an Excel format, and then use Power Query to clean it up and get the data into an Excel table. We will use Power Query to import this…
If you need to calculate the age in years based on a list of birth dates in Excel, fear not! In this short tutorial, we’ll cover a few functions that will help, as well as a method to count the number of rows in each age group. Specifically, we’ll explore the YEARFRAC, TRUNC, DATEDIF, and…
If you’re looking to compare two columns in Excel with Power Query, you’ve come to the right place. In this tutorial, you’ll learn how to use Power Query to compare two lists to find which items appear on both and which items appear on only one list. Plus, you’ll learn how to match on multiple…
Using Microsoft Excel to compare two columns is a great way to look for discrepancies or similarities between two different sets of data. This post provides 3 different ways to accomplish this so that you can use the one that is most appropriate for your data and workbook. Video Step-by-step guide Let’s work through each…
Microsoft Excel can feel overwhelming with its vast array of features, commands, and tools. When you are trying to do something in Excel, and aren’t sure how … what do you do? Traditionally, this is where a Google search happens. And, we can certainly continue using online search. However, we now have another option available…
There are many built-in Excel features and functions. Which is awesome because they enable us to do so many different things. But … what happens when we want to do something for which there is no built-in feature? Are we stuck? No … we can typically get help from a macro. Macros are written in…
Whether you’re trying to decipher a macro created by someone else in your organization, or you’re trying to make sure a code sample you found online is safe to run, ChatGPT can help you understand the VBA code. If you’re not a programmer, understanding macro VBA code can be a daunting task. In this post,…
Microsoft Excel is one of the most powerful and versatile software programs available. It allows users to quickly and accurately organize, analyze, and present data. With the help of ChatGPT, learning how to write Excel formulas just got easier. While ChatGPT may not be able to write formulas that are always 100% accurate, it can…
Have you ever tried to reverse engineer or understand a complex Excel formula? Perhaps you inherited a workbook, and you encounter functions that you haven’t used before. Or, there are multiple functions in a single formula. It would really be nice if the person who created the formula could walk you through it. When this…