Spreadsheet calculators 2

Lecturer:

Tutor:

Supervisor:

Department of Construction Management and Economics

Synopsis:

The course deals with macro programming in spreadsheet calculator Excel. A presumption is a good knowledge of operating spreadsheets fundaments. Editor VBA, procedures, variables and data types, control structures, cycles, string operations, user forms, programme debugging will be detailed examined.

Requirements:

no prerequisites

Syllabus of lectures:

1.Inrtoduction to VBA

3.Variables, constants and daty types

5.Control strctures

7.Cycles and statement numbers

9.Objects and set of objects

11.Properties and methodts

12.Debugging

Syllabus of tutorials:

2.First macro

4.Dynamic fields

6.Decision structures

8.Elements Range and Cells

10.User forms

12.String operations

14.Data import and xport

Study Objective:

Get ability for programming in spreadsheet calculator Excel.

Study materials:

Help for Excel

Help for Visual Basic

Web pages

Note:

Time-table for winter semester 2011/2012:

Time-table is not available yet

Time-table for summer semester 2011/2012:

Time-table is not available yet

The course is a part of the following study plans: