Join the
Assist Training
& Consultancy Ltd
mailing list

---

Email:

24 Barrington Street
Limerick, Ireland.
353 (0) 61 317500
353 (0) 61 316517
info@assisttraining.ie

City & Guilds Certified Courses

Click here for City & Guilds Courses --- BEGINNERS --- Computers & Computing 1 --- INTERMEDIATE --- Wordprocessing II Spreadsheet Methods II Database Methods II Computerised Accounts II Using the Internet II Desktop Publishing II Web Design II Programming in C++ Programming in Visual Basic II 2D Design Using AutoCAD --- ADVANCED --- Wordprocessing III Relational Databases III Wed Design Advanced 3-D Design Using AutoCAD

Computer Training Courses

Spreadsheet Methods II

Course Level:

Course Objectives:

To enable you to get maximum use out Microsoft Excel. To your knowledge of how to move and copy data as well as amending and replacing information and making cells interdependent on each other. To enter formulae that extend beyond simple addition to include ‘If’ style functions and conditional formatting.

Prerequisites:

Good working knowledge of the PC and basic knowledge of Excel.

Duration:

10 weeks (30hrs)

Certification:

City & Guilds Certificate in Information Technology (Level II)

Examinations:

There are three practical and one written exam paper

Course Content:

Concepts and Definitions Data Types Arithmetic Operators Use of Formulae Functions Worksheet Creation Spreadsheet Layout Character Data Numeric Data Formulae Functions Graphs and Charts

Editing Spreadsheets Structure Format Spreadsheet Blocks Erasing Data Moving and Copying Data Amending and Replacing Data Calculation Information Retrieval File Management Printed Outputs Document Presentation

Click here to reserve a place on this course