Creation of Scripts and Macros for Economic Tasks

Garant předmětu:

Lecturer:

Tutor:

Supervisor:

Department of Applied Informatics in Transportation

Synopsis:

Fundamentals of VBA, functions and procedures, examples of their use. Forms and offers for user oriented applications, cooperation with other applications, solution to compatibility problems among different spreadsheet programs versions. Everything with the respect to economic tasks.

Requirements:

algorithmization, fundamentals of programming, spreadsheets programs fundamentals

Syllabus of lectures:

Syllabus of tutorials:

Study Objective:

Acquisition of knowledge in the following fields: use of programming function in spreadsheet programs for data processing, interpretation, and presentation by the means of VBA with the respect to economic practise.

Study materials:

Jurák Z. a koletiv: Excel pro managment, ekonomy a podnikatele, Computer Media, 2006

Breden M., Schwimmer M.: Excel 2007 VBA Velká kniha řešení, Computer Press, 2009

Note:

Further information:

No time-table has been prepared for this course

The course is a part of the following study plans: