Skip to main content
Skip header

ECTS Course Overview



Data processing on PC

* Exchange students do not have to consider this information when selecting suitable courses for an exchange stay.

Course Unit Code155-1553/01
Number of ECTS Credits Allocated4 ECTS credits
Type of Course Unit *Choice-compulsory
Level of Course Unit *First Cycle
Year of Study *
Semester when the Course Unit is deliveredWinter Semester
Mode of DeliveryFace-to-face
Language of InstructionEnglish
Prerequisites and Co-Requisites Course succeeds to compulsory courses of previous semester
Name of Lecturer(s)Personal IDName
NOV21Ing. Vítězslav Novák, Ph.D.
Summary
The aim of the course is to familiarize students with the possibilities of Microsoft Excel spreadsheet for data analysis. The show will be applicable to the basic fuctions and advanced tools such as structured tables, pivot tables, Power Query tool for data transformations and Power Pivot add-in for managing data models.
Learning Outcomes of the Course Unit
To be able to process larger amounts of data using Microsoft Excel tools such as subtotals, pivot tables or PowerPivot add-in.
To be able to process data from other applications.
To understand the difference between databases in Microsoft Excel and Access.
Course Contents
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
Recommended or Required Reading
Required Reading:
WINSTON, Wayne. Microsoft Excel 2019 Data Analysis and Business Modeling. 6th edition. San Francisco, CA: Microsoft Press, 2019. ISBN 978-1509305889.
ALEXANDER, Michael, Dick KUSLEIKA a John WALKENBACH. Excel 2019 Bible. Indianapolis, IN: Wiley, [2019]. ISBN 9781119514787.
LAURENČÍK, Marek. Excel 2016: práce s databázemi a kontingenčními tabulkami. Praha: Grada, 2017. ISBN 978-80-271-0477-2.
MYŠÁK, Milan. Kontingenční tabulky a grafy: výukový průvodce. Brno: Computer Press, 2013. ISBN 978-80-251-4113-7.
NAVARRŮ, Miroslav. Excel 2019: podrobný průvodce uživatele. Praha: Grada, 2019. ISBN 978-80-247-2026-5.
Recommended Reading:
FERRARI, Alberto a 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 a Alberto FERRARI. The Definitive Guide to DAX: Business Intelligence with Microsoft Excel, SQL Server Analysis Services and Power BI. Redmond, Washington: Microsoft Press, 2015. ISBN 978-0-7356-9835-2.
FERRARI, Alberto a 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 a Alberto FERRARI. The Definitive Guide to DAX: Business Intelligence with Microsoft Excel, SQL Server Analysis Services and Power BI. Redmond, Washington: Microsoft Press, 2015. ISBN 978-0-7356-9835-2.
LAURENČÍK, Marek. Excel - pokročilé nástroje: funkce, makra, databáze, kontingenční tabulky, prezentace, příklady. Praha: Grada, 2016. ISBN 978-80-247-5570-0.
Planned learning activities and teaching methods
Lectures, Tutorials
Assesment methods and criteria
Tasks are not Defined