Course code BUS234

BUS234 Advanced Excel – Efficient Models for Business Management

Norsk emneinformasjon

Search for other courses here

Showing course contents for the educational year 2022 - 2023 .

Course responsible: Øystein Dahl
ECTS credits: 5
Faculty: School of Economics and Business
Teaching language: NO
(NO=norsk, EN=Engelsk)
Teaching exam periods:
This course starts in June block. This course has teaching/evaluation in June block.
Course frequency: Annually.
First time: Study year 2019-2020
Course contents:

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.

Learning outcome:
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
Learning activities:

The lectures are given at campus. 

Problem solving between the lectures with assignment support from teaching assistants.

Teaching support:
Exercise teachers will be available for assignment support.
Syllabus:
No compulsory textbook, but recommended learning support in Excel for økonomistudenter, Morten Helbæk, Børre Anton Olsen. Universitetsforlaget. Released 2019.
Prerequisites:
BUS133 - Excel for economists, or equivalent level
Recommended prerequisites:
BUS133 - Excel for economists, or equivalent level. Assumes a good understanding of basic Excel.
Assessment:
3 hour exam.
Nominal workload:
125 hours.
Entrance requirements:
Minimum requirements for entrance to higher education in Norway (generell studiekompetanse).
Reduction of credits:
5 ECTS overlap with BUS234F.
Type of course:

Teaching for three weeks; two double lessons two days a week.

Problem solving between the lectures with assignment support from practice teacher(s).

Examiner:
External examiner ensures the quality of the syllabus, exam assignments and principles for evaluation and answers.
Allowed examination aids: C3 All types of calculators, all other aids – including digital aids
Examination details: Written exam: Letter grades