Excel function - stylus

Another Excel function that you are highly unlikely to use on its own is the MID function: it loves to…

Joining strings together is far easier than splitting them up (think the LEFT, RIGHT and MID functions). The term for…

You will often come across the scenario where data is filled into an Excel worksheet and an error occurs that…

This function takes two or more arguments, and all the arguments must return TRUE for the function to return TRUE…

This tutorial explains the COUNTIF function in Excel, which counts cells meeting specific criteria within a range, featuring syntax explanation…

When using Excel logic functions such as COUNTIF() and SUMIF() which involve ranges being evaluated based on criteria, you cannot…

There are a few super-handy time-saving tricks in Microsoft Excel for when your data is not quite the way you…

This function is straightforward: it simply converts an amount from one unit of measurement to another. This is a handy…

Possibly the most advanced function in the ICT and CAT curricula, Excel's VLOOKUP is something that can easily be mastered…

The following table lists all the Microsoft Excel functions that you will learn in your three years of CAT (DBE…

Tag: Excel function