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…
productivity through technology
There are a few super-handy timesaving tricks in Excel for when your data is not quite the way you need…
How do you decide how your data should be arranged in terms of rows and columns? And what to do…
The standard method for copy-pasting or moving (cut-pasting) an entire Worksheet in a Workbook is clunky and slow. I discovered…
This was a truly esoteric question in the NSC P1 Prelim 2020. I was not aware of this setting: I…
So you have created a form in Excel with nifty Check Box Controls. Looks real purrrty! But how do you…
This function is really straightforward: it simply converts amounts from one unit to another. In the example below the amount…
This little gem finds its way into Matric finals over and over again. It takes some practice to get your…
Possibly the most advanced function in the CAT curriculum, Excel’s VLOOKUP (and HLOOKUP for that matter) is something that can…
The following table lists all the functions that you will learn in your three years of CAT. You also need…