Spreadsheet Methods

Course details

The purpose of this award is to ensure that the learner is fully capable of using a broad range of advanced spreadsheets features to work efffectively and produce clear printouts. On successful completion of this course the learner will be able to carry out advanced selection, formatting,charts, tables, formulae usage, macro production and design of dynamic spreadsheets.

modules

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.

Entry requirements: QQI Level 4 certificate, Leaving certificate or equivalent qualifications and/or relevant life and work experiences

Assessment:

1. Project
2. Examination

Protection for learners:NCU Training is one of only seven fully bonded and insured ICPA (Irish Course Providers Association) member training providers in Ireland. If you train with us your course is fully insured for refund of all fees in case of disruptions. *This is only available on courses of three months in Duration

Complaints procedure:It is your right as a client of our service to make a complaint if you feel your experience with us falls short of what you expected. We want the process to be easy, effective and fair.