Microsoft Excel
This sticky post simply aims to organise and group all the Microsoft Excel-related posts on the blog as well as…
Using Excel’s OR() function
This function takes two or more arguments, and one of the arguments must return TRUE for the function to return…
Using Excel’s ISNA() function
You will often come across the scenario where data is filled into an Excel worksheet and an error occurs that…
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…
Using Excel’s WEEKDAY() function
The WEEKDAY() function returns a number for the day of the week corresponding to the date provided. The day is…
Using Excel’s RIGHT() function
The RIGHT() function returns a specified number of characters from a string, starting from the right-hand side. Syntax =RIGHT(text,num_chars) text…
Using Excel’s LEFT() function
The LEFT() function returns a specified number of characters from a string, starting from the left-hand side. In this tutorial:…
Using Excel’s UPPER() function
Excel’s UPPER() function converts all text in a string to uppercase characters. Syntax =UPPER(text) Returns the text with all characters…
Using Excel’s LOWER() function
Excel’s LOWER() function converts all text in a string to lowercase characters. Syntax =LOWER(text) Returns the text with all characters…
Advanced COUNTIF() function
This caught me out the other day: I was looking to do something that I at first pegged as a…
Using Excel’s PI() function
Excel’s PI function is one of four functions that do not require arguments. This is an awesome cross-curricular, experiential exercise,…