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.
Techniques
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!…
Have you ever encountered any of these common Excel situations where you need to: When you encounter these types of situations, what do you do? My guess is you probably start with a Google search, then follow several links to various blog posts and videos. Sometimes, they will provide you with the answers you are…
If you’ve used the VLOOKUP function before, you know that the lookup column is expected to be in the leftmost column within the range. Meaning, it’s going to look for a value in the leftmost column within the range and once it finds its match, it will shoot to the right to return the related…
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…
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…
In this third and final post of the Skipping Excel series, we’ll connect all the dots and use Zapier to complete our automation. In case you are just joining the series … I’ve been documenting my journey for getting my e-commerce sales into QuickBooks Online. In an ideal situation, there would be a direct built-in…
In this post, the second in the Skipping Excel series, I’ll walk you through the details of the next iteration of this process. In case you are just joining this series, in the first post Skipping Excel 1, I reviewed the manual process of getting my e-commerce transactions into QuickBooks Online. It took about 30…
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…
These top 8 Excel tips and tricks will free up tons of time and allow you to get more work done even faster.
Historically, we’ve had two basic ways to create reports in Excel. We could enter the report labels and use formulas to compute the report values or we could use a PivotTable. Both options had pros and cons. We’d have to pick the report type based on the context of our workbook. In this post, I’ll…