Selecting function criteria in Excel
When using Excel logic functions such as COUNTIF and SUMIF which involve ranges being evaluated based on criteria, you cannot…
Cleaning data in Excel
In the example below I have used three Microsoft Excel functions to identify and then correct a common mistake that…
Excel’s Text to Columns command
There are a few super-handy timesaving tricks in Excel for when your data is not quite the way you need…
Transpose-pasting data in Microsoft Excel
How do you decide how your data should be arranged in terms of rows and columns? And what to do…
Copy-paste and moving Excel worksheets
The standard method for copy-pasting or moving (cut-pasting) an entire Worksheet in a Workbook is clunky and slow. I discovered…
“Shrink to Fit” Excel cell formatting
This was a truly esoteric question in the NSC P1 Prelim 2020. I was not aware of this setting: I…
Adding up Check Boxes in Excel
So you have created a form in Excel with nifty Check Box Controls. Looks real purrrty! But how do you…
Using Excel’s CONVERT function
This function is really straightforward: it simply converts amounts from one unit to another. In the example below the amount…
Nested IF Statements in Excel
This little gem finds its way into Matric finals over and over again. It takes some practice to get your…
Conquering Excel’s VLOOKUP
Possibly the most advanced function in the CAT curriculum, Excel’s VLOOKUP (and HLOOKUP for that matter) is something that can…