Teach-ict.com is a great software teaching and learning
site that provides free training content for Microsoft Office and other
applications. This site was developed by teachers, its coursework
materials are high quality and are targeted to both students and
teachers. Here are their Excel Training Course Workbooks that
cover many of Excel's basic and advanced features.
Excel Training Course Workbooks
Spreadsheet Workbook 1 (.doc)
This training workbook shows you how to create a new spreadsheet using Excel. The following skills are covered:
- Basic Formula - Addition, Subtraction, Multiplication, Division
- Basic Functions - SUM, AVG, MIN, MAX, COUNT
- How to display formulae
- Importance of resizing columns and rows to display data
Spreadsheet Workbook 2 (.doc)
This Training workbook shows you how to create a new spreadsheet using Excel. The following skills are covered:
- Printing to one sheet only
- Displaying grid lines on printouts
- Displaying column letters and row numbers on printouts
- Inserting name onto printouts
- How to use custom headers/footers
- Changing margins/page orientation
- How to print a certain area of the sheet
- How to hide/unhide columns
- Changing formats e.g. decimal places, currency
- Adding borders
- Sorting data
- Ski (.xls)
- Ski Holidy Budget Task (.doc)
Spreadsheet Workbook 3 (.doc)
This training workbook shows you how to create a new spreadsheet using Excel. The following skills are covered:
- absolute cell references
- if then formula
Spreadsheet Workbook 4 (.doc)
This training workbook shows you how to create a new spreadsheet using Excel. The following skills are covered:
- nested IF formula
- If (OR) formula
- If (AND) formula
Spreadsheet Workbook 5 (.doc)
This training workbook shows you how to create a new spreadsheet using Excel. The following skills are covered:
- naming cells
- vlookup
- hlookup
- Modelling Task 5 (.xls)
- Modelling Task 5 Answers (.xls)
More Training for learning some of Excel's advanced features:
- General Practice - supermarkets (.doc)
- Absolute Cell References 1 (.doc)
- Absolute Cell References 2 (.doc)
- Absolute Cell References 3 (.xls)
- Conditional Formatting 1 (.doc)
- Conditional Formatting 2 (.doc)
- IF..Then - Budget (.xls)
- IF..Then - Discounts (.xls) IF..Then Discounts Answers (.xls)
- IF..Then - Tests (.xls) IF..Then Tests Answers (.xls)
- IF..Then - If..then, IF(OR), IF(AND) (.doc) Practice (.xls) Practice Answers (.xls)
- VLookups (.doc)
- VLookups - Class XX (.xls)
- VLookups - Jobs (.xls)
- VLookups - Magazines (.xls) VLookups - Magazines Answers (.xls)
- VLookups -Fuel (.xls) VLookups - Fuel Answers (.xls)
- VLookups - Cats (.xls) VLookups -Cats Answers (.xls)