Advanced Use of Excel - ANA002AS2AE - Opinto-opas

Advanced Use of Excel, 5 op - ANA002AS2AE

Tulevat toteutukset

Advanced Use of Excel ANA002AS2AE-3007 19.05.2025-30.08.2025 5 op (VIRTUAL, ...) +-
Oppimateriaali ja suositeltava kirjallisuus

Material and links to be shared in Moodle.

Toimipiste

Pasila Campus

Opetuskieli

Englanti

Ajoitus

19.05.2025 - 30.08.2025

Ilmoittautumisaika

02.01.2025 - 16.05.2025
Ryhmä
- VIRTUAL
- INSTRUCTED
- SUMMER
Opettaja

Lauri Tapola, Ville Pennanen

Paikkoja

30 - 100

Koulutus

ITBBA Business Information Technology

T&K-osuus

0.00 op

Virtuaaliosuus

5.00 op

Arviointiasteikko

H-5
Advanced Use of Excel ANA002AS2AE-3005 18.08.2025-10.10.2025 5 op (IBE5PASCM, ...) +-
Opetusmenetelmät ja ohjaus

Study like you want, at your own pace based on the videos in the course, on-site in class or remotely online.

Oppimateriaali ja suositeltava kirjallisuus

All the material or the links to those are in Moodle.

Työelämäyhteydet

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

Toimipiste

Pasila Campus

Tenttien ajankohdat ja uusintamahdollisuudet

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

Opetuskieli

Englanti

Kansainvälisyys

We are using English as the course language and the English version of Excel.

Ajoitus

18.08.2025 - 10.10.2025

Oppimistehtävät

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

Ilmoittautumisaika

14.05.2025 - 22.05.2025

Aikataulu

8 weeks, assignments and lessons for every week.
Ryhmä
- IBE5PASCM
- IBE5PAMAR
- IBE4PAACC
- ITE2PAICB1
- CONTACT
- BLENDED
- IBE4PAMAR
- IBE5PACOM
- IBE5PAACC
- EXCH
Toteutuksen valinnaiset oppimistavat

- at your own pace based on the videos and guidance in the course, virtual
- on-site in class or
- remotely online.

Opettaja

Lauri Tapola

Paikkoja

15 - 45

Arviointitavat

Some of the assignments are graded.

Koulutus

ITBBA Business Information Technology, INTBBA International Business

T&K-osuus

0.00 op

Virtuaaliosuus

2.50 op

Arviointiasteikko

H-5
Advanced Use of Excel ANA002AS2AE-3006 12.01.2026-13.03.2026 5 op (IBE4PAACC, ...) +-
Oppimateriaali ja suositeltava kirjallisuus

Material and links to be shared in Moodle.

Toimipiste

Pasila Campus

Opetuskieli

Englanti

Ajoitus

12.01.2026 - 13.03.2026
Ryhmä
- IBE4PAACC
- ITE2PAICB1
- CONTACT
- IBE4PASCM
- BLENDED
- IBE4PAMAR
- IBE4PACOM
- EXCH
- IBE3PA1
Opettaja

Ville Pennanen

Paikkoja

15 - 45

Koulutus

INTBBA International Business, ITBBA Business Information Technology

T&K-osuus

0.00 op

Virtuaaliosuus

2.50 op

Arviointiasteikko

H-5
Advanced Use of Excel ANA002AS2AE-3008 18.05.2026-28.08.2026 5 op (SUMMER, ...) +-
Opetusmenetelmät ja ohjaus

Self studying based on the videos and assignments.

Oppimateriaali ja suositeltava kirjallisuus

Material and links to be shared in Moodle.

Työelämäyhteydet

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

Toimipiste

Pasilan toimipiste

Tenttien ajankohdat ja uusintamahdollisuudet

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

Opetuskieli

Suomi

Ajoitus

18.05.2026 - 28.08.2026

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
Ryhmä
- SUMMER
- VIRTUAL
- INSTRUCTED
Opettaja

Ville Pennanen

Paikkoja

15 - 60

Arviointitavat

Assignments will be evaluated.

T&K-osuus

0.00 op

Virtuaaliosuus

5.00 op

Arviointiasteikko

H-5
Näytä kaikki (4) Piilota

Käynnissä olevat toteutukset

Ei käynnissä olevia toteutuksia.

Päättyneet toteutukset

Advanced Use of Excel ANA002AS2AE-3003 13.01.2025-14.03.2025 5 op (IBE4PAACC, ...) +-
Oppimateriaali ja suositeltava kirjallisuus

Material and links to be shared in Moodle.

Toimipiste

Pasila Campus

Opetuskieli

Englanti

Ajoitus

13.01.2025 - 14.03.2025

Ilmoittautumisaika

02.01.2025 - 10.01.2025
Ryhmä
- IBE4PAACC
- ITE2PAICB1
- CONTACT
- IBE4PASCM
- BLENDED
- IBE4PAMAR
- IBE4PACOM
- EXCH
- IBE3PA1
Opettaja

Lauri Tapola, Ville Pennanen

Paikkoja

15 - 45

Koulutus

ITBBA Business Information Technology, INTBBA International Business

T&K-osuus

0.00 op

Virtuaaliosuus

3.00 op

Arviointiasteikko

H-5
Advanced Use of Excel ANA002AS2AE-3002 19.08.2024-11.10.2024 5 op (IBE5PASCM, ...) +-
Opetusmenetelmät ja ohjaus

Study like you want, at your own pace based on the videos in the course, on-site in class or remotely online.

Oppimateriaali ja suositeltava kirjallisuus

All the material or the links to those are in Moodle.

Työelämäyhteydet

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

Toimipiste

Pasila Campus

Tenttien ajankohdat ja uusintamahdollisuudet

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

Opetuskieli

Englanti

Kansainvälisyys

We are using English as the course language and the English version of Excel.

Ajoitus

19.08.2024 - 11.10.2024

Oppimistehtävät

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

Ilmoittautumisaika

03.06.2024 - 16.08.2024

Aikataulu

8 weeks, assignments and lessons for every week.
Ryhmä
- IBE5PASCM
- IBE5PAMAR
- IBE4PAACC
- ITE2PAICB1
- CONTACT
- IBE4PASCM
- BLENDED
- IBE4PAMAR
- IBE5PACOM
- IBE5PAACC
- EXCH
Toteutuksen valinnaiset oppimistavat

- at your own pace based on the videos and guidance in the course,
- on-site in class or
- remotely online.

Opettaja

Lauri Tapola, Ville Pennanen

Paikkoja

15 - 45

Arviointitavat

Some of the assignments are graded.

Koulutus

ITBBA Business Information Technology, INTBBA International Business

T&K-osuus

0.00 op

Virtuaaliosuus

3.00 op

Arviointiasteikko

H-5
Advanced Use of Excel ANA002AS2AE-3004 20.05.2024-30.08.2024 5 op (EVENING, ...) +-
Opetusmenetelmät ja ohjaus

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

Oppimateriaali ja suositeltava kirjallisuus

Material and links to be shared in Moodle.

Työelämäyhteydet

practical usage of Excel in working life.

Toimipiste

Pasila Campus

Tenttien ajankohdat ja uusintamahdollisuudet

no exams.

Opetuskieli

Englanti

Kansainvälisyys

in English with English version of Excel.

Ajoitus

20.05.2024 - 30.08.2024

Oppimistehtävät

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

Ilmoittautumisaika

23.01.2024 - 17.05.2024

Aikataulu

starting 20.05.2024 and ending 31.08.2024.
Ryhmä
- EVENING
- BLENDED
- SUMMER
- ONLINE
Toteutuksen valinnaiset oppimistavat

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

Opettaja

Lauri Tapola

Paikkoja

15 - 60

Arviointitavat

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

Koulutus

ITBBA Business Information Technology, INTBBA International Business

T&K-osuus

0.00 op

Virtuaaliosuus

3.00 op

Arviointiasteikko

H-5
Näytä kaikki (3) Piilota

- recognize the possibilities of spreadsheet calculation
- identify the possibilities of using the Excel program in working life
- knows how to use the Excel program versatilely and effectively
- knows how to choose appropriate ways from the functions offered by the Excel program

Functions and calculations versatilely; rounding, search, lookup, time.
Pivots and utilization of it.
Forms and templates
Basics of using macros and Visual Basic.
Data refining - data to support decision-making.

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

Material and links to be shared in Moodle.

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 software must be installed on the machine, OnlineExcel is not enough.

Before completing this course, the student must know the basics of Excel.

When the implementation type of the course is CONTACT, ONLINE or BLENDED it is required that the student is present during those teaching hours that are marked in the study schedule. If you are absent more than 25 %, your grade will be lowered by one. If you are absent more than 50 %, the course is failed.

- knows the basic use of the program and copes with the assigned tasks helpfully
- can apply the features of the program independently to a small extent

- can apply a spreadsheet program appropriately
- is able to find new solutions using Excel's functions in a versatile way

- can apply the program versatilely to practical situations
- have strong skills and reliable competence
- is able to independently find new and effective solutions and use the versatile possibilities of Excel