Olet täällä

Advanced Financial Excel and VBA

Advanced Financial Excel and VBA

Code: TOO2LK002E
Extent: 3 op
Timing: 3. Semester
Language: Finnish / English
Level: Professional studies
Type: Compulsory

Prerequisites

Financial Modeling using Excel (TOO2LK001)
Basic Excel skills is a must to be able to partisipate to the course.

Learning outcomes

Student knows the Excel and VBA (Visual Basic for Application) from the financial perspective and is able to use them efficiently. Using the VBA you are able to simplify and automate the calculation processes of Excel.

Contents

Course is as practical as possible and will have many different exercises. During the course we will go through the basic VBA structures, like:

  • If sentence
  • Loop structures
  • Modules
  • Forms
  • Variabel and their visibility
  • Subs and Functions

Due to the practical nature of the course a student must actively participate and do all the home exercises to be able to pass the exam at the end of the course.

Course materials

Lecture notes and other materials given by a teacher. Any basic-level Excel’s VBA book is an asset.

Contact teachers

Christian Brade

Teaching and learning methods

Contact lessons, seft-study and exam.
The own learning assessment 1 hour.

Accreditation of prior learning (APL)

Accreditation of prior learning (APL) is observed on the course according to separate instructions.

Assessment criteria

Students' performance is graded on the following scale: Excellent (5), Very good (4), Good (3), Satisfactory (2), Fair (1), Fail (0). The assessment criterias are presented on scale 1 to 5.

Grade/
Object

1 (min. 40 %
of the objective)

3 (min. 70 %
of the objective)

5 (min. 90 %
of the objective)

Knowledge

Understands the basic concepts and principles of financial Excel and VBA.

Understands the concepts and principles of financial Excel and VBA.

Understands well the concepts and principles of financial Excel and VBA.

Skills

Is able to do some basic financial tasks using Excel and VBA.

Is able to do the basic financial tasks using Excel and VBA.

Is able to do many different financial tasks using Excel and VBA.

Competence

Acts well with Excel and VBA if gets some help.

Acts well with Excel and VBA without help.

Acts well and efficiently with Excel and VBA.

Assessment components and their respective weights

Examination 100 %
The assessment of one's own learning assignment does not impact your grade. The assignment is the same for all courses/modules and your answers will be used also for course/module development. The assignment is completed on an electronic form.