MPM_EVBA Automatic processing of big data in Excel

Faculty of Economics and Administration
Autumn 2024
Extent and Intensity
0/2/0. 5 credit(s). Type of Completion: zk (examination).
In-person direct teaching
Teacher(s)
Ing. Pavel Lasák (seminar tutor)
Guaranteed by
Ing. Pavel Lasák
Division of Applied Mathematics and Computer Science – Faculty of Economics and Administration
Contact Person: Lenka Hráčková
Supplier department: Division of Applied Mathematics and Computer Science – Faculty of Economics and Administration
Timetable of Seminar Groups
MPM_EVBA/01: Mon 14:00–15:50 VT202, except Mon 16. 9., except Mon 4. 11., 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: 20/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
After graduation, the student is able to work in Excel whith VBA: - read, edit, and visualize data - working whith pivot tables - create forms - impotr/export 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.
  • Check the final project.
Literature
    required literature
  • Všechny studijní materiály budou aktualizovány v ISu.
    recommended literature
  • KRÁL, Martin. Excel VBA : výukový kurz. Vyd. 1. Brno: Computer Press, 2010, 504 s. ISBN 9788025123584. info
    not specified
  • LAURENČÍK, Marek and Michal BUREŠ. Programování v Excelu 2019 : záznam, úprava a programování maker. První vydání. Praha: Grada Publishing, 2021, 240 stran. ISBN 9788027131457. URL info
Teaching methods
Practical work with workbooks, solving real problems. Book in Czech language Excel VBA - výukový kurz, Martin Král Programování ve VBA - Microsoft Office Excel 2007 - John Walkenbach In EN find problem google.com
Assessment methods
The course is completed by an examination based on the creation and defense of a seminar paper.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
Teacher's information
http://www.JakNaExcel.cz
The course is also listed under the following terms Autumn 2016, Spring 2017, 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, Spring 2025.
  • Enrolment Statistics (Autumn 2024, recent)
  • Permalink: https://is.muni.cz/course/econ/autumn2024/MPM_EVBA