How to Remove #DIV/0 Error in Excel
If you’re an Excel user, you’ve probably encountered the dreaded #DIV/0 error at some point. This error occurs when you attempt to…
-
-
Average formula in Excel – AVERAGE, AVERAGEIF, AVERAGEIFS function
There are many areas within business reporting where we are looking for the average of a selection of results. A good example…
-
How to do a VLOOKUP with multiple criteria in Excel
There are times when you want to return a match for a VLOOKUP based on multiple criteria. For example, we may have customers…
-
How Change Case in Excel
In this blog we will cover how to change the case of your text in Excel with or without a formula. If…
-
Excel – Using VLOOKUP to compare two lists
If you’re using Microsoft 365, XLOOKUP is now the better and more flexible option than VLOOKUP, and I highly recommend learning it…
-
How to create a list of Working Days – Excel WORKDAY function
This post has been updated and added to by Sharyn, November 2020. Need a list of weekdays or workdays only? Let’s look…
