“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…
productivity through technology
This was a truly esoteric question in the NSC P1 Prelim 2020. I was not aware of this setting: I…
This question pops up quite regularly in assessments: how to set the “Hidden” attribute on the selected text. We have…
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…
A really easy addition to any Microsoft Access database application is a Display Form, or what is commonly referred to…
Microsoft Access allows you to export data from any of it’s 4 main objects (tables, queries, forms & reports) as…
This little gem finds its way into Matric finals over and over again. It takes some practice to get your…
One of the joys of Microsoft is interoperability between applications such as Access and Excel. A stunning example of this…
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…