Skip to main content

Advanced EXCEL Utilization (5 cr)

Code: T000CI54-3009

General information


Enrollment

02.05.2023 - 22.09.2023

Timing

01.08.2023 - 31.07.2024

Number of ECTS credits allocated

5 op

Mode of delivery

Contact teaching

Unit

School of Real Estate and Construction

Campus

Myllypurontie 1

Teaching languages

  • Finnish

Degree programmes

  • Master's Degree Programme in Building Services Engineering

Teachers

  • Jorma Vilska

Groups

  • T0823S6
    Talotekniikan tutkinto-ohjelma, ylempi amk

Objective

On completion of the course the student will be able to use fluently and in a comprehensive way Excel program in engineering.

Content

Creating Excel functions and charts, Pivot tables, filters, sorting, subtotals, statistical analyses, goal seek and solver, macros, VBA basic

Evaluation scale

0-5

Assessment criteria, satisfactory (1)

The student is able to apply the above listed, learned knowledge and skills according to instructions.

Assessment criteria, good (3)

The student is able to apply the above listed, learned knowledge and skills independently.

Assessment criteria, excellent (5)

The student is able to give reasons for his or her choices related to the course contents in a comprehensive manner.

Assessment criteria, approved/failed

The student is able to apply the above listed, learned knowledge and skills according to instructions.