Economic Analyses in Spreadsheets Programs Environment

Garant předmětu:

Lecturer:

Tutor:

Supervisor:

Department of Applied Informatics in Transportation

Synopsis:

Work with spreadsheet programs with the respect to economic problems, use of nested functions and conditional formatting, statistic and mathematic functions. Creation of graphs and other graphic outputs. Data analysis, lists and contingent tables.

Requirements:

tasks algorithmizing, fundamentals of programming, spreadsheet programs fundamentals

Syllabus of lectures:

Syllabus of tutorials:

Study Objective:

Acquisition of knowledge in the following fields: effective use of spreadsheet programs - data procession, interpretation, and presentation with the respect to their use in economic practice. Creation of advanced economic analyses.

Study materials:

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

Bříza V.: Excel 2007 - podrobný průvodce, Grada, 2007

Note:

Further information:

No time-table has been prepared for this course

The course is a part of the following study plans: