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 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…
Mastering Excel’s XLOOKUP() function
The introduction of the XLOOKUP() renders the VLOOKUP() & HLOOKUP() functions redundant. Don’t celebrate yet: the XLOOKUP() function is most…