545-0176/01 – Advanced applications in MS Excel (PAMSE)
Gurantor department | Department of Economics and Control Systems | Credits | 4 |
Subject guarantor | Ing. Igor Černý, Ph.D. | Subject version guarantor | Ing. Igor Černý, Ph.D. |
Study level | undergraduate or graduate | Requirement | Compulsory |
Year | 1 | Semester | winter |
| | Study language | Czech |
Year of introduction | 2020/2021 | Year of cancellation | |
Intended for the faculties | HGF | Intended for study types | Follow-up Master |
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
Lectures
Tutorials
Project work
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.
Compulsory literature:
Recommended literature:
Additional study materials
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.
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.
Other requirements
No next requirements
Prerequisities
Subject has no prerequisities.
Co-requisities
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.MS Excel applications in statistical applications
Conditions for subject completion
Conditions for completion are defined only for particular subject version and form of study
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction