The Rector's Order No. 18/2020 is designed in accordance with the methodology introduced by the Ministry of Health of the Czech Republic, ie the measures are divided into four levels, corresponding to the currently valid epidemiological situation in the Czech Republic.
Please pay close attention to the current status information at the CTU or FTS web sites.
The approved form of communication is also an email, so it is necessary to monitor it regularly for a specific message about the current situation of teaching from your teachers or additional messages from the Department of External Relations.
Let us to be considerate so that together we can manage this difficult time in the lives of each of us as best we can.
The main contact for coronavirus related issues remains the secretariat of the faculty treasurer - phone: 224 359 518 or 733 696 308 or email: email@example.com
Data format, formulas, addressing, functions and nested functions - mathematical, statistical, logical, financial, search, database and time, database work, filters, pivot tables, graphs, macros, data analysis, solver, MS Office, Libre Office.
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.
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.