Economics with Excel (3 cr)
Code: VAL190007-3002
General information
Enrollment
15.11.2020 - 31.12.2020
Timing
01.01.2021 - 31.07.2021
Number of ECTS credits allocated
3 op
Virtual portion
2 op
Mode of delivery
34 % Contact teaching, 66 % Distance learning
Unit
Faculty of Business
Campus
Åbo, Henriksgatan 7
Teaching languages
- Svenska
Degree programmes
- Degree Programme in Business Administration
Teachers
- Katarina Sandström
Teacher in charge
Marika Nygårdas
Objective
The course explores deeper different functions in Excel and use several different ways to handle and analyze big amounts of data, such as filters, charts, pivot-tables and pivot-charts. During the course students learn to create visual reports of quantitative data.
Content
The course contains both lectures and practical exercises in group or individual. For example the following topics are covered in the course:
Charts
Pivot
Mathematical functions
Statistical functions
Logical functions
Lookup-functions
Macros
Evaluation scale
Approved/Rejected
Assessment criteria, approved/failed
Approved home assignments and exams.
Qualifications
Basic use of excel