Advanced Use of Excel (5 op)

Arviointiasteikko

H-5

Toteutustavat, näyttö ja opinnollistaminen

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.

Oppimateriaalit

Material and links to be shared in Moodle.

Opetusmenetelmät ja ohjaus

Self studying based on the videos and assignments.

Työelämäyhteydet

The course is based on assignments that are based on teachers' over 20 years of work-life experience.

Tenttien ajankohdat ja uusintamahdollisuudet

No exams, some assignments are graded, and grading is based on those assignments.

Oppimistehtävät

The assignments are practical based on the possible use cases.
Course assignments cover,
- Visual Basic
- Pivot
- Data analysis in Excel
- Advanced function
- Creating dashboards and forms

Arviointitavat

Assignments will be evaluated.