Economics with Excel VAL190007-3004 01.03.2024-31.05.2024
3 credits+-
Competence objectives of the study unit
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.
Prerequisites
Basic use of excel
Content of the study unit
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