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
Welcome to our tutorial on how to count and sum negative numbers in Excel! We will cover three exercises where we will learn how to utilize COUNTIF, SUMIF, and conditional formatting to count, sum, and identify negative transactions. By the end, you will have multiple techniques to operate on negative numbers in Excel. Let’s jump…
Read More
The objective of this tutorial is to learn how to write formulas in Excel that can identify specific text strings within cells. We will start by using the SEARCH function to find cells that contain a specific word, then convert the results into TRUE / FALSE values, and finally apply conditional formatting to highlight these…
Read More
The goal of this tutorial is to provide step-by-step instructions on how to use various methods to extract or identify the smallest values in a list. We will cover three exercises that include the SMALL function, the SEQUENCE function, and conditional formatting. Video Walkthrough Let’s take each of these methods one at a time. We’ll…
Read More
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…
Read More
This post demonstrates how to remove duplicates from your Microsoft Excel worksheets. As with just about anything in Excel, there are multiple ways. I’ll show you 3 of the easiest and fastest ways to do it, specifically: the Remove Duplicates command, the UNIQUE function, and Power Query. Video Narrative We’ll just walk through each of…
Read More
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…
Read More
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 More
Man sitting at a desk with an open computer learning How to Clean Data in Excel
Read More
A 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 More
Looking 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 More