ESF:MPM_EVBA Economic modeling - Course Information
MPM_EVBA Economic modeling in spreadsheet with VBA
Faculty of Economics and AdministrationAutumn 2016
- Extent and Intensity
- 0/2/0. 5 credit(s). Type of Completion: graded credit.
- Teacher(s)
- Ing. Pavel Lasák (seminar tutor)
- Guaranteed by
- doc. Mgr. Maria Králová, Ph.D.
Department of Applied Mathematics and Computer Science – Faculty of Economics and Administration
Contact Person: Lenka Hráčková
Supplier department: Department of Applied Mathematics and Computer Science – Faculty of Economics and Administration - Timetable of Seminar Groups
- MPM_EVBA/01: Mon 12:50–14:30 VT105, P. Lasák
MPM_EVBA/02: Tue 9:20–11:00 VT204, P. Lasák - Prerequisites
- It is assumed the students have nowledge of the Microsoft Excel Spreadsheet Program (BPM_EMTK Ekonomické modelování v tabulkovém kalkulátoru).
- Course Enrolment Limitations
- The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 60 student(s).
Current registration and enrolment status: enrolled: 0/60, only registered: 0/60, only registered with preference (fields directly associated with the programme): 0/60 - fields of study / plans the course is directly associated with
- there are 66 fields of study the course is directly associated with, display
- Course objectives
- It is assumed the students have nowledge of the Microsoft Excel Spreadsheet Program (BPM_EMTK Ekonomické modelování v tabulkovém kalkulátoru).
- Syllabus
- Seminars:
- 1. Basic concepts in MS Excel, harmonization of basic knowledge.
- 2. Introduction to VBA. Description windows. Recorder. Methods, events, collection.
- 3. Constants, VBA variables, loops, conditions ...
- 4. Work with cell, load, changes, modifications, format
- 4. Working with sheet (sheets), editing row, column ...
- 5. Work graph (chart).
- 6. Import/export data. Working with Files
- 7. UserForm and form elements. MsgBox, InputBox.
- 8. Function, insert functions
- 9. Work with sort, filters, pivot tables
- 10. Others, reaction to the buttons, dialogue boxes.
- 11. Creating automated dashboard. Printing.
- 12. Select the final project, consulting assignment.
- 13. Check the final project.
- Literature
- Všechny studijní materiály budou aktualizovány v ISu.
- Teaching methods (in Czech)
- Excel VBA - výukový kurz, Martin Král Programování ve VBA - Microsoft Office Excel 2007 - John Walkenbach
- Assessment methods
- The course is concluded by graded credit based on creating and defending a seminar work.
- Language of instruction
- Czech
- Further Comments
- Study Materials
The course is taught annually.
- Enrolment Statistics (Autumn 2016, recent)
- Permalink: https://is.muni.cz/course/econ/autumn2016/MPM_EVBA