[ Home | Data Analysis | Excel | Visual Basic ]

It is believed that most of the material described in the booklet document Excel 2002 (XP) Part 1 produced by the Information Systems Division (ISD) of UCL would have been covered in IT courses at school or college.  If having looked through the booklet you feel that this is not so, don't panic.  Tell the demonstrators when you go to the Excel sessions and email Dr Dave Tovee at d.tovee@ucl.ac.uk with a brief note saying what parts you have and have not done before.

The files for the tasks and exercises in Excel 2002 (XP) Part 1 are available from the links below:

Task 4 summary.xls This spreadsheet is used for data entry and editing data shown on pages 16 to 22 in the booklet.
Exercise 2 news.xls for the Newspaper Sales exercise on page 55.
Exercise 3 news1.xls This is for the second Newspaper sales exercise on page 56
Exercise 5 news2.xls This task involves Number formatting, also named Newspaper Sales on page 57
Exercise 6 holiday1.xls This exercise, Holiday costs involves character formats on page 57
Exercise 7 news3.xls More Formatting in this newspaper sales exercise on page 58.

ISD's second booklet, Excel 2002 (XP) Part 2, relates to slightly more advanced features and topics and is more relevant to your use of Excel in practical work, i.e. production of graphs (charts).   Should you wish or need to do any of the ISD exercises they are available below.

Task 1 club.xls This file is required for the first task on page 4
Task 6 florist.xls This exercise involves Absolute Referencing on page 16
Task 7 florist-names.xls for 'Using names' on page 18
Task 9 module.xls The use of Paste Special is required for this task on page 22
Task 11 summary.xls Involves the manipulation of worksheets, named 'More Worksheets' on page 32
Task 13 evals.xls This task; 'Charting Category data' is shown on page 44
Task 14 baby-heights.xls Charting relationships between numerical data on page 44
Task 15 chart1.xls This file is used in the 'Amending an Existing Chart' exercise on page 48
Exercise 1 visitor.xls An exercise with respect to Absolute References shown on page 54.
Exercise 2 train.xls This exercise is also concerned with Absolute References on page 55
Exercise 3 forecast.xls More practise on Absolute references on page 56
Exercise 4 quarter.xls This spreadsheet is needed for the task 'Consolidating Data ino a Workbook' on page 57
Exercise 5 elecgds.xls This is a Revision of worksheets and functions, on page 58
Exercise 6 evals.xls This is an exercise concerning the creation of a Line Chart on page 59
Exercise 7 evals.xls The last exercise involves the production of a Bar Chart, on page 60



[ Next week ]