Target audience: individuals holding or obtaining higher or secondary vocational education in the relevant field, or having completed professional retraining in the relevant area.
Studying methods: лекция, беседа, кейс-стади, ролевая игра, групповая дискуссия, просмотр видео.
After of course, participants will be: to enhance professional competencies reflected in knowledge and skills.
- Use advanced Microsoft Excel functions to create spreadsheets and databases;
- Apply Microsoft Excel in various economic sectors and for solving personal and professional tasks;
- Master methods and techniques for working with advanced and specialised Excel features — Power Pivot, M Language, and Power Query;
- Understand the basic principles of working with add‑ins for concurrent data processing;
- Create consolidated reports and workbooks, and format data;
- Perform necessary calculations with various data without loss of performance;
- Search and sort existing data using special features;
- Present data in a graphical format: 3D geographic maps;
- Design workflows using information and communication technologies and advanced Excel features (Power Pivot, M Language, Power Query);
- Apply specialised Excel modules and functions in practice to solve assigned tasks.
About course: enhancement of professionals’ competencies in using advanced and specialised features of the multifunctional Microsoft Excel software, including Power Pivot, Power Map, M Language, and Power Query.