Information Technology

Spreadsheet Methods (5N1977)

The purpose of this award is to ensure that the learner is fully capable of using a broad range of advanced spreadsheets features to work effectively and produce clear printouts. On successful completion of this course the learner will be able to carry out advanced selection, formatting,charts, tables, formulae usage, macro production and design of dynamic spreadsheets.

"I was expecting spreadsheet methods to be somewhat difficult but to my surprise it was easy to understand and enjoyable to learn" - Ciara

Course content


  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.

Programme Details

  • Award Title: Spreadsheet Methods (5N1977)

  • Duration: 150 of which 50 hours directed and 100 hours self-directed

  • Entry Requirements: QQI Level 4 certificate, Leaving certificate or equivalent qualifications and/or relevant life and work experiences

  • Award Type: Minor Award

  • Framework Level: NFQ Level 5

  • Awarding Body: QQI (Quality and Qualifications Ireland)

  • Assessment:
    1. Project
    2. Examination

  • Protection for Learners:
    As a part of best practice to safeguard the interests of learners enrolled for programmes exceeding three months and in line with the regulatory/statutory requirements of QQI and the ‘Qualifications and Quality Assurance (Education and Training) Act 2012’.
    NCU Training has arranged comprehensive cover by a Learner Protection Policy, Number
    LPI-00098-PHIS with O'Driscoll O'Neil underwritten by Hiscox Insurance Company Limited, June 2018.
    The purpose of this policy is to ensure that learners are protected in the event of the unexpected cessation of any training programme in NCU Training provided, and/or organised and/or sub-contracted training.
    Evidence to confirm implementation of the NCU Training Protection for Learners Policy includes:

    1. A statement of arrangements for Protection for Learners in programme information for relevant programmes of over three months’ duration.
    2. Fee refund documentation, where it applies.
    3. Learner transfer documentation, in the event of the unexpected cessation of programmes

  • Complaints Procedure:
    It is your right as a client of our service to make a complaint if you feel your experience with us falls short of what you expected. We want the process to be easy, effective and fair. If you would like to make a complaint, you can either call us on 01-8479463 or email us directly at

Price and next starting date.

  • Price: €250 (Excluding Certification Fee)
  • Funding: A range of training courses are available with NCU Training which are free to unemployed persons. The first step is to contact your local Employment Services Office to register and apply for training.
  • View Upcoming Courses for next starting date
ncu training

NCU Training is part of NCU CLG,
A not for profit company serving the community for more than 30 years

Contact Details


  • NCU is a great place to do your training, it's facilities are brilliant and all the staff were very helpful with all my needs
    Janice Smith / Healthcare Trainee
  • I found NCU to be very good, I really enjoyed my course and would recommend it anyone.
    John McCarthy / Computer Trainee
  • I completed a train the trainer at NCU and found the centre and all staff to be excellent.
    Peter Brady / completed train the trainer
  • I would recommend NCU to anyone, they do great work in the community and offer many services for free.
    Kathy Wilson / Social Welfare officer