Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2023/2024
UPOZORNĚNÍ: Jsou dostupné studijní plány pro následující akademický rok.

MS Excel in Practice

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
126XEXC Z 1 2C Czech
Garant předmětu:
Petr Dlask
Lecturer:
Petr Dlask
Tutor:
Petr Dlask
Supervisor:
Department of Construction Management and Economics
Synopsis:

The course is designed for office users (especially for MS Excel) to improve their existing skills and get new ones. The main objective is to focus on skills that are applicable in connected subjects and practice. It includes basic principles of work, dead and live tables creation, formatting, fast charts, links to VBA, creation of custom functions, procedures and applications. The content of the course can be modified according to the needs of the students.

Requirements:

The prerequisite is the user knowledge of office applications, focused to MS Excel. The advantage is the basic orientation in the structure of the application and its add-ins.

Syllabus of lectures:

The study subject does not have lectures.

Syllabus of tutorials:

1. Create user functions

2. Test user functions

3. Using internal forms - MsgBox, InputBox

4. Create user forms

5. Pivot Table analysis, table, graph

6. Pivot Table Training, Data model, Editor Power Query

7. Speedometer charts

8. Map charts

9. Creating graphs with maps

10. Live charts

11. Graphs with interval selection, with selection of values

12. Creating custom graphical shapes

13. External data, import of external data

Study Objective:

The aim of the study is to introduce advanced practices. At the same time, the goal is to focus on the individual problems solving. The variety of student tasks offers the ability to apply in different situations.

Study materials:

Available online:

Excel tips: http://people.fsv.cvut.cz/~dlaskpet/Help/ExcelTipy.xlsm

Tutorials: http://people.fsv.cvut.cz/~dlaskpet/Help/data97.xls

Mind map online: https://www.mindmeister.com/1054512660/risk-management

Diagrams symbols: https://www.itnetwork.cz/navrh/uml/vyvojove-diagramy

Symbols Draw.io: https://app.diagrams.net/

Next documents available after login to https://moodle-vyuka.cvut.cz/

Note:
Further information:
http://people.fsv.cvut.cz/~dlaskpet/Excel/index.html
Time-table for winter semester 2023/2024:
06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon
Tue
Wed
Thu
roomTH:B-475

14:00–15:50
(parallel nr.101)
Thákurova 7 (budova FSv)
B475
Fri
Time-table for summer semester 2023/2024:
Time-table is not available yet
The course is a part of the following study plans:
Data valid to 2024-04-22
Aktualizace výše uvedených informací naleznete na adrese https://bilakniha.cvut.cz/en/predmet5206006.html