Learntouse.org

In this video tutorial we will learn how to:

Make a simple calculator by using appropriate formulae.
Colour cells.
Understand the importance of making areas for the user which are separate from the technical areas.
Check our answers against the menu.
Make an area look like a user area by deleting the lines around the text box and colouring it […]

The objectives of this video tutorial are:

To understand what a hypothesis is and how to test a hypothesis.
To learn how to pick out cells in an = sum function.

This video tutorial will follow on from the previous lesson.

We will use autosum again – this time to calculate an average.
We will perform various spreadsheet manipulations – specifically moving cells, inserting a row, inserting a column, deleting a row and deleting a column.
There will be some discussion on what happens to the formulae when you […]

In this video tutorial we are going to learn:

What is a function and what is the difference between a function and a formula.
We’ll have practice in using 3 common functions – to add up a set of numbers using the autosum tool, to average a set of numbers and to find the range of a […]

In this video tutorial we’re going to learn how to:

Put the VAT rate in a separate cell, outside the formula, so that we can change it easily.
We will learn what is an absolute cell reference means in Excel.
We will also learn to define the term ‘relative cell reference’.

In this video tutorial we will learn:

To create a simple record of income & expenditure in Excel.
How to make a text box.
How to subtract using Excel.
How to ensure that negative balances are shown in red, by using conditional formatting.

In this video tutorial we will learn:

How to multiply in Excel.
How to insert a row in Excel.
How to use the copy handle.
Why we use the copy handle.
We’re also going to learn to practice using ‘=sum()’ again.
We’ll see what cells we can change in our spreadsheet model.

In this video tutorial we are going to learn how to:

Add up using the Excel ‘Sum’ function.
How to format cells so that they have a currency.

We will also get some idea of:

What a ’spreadsheet model’ means.
Why spreadsheet models are useful.