MS Excel in Practice

Course guarantor:

Lecturer:

Tutor:

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:

The course is focused on the needs for users of office applications (especially MS Excel). The goal is to improve their existing skills and acquire new ones. Practical skills can be used in cintinuing subjects and practice.

Further information:

http://people.fsv.cvut.cz/~dlaskpet/Excel/index.html

No time-table has been prepared for this course

The course is a part of the following study plans: