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…
How to add a Splash Screen in Microsoft Access
A really easy addition to any Microsoft Access database application is a Splash Screen that opens automatically when the database…
Access’ Export HTML Document function
Microsoft Access allows you to export data from any of it’s 4 main objects (tables, queries, forms & reports) as…
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…
Access’ Import Excel spreadsheet function
One of the joys of Microsoft is interoperability between applications such as Access and Excel. A stunning example of this…
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 functions that you will learn in your three years of CAT. You also need…
Page numbering in Word
Word’s automatic page numbering feature can become quite complicated very quickly! The complexity results from the various options available combined…
Shortcuts for marking CAT practical assessments
I find the following shortcuts invaluable when marking practical assessment files (Word documents, Excel workbooks, etc.). I also teach my…