545-0176/01 – Advanced applications in MS Excel (PAMSE)

Gurantor departmentDepartment of Economics and Control SystemsCredits4
Subject guarantorIng. Igor Černý, Ph.D.Subject version guarantorIng. Igor Černý, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Study languageCzech
Year of introduction2020/2021Year of cancellation
Intended for the facultiesHGFIntended for study typesFollow-up Master
Instruction secured by
LoginNameTuitorTeacher giving lectures
CER25 Ing. Igor Černý, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Graded credit 1+2
Part-time Graded credit 4+8

Subject aims expressed by acquired skills and competences

The aim of the course is to be able to explain the advanced functions and techniques of MS Excel and to be able to apply this knowledge in solving practical technical and economic tasks from the mining company environment.

Teaching methods

Project work


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.

Compulsory literature:

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.

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

Way of continuous check of knowledge in the course of semester

Regular feedback on the progress of knowledge during the current term is provided by the tests.


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.

Other requirements

No next requirements


Subject has no prerequisities.


Subject has no co-requisities.

Subject syllabus:

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.Examining the weights of economic indicators in MS Excel 14.MS Excel applications in statistical applications

Conditions for subject completion

Part-time form (validity from: 2022/2023 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Graded credit Graded credit 100 (100) 51 3
        Zápočtové testy Other task type 100  51 1
Mandatory attendence participation: 80% attendance

Show history

Conditions for subject completion and attendance at the exercises within ISP:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2022/2023 (N0724A290011) Mineral Economics P Czech Ostrava 1 Compulsory study plan
2022/2023 (N0724A290011) Mineral Economics K Czech Most 1 Compulsory study plan
2022/2023 (N0724A290011) Mineral Economics K Czech Ostrava 1 Compulsory study plan
2021/2022 (N0724A290011) Mineral Economics P Czech Ostrava 1 Compulsory study plan
2021/2022 (N0724A290011) Mineral Economics K Czech Most 1 Compulsory study plan
2021/2022 (N0724A290011) Mineral Economics K Czech Ostrava 1 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner