Many people will tell you that you should use INDEX/MATCH instead of VLOOKUP or that you should use a new function like XLOOKUP instead. But you shouldn't be so quick to ditch arguably the most popular function on Excel as it's still very useful. ...
The bulk of Excel users will likely stick to 2D charts that just have an x and y axis. But if you want to add a third element and give your visuals a bit more context, you can create a 3D bubble chart in Excel. Below, I'll show you how to do just th ...
If you're getting an error message in your Excel spreadsheet that there's a circular reference, that means that at least one of your calculations is referencing back to itself in one way or another. It doesn't always have to be that two cells are re ...
There are many ways you can pull and count unique values in Excel, and below, I'll show you five ways you can do so and when you should use each method. For this example, I'm going to use a dataset from data.gov relating to consumer complaints a ...
If you're an accountant, you know that quickly doing a t-account can sometimes help you plan your journal entries and save you some headaches later on. But sometimes it can be time-consuming and a bit cumbersome to go through the process of setting ...
Unless you're still stuck on old versions of Excel, you probably know that you can filter data using colors. And by doing so you can use the SUBTOTAL function in excel to tabulate those amounts. But in this post, I'm going to show you something a li ...
If you earn income from multiple jobs, you know how important it is to keep track of how much you're making. If you work too little, you may not be making as much as you were planning. And if you're working a lot more, you could afford to give yours ...
Array formulas can be challenging to understand but they're worth learning as they can create significant efficiencies for your spreadsheets. Below, I'll show you how you can do two calculations within a single array formula in Excel. Using an ar ...
There are many ways you can speed up data entry in Excel. Using autofill can be particularly helpful because Excel can normally figure out patterns and the formulas that you're going to want to enter. It can save you lots of time from having to manu ...
If you're doing any type of data analysis, a moving average can be useful in smoothing trends and normalizing data. Below, I'll show you how you can easily create a moving average in Excel. The data will again be based on the retail and food service ...
