Here are more Spreadsheet
Training and Learning Resources, from
teach-ict.com, that will teach you all
about Spreadsheets and how to use them. These will get you
going to become an expert using Excel, Microsoft's
spreadsheet application. Included here are: content on understanding
spreadsheets, help sheets for various Excel functions, many
spreadsheet lessons and practice tasks, and a Spreadsheet
Mind Map, which a great way to visually understand how
spreadsheets are set up and work.
Spreadsheets Theory
Understanding
Spreadsheets
These pages give a clear
understanding of how spreadsheets work and how to use them.
Spreadsheets Slides
These slides introduce spreadsheets, what they are, and what they are used for. (Powerpoint format)
Spreadsheets explained
This resource clearly explains the topic of spreadsheets is an easy to understand way. (Word format)
Spreadsheet Formula Sldies
These slides covers the most important Excel formulas that are required to complete the spreadsheet projects. (Powerpoint format)
Excel Function Help Sheets
Here is an excellent set of resources which explain different functions which can be used in Excel. (Word format)
Spreadsheet Lessons and Practice Tasks
Worksheet 1 - Billericay
These are questions that will test if you understand this topic.
Basic Excel Formulas 2
This worksheet demonstrates Excel's fundamental formulas.
Worksheet 3
A lesson to check your knowledge of spreadsheets. You are given a fill-in-the gaps exercise and then asked to answer some basic questions about spreadsheets.
Worksheet 4
In this speadsheet lesson, you are asked to design a simple spreadsheet for a school fete.
Worksheet 5
This speadsheet lesson has you design a simple spreadsheet to hold teacher's marks.
Burgers
Here you are provided a completed spreadsheet and requested to use it to calculate the nutritional values of a range of foods. Here is the Excel file for this exercise.
The Disco
Use Excel to calcualate the cost of setting up a disco. It begins with simple formulas, then shows the use of absolute cell references and IF..Then functions.
Supermarket Comparisons
In this spreadsheet exercise gives you a list of groceries and asks you to use Excel to calculate total costs, average, minimum and maximum.
Profit and Loss - Computer Supplies shop
In this spreadsheet lesson, you will create a model to simulate a computer supplies shop and then you will develop the fomulas to calcualate profit and loss. You will then use the spreadsheet to model various scenarios. Here is the Excel file for this exercise.
Wordsearch
This is a spreadsheet word search to help with remembering key terms.
Skiing
This is another exercise to hone your spreadsheet skills with Excel. Here is the Excel file for this exercise.
Basic Spreadsheet Guide
This provides a guide to the fundamental features of Excel and its use. It does not show how to create a formula.
Worksheet - Fill in the gaps
Fill in the gaps of spreadsheet phrases with the right words, to check your knowledge.