Advanced Use of Excel (5 cr)

Evaluation scale

H-5

Schedule

starting 20.05.2024 and ending 31.08.2024.

Implementation methods, demonstration and Work&Study

a) Contact
b) Online
c) Virtual
d) Demonstrating competencies, https://www.haaga-helia.fi/en/demonstrate-your-competencies
f) Work & study, https://www.haaga-helia.fi/en/career-planning/recognition-learning

Intro

You will get a useful continuation on the topics of the basic course. You will learn the versatile use of functions and learn how to process data with Pivot. You will also notice that macros and forms are actually quite handy functions. After this course, you will be able to apply Excel's power user features in a versatile way.

Materials

Material and links to be shared in Moodle.

Teaching methods and instruction

Study at your own pace based on the videos in the course.
Voluntary EVENING ONLINE lessons: twice in May and once in August.
Online lessons:
- Monday 20.5.2024 17-20
- Monday 27.5.2024 17-20
- Monday 12.8.2024 17-20

Working life connections

practical usage of Excel in working life.

Exam dates and re-exam possibilities

no exams.

Internationality

in English with English version of Excel.

Completion alternatives

- at your own pace based on the videos and guidance in the course
- remotely online
- RPL.

Learning assignments

The assignments are practical and useful, skills taught are important to manage in work-life.

Assessment methods

Some of the assignments are graded. Grade is based on the quality of the assignments.