Spreadsheet Methods
Spreadsheet Methods prepares learners to create and design spreadsheets customised to a range of tasks in a business environment.
Course Code
5N1977
Entry Requirements
• Over 18 years old
• Good spoken and written English
• QQI level 4 certificate
• Leaving certificate and/or relevant life and work experience
Qualification
QQI Level 5
Duration
4 days
Assessment
Project / Examination - Practice
• Participants must have:
– Proof of name and date of birth
– PPS Number
• Cancellation fee:
– 100% price for cancellations made less than 7 days in advance, or in case of no-show
– No fee for cancellations made 7 or more days in advance
Learners will be able to:
1 Investigate a range of common uses for spreadsheets
2 Explore key spreadsheet elements including cells, cell references, numeric, alpha, and alphanumeric data, formulae, functions, graphs and macros
3 Demonstrate common spreadsheet usability features to include use of toolbars, window management, sorting, and filtering
4 Use spreadsheet design features involving data and cell formatting techniques which enhance understanding and legibility
5 Automate routine multi-step tasks through the creation, execution, and management of simple macros
6 Print complete or partial sections of a spreadsheet, formatted fit for presentation
7 Use advanced spreadsheet features including absolute and relative cell references, conditional IF statements, statistical, financial, and date and time functions
8 Generate a variety of types of graphs, with appropriate titles and labels, from spreadsheet data
9 Produce a spreadsheet, with minimal supervision, that meets a simple design specification and is fit for purpose
10 Demonstrate personal initiative and resourcefulness in editing and amending spreadsheets to ensure they are fit for purpose.
Price
€295.00
Funding
Course funding options may be available, depending on eligibility. Contact your local Intreo office or Local Employment services.
Protection for Learners
Glin National College (GNC) offers students learner protection insurance, which ensures that learners of a validated programme of three months or longer leading to a QQI award have an opportunity to complete that programme, or are refunded the money most recently paid if that programme ends before they complete it. Each learner receives a Learner Protection Insurance Policy in their name and we will notify them in writing of any change in information within 14 days of becoming aware of that change.
Complaints Procedure
It is our policy to deal with any expression of dissatisfaction concerning our services or their provision in a fair manner. Complainants should raise their concerns as soon as possible, and where the conduct complained of is violent or criminal in nature, the Gardai will be contacted without delay.
While in no way diminishing the issue or the effects on individuals, an informal approach should be the first course of action as it can often easily resolve matters. If the situation or behaviour continues, the complainant can proceed to making a formal complaint. If a hearing by investigation is required, its results evaluate whether the complaint is valid or invalid, or is malicious, or whether there is insufficient evidence. If a complaint is not resolved to the satisfaction of the complainant, it may be referred again for internal review by Glin National College or in writing to the office of the Chairperson of the Board of Management.
Book upcoming courses now
What they say
Connect with Glin National College for more information
Call us today on 01 847 9463 or send a message