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.
Keyboard Shortcuts
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…
Read More
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…
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
Let’s say you’ve been building a worksheet to share with your coworkers. When you share it, they’ll be able to see, edit, and change everything that’s in the workbook, including your formulas. It can sometimes be a little too easy to make those changes accidentally. That’s why it’s a good idea to lock and even…
Read More
You might be surprised how much time is lost flipping between Excel workbooks trying to find information – especially if you have a lot to sort through. Learning how to merge Excel files will make finding information easier, faster, and more user-friendly (especially if you’re sharing workbooks). While you can use VBA to combine files,…
Read More
Even if you’ve been using Excel for a while, you may find yourself Googling how to use or access certain features. For example, if you rarely need to convert units of measurement, you might forget the function that does that for you. We’ve put together a list of very common Excel questions that you can…
Read More
Do you use Excel frequently and find that you often have to repeat the same tasks over and over? If so, you can use Microsoft Excel macros to automate those tasks and cut down on how much time it takes to complete them! You can create a macro by recording your keystrokes and mouse clicks,…
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