This course is aimed to provide the students with proper tools and knowledge to handle various types of data while struggling with their homework or theses, which is done on a commonly available platform of MS Excel.
After a general short repetition (depending on the current knowledge of the attendants) of basic excel features and functions we torn to more sophisticated data analysis, searching tools, filtering and advanced formatting. Should there be any specific needs resulting from the other courses’ tasks, this course will definitely address them. In a nutshell, the course should serve to strengthen and deepen the knowledge of MSExcel which should help the students to make their work on projects quicker and more efficient as well as enhance their position in possible job interviews with a useful skill.
Last update: Bednařík Petr, PhDr., Ph.D. (15.02.2020)
Aim of the course -
This course is aimed to provide the students with proper tools and knowledge to handle various types of data while struggling with their homework or theses, which is done on a commonly available platform of MS Excel.
After a general short repetition (depending on the current knowledge of the attendants) of basic excel features and functions we torn to more sophisticated data analysis, searching tools, filtering and advanced formatting. Should there be any specific needs resulting from the other courses’ tasks, this course will definitely address them. In a nutshell, the course should serve to strengthen and deepen the knowledge of MSExcel which should help the students to make their work on projects quicker and more efficient as well as enhance their position in possible job interviews with a useful skill.
Last update: Polák Petr, Mgr., M.Sc., Ph.D. (17.02.2026)
This course is aimed to provide the students with proper tools and knowledge to handle various types of data while struggling with their homework or theses, which is done on a commonly available platform of MS Excel. After a general short repetition (depending on the current knowledge of the attendants) of basic excel features and functions we torn to more sophisticated data analysis, searching tools, filtering and advanced formatting. Should there be any specific needs resulting from the other courses’ tasks, this course will definitely address them. In a nutshell, the course should serve to strengthen and deepen the knowledge of MSExcel which should help the students to make their work on projects quicker and more efficient as well as enhance their position in possible job interviews with a useful skill.
Students can bring their own notebook to the exam. However, if any technical issue concerning their notebooks should prevent them from sitting for the exam, they will be asked to use the computers in the lab. Students can use MS Office help (offline and online), own notes, google, etc. But any form of external communication or help provided by someone else is not allowed. Also using other excel files is not permitted. Students have to register via SIS for the exam.
Use of AI:
Students are permitted to used generative and other AI tools under the condition, that they are used as a search engine - thus no file or screenshot is uploaded.
Grading:
Test (60% weight). graded on scale 0-100 points. Project (35% weight), graded on scale 0-35 points. Homework (5% weigth), graded on scale 0-5 points. Overall score is therefore 0.6 * Test + Homework + Project => between 0 and 100 points.
A: 90+ to 100 B: 80+ to 90 C: 70+ to 80 D: 60+ to 70 E: 50+ to 60 F: 50 or less
Last update: Polák Petr, Mgr., M.Sc., Ph.D. (16.12.2025)
Students can bring their own notebook to the exam. However, if any technical issue concerning their notebooks should prevent them from sitting for the exam, they will be asked to use the computers in the lab. Students can use MS Office help (offline and online), own notes, google, etc. But any form of external communication or help provided by someone else is not allowed. Usage of other excel files is not permitted. Students have to register via SIS for the exam.
Use of AI:
Students are permitted to used generative and other AI tools under the condition, that they are used as a search engine - thus no file or screenshot is uploaded.
Grading:
Test (60% weight). graded on scale 0-100 points. Project (35% weight), graded on scale 0-35 points. Homework (5% weigth), graded on scale 0-5 points. Overall score is therefore 0.6 * Test + Homework + Project => between 0 and 100 points.
A: 90+ to 100 B: 80+ to 90 C: 70+ to 80 D: 60+ to 70 E: 50+ to 60 F: 50 or less
Last update: Polák Petr, Mgr., M.Sc., Ph.D. (16.12.2025)
Syllabus -
Description: This course is aimed to provide the students with proper tools and knowledge to handle various types of data while struggling with their homework or theses, which is done on a commonly available platform of MS Excel. After a general short repetition (depending on the current knowledge of the attendants) of basic excel features and functions we torn to more sophisticated data analysis, searching tools, filtering and advanced formatting. Should there be any specific needs resulting from the other courses’ tasks, this course will definitely address them. In a nutshell, the course should serve to strengthen and deepen the knowledge of MSExcel which should help the students to make their work on projects quicker and more efficient as well as enhance their position in possible job interviews with a useful skill.
Content:
Introduction to excel, logical functions Mathematical functions Lookup and reference functions Information/Error functions Text functions Date and time functions Conditional formating Sorting, Filters, Pivot table Pivot table, Goalseek Charts Introduction to Macros
(project preparation)
Literature: Any handbook will do. No book is required.
Last update: Polák Petr, Mgr., M.Sc., Ph.D. (19.03.2020)
Content:
Introduction to excel, logical functions Mathematical functions Lookup and reference functions Information/Error functions Text functions Date and time functions Conditional formating Sorting, Filters, Pivot table Pivot table, Goalseek Charts Introduction to Macros
Last update: Hollmannová Monika, Ing. (29.10.2019)
