MPM_EVBA Economic modeling in spreadsheet with VBA

Faculty of Economics and Administration
Spring 2017
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 11:05–12:45 VT203, 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 25 student(s).
Current registration and enrolment status: enrolled: 0/25, only registered: 0/25, only registered with preference (fields directly associated with the programme): 0/25
fields of study / plans the course is directly associated with
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.
The course is also listed under the following terms Autumn 2016, Autumn 2017, Spring 2018, Autumn 2018, Spring 2019, Autumn 2019, Spring 2020, Autumn 2020, Spring 2021, Autumn 2021, Spring 2022, Autumn 2022, Spring 2023, Autumn 2023, Spring 2024, Autumn 2024, Spring 2025.
  • Enrolment Statistics (Spring 2017, recent)
  • Permalink: https://is.muni.cz/course/econ/spring2017/MPM_EVBA