In this lesson we build a compound interest calculator to calculate how much interest the bank will pay you if you save a certain amount of money in the bank. We talk about absolute referencing using dollar signs and what happens when you fill down by dragging the corner dot down the screen.

In this first Microsoft Excel Spreadsheet lesson, we talk about how to conduct some basic numerical operations (add, subtract, multiply, divide, to the power of, brackets) and how to use cell reference in combination with the mathematical operations (e.g. E5+E6 etc).

In this tutorial you will learn about Vlookup and how to use it to look up values in a table, so you can convert a letter to a number e.g. A+ to 15, A to 14, A- to 13.

In this lesson you will learn about pivot tables and how you can use it to help you gain insight into the data in a spreadsheet. The data used for this spreadsheet can be downloaded from: https://data.qld.gov.au/dataset/overs…

Is the “distribute page” option missing from your Class Notebook? Here is how you would fix that problem.

Even though it can be quite obvious how to fix this problem, whether it has worked or not can be decieving due to the appearance of the menu button.

In this video we show you how to quickly insert rows in Excel.

So I tried to start Microsoft Access 2013 on my PC for the first time (I never used it on this computer) and it came up with this message: “Automatic configuration of the current version of Microsoft Access has failed. Your database might not function correctly. This can occur if you do not have the …

So I discovered NetBalancer, version 9.1.4, by SeriousBit, which not only allows you to limit the download/upload speed of every process, but lets you terminate them if you don’t like them 🙂 And best part is – I didn’t pay a cent for it 🙂

So how quickly can you hide desktop icons in Windows? I can do it in.. 0.1 seconds? Maybe a bit more, but not much. However long it takes to do a double click.