WINSTON, Wayne. Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365). San Francisco, Microsoft Press, 2021. ISBN 978-0137613663 .
ALEXANDER, Michael and KUSLEIKA, Dick. Microsoft Excel 365 Bible. Indianapolis, John Wiley & Sons, 2022. ISBN 978-1119835103 .
DECKLER, Greg and POWELL, Brett. Mastering Microsoft Power BI - Second Edition: Expert techniques to create interactive insights for effective data analytics and business intelligence. Birmingham, Packt Publishing, 2022. ISBN 978-1801811484.
Terminated in academic year 2024/2025
Data processing on PC
| Type of study | Bachelor |
|---|---|
| Language of instruction | English |
| Code | 155-1553/01 |
| Abbreviation | ZDEng |
| Course title | Data processing on PC |
| Credits | 4 |
| Coordinating department | Department of Applied Informatics |
| Course coordinator | Ing. Vítězslav Novák, Ph.D. |
Subject syllabus
Lectures:
1) Addressing in Excel
2) Excel Statistical Functions
3) Excel Other Functions
4) Formatting in Excel
5) Charts in Excel
6) Lists in Excel
7) Structured Tables in Excel
8) Pivot Tables and Charts
9) Using of Power Pivot and Power Query
10) Comparison of Excel and Access
1) Addressing in Excel
2) Excel Statistical Functions
3) Excel Other Functions
4) Formatting in Excel
5) Charts in Excel
6) Lists in Excel
7) Structured Tables in Excel
8) Pivot Tables and Charts
9) Using of Power Pivot and Power Query
10) Comparison of Excel and Access
Literature
Advised literature
FERRARI, Alberto and Marco RUSSO. Analyzing Data with Microsoft Power BI and Power Pivot for Excel. Redmond, Washington: Microsoft Press, 2017. ISBN 978-1-5093-0276-5.
RUSSO, Marco and Alberto FERRARI. The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition. Redmond, Washington: Microsoft Press, 2019. ISBN 978-1509306978 .
DECKLER, Greg. Learn Power BI - Second Edition: A comprehensive, step-by-step guide for beginners to learn real-world business intelligence. Birmingham, Packt Publishing, 2022. ISBN 978-1801811958 .
RUSSO, Marco and Alberto FERRARI. The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition. Redmond, Washington: Microsoft Press, 2019. ISBN 978-1509306978 .
DECKLER, Greg. Learn Power BI - Second Edition: A comprehensive, step-by-step guide for beginners to learn real-world business intelligence. Birmingham, Packt Publishing, 2022. ISBN 978-1801811958 .