Using Excel’s ROMAN() function
We covered converting Roman numerals to numbers in the post Using Excel’s ARABIC function. Here we look at the opposite…
Applying Styles in Microsoft Word
Styles allow you to easily and consistently format your documents: using Styles allows you to quickly apply, modify and manage…
TRUNCATE and Access
There is no TRUNCATE in Access. This post explains how to achieve equivalent results in Microsoft Access.
Using Excel’s DEC2BIN() function
If nothing else, Excel’s DEC2BIN function is handy for playing with binary notation when you are studying your ICT theory.…
Text Delimiters & Qualifiers
We are probably most comfortable seeing data in a structure such as a table; tabulated data is easy to follow…
Use JavaScript to manipulate the DOM
Your HTML page is a structured static document consisting of various elements. We talk about the Document Object Model (“DOM”).…
Insert vs Overtype mode in Word
A common problem is when a user suddenly finds that when editing text, the text that they are typing is…
Excel’s SUM() function
SUM is probably the first function you will learn as well as one of the most used functions. It can…