Excel functions you need to know for IGCSE & AS
The post lists all the Microsoft Excel functions that you will learn in your 3-year IGCSE journey followed by your…
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…
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…