academy@academyit.ru
Excel_VBA
Пользователь Microsoft Windows/Office
3 дня /24 час
Microsoft Excel 2019/2016. Макросы на VBA
0 0
Физлицам
17900 ₽
Юрлицам
19900 ₽
Очное обучение.
Курсы проводятся во всех региональных учебных центрах Академии АйТи или на базе заказчика.
Онлайн класс. Удаленное подключение к очным курсам.
Для обучения достаточно иметь доступ в Интернет.
Время онлайн трансляции курса устанавливается в зависимости от города проведения очного обучения. Предусмотрено предоставление записей слушателям в отдаленных часовых поясах.
-
Описание образовательной программы
Наибольшее количество прикладных задач, требующих использования макросов, возникает при работе с электронными таблицами Excel. Опытные пользователи могут самостоятельно справиться с вопросами автоматизации Microsoft Excel 2019/2016, если освоят возможности программирования макросов на VBA.
По окончании курса Вы будете уметь:
- Использовать автоматическую запись макроса в Excel и исправлять недостатки автоматически генерируемого программного кода
- Создавать проекты в редакторе VBA, редактировать, отлаживать и выполнять программный код
- Программировать работу с переменными, условные переходы и циклы, диалоги для ввода значений и вывода сообщений
- Программировать доступ и управление объектами Excel (такими как рабочая книга, рабочие листы и диапазоны ячеек)
- Создавать и применять пользовательские функции
Целевая аудитория
Специалисты, использующие Excel в повседневной профессиональной деятельности и желающие научиться разбирать программный код на VBA и самостоятельно программировать макросы
Содержание
1
Автоматическая запись макроса в Microsoft Excel 2019/2016
- Использование макрорекордера для записи макроса в Microsoft Excel 2019/2016
- Использование абсолютных и относительных ссылок при записи макроса
- Исправление недостатков программного кода, генерируемого автоматически
2
Работа в редакторе Visual Basic. Основы программировании на VBA
- Создание проекта VBA. Использование окна проекта. Работа с модулями.
- Ввод и редактирование программного кода
- Создание, сохранение и запуск процедуры VBA
- Типы данных, переменные, константы
- Инструкции управления порядком выполнения команд: If…Then…Else и Select Case
3
Программирование объектов Excel. Свойства и методы рабочих книг, листов и диапазонов ячеек
- Понятие объектно-ориентированного программирования
- Модель объектов Excel, ссылки на объекты
- Обзор свойств и методов объекта Workbook
- Управление листами: использование коллекции Worksheets и объекта Worksheet
- Работа с диапазонами ячеек: использование объекта Range, его свойств и методов
- Использование объектных переменных и конструкции With … End With
4
Циклы: программирование многократных действий
- Разновидности циклов в VBA
- Цикл со счетчиком For...Next
- Циклы с условием Do...Loop
- Цикл по объектам For Each...Next
- Примеры циклических операций с ячейками и листами рабочих книг Excel
5
Создание пользовательской функции. Примеры пользовательских функций
- Создание процедуры Function
- Использование пользовательской функции в процедуре VBA и на рабочем листе
- Решение типичных задач автоматизации в Excel с помощью пользовательских функций
6
Обработка ошибок. Отладка и тестирование программы
- Типы ошибок
- Создание процедуры обработки ошибок Run-time
- Отладка и пошаговое тестирование программы
7
Защита проекта VBA. Автоматизация запуска макросов
- Настройка уровней безопасности
- Защита проекта VBA
- Создание пользовательских кнопок для запуска макросов
- Использование событий рабочих книг и листов для запуска макросов
Преподаватели
Рекомендуемые курсы
Пользователь Microsoft Windows/Office
Microsoft Excel 2019/2016. Продвинутый уровень
Excel_A
Академия АйТи
2 дня /16 часов
Excel_A
Академия АйТи
2 дня /16 часов
8900 ₽
Пользователь Microsoft Windows/Office
Microsoft Excel 2019/2016. VBA. Углубленное про...
Excel_VBAA
Академия АйТи
2 дня /16 часов
Excel_VBAA
Академия АйТи
2 дня /16 часов
Физлицам
13900 ₽
Юрлицам
15900 ₽
- программировать сложные процедуры с вложенными циклами, использующие массивы переменных
- автоматизировать работу с файловой системой, использовать диалоги для выбора файлов и папок
- автоматизировать создания cводных таблиц
- создавать пользовательские формы для организации диалоговых окон для работы пользователей
- создавать надстройки Microsoft Excel 2019/2016 с помощью VBA
В курсе рассматриваются вопросы автоматизации обработки множества рабочих файлов, организации доступа к базам данных, создания диалоговых окон для конечного пользователя и оформления проекта VBA в виде надстройки Excel.
По окончании курса Вы будете уметь:
- программировать сложные процедуры с вложенными циклами, использующие массивы переменных
- автоматизировать работу с файловой системой, использовать диалоги для выбора файлов и папок
- автоматизировать создания cводных таблиц
- создавать пользовательские формы для организации диалоговых окон для работы пользователей
- создавать надстройки Microsoft Excel 2019/2016 с помощью VBA
Совершенствование знаний и навыков, необходимых для углубленного изучения программирования в среде Microsoft Excel 2019/2016.
[TYPE] => HTML ) [~DESCRIPTION] => ) [AUDIT_CATALOG] => Array ( [ID] => 75 [IBLOCK_ID] => 26 [NAME] => Целевая аудитория [ACTIVE] => Y [SORT] => 750 [CODE] => AUDIT_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 75 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Целевая аудитория [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TRAIN_CATALOG] => Array ( [ID] => 76 [IBLOCK_ID] => 26 [NAME] => Необходимая подготовка [ACTIVE] => Y [SORT] => 800 [CODE] => TRAIN_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 76 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Необходимая подготовка [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [TEXT] => Желательно прохождение курса <b><a href="http://www.academy.it.ru/courses/Excel_VBA">Microsoft Excel 2019/2016. Макросы на VBA</a></b> [TYPE] => HTML ) [PROPERTY_VALUE_ID] => 20896326 [DESCRIPTION] => [~VALUE] => Array ( [TEXT] => Желательно прохождение курса Microsoft Excel 2019/2016. Макросы на VBA [TYPE] => HTML ) [~DESCRIPTION] => ) [CONTENT_CATALOG] => Array ( [ID] => 77 [IBLOCK_ID] => 26 [NAME] => Содержание [ACTIVE] => Y [SORT] => 850 [CODE] => CONTENT_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 77 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Содержание [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [SERTIF_CATALOG] => Array ( [ID] => 78 [IBLOCK_ID] => 26 [NAME] => Сертификация [ACTIVE] => Y [SORT] => 900 [CODE] => SERTIF_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 78 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Сертификация [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [DOC_CATALOG] => Array ( [ID] => 79 [IBLOCK_ID] => 26 [NAME] => Получаемый документ [ACTIVE] => Y [SORT] => 950 [CODE] => DOC_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 79 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Получаемый документ [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [TEXT] => <img width="437" alt="Сертификат.jpg" src="/upload/medialibrary/b37/b370784d3f620d37311f6ecb970a4aec.jpg" height="300" title="Сертификат.jpg"><img width="437" alt="Certifiate_Microsoft.jpg" src="/upload/medialibrary/f15/f1547ee55c54b5992981f7a5c4e4db14.jpg" height="316" title="Certifiate_Microsoft.jpg"> [TYPE] => HTML ) [PROPERTY_VALUE_ID] => 20896328 [DESCRIPTION] => [~VALUE] => Array ( [TEXT] =>
[TYPE] => HTML
)
[~DESCRIPTION] =>
)
[LENGTH_CATALOG] => Array
(
[ID] => 80
[IBLOCK_ID] => 26
[NAME] => Продолжительность обучения
[ACTIVE] => Y
[SORT] => 1000
[CODE] => LENGTH_CATALOG
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] => 80
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => Y
[FILTRABLE] => Y
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Продолжительность обучения
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 2 дня /16 часов
[PROPERTY_VALUE_ID] => 20893841
[DESCRIPTION] =>
[~VALUE] => 2 дня /16 часов
[~DESCRIPTION] =>
)
[prepodavatel] => Array
(
[ID] => 82
[IBLOCK_ID] => 26
[NAME] => Преподаватели
[ACTIVE] => Y
[SORT] => 1050
[CODE] => prepodavatel
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => E
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => Y
[XML_ID] => 82
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 25
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Преподаватели
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => Array
(
[0] => 163
)
[PROPERTY_VALUE_ID] => Array
(
[0] => 20901361
)
[DESCRIPTION] => Array
(
[0] =>
)
[~VALUE] => Array
(
[0] => 163
)
[~DESCRIPTION] => Array
(
[0] =>
)
)
[FORUM_TOPIC_ID] => Array
(
[ID] => 175
[IBLOCK_ID] => 26
[NAME] => Тема форума для комментариев
[ACTIVE] => Y
[SORT] => 1150
[CODE] => FORUM_TOPIC_ID
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => N
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] => 175
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Тема форума для комментариев
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[FORUM_MESSAGE_CNT] => Array
(
[ID] => 176
[IBLOCK_ID] => 26
[NAME] => Количество комментариев к элементу
[ACTIVE] => Y
[SORT] => 1200
[CODE] => FORUM_MESSAGE_CNT
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => N
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] => 176
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Количество комментариев к элементу
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[OPTIONS_CATALOG] => Array
(
[ID] => 229
[IBLOCK_ID] => 26
[NAME] => Доп. опции
[ACTIVE] => Y
[SORT] => 1300
[CODE] => OPTIONS_CATALOG
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => E
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => Y
[XML_ID] => 229
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 60
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] => EList
[USER_TYPE_SETTINGS] => Array
(
[size] => 1
[width] => 0
[group] => N
[multiple] => N
)
[HINT] =>
[~NAME] => Доп. опции
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[MOODLE_ID] => Array
(
[ID] => 244
[IBLOCK_ID] => 26
[NAME] => ID курса в СДО
[ACTIVE] => Y
[SORT] => 1350
[CODE] => MOODLE_ID
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => N
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => ID курса в СДО
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[COUNT_ORDER] => Array
(
[ID] => 248
[IBLOCK_ID] => 26
[NAME] => Количество заказов
[ACTIVE] => Y
[SORT] => 1400
[CODE] => COUNT_ORDER
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => N
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Количество заказов
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[IN_ASO] => Array
(
[ID] => 251
[IBLOCK_ID] => 26
[NAME] => Курс в АСО
[ACTIVE] => Y
[SORT] => 1450
[CODE] => IN_ASO
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => L
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Курс в АСО
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
[VALUE_ENUM_ID] =>
)
[VARIANTY_VIEZD] => Array
(
[ID] => 384
[IBLOCK_ID] => 26
[NAME] => Целевая аудитория (Новый блок)
[ACTIVE] => Y
[SORT] => 1500
[CODE] => VARIANTY_VIEZD
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => E
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => Y
[XML_ID] => 288
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Целевая аудитория (Новый блок)
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => Array
(
[0] => 26269
)
[PROPERTY_VALUE_ID] => Array
(
[0] => 21364443
)
[DESCRIPTION] => Array
(
[0] =>
)
[~VALUE] => Array
(
[0] => 26269
)
[~DESCRIPTION] => Array
(
[0] =>
)
)
[RAZPISANIE] => Array
(
[ID] => 385
[IBLOCK_ID] => 26
[NAME] => Расписание
[ACTIVE] => Y
[SORT] => 1550
[CODE] => RAZPISANIE
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => E
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => Y
[XML_ID] => 289
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 64
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Расписание
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => Array
(
[0] => 26270
[1] => 26271
[2] => 26272
[3] => 26273
[4] => 26274
[5] => 26275
)
[PROPERTY_VALUE_ID] => Array
(
[0] => 21364444
[1] => 21364445
[2] => 21364446
[3] => 21364447
[4] => 21364448
[5] => 21364449
)
[DESCRIPTION] => Array
(
[0] =>
[1] =>
[2] =>
[3] =>
[4] =>
[5] =>
)
[~VALUE] => Array
(
[0] => 26270
[1] => 26271
[2] => 26272
[3] => 26273
[4] => 26274
[5] => 26275
)
[~DESCRIPTION] => Array
(
[0] =>
[1] =>
[2] =>
[3] =>
[4] =>
[5] =>
)
)
[VIDEO] => Array
(
[ID] => 386
[IBLOCK_ID] => 26
[NAME] => Видео
[ACTIVE] => Y
[SORT] => 1600
[CODE] => VIDEO
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] => 293
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Видео
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[EKSAMEN] => Array
(
[ID] => 387
[IBLOCK_ID] => 26
[NAME] => Экзамены
[ACTIVE] => Y
[SORT] => 1650
[CODE] => EKSAMEN
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => E
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => Y
[XML_ID] => 294
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Экзамены
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[prods] => Array
(
[ID] => 83
[IBLOCK_ID] => 26
[NAME] => Похожие (связанные) продукты
[ACTIVE] => Y
[SORT] => 1670
[CODE] => prods
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => E
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => Y
[XML_ID] => 83
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 26
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] => Выбранные курсы выводятся в карточке курса блок "Рекомендуемые курсы"
[~NAME] => Похожие (связанные) продукты
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => Array
(
[0] => 12259
)
[PROPERTY_VALUE_ID] => Array
(
[0] => 20901362
)
[DESCRIPTION] => Array
(
[0] =>
)
[~VALUE] => Array
(
[0] => 12259
)
[~DESCRIPTION] => Array
(
[0] =>
)
)
[RECOMMENT_COURSE] => Array
(
[ID] => 388
[IBLOCK_ID] => 26
[NAME] => Рекомендуемые курсы
[ACTIVE] => Y
[SORT] => 1700
[CODE] => RECOMMENT_COURSE
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => E
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => Y
[XML_ID] => 295
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 26
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] => Выбранные курсы выводятся в карточке курса блок "Рекомендуемые курсы"
[~NAME] => Рекомендуемые курсы
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[TARIF_PLAN] => Array
(
[ID] => 389
[IBLOCK_ID] => 26
[NAME] => Тарифные планы
[ACTIVE] => Y
[SORT] => 1750
[CODE] => TARIF_PLAN
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => E
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => Y
[XML_ID] => 296
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Тарифные планы
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[PODZAGOLOVOK_NAME] => Array
(
[ID] => 390
[IBLOCK_ID] => 26
[NAME] => Подзаголовок для названия
[ACTIVE] => Y
[SORT] => 1800
[CODE] => PODZAGOLOVOK_NAME
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] => 309
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Подзаголовок для названия
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[TITLE_PROGRAMM] => Array
(
[ID] => 391
[IBLOCK_ID] => 26
[NAME] => Заголовок - Образовательная программа
[ACTIVE] => Y
[SORT] => 1850
[CODE] => TITLE_PROGRAMM
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] => 310
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Заголовок - Образовательная программа
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[SERTIF_KURSE] => Array
(
[ID] => 392
[IBLOCK_ID] => 26
[NAME] => Сертификаты (блок)
[ACTIVE] => Y
[SORT] => 1900
[CODE] => SERTIF_KURSE
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => E
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => Y
[XML_ID] => 311
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Сертификаты (блок)
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[PACKET_PRED] => Array
(
[ID] => 393
[IBLOCK_ID] => 26
[NAME] => Пакетные предложения
[ACTIVE] => Y
[SORT] => 1950
[CODE] => PACKET_PRED
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => E
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => Y
[XML_ID] => 312
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 63
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Пакетные предложения
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[SALE] => Array
(
[ID] => 394
[IBLOCK_ID] => 26
[NAME] => Акция
[ACTIVE] => Y
[SORT] => 2000
[CODE] => SALE
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => L
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => C
[MULTIPLE] => N
[XML_ID] => 366
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Акция
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
[VALUE_ENUM_ID] =>
)
[TITLE_ANNOTATION] => Array
(
[ID] => 395
[IBLOCK_ID] => 26
[NAME] => Заголовок - Аннотация
[ACTIVE] => Y
[SORT] => 2050
[CODE] => TITLE_ANNOTATION
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] => 370
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Заголовок - Аннотация
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[TITLE_CEL_COURSE] => Array
(
[ID] => 396
[IBLOCK_ID] => 26
[NAME] => Заголовок - Цель курса
[ACTIVE] => Y
[SORT] => 2100
[CODE] => TITLE_CEL_COURSE
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] => 371
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Заголовок - Цель курса
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[TITLE_CEL_AUDITOR] => Array
(
[ID] => 397
[IBLOCK_ID] => 26
[NAME] => Заголовок - Целевая аудитория
[ACTIVE] => Y
[SORT] => 2150
[CODE] => TITLE_CEL_AUDITOR
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] => 372
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Заголовок - Целевая аудитория
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[TITLE_SODERSHANIE] => Array
(
[ID] => 398
[IBLOCK_ID] => 26
[NAME] => Заголовок - Содержание
[ACTIVE] => Y
[SORT] => 2200
[CODE] => TITLE_SODERSHANIE
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] => 373
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Заголовок - Содержание
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[TITLE_SERTIF] => Array
(
[ID] => 399
[IBLOCK_ID] => 26
[NAME] => Заголовок - Сертификация
[ACTIVE] => Y
[SORT] => 2250
[CODE] => TITLE_SERTIF
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] => 374
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Заголовок - Сертификация
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[TITLE_DOCUMENT] => Array
(
[ID] => 400
[IBLOCK_ID] => 26
[NAME] => Заголовок - Получаемый документ
[ACTIVE] => Y
[SORT] => 2300
[CODE] => TITLE_DOCUMENT
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] => 375
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Заголовок - Получаемый документ
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[CONNECT_BUY] => Array
(
[ID] => 401
[IBLOCK_ID] => 26
[NAME] => Курс можно купить
[ACTIVE] => Y
[SORT] => 2350
[CODE] => CONNECT_BUY
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => L
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => C
[MULTIPLE] => N
[XML_ID] => 377
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Курс можно купить
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
[VALUE_ENUM_ID] =>
)
[OFFERTA] => Array
(
[ID] => 402
[IBLOCK_ID] => 26
[NAME] => Файл оферты
[ACTIVE] => Y
[SORT] => 2400
[CODE] => OFFERTA
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => F
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] => 399
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Файл оферты
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[POPULAR_COURSE_SORT] => Array
(
[ID] => 752
[IBLOCK_ID] => 26
[NAME] => Сортировка (Популярные курсы)
[ACTIVE] => Y
[SORT] => 2450
[CODE] => POPULAR_COURSE_SORT
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Сортировка (Популярные курсы)
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[RASPISANIE_TITLE] => Array
(
[ID] => 761
[IBLOCK_ID] => 26
[NAME] => Расписание (Заголовок)
[ACTIVE] => Y
[SORT] => 2500
[CODE] => RASPISANIE_TITLE
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Расписание (Заголовок)
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[code] => Array
(
[ID] => 180
[IBLOCK_ID] => 26
[NAME] => Код курса (служебное)
[ACTIVE] => Y
[SORT] => 2550
[CODE] => code
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] => 180
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => Y
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Код курса (служебное)
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => Excel_VBAA
[PROPERTY_VALUE_ID] => 21337846
[DESCRIPTION] =>
[~VALUE] => Excel_VBAA
[~DESCRIPTION] =>
)
[MARKET_CATEGOR] => Array
(
[ID] => 762
[IBLOCK_ID] => 26
[NAME] => Категория Яндекс.Маркет
[ACTIVE] => Y
[SORT] => 3000
[CODE] => MARKET_CATEGOR
[DEFAULT_VALUE] => 3205
[PROPERTY_TYPE] => N
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => Y
[FILTRABLE] => Y
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] => ym_service_category
[USER_TYPE_SETTINGS] => Array
(
)
[HINT] =>
[~NAME] => Категория Яндекс.Маркет
[~DEFAULT_VALUE] => 3205
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 3205
[PROPERTY_VALUE_ID] => 21389979
[DESCRIPTION] =>
[~VALUE] => 3205
[~DESCRIPTION] =>
)
[POST_TEACHERS] =>
)
[DISPLAY_PROPERTIES] => Array
(
)
[IPROPERTY_VALUES] => Array
(
[ELEMENT_META_DESCRIPTION] => Наибольшее количество прикладных задач, которые невозможно реализовать без макросов, возникает при работе с электронными таблицами Excel.<br>
<br>
В курсе рассматриваются вопросы автоматизации обработки множества рабочих файлов, организации доступа к базам данных, создания диалоговых окон для конечного пользователя и оформления проекта VBA в виде надстройки Excel.<br>
<br>
<b>
По окончании курса Вы будете уметь:<br>
</b><br>
<ul>
<li> программировать сложные процедуры с вложенными циклами, использующие массивы переменных</li>
<li> автоматизировать работу с файловой системой, использовать диалоги для выбора файлов и папок</li>
<li> автоматизировать создания cводных таблиц</li>
<li> создавать пользовательские формы для организации диалоговых окон для работы пользователей</li>
<li> создавать надстройки Microsoft Excel 2019/2016 с помощью VBA</li>
</ul>
[ELEMENT_META_TITLE] => Microsoft Excel 2019/2016. VBA. Углубленное программирование
)
)
0 отзывов
Об этом курсе отзывов пока нет. Будьте первым.
Чтобы оставить отзыв необходимо авторизоваться на сайте или зарегистрироваться.
