NR Advanced Excel / Spreadsheets L5
Objectives of the Programme Module
To develop a fundamental understanding of spreadsheet concepts and their range of
application. Gain extensive practical experience in spreadsheet design and
implementation.
To explore spreadsheet software commonly used in business and other activities, and
demonstrate initiative in responding to spreadsheet assessments.
To create an awareness and understanding of uses/functions of macros.
To assist the learner to develop the academic and vocational language, literacy and
numeracy skills related to Spreadsheet Methods through the medium of the indicative
content.
To enable the learner to take responsibility for his/her own learning.
Target Award
QQI Business Administration – 5M2468
Start Date: 27-08-2026 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 |
|---|---|---|
| Business Administration | Business Administration Skills (5N1610) | QQI |
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.