Microsoft Office
This section of the blog was originally created whilst I was teaching the DBE CAPS Curriculum. As I move forward,…
Using PowerPoint’s Photo Album feature
I cannot tell you how many times I have seen people not create a slideshow to show an audience an…
Using Excel’s OR() function
This function takes two or more arguments, and one of the arguments must return TRUE for the function to return…
VBA to truncate or delete Access database tables
Access SQL does not have anything like TRUNCATE table. There is also no way to run a DROP table query.…
Adding fields to an existing Access Report
In this tutorial: Required knowledge: 1. Scenario You have created a report and the underlying object has changed. This could…
Using Excel’s ISNA() function
You will often come across the scenario where data is filled into an Excel worksheet and an error occurs that…
Changing field properties during import into Access
One of the steps of the Import Data Wizard in Access allows you to modify the field settings during the…
Alt text in Microsoft 365
In my opinion, Microsoft’s alt text generator is one of the more successful implementations of an AI-enabled software feature. The…
Excel VBA to select a cell based on its value
I use a workbook to keep a digital register for each of my classes. There is a column per day,…
Mastering Excel’s XLOOKUP() function
The introduction of the XLOOKUP() renders the VLOOKUP() & HLOOKUP() functions redundant. Don’t celebrate yet: the XLOOKUP() function is most…
Using Excel’s WEEKDAY() function
The WEEKDAY() function returns a number for the day of the week corresponding to the date provided. The day is…