Spreadsheet Methods 5N1977 (Self-paced)

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)

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.