x !
Archived Curricula Guide 2008–2010
Curricula Guide is archieved. Please refer to current Curricula Guides
TILTA31 Excel Programming (VBA) 8 ECTS
Organised by
Statistics
Preceding studies
Statistics until regression and variance analysis, knowledge of the basics of Excel and programming.

Learning outcomes

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.

Belongs to following study modules

Department of Mathematics and Statistics
Intermediate Studies in Statistics (Statistics)
2009–2010
Teaching
Archived Teaching Schedule. Please refer to current Teaching Shedule.
Period I Period II Period III Period IV
TILTA31 Excel-ohjelmointi (VBA)
Department of Mathematics and Statistics