Clearing ALL checkboxes in an Excel workbook
Yet another “helper” script for marking CAT PAT‘s! I was modifying one of the Excel marking rubrics and to test…
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…
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…
Phase 2 Excel data capture
Once you have administered your PAT questionnaire (25 respondents for Grade 12), you must capture and analyze the data. You…
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…
Excel functions you need to know for CAT
The following table lists all the Microsoft Excel functions that you will learn in your three years of CAT (DBE…