Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2019/2020

MS Excel in Practice

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
126XEXC Z 1 2C Czech
Lecturer:
Petr Dlask (guarantor)
Tutor:
Petr Dlask (guarantor)
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.

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:

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

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

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

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:
Note:
Further information:
http://people.fsv.cvut.cz/~dlaskpet/Excel/index.html
Time-table for winter semester 2019/2020:
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
Fri
roomTH:B-475

14:00–15:50
(parallel nr.101)
Thákurova 7 (FSv-budova A)
B475
roomTH:B-475

16:00–17:50
(parallel nr.102)
Thákurova 7 (FSv-budova A)
B475
Thu
Fri
Time-table for summer semester 2019/2020:
Time-table is not available yet
The course is a part of the following study plans:
Data valid to 2020-04-08
For updated information see http://bilakniha.cvut.cz/en/predmet5206006.html