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
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 MoreCombining data from multiple tables in Excel has historically been very manual … especially when the tables have different column orders. In this blog post, we’ll tackle this challenge by getting Excel to combine the tables with a formula that uses the VSTACK and CHOOSECOLS functions. Video Step by step Let’s use a basic example.…
Read MoreIf you have ever tried to combine data from different tables manually, that is a lot of copy/paste! In this post, I’ll show you how to use Excel’s VSTACK function so you can do it instantly with a single formula. No copy/paste needed!! Video Step by Step Let’s say you have a table in Excel…
Read MoreCreating banded rows in a Microsoft Excel table is a great way to make data easier to read and interpret. Banded rows can also be used to help separate and highlight important information. You don’t need to use VBA, Power Query, or manual formatting – you can do it quickly and easily with just a…
Read MoreBeing able to hide rows based on cell value in Excel is a handy skill for anyone who needs to organize a large spreadsheet. Imagine you have a huge list of data, but only some of the rows are relevant to you at the moment. When you hide rows based on cell value, you can…
Read MoreMy friend John Michaloudis does an annual survey of Excel MVPs and experts and asks for their best Excel tip. He compiles the tips into an audio podcast along with show notes and related links. This is a great resource and I love sharing it every year. This year, he rounded up tips from: You’ll…
Read MoreWhether you’re working with something like test scores, tracking expenses, or any other type of data, being able to round numbers to the nearest 5 in Excel is a handy skill. This is helpful when you need to round to the nearest multiple (like 5) instead of simply to the nearest whole number. Here are…
Read MoreMicrosoft Excel is fantastic since it simplifies the process of creating and managing a portfolio (especially an investment portfolio). Basis Points can be referenced in stock trading, indexing, and interest rates when expressing percentage changes. Having a handy calculator makes them much easier to determine. Building a Basis Points calculator in Excel is probably easier…
Read MoreWhether you’re tracking your personal or business finances, an average daily balance calculator in Excel can help you get a better understanding of your loan payments, and it can also be useful for creating payment projections. The average daily balance method is commonly used to calculate finance charges for credit card balances, as well as…
Read MoreYou’ve probably come across situations where Excel didn’t allow you to make certain changes to your data because some of the cells you selected were merged. But, it can be tough to find merged cells in Excel because they often look so similar to others. Working with large datasets makes it even more difficult as…
Read More