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 […]