Advanced Use of Excel (5cr)

Code: ANA002AS2AE-3006

Basic information of implementation

Timing: 12.01.2026 - 13.03.2026; The implementation has not yet started.

ECTS Credits: 5 cr

Campus: Pasila Campus

Teaching languages: English

Seats: 15 - 45

Degree programmes: ITBBA Business Information Technology; INTBBA International Business

Teachers: Ville Pennanen

Groups: IBE4PAACC
INTBBA, 4. semester, Pasila, Accounting and Finance; ITE2PAICB1
Business Information Technology, 2nd semester, ICT and Business, Pasila, group 1; CONTACT
Contact implementation; IBE4PASCM
INTBBA, 4. semester, Pasila, Supply Chain Management; BLENDED
Blended implementation; IBE4PAMAR
INTBBA, 4. semester, Pasila, Marketing and Sales; IBE4PACOM
INTBBA, 4. semester, Pasila, International Business Communication; EXCH
EXCH Exchange students; IBE3PA1
INTBBA, 3. semester, Pasila, group 1

Course: ANA002AS2AE

Evaluation scale

H-5

Schedule

The weekly schedule can be found on Moodle.

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

The implementation is contact / blended. The learning environment is the classroom and Moodle learning environments. The implementation also includes exercises and requires self-directed learning. Learning materials can be found on Moodle. The meetings include theory acquisition and guidance, promotion of group work and applied tasks.

The course progresses according to a weekly schedule. Course material is generally available at the start of the course. Current material will be added during the course.

Working life connections

The assignments in the course are designed based on real life cases.

Exam dates and re-exam possibilities

There is no exam in the course. The course consists of learning assignments.

Learning assignments

The course includes a learning assignment related to each weekly module, in which the student must apply the knowledge learned in the lectures.

Assessment methods

Each assignment will be evaluated and details of the evaluation can be found from the Moodle,

When the course is delivered in contact, online or blended mode, the student must be present for the teaching hours marked for the course. If you are absent for more than 25%, your grade will be reduced by one. If you are absent for more than 50%, the course is failed.