Advanced Use of Excel (5cr)

Evaluation scale

H-5

Schedule

starting 20.05.2024 and ending 31.08.2024.

Implementation methods, demonstration and Work&Study

CONTACT BLENDED
ONLINE BLENDED
VIRTUAL
DEMO
WORKSTUDY

Descriptions of implementation methods can be found in Haaga-Helia's website: https://www.haaga-helia.fi/en/implementation-types
You can complete the course unit by demonstrating or by Work&Study even if the course unit doesn't have DEMO or WORKSTUDY implementations. More information about recognition of learning at Haaga-Helia's website: 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.
The course materials do not fully support Mac users. Mac users may work through vdi.
Note! The Excel must be installed on the local computer, OnlineExcel is not enough.

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.