Calculate the distance between two coordinates in Excel
For this tutorial, we will use a datasheet listing the towns and cities of South Africa by Province with their…
Create a custom function in Excel
Excel has hundreds of powerful functions. Here is how you can create your own! In this tutorial: Required knowledge: 1.…
Filtering data in Excel
As your spreadsheets grow, it is important to master skills to make your data manageable. Filtering data is a quick…
Using Excel’s IFNA() function
You will often come across the scenario where data is filled into an Excel worksheet and an error occurs that…
Using Excel’s ERROR.TYPE()
Excel’s ERROR.TYPE() function returns a number corresponding to a specific error value. In this tutorial: See also: 1. Syntax =ERROR.TYPE(error_val)…
Using Excel’s VALUE() function
Excel's VALUE() function is a simple function that makes numbers that aren't formatted as numbers into numbers. The examples illustrate…
Using Excel’s MOD() function
Excel’s MOD() function is used to determine the remainder of a division operation. For example, if you divide 10 by…
Using Excel’s ABS() function
Excel’s ABS() function is another super-simple Excel function. In this tutorial: Required knowledge: 1. Syntax =ABS(number) Returns the absolute value…