Parttime Classroom Business and administration and law

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


Day Mornings Afternoons Evenings
Education Requirements
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
Learning Outcomes of Level 5 Spreadsheet Methods 5N1977
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
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.


EnniscorthyFurther Education and Training Centre


Gonzaga House, Weafer Street, Enniscorthy


  • Free Parking
  • Wheel Chair Access
  • Tea/Coffee Making

Contact Details

Course Contact:
Susan Neville