No matter how great you are with spreadsheets, sooner or later (most likely sooner) you’re going to run into an error....
Spreadsheets articles
How to use the MATCH Excel function
The MATCH Excel function tells you the position of a value within a range of cells. The function on its own can be...
How to use the IF AND function combination in Excel
The IF function in Excel is extremely useful: it generates different outcomes depending on whether the input meets a...
How to use the LOOKUP function in Excel
A common task in Excel is searching your spreadsheet for certain values, and using a function to do this and return a...
How to use the SUMPRODUCT Excel function
You might think the SUMPRODUCT Excel function is pretty boring at first glance, but the function is actually extremely...
How to use the VLOOKUP Excel function
The VLOOKUP Excel function is undoubtedly one of the most useful functions that Excel offers. It can also be one of...
How to use the SUMIF function in Excel
People often use Microsoft Excel for highly sophisticated and complex calculations. At other times, you may just want...
Google Sheets vs Microsoft Excel: 2021 Comparison
Although almost every business uses spreadsheets, when it comes to spreadsheet software it's a battle between just two...
How to use the PMT function in Excel
Microsoft Excel is a great tool for managing and analyzing all sorts of data. It also has a number of financial...