BUS133 Excel for Business

Credits (ECTS):5

Course responsible:Øystein Dahl

Campus / Online:Taught campus Ås

Teaching language:Norsk

Course frequency:Annually

Nominal workload:125 hours.

Teaching and exam period:This course starts in Autumn parallel. This course has teaching/evaluation in Autumn parallel.

About this course

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.

Learning outcome

Knowledge:

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 filter data
  • handle data from external sources
  • use excels internal table functionality
  • make PivotTables

Skills:

The candidate can:

  • develop efficient and structured models in Excel
  • work fast with Excel
  • Live lectures at school. Demonstration of Excel.

    Exercises in the computer lab with teaching assistances.

  • Final exam (on Campus) entirely done in Excel: 100 % of total grade. Duration 3 hours.
  • External examiner will control the quality of syllabus, questions for the final examination, and principles for the assessment of the examination answers.
  • No compulsory assignments.
  • Lectures: 2 hours per week. Excercises: 2 hours per week. Total: Approximately 52 hours.
  • 5 ECTS overlap with BUS133F and BUS134-B.
  • Letter grades
  • Minimum requirements for entrance to higher education in Norway (generell studiekompetanse)