learntouse
About this original series
-
# Episodes
8 episodes -
Rating
TV-UN
Episodes of learntouse
-
-
Lesson 9: Making a Units Conversion Calculator
www.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.
-
-
Release date
Feb 29, 2008
-
Runtime
03:58
-
-
Lesson 2: Multiplying & Copy Handle Using Excel
www.learntouse.orgIn 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.
-
-
Release date
Feb 26, 2008
-
Runtime
05:49
-
-
Lesson 8: Testing Hypothesis With Excel
www.learntouse.orgThe 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.
-
-
Release date
Feb 26, 2008
-
Runtime
05:05
-
-
Lesson 7: Manipulation Using Excel
www.learntouse.orgThis 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
-
-
Release date
Feb 26, 2008
-
Runtime
04:36
-
-
Lesson 6 - Using Functions In Excel
www.learntouse.orgWe 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.
-
-
Release date
Feb 26, 2008
-
Runtime
05:26
-
-
Lesson 3 - Subtracting & Conditional Formatting
www.learntouse.org 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?.
-
-
Release date
Feb 26, 2008
-
Runtime
07:25
-
-
Lesson 5: Absolute Cell References In Excel
www.learntouse.org In this lesson we will learn: * The difference between absolute and relative cell references
-
-
Release date
Feb 26, 2008
-
Runtime
05:42
-
-
Lesson 1: Addition Using Excel
http://www.learntouse.org/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.
-
-
Release date
Feb 26, 2008
-
Runtime
04:27
-
-
