|
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
- 26 hours per semester
- Home preparation for classes
- 13 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
|
-
KOLOKOLOV, Alex. Make your data speak: creating actionable data through Excel for non-technical professionals. New York. 2022.
-
KUSLEIKA, Dick. Data visualization with Excel dashboards and reports. Indianapolis. 2021.
-
MURRAY, Alan. Advanced Excel success: a practical guide to mastering Excel. New York. 2021.
-
Salkind, N. J. Excel statistics: a quick guide. Los Angeles: SAGE, 2016. ISBN 978-1-4833-7404-8.
-
SKINNER, Henry. Excel: The Absolute Beginner's Guide to Maximizing Your Excel Experience for Maximum Productivity and Efficiency With all Formulas & Functions and Practical Examples. 2022.
-
WINSTON, Wayne L. Microsoft Excel data analysis and business modeling: (Office 2021 and Microsoft 365). 7th edition. New York, NY. 2022.
|