Spreadsheets Advanced 6N4089

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 - Spreadsheets Advanced - Terminology and Concepts

Unit 2 - Recap on Level 5 Spreadsheets

Unit 3 - Spreadsheets Advanced - Absolute References, IFs and LookUps

Unit 4 - Spreadsheets Advanced - Advanced Functions

Unit 5 - Spreadsheets Advanced - Validity and Auditing

Unit 6 - Spreadsheets Advanced - Enhancing Productivity

Unit 7 - Spreadsheets Advanced - Collaborative Editing

Unit 8 - Spreadsheets Advanced - Exam Preparation

Unit 9 - Spreadsheets Advanced - Project

Unit 10 - Spreadsheets Advanced - 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

 "Very good course to learn additional functions of Excel. This course helped me to improve Excel skills and utilise more advanced functions." 

Jane Creevy
Admin Assistant (2020)

 "I recently completed the Spreadsheets Advanced L6 Module and I am very happy with how the course was delivered. The tutors were very helpful and guided me through the module while answering any questions that I had. I would definitely recommend Lir Business  Services & Training to anyone looking to complete a QQI Certified Course online.

Joey C.
Creative Artist (2021)

 "Waiting ... 2024" 

Lir Swan
Learner

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)

Blended Online Course


€330

  • 'Live' Tutor Online Weekly Scheduled Sessions
  • Lir Upcoming Course Dates
  • Self-directed Learning - Lir eLearning Hub
  • Tutor Online Support
  • Lir Mobile Course App
  • Blended Learning Online
  • Lir Microsoft 365 Software
  • Lir Learner Supports
  • Lir Community Chat
  • CE Participant Rate (Contact Lir Reception 044-934 2754)
  • Or In-Company (Tailor-made Course)


Classroom-based


€330

  • Attend a Public Lir Course
  • Lir Upcoming Course Dates
  • Self-directed Learning - Lir eLearning Hub
  • Tutor Support
  • Lir Mobile Course App
  • Lir Microsoft 365 Software
  • Lir Community Chat
  • CE Participant Rate (Contact Lir Reception 044-934 2754)
  • Or In-Company (Tailor-made Course)

Other Modules to consider towards the Lir QQI 6M4985 Business Major Award and other Awards.

Administration Practice QQI 6N4169 Course Card showing hands placed on a computer keyboard and Lir logo

Administration
Practice
Level 6
(1 module)

Assessment Practice QQI 6N2228 Course Card showing hands placed on a computer keyboard and Lir logo

Assessment
Practice
Level 6
(1 module)

Bookkeeping Level 6 Advanced QQI 6N4865 Course Card showing hands placed on a computer keyboard and Lir logo

Bookkeeping
(Manual & Computerised)
Level 6
(1 module)

Business Management QQI 6N4310 Course Card showing hands placed on a computer keyboard and Lir logo

Business
Management
Level 6
(1 module)

Communications QQI 6N1950 Course Card showing hands placed on a computer keyboard and Lir logo

Communication
Skills
Level 6
(1 module)

Front Office Skills Level 6 QQI 6N4186 Course Card showing hands placed on a computer keyboard and Lir logo

Front Office
Skills
Level 6
(1 module)

Human Resources Management QQI 6N3750 Course Card showing hands placed on a computer keyboard and Lir logo

Human Resources
Management
Level 6
(1 module)

Leadership QQI 6N2191 Course Card showing hands placed on a computer keyboard and Lir logo

Leadership
Skills
Level 6
(1 module)

Payroll Advanced Level 6 QQI 6N4005 Course Card showing hands placed on a computer keyboard and Lir logo

Payroll
(Manual and Computerised)
Level 6
(1 module)

Spreadsheets Advanced QQI 6N4085 Course Card showing hands placed on a computer keyboard and Lir logo

Spreadsheets
Advanced
Level 6
(1 module)

Supervisory Management QQI 6N4329 Course Card showing hands placed on a computer keyboard and Lir logo

Supervisory
Management
Level 6
(1 module)

Training Delivery and Evaluation QQI 6N3326 Course Card showing hands placed on a computer keyboard and Lir logo

Training Delivery
and Evaluation
Level 6
(1 module)

Training Needs Identification QQI 6N3325 Course Card showing hands placed on a computer keyboard and Lir logo

Training Needs Identification
and Design
Level 6
(1 module)

Word Processing Advanced QQI 6N4977 Course Card showing hands placed on a computer keyboard and Lir logo

Word Processing
Advanced
Level 6
(1 module)

Work Experience Advanced QQI 6N1946 Course Card showing hands placed on a computer keyboard and Lir logo

Work
Experience
Level 6
(1 module)

Check our Social Media Platforms for Special Offers and Promotions