MPM_EVBA Economic modeling in spreadsheet with VBA

Faculty of Economics and Administration
Spring 2019
Extent and Intensity
0/2/0. 5 credit(s). Type of Completion: zk (examination).
Teacher(s)
Ing. Pavel Lasák (seminar tutor)
Guaranteed by
Ing. Pavel Lasák
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 10:00–11:50 VT202, 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 24 student(s).
Current registration and enrolment status: enrolled: 0/24, only registered: 0/24, only registered with preference (fields directly associated with the programme): 0/24
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).
Learning outcomes
Working with Excel VBA. - read data - format data - create charts - sort data
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
    required literature
  • Všechny studijní materiály budou aktualizovány v ISu.
Teaching methods
google.com
Assessment methods
The course is concluded by classified 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, Spring 2017, Autumn 2017, Spring 2018, Autumn 2018, 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 2019, recent)
  • Permalink: https://is.muni.cz/course/econ/spring2019/MPM_EVBA