Spreadsheets Advanced 6N4089 (Self-paced)
This is a standalone QQI Certified module, or part of the 6M4985 Business Major Award.
Course Summary
This is an Advanced Spreadsheet course designed by Lir at Level 6 on the N.F.Q. (National Framework of Qualifications). On successful completion of this module, you will achieve a QQI 6N4089 Spreadsheets Advanced component certificate. This module forms part of many QQI Major Awards, including QQI 6M4985 Business Advanced Executive Programme for Office Managers and also 6M4985 Business Advanced which we offer at Lir.
Course Content
Introduction to Spreadsheets Advanced
Unit 1 - Spreadsheet Terminology
Unit 2 - Recap on Level 5 Spreadsheets
Unit 3 - Absolute References, IFs and LookUps
Unit 4 - Spreadsheet Advanced Functions
Unit 5 - Validity and Auditing
Unit 6 - Enhancing Productivity
Unit 7 - Collaborative Editing
Unit 8 - Exam Preparation
Unit 9 - Project
Unit 10 - Course Completion
How do I book my course?
First of all, contact Lir Reception (044) 9342754 before you book. This way you will get an opportunity to speak with a Training Professional to discuss your options and to make sure that this module is the best one for you. To register, fill out our Lir Registration Form. You will have been given an Access Code for this form. Once registered we set you up with a Lir Microsoft email address which gives you access to Microsoft 365 software, at no extra cost to you. From there we send you access details on how to access your course so you can avail of the 'Live' Tutor scheduled Online Classes, Learner Supports and give you access to the Lir eLearning Hub.
Frances Gallagher
Deirdre Corroon
"I found this course to be very in depth, there was a lot of content provided. It was the most thorough of all the modules I have done at Level 6 and the tutor was very quick to reply. Would definitely recommend. "
Erica W
(2024)
"Enjoyed the course immensely, being able to study the modules at your own pace is a good bonus. Easy to follow and material can be used to look back on as needed. Everything I learned will be useful to me in my work. Excellent course to study. Well structured & easy to follow also, help is always at hand when needed. I would highly recommend it."
Brian D
(2023)
“Very good course to learn additional functions of Excel. This course helped me to improve Excel skills and utilise more advanced functions."
Jane C
Admin Assistant (2020)
Joey C
Creative Artist (2021)
"Waiting for you"
Learner
(2024)
"Waiting ... 2024"
Learner
(2024)
Self-Paced Course
€330
- 1-to-1 Online Tutor Support
- Self-directed Learning in the Lir eLearning Hub
- Tutor Online Support
- Weekly Check-in
- Lir Mobile Course App
- Lir Microsoft 365 Software
- Lir Learner Supports
- Lir Community Chat
- CE Participant Rate (Contact Lir Reception 044-934 2754)
Lir Blogs and News ...
Blog Post
A Day in the Live of a Medical Secretary.
Blog Post
Other Modules to consider towards the Lir QQI 6M4985 Business Major Award and other Awards.
Administration
Practice
Level 6
(1 module)
Assessment
Practice
Level 6
(1 module)
Bookkeeping
(Manual & Computerised)
Level 6
(1 module)
Business
Management
Level 6
(1 module)
Communication
Skills
Level 6
(1 module)
Front Office
Skills
Level 6
(1 module)
Human Resources
Management
Level 6
(1 module)
Leadership
Skills
Level 6
(1 module)
Payroll
(Manual and Computerised)
Level 6
(1 module)
Spreadsheets
Advanced
Level 6
(1 module)
Supervisory
Management
Level 6
(1 module)
Training Delivery
and Evaluation
Level 6
(1 module)
Training Needs Identification
and Design
Level 6
(1 module)
Word Processing
Advanced
Level 6
(1 module)
