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 TasksWorksheet
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.
Popularity: 22% [?]
Share and Enjoy:
These icons link to social bookmarking sites where readers can share and discover new web pages.
Related Posts:Excel 2007 Course TutorialsPhotoshop, FrontPage and Acrobat TutorialsMicrsoft Office 2003 and 2002 TutorialsExcel Training Course WorkbooksMicrosoft Excel Tutorials
Tags for this post>>
Excel