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.
Conditional Formatting
When a formula contains an invalid cell or range reference, the #REF! error is displayed. #REF! in Excel is short for reference, and you’ll usually see it pop up when cells that were referenced in formulas are deleted. They can be a nuisance, but they’re usually pretty simple to find and fix. Here’s how to…
Read MoreMan sitting at a desk with an open computer learning How to Clean Data in Excel
Read MoreA duplicate value is a value that shows up more than once in a spreadsheet. These pop up all the time when working with datasets, and they can be tedious to sort through if you don’t know the quick ways to find them. Learn how to highlight duplicates in Excel to make the process take…
Read MoreLooking for some advanced Excel tips to help you become a spreadsheet pro? We’re sharing 8 tips that will take your skills to the next level!
Read MoreYou 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 MoreThese top 8 Excel tips and tricks will free up tons of time and allow you to get more work done even faster.
Read MoreIn this post, we’ll see how to create an Excel calendar with a single formula. Specifically, we will write a formula that displays the days of any month in a graphical calendar format. Our graphical calendar displays the days of the specified month in 7 columns (Sunday through Saturday) and includes a row for each…
Read MoreThis is the first post in the Slow to Fast series, where we will incrementally improve the task of comparing two lists (commonly called a reconciliation). The illustration I’ll use is a bank reconciliation. We want to compare the list of checks in our accounting system with the list of checks from our bank download.…
Read MoreI was recently asked how to set up conditional formatting to format a row based on the value in a column. In this post, I’ll demonstrate how to create a conditional formatting rule that automatically formats a row based on a single column value for all rows in the worksheet. Thanks Karla for your question!…
Read MoreComparing lists is a fairly common task in Excel, and as with anything, there are many ways to approach it. When we compare two lists, we are essentially trying to find out which names appear in both lists, or, which names appear in only one list. Tony posted a blog comment about how to perform…
Read More