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

Excel How To Remove Duplicates (3 Easy Ways)

By Jeff Lenning | May 30, 2023 |

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
Woman happily looking at her laptop after learning how to hide rows in Excel based on cell value

Hide Rows in Excel Based on Cell Value (Without VBA)

By Excel University | February 28, 2023 |

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
Frustrated woman looking at a computer screen while learning how to fix #REF in Excel

What’s #REF in Excel and How to Fix It

By Excel University | November 15, 2022 |

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

How to Clean Data in Excel – 8 Easy Ways

By Excel University | November 8, 2022 |

Man sitting at a desk with an open computer learning How to Clean Data in Excel

Read More
Woman looking through a magnifying glass at how to highlight duplicates in excel

How to Highlight Duplicates in Excel

By Excel University | July 26, 2022 |

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
Woman pointing to the left while thinking about advanced Excel tips

Even Pros Could Learn a Thing or Two From These 8 Advanced Excel Tips

By Excel University | June 21, 2022 |

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
Woman sitting in front of laptop with a cup of coffee while learning the top Excel skills

These Top Excel Skills are Surprisingly Easy to Learn

By Excel University | May 24, 2022 |

You 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 More
Piggy bank with a clock on top to represent time saved by learning Excel tips and tricks

Top 8 Excel Tips and Tricks to Save You Time

By Excel University | April 5, 2022 |

These top 8 Excel tips and tricks will free up tons of time and allow you to get more work done even faster.

Read More

Excel Calendar with One Formula

By Jeff Lenning | October 20, 2021 |

In 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 More

Slow to Fast 1

By Jeff Lenning | February 8, 2021 |

This 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 More