|
Lecturer(s)
|
-
Urbánek Tomáš, Ing. Ph.D.
-
Kunčar Aleš, Ing.
|
|
Course content
|
- Introduction to MS Excel and basics of working with workbooks - Formatting data and cells - Sorting data (simple and multi-level) - Filtering data (automatic and advanced filter) - Using slicers - Data import and transformation (Power Query Editor) - Basic MS Excel formulas and functions - Advanced MS Excel functions - PivotTables - PivotCharts and standard charts - Data analysis and presentation - Dashboard creation
|
|
Learning activities and teaching methods
|
Exercises on PC, Practice exercises
- Participation in classes
- 10 hours per semester
- Home preparation for classes
- 29 hours per semester
- Preparation for course credit
- 36 hours per semester
|
| prerequisite |
|---|
| Knowledge |
|---|
| Prerequisities are not set |
| Prerequisities are not set |
| Skills |
|---|
| Prerequisities are not set |
| Prerequisities are not set |
| learning outcomes |
|---|
| Knowledge |
|---|
| defines the fundamental concepts and principles of computer data processing |
| defines the fundamental concepts and principles of computer data processing |
| describes data structures and the principles of proper data preparation for analysis |
| describes data structures and the principles of proper data preparation for analysis |
| explains the principles of data import and transformation using the Power Query Editor |
| explains the principles of data import and transformation using the Power Query Editor |
| explains the purpose and logic of selected functions |
| explains the purpose and logic of selected functions |
| characterizes the principles of data visualization and dashboard creation for a clear presentation of analytical outputs |
| characterizes the principles of data visualization and dashboard creation for a clear presentation of analytical outputs |
| Skills |
|---|
| apply MS Excel as a tool for processing and analyzing economic data |
| apply MS Excel as a tool for processing and analyzing economic data |
| import and transform data from various sources using the Power Query Editor |
| import and transform data from various sources using the Power Query Editor |
| structure, sort, and filter datasets according to specified criteria |
| structure, sort, and filter datasets according to specified criteria |
| analyze data using selected functions |
| analyze data using selected functions |
| design and implement clear data visualizations using appropriate charts |
| design and implement clear data visualizations using appropriate charts |
| create functional and intuitive dashboards to support decision-making in economic practice |
| create functional and intuitive dashboards to support decision-making in economic practice |
| solve model economic problems using MS Excel spreadsheet software |
| solve model economic problems using MS Excel spreadsheet software |
| teaching methods |
|---|
| Knowledge |
|---|
| Practice exercises |
| Exercises on PC |
| Exercises on PC |
| Practice exercises |
| Skills |
|---|
| Exercises on PC |
| Exercises on PC |
| Practice exercises |
| Practice exercises |
| assessment methods |
|---|
| Knowledge |
|---|
| Analysis of the student's performance |
| Grade (Using a grade system) |
| Grade (Using a grade system) |
| Analysis of the student's performance |
|
Recommended literature
|
-
Barilla. J., Simr, P., Sýkorová, K. Microsoft Excel 2016: podrobná uživatelská příručka. Brno: Computer Press, 2016. ISBN 978-80-251-4838-9.
-
Laurenčík, M. Excel - pokročilé nástroje: funkce, makra, databáze, kontingenční tabulky, prezentace, příklady. Praha: Grada, 2016. ISBN 978-80-247-5570-0.
-
Laurenčík, M. Excel 2016: práce s databázemi a kontingenčními tabulkami. Praha: Grada, 2017. ISBN 978-80-271-0477-2.
-
NAVARRŮ, Miroslav. Excel 2019: podrobný průvodce uživatele. http://www.grada.cz/excel2019. Praha: Grada Publishing, 2019. ISBN 978-80-247-2026-5.
-
WINSTON, Wayne L. Microsoft Excel data analysis and business modeling: (Office 2021 and Microsoft 365). 7th edition. New York, NY. 2022.
|