Spreadsheet Methods
Spreadsheet Methods
5N1977
QQI Level 5
Business Studies (5M2102)
7pm to 10pm
Wednesday
Autumn
12 Weeks (+ 2 Saturdays)
Description
Spreadsheets are a cornerstone of modern business, but their potential can seem overwhelming. This Spreadsheet Methods module equips you to confidently navigate the world of spreadsheets, transforming them from a mystery into a powerful tool! Spread conveniently over evenings, this course delves into the practical applications of spreadsheets, showcasing their versatility in managing data, performing calculations, and creating clear visuals.
We'll start with the building blocks: cells, references, and data types. You'll learn how to navigate the spreadsheet interface, using toolbars and features for efficient data entry and manipulation. Sorting and filtering will become second nature, allowing you to organise information with ease.
Beyond the basics, we'll explore formatting techniques to enhance the clarity and readability of your spreadsheets. Formulas and functions will unlock the power of calculations, automating tasks and saving you valuable time. Creating charts and graphs will bring your data to life, allowing you to visualise trends and insights.
As you progress, you'll delve into advanced features like absolute and relative cell references, conditional statements, and specialised functions for finance, statistics, and date/time manipulation. This course doesn't stop at theory – you'll gain practical experience by building your own spreadsheet from scratch, applying your newfound skills to solve real-world scenarios. We'll even introduce the concept of macros, allowing you to automate repetitive tasks and streamline your workflow.
By the end of this module, you'll be well-equipped to utilise spreadsheets with confidence, transforming data into valuable insights and creating clear, professional presentations. Get ready to unlock the full potential of spreadsheets and become a master of this essential business tool!
Access
English Requirement
Progression
Module Document
Click to Download Module Document PDFFurther Information
At Gorey Adult Education, we're here to help you every step of the way on your learning journey. Whether you have a question about a specific course, the registration process, or just need some friendly advice, don't hesitate to reach out! Our helpful staff is always happy to chat and ensure you have a smooth and successful learning experience.
Esmonde Street
Gorey
Wexford
Ireland, Y25 YX29
053 9421167
Gorey Adult Education
Updated: July 2024
Registration
- You must register to participate in any course.
- Registration is not complete until you pay the fee.
- Places are offered on a first-come, first-served basis.
- Paying the fee doesn't guarantee a spot in a specific course.
- If a course is full or cancelled, you'll be offered a transfer to another course or a refund of the registration fee.
Registration Fees
- A registration fee of €40 applies to all standard courses and €95 for all certified courses.
Course Fees
- Fees under €300 are due by the third night of the course, along with any applicable registration fee.
- Fees over €300 can be paid in installments (details provided beforehand). A one-third deposit is required upfront for these courses.
- You are not registered until you have paid the registration fee and any applicable deposit.
Payment Methods
- Cash is no longer accepted for fees.
- We accept payments by cheque, banker's draft, postal order, Laser card, or Visa card.
- You can also register and pay for your course online using Easy Payments Plus. Look for the EPP icon on the right side of the screen and follow the instructions.
Refunds and Deferrals
- Registration fees are non-refundable unless the course is cancelled.
- Refunds/deferrals for other reasons are possible under certain conditions:
- Requested by the third night of the course.
- In writing.
- With a medical certificate (for medical reasons).
- Appeals of refund/deferral decisions can be made to the Board of Management.
Discounts
- Participants receiving Jobseeker's Benefit or a State Pension get a 25% discount on uncertified courses (Evidence required).
Examinations and Certification
- Pay all fees before taking final exams.
- You may be excluded from exams if fees are unpaid.
- Certificates are issued based on registration details.
- Collect certificates in person or at an award ceremony.
- There's a fee to replace lost or inaccurate certificates.
General Information
- The Board of Management reserves the right of admission.
- The school is not responsible for lost or damaged student property.
- In case of closure due to bad weather, a notice will be posted on the website, Facebook page, and phone answering service. Cancelled classes may be rescheduled.
Payment Terms
- Gorey Community School and its third-party suppliers provide the payment system.
- Gorey Community School can update these terms anytime, and changes are effective immediately.