Advanced applications in MS Excel

Advanced applications in MS Excel
545-0176/01
čeština Advanced applications in MS Excel
545-0176/02
angličtina

Summary

The course develops and deepens basic knowledge and skills about the environment of the MS Excel spreadsheet calculator. The subject focuses on advanced MS Excel features and techniques, including basic macro programming. The student will be able to apply the acquired theoretical knowledge in solving practical technical and economic tasks from the environment of the mining company.

Literature

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

Advised literature

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. .
PERSON, Ron. Balanced Scorecards and operational dashboards with Microsoft Excel. Indianapolis: Wiley, c2009. ISBN 978-0-470-38681-1.

back to search page

Language of instruction	čeština, angličtina
Code	545-0176
Abbreviation	PAMSE
Course title	Advanced applications in MS Excel
Coordinating department	Department of Economics and Control Systems
Course coordinator	Ing. Igor Černý, Ph.D.