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.
The course can be taken by students both from Helsinki and Vaasa.
Learn Excel from the beginning and become a good user of the most prominent features of the program. The course is based on twelve hands on exercises.
On the course, the students work with inserting and modifying data, sorting and filtering, functions and formula definition. Further special issues like Mail Merge, Pivot Tables, Macros, Scenarios and importing a processing data from Access are in the course. All the examples are business oriented which gives the students a realistic view of business related working tasks.
The course is a digital web course with no teaching in class. The exercises are written so one ought to be able to do them without the support of a teacher.