Excel (4 cr)

Code: KH00BZ47-3005

General information

Enrollment: 02.08.2023 - 31.08.2023
Registration for the implementation has ended.

Timing: 29.08.2023 - 28.12.2023
Implementation has ended.

Number of ECTS credits allocated: 4 cr

Local portion: 4 cr

Mode of delivery: Contact learning

Unit: Engineering and Business

Teaching languages: Finnish

Degree programmes: Degree Programme in Business Logistics

Teachers: Virpi Raivonen

Groups: PLILOS22HANK
PLILOS22Purchasing; PLILOS22KULJ
PLILOS22Transport

Course: KH00BZ47

No reservations found for realization KH00BZ47-3005!

Evaluation scale

H-5

Objective

Students are able to
- use an Excel program for analysis and decision-making in business operations support
- solve problems using functions
- forms and take advantage of the connections between the tables
- apply search features
- master Pivot tabulation

Content

- Basics of Excel refresher
- Lookup functions
- Pivot function

Materials

Oheiskirjallisuus:

E-kirja

Freund, S. M. & Starks, J. L. 2020. Microsoft Office 365 & Excel 2019 comprehensive. Boston: Cengage.

Clark, D. a. 2020. Beginning Microsoft Power BI: A Practical Guide to Self-Service Data Analytics. 3rd ed. 2020. Berkeley, CA: Apress.

Fairhurst, D. S. 2019. Using Excel for business and financial modelling: A practical guide. Third edition. Chichester, West Sussex: Wiley.

Alexander, M., Kusleika, D. & Walkenbach, J. 2019. Excel 2019 Bible. 1st edition. Indianapolis, IN: Wiley.

Vahva suositus:

Leino, Timo. Excel käyttäjän käsikirja: Otava

Teaching methods

Learning by doing
Tuntitehtävät
Harjoitustyöt
Loppukoe

Exam schedules

Kurssikoe vko

Koetta ei voi uusia sillä kokeen pisteet ovat osa arvioitavaa kokonaisuutta.
Uusintakoe vko

Student workload

Työn mitoitus:

Kontakti
Tiedonhankinta
Tuntitehtävät
Materiaaliin tutustuminen
Harjoitustyöt
Vertaisarviointi
Itsearviointi
Koe ja valmistautuminen
Yhteensä 107