The course focuses on the development and construction of models for use in common business operations. Examples are models for investment, product calculations, budgeting, cost allocation, HR-reporting.

Solid basic skills in Excel are required. Less emphasis is placed on pure Excel training, and more on the practical use of Excel to support everyday life as an economist or a controller, from data collection, processing to presentation

Thorough training is provided in look-up and reference formulas, use of offset() and indirect(), and processing of unstructured data by means of advanced structure of text formulas.

Furthermore, there will be specialization in the use of pivot tables for fast and precise data processing. We consider different types of graphs, and a combination of graphs and linking with dynamic images.

A basic introduction to the use and construction of macros is given (however, this is not a course in macro programming).

After completion of the course, students will:

• be able to handle larger amounts of data and turn them into understandable and manageable information
• be able to create models that can be effectively updated periodically
• be able to make good presentations of data
• be able to efficiently handle external information into own Excel models
• be able to use formulas effectively - focus on look-up formulas, text and logic
• know the use of macros

The lectures are given in real time via Zoom. Students who have real models they want to develop can present it and we can possibly include the construction of the relevant model in the course.

Double lessons three days a week (Monday, Wednesday, Friday). Problem solving between the lectures with assignment support from practice teacher(s).

Exercise teachers will be available for assignment support.