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 ... 2022" 

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

Business Management L6

Word Processing Advanced L6

Bookkeeping Advanced L6

Payroll
Advanced L6

Communications
Level 6

Human Resources Managment L6

Leadership
Level 6

Supervisory Management L6

Administration
Practice L6

Training Delivery & Evaluation L6

Assessment
Practice L6

Work
Experience L6