Advanced Use of Excel (5op)

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.

Osaamistavoitteet

After having completed this course or attained an equivalent competence level, the student is able to :
- recognize the possibilities of spreadsheet calculation
- identify the possibilities of using the Excel program in working life
- use the Excel program versatilely and effectively
- choose appropriate ways from the functions offered by the Excel program

Sisältö

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

Toteutustavat, näyttö ja opinnollistaminen

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

Oppimateriaalit

Material and links to be shared in Moodle.

Lähtötaso ja sidonnaisuudet muihin opintojaksoihin

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

Arviointikriteerit - arvosana 1

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

Arviointikriteerit - arvosana 3

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

Arviointikriteerit - arvosana 5

- 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