Spreadsheet Methods 5N1977 'Live' Tutor Classes

This is a standalone QQI Certified module, or part of the 5M2468 Business Administration or 5M1997 Office Administration Major Award.

Course Content

Introducing the 5N1977 Spreadsheets Online Course:

Master the Art of Data Manipulation and Analysis

Are you ready to unlock the full potential of spreadsheets and improve your data management skills? Look no further!

Welcome to the 5N1977 Spreadsheets Online Course, where we will equip you with the essential knowledge and practical techniques to become more efficient and creative with spreadsheets.

Why Choose our Lir Spreadsheets Course?

Our comprehensive course is meticulously designed to cater to beginners and seasoned professionals alike. Whether you are a business owner, a data analyst, or an aspiring spreadsheet guru, this course is your ultimate gateway to improving your skills/existing skills. We have crafted a curriculum that covers everything you need to know to excel in spreadsheet manipulation and analysis.

Learning Outcomes:
1. Investigate a range of common uses for spreadsheets.

2. Identify features of different types of business organisations:
Gain a deep understanding of the various organisational structures and how they impact business operations. Expand your knowledge and sharpen your decision-making skills.

3. Explore key spreadsheet elements: 
Dive into the fundamental building blocks of spreadsheets. Learn about cells, cell references, and different types of data such as numeric, alpha, and alphanumeric. Discover the power of formulae, functions, graphs, and macros, and harness them to transform raw data into meaningful insights.

4. Demonstrate common spreadsheet usability features:
Master the art of efficient spreadsheet usage. Discover how to leverage toolbars, manage windows effectively, and utilise sorting and filtering techniques to navigate through vast amounts of data effortlessly.

5. Use spreadsheet design features to enhance understanding and legibility:
Unlock the secrets of captivating spreadsheet design. Learn formatting techniques that enhance clarity, making your data easy to interpret. Impress your audience with visually appealing and professional-looking spreadsheets.

6. Automate routine multi-step tasks through simple macros:
Save time and effort by automating repetitive tasks. We'll guide you in creating, executing, and managing simple macros that streamline your workflow and boost productivity.

7. Print sections of a spreadsheet fit for presentation:
Showcase your data in its best light. Discover how to print complete or partial sections of your spreadsheet, formatted beautifully and ready for presentation.

8. Use advanced spreadsheet features: 
Take your spreadsheet skills to the next level. Learn to utilize absolute and relative cell references, various conditional IF statements, and powerful functions for statistical analysis, financial calculations, and managing date and time data. 9.Generate visually stunning graphs: Unleash your data visualization prowess. Learn how to create a variety of graph types with appropriate titles and labels, bringing your data to life and enabling clearer insights.

10. Produce purposeful spreadsheets independently: 
Demonstrate your expertise by creating purpose-built spreadsheets with minimal supervision. Meet design specifications and ensure your spreadsheets are fit for their intended purpose.

11. Demonstrate resourcefulness in editing and amending spreadsheets:
Showcase your personal initiative and resourcefulness. Learn how to edit and refine spreadsheets to ensure they meet the highest standards and are tailored to specific needs.

Unlock Your Spreadsheet Superpowers Today! 
Enrol in the 5N1977 Spreadsheets Online Course and embark on a transformative journey towards spreadsheet mastery. Join our vibrant community of learners and gain access to a wealth of knowledge, interactive exercises, real-world examples, and expert guidance. Don't let your data remain untapped potential – empower yourself with the skills you need to succeed in the digital age.

Spaces are limited for ‘Live’ Tutor Online classes and classroom-based classes, so secure your spot now! Click the button below to register and unlock a world of endless possibilities with spreadsheets.

In Summary: This is an ideal course that will give you the knowledge, skill and competence to use a spreadsheet software application to create and modify spreadsheets using spreadsheet features and functions in an efficient and accurate manner.

What's more, it's fun ... yes, spreadsheets can be fun, and it can do so much more to make your busy life in the office easier.  It allows you to be creative, and really think about where and how you can use this application.  You've guessed it - "we love spreadsheets" and you will too - so give it a go.  This course is run as a Blended 'Live' Tutor Online scheduled weekly course, or as a Self-paced course with Tutor Support throughout the duration of your course.  

So, what are you waiting for?  If you would like to speak to someone to discuss your options, contact Lir Reception (044) 9342754 or training@lirbusinesscentre.com

Course Content

Introduction to Spreadsheet Methods 5N1977

Unit 1 - Spreadsheets Terminology and Basic Concepts

Unit 2 - Spreadsheets - Formulae and Functions

Unit 3 - Spreadsheets - Additional Functions

Unit  4 - Spreadsheets - Nested IFs

Unit 5 - Spreadsheets - LookUps

Unit 6 - Spreadsheets - Practice Assignment

Unit 7 - Spreadsheets - Exam Preparation

Unit 8 - Spreadsheets - Project

Unit 9 - Spreadsheets - 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.


Director of Training/Tutor


Training Co-Ordinator



 "I know more about how to use Excel spreadsheets now. I am creating 'if' formulas at work and finally I know how to create Macros

Shalima Fiorvanti
Office Admin

 Waiting ... 2022." 

Lir Swan

 "Waiting ... 2022." 

Lir Swan

'Live' Tutor Online Course


  • Attend 'Live' Tutor Online Scheduled Weekly Classes
  • 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
  • Flexi-payments also available
  • CE Participant Rate (Contact Lir Reception 044-934 2754)

Other Modules to consider towards the Lir QQI 5M2468 Business Administration Major Award and other Awards such as the
5M1997 Office Administration Major Award

Business Administration L5


Experience L5

Processing L5

Production L5

Level 5

Service L5

Methods L5

Terminology L5

Information and Administration L5

Studies L5

Marketing L5


Reception and Frontline Office Skills

Research and Study Skills L5

Methods L5