Spreadsheet calculators are an important tool, especially for students and graduates in Software engineering in economics.
The winter semester introduces the students also into other office tools. The accent is put on advanced functions of MS Excel
(names, functions and expressions, pivot table and graph). Next, the VBA language will be introduced and macros and user functions
will be addressed.

Requirements:

Syllabus of lectures:

1.Introduction into office applications

2.Word processors: basic functionalities

3.Text processors: advanced typographic topics

4.Presentations: introduction, fundamentals

5.Presentations: advanced techniques

6.Introduction into spreadsheets

7.Charts, pivot table, pivot chart

8.Functions: mathematical and logical

9.Functions: reference and database

10.Functions: text and date

11.VBA programming: macros, introduction

12.VBA programming: user functions

13.VBA programming: events

14.VBA programming: work with the spreadsheet.

Syllabus of tutorials:

1.Introduction into office applications

2.Word processors: basic functionalities

3.Text processors: advanced typographic topics

4.Presentations: introduction, fundamentals

5.Presentations: advanced techniques

6.Introduction into spreadsheets

7.Charts, pivot table, pivot chart

8.Functions: mathematical and logical

9.Functions: reference and database

10.Functions: text and date

11.VBA programming: macros, introduction

12.VBA programming: user functions

13.VBA programming: events

14.VBA programming: work with the spreadsheet.

Study Objective:

To introduce the students to MS Office, especiallz to MS Excel in the relation to their study program. The students shall
learn about VBA and be able to use it (macros, functions, forms).