University College Ghent
Geraard de Duivelstraat 5 - 9000 Ghent - Belgium
Phone: 09 243 33 33 - E-mail:
Spreadsheet Applications (English language)34176/4701/2122/1/72
Study guide

Spreadsheet Applications (English language)

Academic year 2021-22
Is found in:
  • International Curriculum Business, Retail and Languages, programme stage 1
This is a single course unit.
Study load: 3 credits
Weight: 3,00
Total study time: 75,00 hours
It is not possible to enrol in this course unit under
  • exam contract (to obtain a credit).
  • exam contract (to obtain a degree).
Special admission is required to enrol in this course unit under credit contract.
Co-ordinator: Mestdagh Barbara
Languages: English
Scheduled for: Semester 1 or Semester 2

Final objectives

can work in a project-based manner and devise and carry out research step by step and in a professional manner


Can apply basic Microsoft Excel techniques.
Can work with graphs in Microsoft Excel
Can work with data lists in Microsoft Excel
Can work with advanced functions and hyperlinks in Microsoft Excel
Can process, edit, analyze, present and interpret data in an Excel program


Working with tables: sorting, filteringWorking with data, formulas, functions, and range names
Format cells and worksheets
Working with tables: sorting, filtering
Pivot tables
Data Validation
Advanced features: date and time functions, logical functions, search functions, text functions, nesting functions

Organisation of education

Contactonderwijs24,00 hours

Teaching methods

  • Learning dialogue
  • Practice session

Study guidance

Individual learning problems can always be reported to the lecturer.


Evaluation(s) for first exam chance
Inside Regular exam scheduleWritten examination100,00
Evaluation(s) for re-sit exam
Inside Regular exam scheduleWritten examination100,00
This course unit is marked out of 20 (rounded to an integer).
Re-sit exam: is possible.

Other study materials

Course material will be made available online (Chamilo)


Final terms secondary school in Flanders
Possible deadlines for learning account: 01.12.2021 () or 15.03.2022 ()