Ecdl Module 4 Pdf Download

The European Computer Driving Licence (ECDL) Excel Part 2 is the second of two workbooks designed to cover the ECDL Module 4 Spreadsheets syllabus. It is one in a series of workbooks designed to cover the. Training account it is necessary to download the training files used in this workbook from the IS training web site at.

Wacki kosmiczna rozgrywka chomikuj. ECDL Module 4 Document 354 Version 2 Information Systems EISD Information Systems Part of the Education & Information Support Division Title: Excel 2002 (XP) Part 2 Authors: Rachel Healy and Fiona Strawbridge Reference: Doc 354 v2 ECDL: Module 4 Spreadsheets (Part 2 of 2) Date: September 2002 Revisions: Adapted from: Intermediate Excel 5.0 by Rachel Healy. Updated for Excel 2002 (XP) in August 2002 by Fiona Strawbridge and Tamsin Griffith.

Abstract Microsoft Excel is a spreadsheet application used for manipulating and calculating numerical data. This workbook is aimed at users who have some knowledge of spreadsheets and of the Excel package, and/or have completed the Excel Part 1 course. It has been designed to accompany the Information Systems Excel Part 2 course (see www.ucl.ac.uk/is/training for course details) and it can be used as a self-paced tutorial.

The European Computer Driving Licence (ECDL) Excel Part 2 is the second of two workbooks designed to cover the ECDL Module 4 Spreadsheets syllabus. It is one in a series of workbooks designed to cover the seven modules of the ECDL Syllabus (Version 3.0).

For further information, visit the ECDL web pages at www.ucl.ac.uk/is/training/ecdl.htm Pre-requisites It is assumed in this Workbook that you have the requisite keyboard skills and knowledge of a PC including file management, and that you are familiar with the basic uses or Excel including data entry, simple use of formulae and functions, and formatting. If you are unfamiliar with any of these topics, please consult the other workbooks in the series. Please Note Excel 2002 can be accessed from UCL Information Systems (IS) PC Workstations running WTS1. It is assumed in this Workbook that you are a registered user (i.e. You have an IS userid and password) using a PC on the Information Systems WTS Service. Microsoft is a registered trademark and Windows is a trademark of Microsoft Corporation. Screen shots re-printed by permission from Microsoft Corporation.

1 WTS is the Windows Terminal Service which provides a Windows 2000 environment. Spreadsheets Excel Contents 1.

Introduction........1 2. Data Management With Lists......2 2.1 2.2 2.3 3. To Create a List.......2 Sorting Records in a List......2 Simple Filters.......5 Subtotals........8 Task Three – Subtotals.......9 4.