Millmount Road, Mullingar
Co. Westmeath
Ph 044 9340786

LATEST NEWS


Curriculum » Evening Courses Course Details:

Spreadsheets using Excel QQI L5 (5N1977)

Description

Ideal for those wishing to improve their knowledge and skill using MS Office Excel. Certification provided in QQI FETAC Level 5 Spreadsheet Methods. Also we cover the process of designing, creating and testing a small spreadsheet application.

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.


Millmount Road, Mullingar, Co. Westmeath
Ph 044 9340786 - Fax 044 9341886
Email admin.mcc@lwetb.ie

Designed & Developed by Handyweb.ie | Handyinfo.ie