S_BR_CA2_k Controlling applications II

STING ACADEMY
summer 2026
Extent and Intensity
0/0. 4 credit(s). Type of Completion: graded credit.
Teacher(s)
Ing. Libor Kegler (seminar tutor)
Guaranteed by
doc. Ing. Ondřej Žižlavský, Ph.D.
Centre for Accounting and Taxation – Academic Department – STING ACADEMY
Timetable of Seminar Groups
S_BR_CA2_k/01: Sat 11. 4. 14:40–17:50 BR Učebna 10, Sun 12. 4. 14:40–17:50 BR Učebna 10, Sat 16. 5. 8:45–11:55 BR Učebna 05, Sun 17. 5. 14:40–17:50 BR Učebna 03, L. Kegler
Course Enrolment Limitations
The course is offered to students of any study field.
Course objectives
The course is focused on the practical solution of specific economic tasks through the application of MS Excel. In particular, it presents MS Excel tools and functions used in reporting and controlling. Students apply the theoretical knowledge acquired in their previous studies within the chosen specialisation and are able to use computer technology to solve selected controlling tasks, including the interpretation of their informational significance.
Syllabus

Seminars:

  1. Data warehouse and structured data – working with large tables
  2. Data warehouse and structured data – pivot tables and data warehouse
  3. Data warehouse and structured data – reporting of the data model
  4. Automated reporting – MS Excel functions applicable in controlling and analyses
  5. Automated reporting – reporting of the data model
  6. Data models and data interface – creation of simple macros
  7. Data models and data interface – import and methods of structuring data for controlling analyses
  8. Financial data model – source data and their processing
  9. Financial data model – comprehensive example of a managerial income statement as a tool for controlling analyses
  10. Data models and their significance – household accounting data model
  11. Data models and their significance – implementation of the data model
  12. Credit test
Assessment methods

Full-time form of study:


Method of course completion – graded credit. Requirements for obtaining the graded credit: successful completion of the credit test during the semester and active participation in seminars.


Combined form of study:


The test required to obtain the graded credit is written. The test covers the content of all individual lectures within the course.

Language of instruction
Czech
Teacher's information
Povinná literatura
NAVARRŮ, M. Excel 2019: Podrobný průvodce uživatele. 1. vyd. Praha: Grada Publishing, 2019, 264 s. ISBN 978-80-247-2026-5.
SYNEK, M., KOPKÁNĚ, H., KUBÁLKOVÁ, M. Manažerské výpočty a ekonomická analýza. Praha: C.H. Beck, 2009. 301 s. ISBN 978-80-7400-154-3.
ZÁMEČNÍK, R. Základy controllingu. 2. přepracované vyd. Brno: Sting spol. s r.o., nakladatelství, 2022. 82 s. ISBN 978-80-87482-40-7.

Doporučená literatura
BROŽ, M. Microsoft Excel 2007 pro manažery a ekonomy. 1.vyd. Praha: CP Books, 2009. 435 s. ISBN 978-80-251-2116-0.
FIBÍROVÁ, J., ŠOLJAKOVÁ, L. Reporting. 3., rozš. a aktualiz. vyd. Praha: Grada, 2010, 221 s. ISBN 978-80-247-2759-2.
HAVLÍČEK K. Management & controlling: malé a střední firmy. 1. vyd. Praha: Vysoká škola finanční a správní, 2011, 210 s, ISBN: 978-80-7408-056-2.
CHODASOVÁ, Z. Podnikový controlling: nástroj manažmentu. Bratislava: Statis, 2012, 161 s. Ekonomika firmy. ISBN 978-80-85659-70-2.
KISLINGEROVÁ, Eva a kol.: Manažerské finance. 3. přepracované a rozšířené vydání. Praha, Nakladatelství C. H. Beck 2010. 864 stran. ISBN:978-80-7400-194-9
PONIŠČIAKOVÁ, Oľga a Martina GOGOLOVÁ. Podnikový controlling. Žilina: Žilinská univerzita v Žiline, 2017, 219 s. ISBN 9788055413204.
SYNEK, M. Manažerská ekonomika. 5. vyd. Praha: Grada Publishing, 2011. 471 s. ISBN: 978-80-247-3494-1.
  • Enrolment Statistics (recent)
  • Permalink: https://is.newton.cz/course/sting/summer2026/S_BR_CA2_k