Office Administration

DFS2108 - Spreadheet Methods (Excel) (QQI Level 5)

Course

DFS2108 - Spreadsheet Methods (QQI Level 5)

Duration 12 Weeks
Cost €265.00
Night Mondays 6.30pm - 9.30pm
Register

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.

Basic computer skills required.

All DIFE Night School students receive free Microsoft Office licence for one year

Classes may go online depending on Government Restrictions

Class starts Monday 1st February 2021 6.30pm - 9.30pm

Learning Outcomes

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 the 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.

For full Module Descriptor Click here 

Contact DIFE

sample
+353 41 9837105

sample
https://dife.ie/

sample
This email address is being protected from spambots. You need JavaScript enabled to view it.

Contact Ó Fiaich Institute

sample
+353 42 9353967

sample
https://www.ofi.ie/

sample
This email address is being protected from spambots. You need JavaScript enabled to view it.

Contact St. Olivers

sample
+353 41 9838390 

sample
http://www.socc.ie/

sample
This email address is being protected from spambots. You need JavaScript enabled to view it.