EY Advanced Excel / Spreadsheets L5
Module Aim
This programme module aims to equip the learner with the knowledge, skills and competence to use a word processing application to produce documents in a variety of contexts to a mailable and publishable standard whilst working autonomously and under general direction
Target Award
QQI Office Administration – 5M1997
Start Date: 29-08-2024 Hours/week: 04 Hrs 00 Mins Duration: 16 weeks
NFQ Level 4 or equivalent when accessing a Level 5 programme.
CERFL proficiency at B2 for access to Level 5 courses for those whose first language is not English
Mature learner entry requirements available via the local ETB pathway
Additional requirements may apply to non-EU/EEA Applicants and may be subject to full international fees (Please refer to Information for International Learners)
*Each provider may have additional requirements, not outlined above.
Age Requirements
Minimum statutory school leaving age (16+)
Learning Aptitude
Applicants must have a motivation to learn, an interest in the subject and the ability to acquire the knowledge, skills and competencies set out in the course.
Previous Experience
Applicants must be able to demonstrate a moderate range of knowledge, skills and competencies relevant to the course, be able to work with responsibility and demonstrate the ability to work on their own initiative.
| Module | Award | Body |
|---|---|---|
| Spreadsheet Methods | Spreadsheet Methods (5N1977) | QQI |
Learners will be able to:
1. Investigate a range of common uses for spreadsheets.
2. Explore key spreadsheet elements including cells, cell references, numeric, alpha, and
alphanumeric data, formulae, functions, graphs and macros.
3. Demonstrate common spreadsheet usability features to include use of toolbars, window
management, sorting, and filtering.
4. Use spreadsheet design features involving data and cell formatting techniques which enhance
understanding and legibility.
5. Automate routine multi-step tasks through the creation, execution, and management of
simple macros.
6. Print complete or partial sections of a spreadsheet, formatted fit for presentation.
7. Use advanced spreadsheet features including absolute and relative cell references,
conditional IF statements, statistical, financial, and date and time functions.
8. Generate a variety of types of graphs, with appropriate titles and labels, from spreadsheet
data.
9. Produce a spreadsheet, with minimal supervision, that meets a simple design specification
and is fit for purpose.
10. Demonstrate personal initiative and resourcefulness in editing and amending spreadsheets to
ensure they are fit for purpose.