Economics with Excel (3 cr)
Code: VAL190007-3003
General information
Enrollment
15.11.2021 - 16.01.2022
Timing
17.01.2022 - 30.04.2022
Number of ECTS credits allocated
3 op
Mode of delivery
Contact teaching
Campus
Åbo, Henriksgatan 7
Teaching languages
- Svenska
Degree programmes
- Degree Programme in Business Administration
Teachers
- Katarina Sandström
Teacher in charge
Katarina Sandström
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