Ubuntu Desktop Operating System
I have an old laptop running Windows 8.1. I did not believe it was worth paying to update it to…
Video background in HTML using CSS
It is possible to insert a video as the background to a webpage using CSS. This is probably a truly…
The Haversine Formula
The Haversine Formula calculates the distance between two points on a sphere, considering the curvature. It is an accurate method…
Declaring and using Constants in VBA
This tutorial follows on from the Create a custom function in Excel tutorial and refactors the code from that tutorial.…
Calculate the distance between two coordinates in Excel
For this tutorial, we will use a datasheet listing the towns and cities of South Africa by Province with their…
Create a custom function in Excel
Excel has hundreds of powerful functions. Here is how you can create your own! In this tutorial: Required knowledge: 1.…
Advanced UPDATE query to manipulate a string
This tutorial is specifically for CAT PAT students completing the Access phase of their projects. This is an advanced tutorial…
VBA’s Environ function
This tutorial covers how to get system information using VBA. The information available ties into the Windows Environment variables and…