Advanced Use of ExcelLaajuus (5 op)
Opintojakson tunnus: ANA002AS2AE
Opintojakson perustiedot
- Laajuus
- 5 op
Osaamistavoitteet
- 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
Sisältö
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.
Lähtötaso ja sidonnaisuudet muihin opintojaksoihin
Before completing this course, the student must know the basics of Excel.
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
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
Oppimateriaalit
Material and links to be shared in Moodle.
Lisätiedot
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.