The course introduces the statistical features of Excel and the VBA programming language.
Contents
The topics to be discussed: 1) database functions of Excel, 2) Data/Table and Data/PivotTable commands in Excel, 3) Excel objects in VBA, 4) conditional statements and loops in VBA, 5) custom forms, 6) matrix language in VBA.
Teaching language
Finnish
Modes of study
At least 50% of the weekly exercices and an assignment.
Evaluation
Numeric 1-5.
Recommended year of study
2. year autumn
2. year spring
3. year autumn
3. year spring
Study materials
Hansen, S. M., Mastering Excel 2003 programming with VBA. Sybex 2004.