Login
Home
View Courses
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)1c7d4a88-b76d-4e0f-b26c-d45372d4535f1c7d4a88-b76d-4e0f-b26c-d45372d4535fClass 1 and 2 cells , rows, columns, data types, formulae, autofill, 1c7d4a88-b76d-4e0f-b26c-d45372d4535fClass 3 formulas, absolute and relative cell referencing, printing options1c7d4a88-b76d-4e0f-b26c-d45372d4535fClass 4 functions, named ranges, sorting spreadsheet data, filtering1c7d4a88-b76d-4e0f-b26c-d45372d4535fClass 5 Charts (types, creating, formatting, displaying, adding additional data, column charts based on multiple ranges)1c7d4a88-b76d-4e0f-b26c-d45372d4535fClass 6 If statements (simple, conditional formatting)1c7d4a88-b76d-4e0f-b26c-d45372d4535fClass 7 If statements (compound, AND, OR function and nested)1c7d4a88-b76d-4e0f-b26c-d45372d4535fClass 8 Lookups (vertical, horizontal)1c7d4a88-b76d-4e0f-b26c-d45372d4535fClass 9 lookups (continued, Lookup errors, editing lookup table)1c7d4a88-b76d-4e0f-b26c-d45372d4535fClass 10 Examination practice1c7d4a88-b76d-4e0f-b26c-d45372d4535fClass 11 QQI 5 Examination1c7d4a88-b76d-4e0f-b26c-d45372d4535f1c7d4a88-b76d-4e0f-b26c-d45372d4535fCourse material required : Step by Step Spreadsheets Gill Education (ISBN1c7d4a88-b76d-4e0f-b26c-d45372d4535f9780717160440)
Sign me up