Hello, Limerick College of Further Education has detected that you are using an outdated version of Internet Explorer. If possible we strongly urge you to update your browser or switch over to Chrome or Firefox so you can enjoy the full user experience of our website and avail of all the features!
Close This Message'
Full
Time
Apply
Part
Time
Apply
Contact
LCFE
Courses

Advanced Certificate in Spreadsheet Techniques (QQI Level 6) | CM020 (14 weeks Class Based)

Course Overview

Award(s)
QQI Level 6 Spreadsheet Techniques 6N4089
Course Code:
CM020 | TUES 18.30-22.00
Fees:
€290

The purpose of this course is aimed at training the learner to design and create spreadsheets using advanced spreadsheet techniques working independently or within a supervisory capacity.

Apply for this Course
Programme Description

Learners will be able to:
• Describe spreadsheet design principles to include requirements
analysis, solution design, data inputs and expected outputs, data formats, and worksheet layout
• Customise the user interface to optimise application usability
by creating default file locations, Customising toolbars, creating custom menus, showing and hiding rows and columns, freezing Panels and using multiple windows
• Use advanced application-provided data manipulation capabilities to include logical, mathematical, text and financial functions and formulae
• Automate routine multi-step tasks through the creation, execution, & management of complex Macros
• Debug spreadsheet errors using features such as formula auditing
• Analyse spreadsheet data using pivot tables, charts and graphics
• Enhance spreadsheet usability through worksheet and cell protection, data validation, and conditional formatting
• Design a spreadsheet to meet an advanced specification, implementing a comprehensive range of spreadsheet features to produce the required outcome
• Assess the suitability of using a spreadsheet to achieve a given
requirement
• Critique spreadsheets created by others to include recommendations for any required changes.

x
This provision is co-funded by the Irish Government and the European Social Fund as part of the ESF Programme for Employability, Inclusion and Learning 2014 – 2020.