MS Excel in Practice

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: