Практические аспекты Excel и VBA

2020/2021

Статус: Дисциплина общефакультетского пула

Кто читает: Международный институт экономики и финансов

Где читается: Международный институт экономики и финансов

Когда читается: 1, 2 модуль

Преподаватели: Акиньшин Никита Андреевич

Язык: русский

Кредиты: 3

Контактные часы: 32

Дополнительные материалы в LMS Задать вопрос

Аннотация

The course is recommended for students who have already completed one of the three following courses: Information Computer Systems, Programming and Data Processing or Programming and Databases. The course is designed to teach students how to use Excel and VBAand to give them the skills needed for automation of everyday using. Advanced knowledge of Excel and VBAis a competitiveadvantage in the job market, while the ability to automate everyday operations increases efficiency and allows to devote more time to issues that need deeper analysis.

Цель освоения дисциплины

The main aim of thecourse is to develop hard skills and to increase value of ICEF students in the jobs market.

Планируемые результаты обучения

to use all formulas used in the work of a financier
to build basic charts to create effective presentations
to use special tools Excel (i.e. PowerPivot) for numerical optimization and interactive data presentation
use VBA language for optimizing Excel work
to create financial models