Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2022/2023

Advanced Data Processing in Spreadsheets

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
614W1PZ KZ 4 8B Czech
Lecturer:
Jan Mejstřík
Tutor:
Jan Mejstřík
Supervisor:
Department Děčín
Synopsis:

Students will be familiar with principles of working in a spreadsheet. Graphic layout of the table appearance, formatting of numbers, insertion of formulas and functions, including addressing, error detection. Working with large spreadsheets, filters, advanced filters, database functions. Pivot tables and charts, conditional formatting, solution finding, solver, macros, data analysis. Examples and questions from various companies and training.

Requirements:

not defined

Syllabus of lectures:
Syllabus of tutorials:
Study Objective:

Getting to know the possibilities and tools of MS Excel so that students can use it in practice. Functions from all areas (information, error, ...) will be shown, the student will be able to decide on the appropriate use of functions according to the situation, to work with large lists, to graphically present data in graphs and other tools.

Study materials:

M. Dodge, C. S. Douglas: Microsoft Excel 2010 Inside Out, O'Reilly Media

Bezvoda V., Brož M.: Microsoft Excel 2007/2010 Vzorce, funkce, výpočty, Computer Press

Note:
Time-table for winter semester 2022/2023:
Time-table is not available yet
Time-table for summer semester 2022/2023:
Time-table is not available yet
The course is a part of the following study plans:
Data valid to 2022-09-29
Aktualizace výše uvedených informací naleznete na adrese https://bilakniha.cvut.cz/en/predmet5277206.html