Excel’s Subtotal feature
This is something that is tested almost every year in Grade 12 exam papers: the Subtotal command in the Outline…
Modifying an Access Form
When you create a Form you select the underlying object. A Form can be based on a table, or multiple…
Excel Conditional Formatting
OK, so the following scenario catches me every time: Conditional Formatting of cells based on values in a separate range…
Word’s Table of Contents feature
The Table of Contents feature relies on the use of Styles in a document. The feature works “out-of-the-box”: it is…
UPDATE query to split values in a field into 2 fields
We covered the Excel solution to this post’s scenario in the post Cleaning data in Excel. Using exactly the same…
Advanced criteria in Excel logic functions
This solution was arrived at whilst doing some advanced analysis for a Matric PAT where data from a Google Form questionnaire is…
Text mask effect in PowerPoint
PowerPoint presentations are often the target of derision. This is largely due to people misunderstanding the effective use of the…
Using an Excel function as part of another function
Using one Excel function as an argument for a second Excel function is an important skill to master. This process…
Using Excel’s COUNTIF function
Below is a simple, self-explanatory example of using the COUNTIF function to evaluate a range of data. The COUNTIF function…
Creating Microsoft Access Forms
Just as the Table objects store data in your Microsoft Access database, the Form objects serve as the user interface…