Aim of this course

The course deals with programming in software packages Microsoft Office. The features of the programming language Visual Basic for Application (VBA) in spreadsheets on the basis of Excel are studied thoroughly. The course has an applied trend.

Books

Estonian

English

What we do?

Introduction

• Create a Macro http://www.excel-vba-easy.com/vba-how-to-create-macro-excel.html

Recording and executing macros

• Excel Macro Recorder http://www.excel-vba-easy.com/vba-how-to-excel-macro-recorder.html

VBA language

Simple VBA programming

Variables in VBA

Conditional branching in VBA

Looping through code

Building procedures and functions

Building User Interfaces