Spreadsheet Methods 5N1977 (Self-paced)

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

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.

Course Content


🧠 What You'll Learn:
 πŸ” Explore Real-World Uses for Spreadsheets Discover the wide range of spreadsheet applications across different industries – from budgeting to project tracking and everything in between.  

🏒 Understand Business Organisations Learn about various business structures and how these affect workflows, responsibilities, and data handling.  πŸ§± Get to Grips with Spreadsheet Basics Understand how cells, cell references, numeric, alpha, and alphanumeric data work. Get hands-on with functions, formulas, graphs, and macros.  

πŸ› οΈ Use Usability Tools Like a Pro Master toolbars, sorting, filtering, and window management to boost your productivity and make data more manageable.  πŸŽ¨ Design for Clarity and Impact Learn formatting tricks that make your spreadsheets cleaner, easier to read, and visually impressive.  

πŸ€– Automate with Simple Macros Save time by automating repetitive tasks. We’ll show you how to create and run your own basic macros to streamline your work.  

πŸ–¨οΈ Print Professionally Discover how to print specific sections or entire spreadsheets with clean formatting – ideal for reports or meetings.  

βš™οΈ Advance Your Spreadsheet Techniques Use absolute/relative cell references, conditional IF statements, and perform financial, statistical, and time/date calculations.  

πŸ“ˆ Create Impactful Graphs Bring your data to life with clear, well-labelled graphs and charts that make information easy to understand at a glance.  

🧩 Build Purpose-Driven Spreadsheets Apply your skills to create spreadsheets that meet real needs and design briefs – independently and confidently.  

πŸ› οΈ Refine and Improve Like a Pro Sharpen your ability to edit, tweak, and polish spreadsheets to ensure they’re practical, accurate, and professional.

πŸš€ Unlock Your Spreadsheet Superpowers Enrol today in the Self-Paced Online Spreadsheets Course and gain:
βœ… 24/7 access to materials
βœ… Interactive exercises and real-world examples
βœ… Ongoing Tutor Support - a full Contact Bar with a range of ways of contacting your Tutor/Support
βœ… Certification on successful completion
βœ… A fun, flexible learning experience that fits around your schedule
 
πŸ§‘β€πŸ« Prefer live classes? We also offer a Blended Option with weekly scheduled β€˜Live’ Online Tutor sessions (scroll up)

Why a Fully Online, Self-Paced Course with Support could be Perfect for You

Learning at your own pace doesn’t mean learning alone. At Lir, our Fully Online, Self-Paced course is designed for busy learners who want the freedom to study when it suits them – while still having access to real guidance, structure, and human support.

Here's Why it Works ...

  • You control your study time – ideal for parents, shift workers, and career changers.
  • Set deadlines keep you focused – you're free to choose your pace within a structured timeframe, helping you stay motivated without feeling rushed.
  • Ongoing support from tutors and our admin team – you’re never left figuring it out on your own.

πŸ“š Did you know?

Studies show that learners in online environments with flexible pacing perform just as well as in-person learners – when clear structure and tutor interaction are present. (Source: Bernard et al., 2009; Moore et al., 2011, Journal of Distance Education)

🀝 You're Not Alone – Here's How We Support You at Lir:

πŸ’» Weekly Check-Ins

We check in to see how you're progressing and offer support or feedback when needed.

πŸ‘©β€πŸ« Tutor Feedback

Submit tasks or questions anytime and receive personalised responses within 48 hours.

πŸ“… Private Messaging, Email, Lir Community Support, or 1-to-1 Zoom/Teams Sessions

Get help between classes via email or message. We’re always here when you need us.

πŸ’‘ Interactive Course Content

Learn through video lessons, real-world scenarios, and guided activities – all designed to keep you engaged.

In order to commence this programme, you must have either successfully completed a programme at a level 5 QQI Certificate/ equivalent qualifications. If you do not have the required qualification you may also be eligible if you can demonstrate that you have the necessary skills to complete this module. If you have a Level 5 Certification and a computer skills qualification at Level 5 in Word Processing and Spreadsheets, and/or life/work experience at that level or higher. 

If you have a disability, medical condition or learning difficulty: In line with the Equal Status Acts 2000 to 2015 - we provide reasonable accommodation to meet the needs of our learners to ensure fairness and equality with others. See Learner Supports for further information.

IT/Computer Skills - sufficient working knowledge of computers.   You must have access to a PC (desktop), laptop or mobile device with internet access, Windows 8 or later or a Mac with OSX 10.5 or later, a browser with the latest version of Microsoft Edge, Chrome, Firefox or Safari, Adobe Reader to view PDFs.    Camera: Your device must have a working camera and audio. PC must be capable of playing video and audio files.   Software: We can provide you with access to Microsoft 365 Office applications (Word, Excel, Powerpoint, Outlook, Teams), Zoom and a Bookkeeping Software Licence.

Blended Learning: You must be self-motivated and be able to take responsibility for your own self-directed learning, outside the 'Live' Tutor online classes as you complete your blended learning course, or in the Fully Online Self-paced modules. Be disciplined in self-directed learning in line with practical preparation, study, and reflection time where appropriate. You have to set time aside. You will be expected to: fluently read, draft, prepare and understand material which is relevant and reflects a broad personal knowledge. fluently read, draft, prepare and understand quantitative data. problem-solving within a group or a number of groups and independently. It is expected that you will have a range of learning styles, strengths and needs related to the programme and have the capacity to take responsibility for your own learning within the managed classroom and online environment, provided by Lir Business Services & Training Centre.  

You must reside in Ireland and have a valid PPS Number.

The interview process ascertains existing levels of knowledge, skills competence and English language proficiency. A copy of your current Curriculum Vitae or certificate will be required and Photo ID.  The Induction will be carried out using Zoom, so you must have a working camera, a microphone for the session.

Learners will also require a good command of the English language and have a recognised English language qualification.      An assessment of English writing and comprehension may be given to ensure equivalency with English language speaking and learning to assess a minimum standard level.     Leaving Certificate (H7/06 in English).

English Language:  This course is completed using the English language.  
QQI 5N1642 English as a Second Language (merit or distinction).  
QQI 5N0690 Communications Level 5 (merit or distinction).  
CEFR - Common European Framework for Languages (level B2 or higher). A competency test may be carried out for English language and literacy and/or computer skills to ensure that you have the skills necessary to complete the programme.    
IELTS Indicator Test The minimum score is 6 unless otherwise stated.  
TOEFL iBT Special Home Edition The minimum score is 92 unless otherwise stated.   Duolingo English Test The minimum score required is 95 unless stated otherwise.  
Exam English If you are unsure of your current level, you can take a free test on sites such as this one.    https://www.ieltsindicator.com  International English Language Testing System - Academic The minimum score is 6 unless otherwise stated. https://www.ets.org/s/cv/toefl/at-home/  TOEFL iBT Special Home Edition.  Test of English as a Foreign Language. Internet-based test (minimum score is 100 out of 120.  Reading and Writing not less than 22. https://englishtest.duolingo.com/applicants. The minimum score required is 95 unless stated otherwise.  

If you are unsure of your current level, you can take a free test on a number of sites, like http://www.examenglish.com/leveltest/index.php, or contact Lir Reception (044) 9342754 to speak to a qualified person who can assist you.    If you are unsure contact Lir Reception (044) 9342754 to speak to a Training Consultant who will be able to assist you.     

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

Director of Training/Tutor
frances@lirbusinesscentre.com

Joan

Training Co-Ordinator
joan@lirbusinesscentre.com

Deirdre

Tutor/Facilitator
deirdre@lirbusinesscentre.com

 "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 F
Office Admin

 "Would highly recommend Lir Business Centre. Frances is so supportive. Courses are well delivered and a fantastic choice of courses.

Linda M.E
(2024)

 "Waiting ... 2024." 

Lir Swan
Learner

Self-Paced Course


€300

  • 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)

Download Course Brochure

I have read and agree to the terms & conditions.

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

Bookkeeping
 L5

Work
Experience L5

Word
Processing L5

Text
Production L5

Communications
Level 5

Customer
Service L5

Database
Methods L5

Medical
Terminology L5

Information and Administration L5

Intercultural
Studies L5

Digital
Marketing L5

Payroll
 L5

Reception and Frontline Office Skills

Research and Study Skills L5

Spreadsheet
Methods L5

Check our Social Media Platforms for Special Offers and Promotions