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 same as the background.

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 move a block of cells on Excel

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 set of numbers.
• We’ll have further practice in using the copy (or fill) handle.
• We’ll have further practice in formatting cells – formatting the text, the alignment, the date and the pupils’ average mark.

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.