2579-V

2579-V Advanced Course in Excel and VBA, 8 cr

Place: 
Vaasa
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

Assessment: 

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

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

Open University Quota: 3
JOO students Quota: 3