BUS133 Excel – From Data to Information
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 student has
• knowledge of the structure of Microsoft Excel
• Knowledge of the functionality needed to build financial models
• knowledge of the various components of Excel
• knowledge of techniques for turning data into information
Skills
The student is able to:
• Set up master data for use in a model - register, paste and import data
• Structure basic data - adapting formats, quality assuring, adjusting and using names
• Analyze data - four types of calculations, simple statistics, sort
• Present data - formatting, customizing, and creating graphs
• Use Excel's built-in table feature
• Create pivot tables
General competency:
The student is able to:
• develop efficient and structured Excel models
• handle a process for transforming data to information - e.g. raw data to a graph
• work efficiently with Excel
Learning activities
Assessment method
Examiner scheme
Mandatory activity
Teaching hours
Reduction of credits
Admission requirements