A short spreadsheet course

Task Menu

Student data

Data
Tasks
Notes
Solution

Peter The Carpenter

Data
Task
Notes
Solution

Football League

Data
Tasks
Notes
Solution

ICT Charts

Task
Notes

Katie's Kitchen

Task
Data sheet
Sample Solution

The Big Guide to Excel2007 [1.7MB PDF]

There are several tasks available as exercises designed to show Excel working in different environments.

Student Data

Follow a series of instructions to work with data for a large number of students and produce summary information and lists. This is the main task for those seeking to start at the beginning and work through a wide range of spreadsheet functions.

Peter The Carpenter

Enter information into an existing sheet and produce a cash flow forecast, with an option to develop it to cater for future adjustments in work. Quite straightforward and can be adjusted to suit different circumstances if required.

The Football League Table

Prepare a simple data table of results and update it with the latest results. That part is very simple but this task also has a much more advanced and interesting second element - making a data entry table with a results table that is automatically updated.

ICT Charts

Just try displaying some simple data more effectively. No guidance notes so experiment with charts!

Katie's Kitchen

A realistic cash flow forecasting task with no guidance notes (but access to a completed solution!) This requires a good understanding of how information should be presented, and common sense !

 
Start the Excel course

Download notes

See sample answers

Download the notes as a PDF file 940KB
xlsm file with macros - safe to open [133KB]

1 + 1 = 3