View Courses

Course Details

Course Title:

Course Cost:

Course Start Date:

Discounts

* Discounted Amount Second Family Member:

* Discounted Amount Third Family Member:

* Discounted Amount 4+ Family Member(s):

SPREADSHEETS COURSE OUTLINE for  Spreadsheet Methods 5N1977 QQI 5 (QQI Certification optional at extra fee of €20)

Class 1 and 2 cells , rows, columns, data types, formulae, autofill, 
Class 3	formulas, absolute and relative cell referencing, printing options
Class 4	functions, named ranges, sorting spreadsheet data, filtering
Class 5	Charts	(types, creating, formatting, displaying, adding additional data, column charts based on multiple ranges)
Class 6	If statements (simple, conditional formatting)
Class 7	If statements (compound, AND, OR function and nested)
Class 8	Lookups (vertical, horizontal)
Class 9 lookups (continued, Lookup errors, editing lookup table)
Class 10 Examination practice
Class 11 QQI 5 Examination

Course material required : Step by Step Spreadsheets Gill Education (ISBN
9780717160440)

Sign me up