2579

2579 Advanced Course in Excel and VBA, 8 cr

Place: 
Helsinki
Type: 
Intermediate studies
Kind: 
Course
Teaching language: 
English
Course Description: 

The aim of the course is to teach advanced Excel with the Solver and Goal Seek. The course also addresses Visual Basic for Applications. The aim is that students after the course have excellent knowledge of Excel and good knowledge of VBA. The VBA part deals with functions, procedures, controls, events, tables, loops, forms, splash screens, wizards and much more.

Learning Goal: 

You have a good knowledge of Excel. You have the practical ability and logical thinking that is required to develop advanced Excel macros.

After completing the course, you will be able to: 

• use Excel's more advanced features such as Solver
• use the object-oriented programming language Visual Basic for Applications (VBA)
• apply basic programming techniques such as loops, tables, conditional statements, etc..

Pre-requisites: 

Completed course 2577 Basic Course in Excel.

Total Student Workload: 

214 hours divided into
Scheduled (contact) hours: 0 h
Non-scheduled work: 214 h

Instruction: 

The course is a digital course on the web.

Literature and Course Material: 
  • The course material with theory and exercises will be on Moodle
  • Alexander, M. (2016). Excel 2016 Power Programming with VBA. Indianapolis: John Wiley & Sons. (Supplementary reading).

 

Assessment: 

Exam in the e-exam system and an extensive examination work.

Equivalent Courses: 

Students who have taken the earlier Swedish course Avancerad Excel och VBA (8 credits, course code 2556-V) cannot take this course.

Non-degree studies (Open University, JOO and Contract Studies): 

Open University Quota: 3
JOO students Quota: 3