BUS133 Excel for Business
There may be changes to the course due to to corona restrictions. See Canvas and StudentWeb for info.
Showing course contents for the educational year 2020 - 2021 .
Course responsible: Stig Aleksander Aune
Teachers: Øystein Dahl
ECTS credits: 5
Faculty: School of Economics and Business
Teaching language: NO
Teaching exam periods:
This course starts in Autumn parallel. This course has teaching/evaluation in Autumn parallel.
Course frequency: Annually
First time: 2007V
The course gives a basic introduction to Microsoft Excel, an essential computer tool used in business. An important objective of the course is that the students can use Excel in other courses.
Demonstrations and practical exercises in the use of formulas and functions and data tables. Presentation of models using formatting and graphics. Analysis and management of data, including external data, filtering and use of pivot tables.
Demonstrations and practical exercises in making simple financial models. To the extent possible models used will deal with relevant aspects from the first autumn parallel.
The candidate has:
- knowledge about the different components of Excel
The candidate can:
- use the help tool in Excel
- create, save and open Excel work books
- input data into cells
- format cells
- create formulas and use Excel functions
- copy data and formulas
- create graphs and charts in various formats based on numerical data
- make simple financial models
- sort and filtering data
- import data from external sources
- make PivotTables
The candidate can:
- develop efficient and structured models in Excel
- work fast with Excel
Digital lectures: Demonstration of Excel. Exercises in the computer lab and/or digitally.
Excel for økonomistudenter, Morten Helbæk, Børre Anton Olsen. 2019 Universitetsforlaget.
One compulsory assignment. This must be approved to sit the exam. It is valid for two years.
Final written home exam: 100 % of total grade. Duration 3h.
Minimum requirements for entrance to higher education in Norway (generell studiekompetanse)
Type of course:
Lectures: 2 hours per week. Excercises: 2 hours per week. Total: Approximately 52 hours.
External examiner will control the quality of syllabus, questions for the final examination, and principles for the assessment of the examination answers.
Allowed examination aids: C3 Alle typer kalkulatorer, alle andre hjelpemidler - inkludert digitale
Examination details: One written exam: A - E / F