BUS133F Excel – From Data to Information - Online Version

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.

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

• structuring 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