Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2019/2020

Creation of Scripts and Macros for Economic Tasks

The course is not on the list Without time-table
Code Completion Credits Range Language
14TEU KZ 2 0+2 Czech
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:
Data valid to 2019-12-16
For updated information see http://bilakniha.cvut.cz/en/predmet1467906.html