Advanced Data Processing in Spreadsheets
| Code | Completion | Credits | Range | Language |
|---|---|---|---|---|
| 614W1PZ | KZ | 4 | 8B | Czech |
- Garant předmětu:
- 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:
-
- KOMBI bak. studium od 15-16 (obor LOG) (compulsory elective course)
- KOMBI bak. studium od 16-17 (obor LOG) (compulsory elective course)
- KOMBI bak. studium od 16-17 (obor LED) (compulsory elective course)
- KOMBI bak. studium (obor LOG) začátek studia od 16-17, skok do 2.r. (compulsory elective course)
- KOMBI bak. studium od 16-17 (obor LED) uznány předměty (compulsory elective course)
- KOMBI bak. studium od 17-18 (obor LOG) (compulsory elective course)
- KOMBI bak. studium od 17-18 (obor LED) (compulsory elective course)
- KOMBI bak. studium od 17-18 (obor LOG) uznány předměty (compulsory elective course)
- KOMBI bak. studium od 17-18 (obor LED) uznané předměty (compulsory elective course)
- KOMBI bak. studium od 18-19 (obor LOG) (compulsory elective course)
- KOMBI bak. studium od 18-19 (obor LED) (compulsory elective course)
- KOMBI bak. studium od 19-20 (obor LOG) (compulsory elective course)
- KOMBI bak. studium od 19-20 (obor LED) (compulsory elective course)
- KOMBI bak. studium od 19-20 (obor LOG), skok do 2.r. (compulsory elective course)
- KOMBI bak. studium od 19-20 (obor LOG), skok do 3.r. (compulsory elective course)
- KOMBI bak. studium od 20-21 (specializace LOG, ne obor) (compulsory elective course)
- KOMBI bak. studium od 20-21 (obor LED) (compulsory elective course)
- KOMBI bak. studium od 18-19 (obor LOG) skok z 2.r. do 3.r. (compulsory elective course)
- KOMBI bak. studium od 20-21 (obor LOG), skok do 3.r. (compulsory elective course)
- KOMBI bak. studium od 20-21 (obor LOG), skok do 2.r. (compulsory elective course)
- KOMBI bak. studium od 21-22 (specializace LOG, ne obor) (compulsory elective course)
- KOMBI bak. studium od 21-22 (obor LED) (compulsory elective course)
- KOMBI bak. studium od 19-20 (obor LED) uznané předměty (compulsory elective course)
- KOMBI bak. studium od 21-22 (obor LED), skok do 3.r. (compulsory elective course)
- KOMBI bak. studium od 21-22 (obor LOG), skok do 3.r. (compulsory elective course)
- KOMBI bak. studium od 21-22 (obor LED), skok do 2.r. (compulsory elective course)
- KOMBI bak. studium od 22-23 (specializace LOG), skok do 3.r. (compulsory elective course)