Skip to main content
Skip header
Close

Searching

Advanced applications in MS Excel

Type of study Follow-up Master
Language of instruction Czech
Code 545-0176/01
Abbreviation PAMSE
Course title Advanced applications in MS Excel
Credits 4
Coordinating department Department of Economics and Control Systems
Course coordinator Ing. Igor Černý, Ph.D.

Osnova předmětu

1. MS Excel environment
2. Advanced formatting and editing techniques
3. Formula creation and data analysis
4. Advanced techniques of data processing
5. Database and list management
6. Analyzing data using PivotTables
7. Using macros
8. Collaboration in MS Excel
9. MS Excel application in benchmarking
10.MS Excel application in inventory management
11.MS Excel applications in project management
12.MS Excel applications in economic modeling
13.MS Excel applications in statistical applications

E-learning

For communication beyond the framework of in-person training camps, the Moodle learning management system (lms.vsb.cz) is used, through which communication is enabled not only between the teacher and students, but also between students.

Povinná literatura

ALEXANDER, Michael a Dick KUSLEIKA. Excel 2016 Power Programming with VBA. Indianapolis, IN: Wiley. Mr. Spreadsheet's bookshelf. ISBN 9781119415503 .
DECOURSEY, William,James. Statistics and probability for engineering applications: with Microsoft Excel. Amsterdam: Elsevier, 2007. ISBN 978-0-7506-7618-2 .
HÄCKER, Joachim a Dietmar ERNST. Financial modeling: an introductory guide to Excel and VBA applications in finance. London: Palgrave Macmillan. Global financial markets. ISBN 9781137426581 .
MAYES, Timothy R. Financial analysis with Microsoft Excel 2019. 9th edition. Boston: Cengage. ISBN 978-0357-44205-0.

Doporučená literatura

ANDERSON, David Ray, Dennis J. SWEENEY a Thomas Arthur WILLIAMS. Modern business statistics with Microsoft Office Excel. 4th ed. Mason: South-Western Cengage Learning. ISBN 978-0-538-47976-9.
BENNINGA, Simon. Principles of finance with Excel. 2nd ed. New York: Oxford University Press. ISBN 978-0-19-975547-9.
FAIRHURST, Danielle Stein. Using Excel for business and financial modelling: a practical guide. Third edition. Chichester, United Kingdom: Wiley. Wiley finance series. ISBN 9781119520375 .
PERSON, Ron. Balanced Scorecards and operational dashboards with Microsoft Excel. Indianapolis: Wiley, c2009. ISBN 978-0-470-38681-1.


zpět na vyhledávání