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.
Features
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!…
Today we’re going to be discussing how to use AI to write formulas in excel. This new capability is available now in Excel online, and may be available in other versions of Excel in the future. Video Note At the time of this post, this feature is available in some version of Excel Online, and…
Creating 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…
Being 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…
My 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…
Whether 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…
You’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…
Any work you do in Excel is built around data. The cleaner the data is, the easier worksheets are to read and maintain – and correct formatting plays a big role. Being able to remove leading spaces in Excel helps make your data look clean and keeps your formulas operating as expected. Extra leading spaces…
Selecting every other row in Excel can be helpful. Aside from making it easy to get rid of duplicate rows, it can also be a great way to highlight important information, make the data easier to read with formatting, and more. However … if you’ve ever tried to select every other row in Excel, you…
Excel is used for many different tasks, such as budgeting, reporting, comparing bank statements, and other things. It can also be used to export, clean, and import data between two separate systems. For example, suppose you export transactions from an e-commerce system, open them in Excel, tidy up the information a little, and then transfer…