Spreadsheet Methods - MS Excel

To check out the next start date / enrolment date for evening courses please view the college website
https://monaghaninstitute.ie/courses/evening-courses/

or contact eveningcourses@cmetb.ie to register or call 087 4054311 or 049 4353904.

Monaghan Institute, Armagh Road, Monaghan.

All Level 5 and Level 6 evening courses are free of charge under the Skills to Advance or Skills to Compete initiative.

https://monaghaninstitute.ie/courses/evening-courses/

The purpose of this award is:
- To equip the learner with the knowledge, skill and competence to create and modify spreadsheets under supervision, using common spreadsheet features.

- To develop a fundamental understanding of spreadsheet concepts and their range of application and gain extensive practical experience in spreadsheet design and implementation.

- To create an awareness and understanding of uses/functions of macros.


Learners will be able to:
• Investigate a range of common uses for spreadsheets

• Explore key spreadsheet elements including cells, cell references, numeric, alpha, and alphanumeric data, formulae, functions, graphs and macros

• Demonstrate common spreadsheet usability features to include use of toolbars, window management, sorting, and filtering

• Use spreadsheet design features involving data and cell formatting techniques which enhance understanding and legibility

• Automate routine multi-step tasks through the creation, execution, and management of simple macros

• Print complete or partial sections of a spreadsheet, formatted fit for presentation

• Use advanced spreadsheet features including absolute and relative cell references, conditional IF statements, statistical, financial, and date and time functions

• Generate a variety of types of graphs, with appropriate titles and labels, from spreadsheet data

• Produce a spreadsheet, with minimal supervision, that meets a simple design specification and is fit for purpose

• Demonstrate personal initiative and resourcefulness in editing and amending spreadsheets to ensure they are fit for purpose.

5N1977 Spreadsheet Methods

Why study for an Evening Qualification?
- Gain a competitive advantage in the workplace by enhancing your knowledge and skills

- Enhance existing qualifications and CV

- Develop both academically and professionally (enhanced skills such as communication, leadership skills, listening skills)

- Personal development and self-actualisation felt when you obtain a recognised national qualification.

- Develop a personal interest

- Adapt to workplace changes

- Flexible learning – courses are delivered on a part time basis

Charlotte Dunne
Community Education Facilitator (Evening Provision)
Cavan Monaghan ETB
Email: eveningcourses@cmetb.ie
Tel: 049 4353904
Mob: 087 4054311