academy@academyit.ru
Excel_A
Пользователь Microsoft Windows/Office
2 дня /16 часов
Microsoft Excel 2019/2016. Продвинутый уровень
0 0
8900 ₽
Очное обучение.
Курсы проводятся во всех региональных учебных центрах Академии АйТи или на базе заказчика.
-
Описание образовательной программы
Вы получите знания и навыки, которые позволят Вам эффективно работать с большими объемами данных, производить их сложный анализ, эффективно использовать встроенные функции MS Excel 2019/2016 и макросы.
Вы научитесь сравнивать таблицы, сможете использовать функцию ВПР для подстановки данных из одной таблицы в другую, осуществлять различные вычисления как с простыми, так и сложными условиями.
В курсе будет рассмотрен как мощный функционал версий Microsoft Excel 2019/2016, так и новые возможности MS Excel 2016, которые появились при работе со сводными таблицами.По окончании курса Вы будете уметь:
- Наиболее эффективно применять инструменты и функции Excel для анализа и обработки данных
- Использовать функции для сравнения и подстановки данных
- Выполнять вычисления с применением различных условий
- Выделять нужные данные условным форматированием
- Защищать ячейки, рабочие листы и книги
- Контролировать ввод данных
- Вычислять промежуточные и общие итоги в таблицах
- Сортировать и фильтровать данные по значениям и по цвету
- Быстро и наглядно создавать отчеты сводных таблиц и диаграмм, чтобы подводить итоги и анализировать данные по годам, кварталам, месяцам причем как в абсолютных, так и относительных величинах
Целевая аудитория
Специалисты различного профиля, владеющие уверенными знаниями Microsoft Excel уровня 1 и желающие расширить свои знания для выполнения наиболее распространенных задач в программе Microsoft Excel 2019/2016
Содержание
1
Применение встроенных функций Excel
- Различные типы ссылок
- Связывание листов и рабочих книг
- Применение различных типов встроенных функций
- Математические функции: суммирование с условиями, округление результатов вычислений
- Статистические функции: вычисление количества и средних значений с условиями
- Функции ссылок и подстановки: ВПР и ГПР
- Логические функции: ЕСЛИ, И, ИЛИ, ЕСЛИОШИБКА
- Текстовые функции: объединение и разбиение данных
- Функции для работы с датами
2
Условное форматирование
- Применение встроенных правил: гистограмма, цветовые шкалы, наборы значков
- Создание правил форматирования с применением формул
- Редактирование правил
3
Особенности совместной работы
- Защита ячеек, листов и рабочих книг Excel
- Проверка вводимых значений:
- Установка ограничений на ввод данных
- Поиск неверных значений
4
Работа с большими табличными массивами
- Создание и ведение таблиц
- Удаление дубликатов
- Сортировка данных:
- Сортировка по одному критерию
- Многоуровневая сортировка
- Сортировка по форматированию
- Фильтрация данных:
- Автофильтр
- Срезы
- Расширенный фильтр
- Подведение промежуточных итогов
- Консолидация данных
5
Анализ данных с помощью сводных таблиц
- Создание сводных таблиц
- Преобразование сводных таблиц
- Фильтрация данных: фильтры, срезы, временная шкала
- Настройка полей сводной таблицы
- Добавление вычисляемых полей в сводную таблицу
- Группировка полей в сводных таблицах
- Сводные диаграммы
- Обновление сводных таблиц и диаграмм
-
Получаемый документ
-
Необходимая подготовка
Желательно прохождение курса Microsoft Excel 2019/2016. Базовый уровень
-
Цель курса
Совершенствование практических умений и навыков пользователя для профессионального владения Microsoft Excel 2019\2016.
Рекомендуемые курсы
Пользователь Microsoft Windows/Office
Microsoft Excel 2019/2016. Базовый уровень
Excel_F
Академия АйТи
2 дня /16 часов
Excel_F
Академия АйТи
2 дня /16 часов
Физлицам
8900 ₽
Юрлицам
9500 ₽
- Понимать структуру книги Excel
- Правильно вводить данные, использовать заполнение ячеек списками и данных прогрессий
- Осуществлять вычисления по формулам с использованием данных, находящихся как на одном, так и на разных листах
- Получать результаты расчета данных по функциям
- Оформлять таблицы в соответствии с любыми требованиями
- Строить диаграммы для наглядного представления табличных данных
- Осуществлять сортировку и фильтровку данных
- Подготовить и вывести на печать как таблицу, так и диаграмму
- Понимать структуру книги Excel
- Правильно вводить данные, использовать заполнение ячеек списками и данных прогрессий
- Осуществлять вычисления по формулам с использованием данных, находящихся как на одном, так и на разных листах
- Получать результаты расчета данных по функциям
- Оформлять таблицы в соответствии с любыми требованиями
- Строить диаграммы для наглядного представления табличных данных
- Осуществлять сортировку и фильтровку данных
- Подготовить и вывести на печать как таблицу, так и диаграмму
Формирование знаний и практических навыков по использованию 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] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [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"> [TYPE] => HTML ) [PROPERTY_VALUE_ID] => 20896291 [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] => 20893801
[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
[1] => 10420
[2] => 2852
)
[PROPERTY_VALUE_ID] => Array
(
[0] => 20901269
[1] => 20901270
[2] => 20901271
)
[DESCRIPTION] => Array
(
[0] =>
[1] =>
[2] =>
)
[~VALUE] => Array
(
[0] => 163
[1] => 10420
[2] => 2852
)
[~DESCRIPTION] => Array
(
[0] =>
[1] =>
[2] =>
)
)
[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] => 25357
)
[PROPERTY_VALUE_ID] => Array
(
[0] => 21364288
)
[DESCRIPTION] => Array
(
[0] =>
)
[~VALUE] => Array
(
[0] => 25357
)
[~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] => 26238
[1] => 26239
[2] => 26240
[3] => 26241
)
[PROPERTY_VALUE_ID] => Array
(
[0] => 21364289
[1] => 21364290
[2] => 21364291
[3] => 21364292
)
[DESCRIPTION] => Array
(
[0] =>
[1] =>
[2] =>
[3] =>
)
[~VALUE] => Array
(
[0] => 26238
[1] => 26239
[2] => 26240
[3] => 26241
)
[~DESCRIPTION] => Array
(
[0] =>
[1] =>
[2] =>
[3] =>
)
)
[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] => 12260
[1] => 12257
[2] => 12256
[3] => 12259
)
[PROPERTY_VALUE_ID] => Array
(
[0] => 20901272
[1] => 20901273
[2] => 20901274
[3] => 20901275
)
[DESCRIPTION] => Array
(
[0] =>
[1] =>
[2] =>
[3] =>
)
[~VALUE] => Array
(
[0] => 12260
[1] => 12257
[2] => 12256
[3] => 12259
)
[~DESCRIPTION] => Array
(
[0] =>
[1] =>
[2] =>
[3] =>
)
)
[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] => 21375150
[DESCRIPTION] =>
[~VALUE] => Содержание
[~DESCRIPTION] =>
)
[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_F
[PROPERTY_VALUE_ID] => 21337823
[DESCRIPTION] =>
[~VALUE] => Excel_F
[~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] => 21389984
[DESCRIPTION] =>
[~VALUE] => 3205
[~DESCRIPTION] =>
)
[POST_TEACHERS] =>
)
[DISPLAY_PROPERTIES] => Array
(
)
[IPROPERTY_VALUES] => Array
(
[ELEMENT_META_DESCRIPTION] => В курсе будет рассмотрен как функционал, общий для версий Microsoft Excel 2019/2016, так и новые возможности MS Excel 2016, такие как быстрый анализ таблиц и настройка диаграмм.<b>По окончании курса Вы будете уметь:</b><b><br>
</b>
<ul>
<li> Понимать структуру книги Excel</li>
<li> Правильно вводить данные, использовать заполнение ячеек списками и данных прогрессий</li>
<li> Осуществлять вычисления по формулам с использованием данных, находящихся как на одном, так и на разных листах</li>
<li> Получать результаты расчета данных по функциям</li>
<li> Оформлять таблицы в соответствии с любыми требованиями</li>
<li> Строить диаграммы для наглядного представления табличных данных</li>
<li> Осуществлять сортировку и фильтровку данных</li>
<li> Подготовить и вывести на печать как таблицу, так и диаграмму</li>
</ul>
[ELEMENT_META_TITLE] => Microsoft Excel 2019/2016. Базовый уровень
)
)
Пользователь Microsoft Windows/Office
Microsoft Excel 2019/2016. Анализ и визуализаци...
Excel_V
Академия АйТи
2 дня /16 часов
Excel_V
Академия АйТи
2 дня /16 часов
Физлицам
10900 ₽
Юрлицам
12900 ₽
- Создавать сложные формулы массивов для обработки данных с использованием встроенных функций разных категорий
- Выбирать оптимальные стратегии решений с помощью Сценариев и Таблиц данных
- Решать задачи одно- и многокритериальной оптимизации
- Строить нестандартные типы диаграмм для наглядного сравнения и анализа числовых данных.
- Управлять данными диаграммы с помощью пользовательских элементов управления
- Прогнозировать развитие ситуаций разными способами, в том числе с учетом сезонности
- Использовать быстрый прогноз с использованием листа прогноза
- Импортировать данные из внешних источников: web, текстовых файлов (*.txt, *.csv)
- Создавать запросы к внешним данным с использованием редактора Microsoft Query
- Строить отчеты сводных таблиц по данным OLAP-куба
По окончании курса Вы будете уметь:
- Создавать сложные формулы массивов для обработки данных с использованием встроенных функций разных категорий
- Выбирать оптимальные стратегии решений с помощью Сценариев и Таблиц данных
- Решать задачи одно- и многокритериальной оптимизации
- Строить нестандартные типы диаграмм для наглядного сравнения и анализа числовых данных.
- Управлять данными диаграммы с помощью пользовательских элементов управления
- Прогнозировать развитие ситуаций разными способами, в том числе с учетом сезонности
- Использовать быстрый прогноз с использованием листа прогноза
- Импортировать данные из внешних источников: web, текстовых файлов (*.txt, *.csv)
- Создавать запросы к внешним данным с использованием редактора Microsoft Query
- Строить отчеты сводных таблиц по данным OLAP-куба
[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] => 20893817
[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] => 10420
[1] => 6004
[2] => 163
[3] => 2852
)
[PROPERTY_VALUE_ID] => Array
(
[0] => 20895859
[1] => 20901293
[2] => 20901294
[3] => 20901295
)
[DESCRIPTION] => Array
(
[0] =>
[1] =>
[2] =>
[3] =>
)
[~VALUE] => Array
(
[0] => 10420
[1] => 6004
[2] => 163
[3] => 2852
)
[~DESCRIPTION] => Array
(
[0] =>
[1] =>
[2] =>
[3] =>
)
)
[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] => 26242
)
[PROPERTY_VALUE_ID] => Array
(
[0] => 21364336
)
[DESCRIPTION] => Array
(
[0] =>
)
[~VALUE] => Array
(
[0] => 26242
)
[~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] => 26248
[1] => 26249
[2] => 26250
[3] => 26251
[4] => 26252
[5] => 26253
)
[PROPERTY_VALUE_ID] => Array
(
[0] => 21364337
[1] => 21364338
[2] => 21364339
[3] => 21364340
[4] => 21364341
[5] => 21364342
)
[DESCRIPTION] => Array
(
[0] =>
[1] =>
[2] =>
[3] =>
[4] =>
[5] =>
)
[~VALUE] => Array
(
[0] => 26248
[1] => 26249
[2] => 26250
[3] => 26251
[4] => 26252
[5] => 26253
)
[~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] => 12255
[1] => 12258
[2] => 12260
[3] => 12256
[4] => 12259
)
[PROPERTY_VALUE_ID] => Array
(
[0] => 20901296
[1] => 20901297
[2] => 20901298
[3] => 20901299
[4] => 20901300
)
[DESCRIPTION] => Array
(
[0] =>
[1] =>
[2] =>
[3] =>
[4] =>
)
[~VALUE] => Array
(
[0] => 12255
[1] => 12258
[2] => 12260
[3] => 12256
[4] => 12259
)
[~DESCRIPTION] => Array
(
[0] =>
[1] =>
[2] =>
[3] =>
[4] =>
)
)
[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] => 21375196
[DESCRIPTION] =>
[~VALUE] => Содержание
[~DESCRIPTION] =>
)
[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_V
[PROPERTY_VALUE_ID] => 21337830
[DESCRIPTION] =>
[~VALUE] => Excel_V
[~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] => 21389982
[DESCRIPTION] =>
[~VALUE] => 3205
[~DESCRIPTION] =>
)
[POST_TEACHERS] =>
)
[DISPLAY_PROPERTIES] => Array
(
)
[IPROPERTY_VALUES] => Array
(
[ELEMENT_META_DESCRIPTION] => Пройдя обучение на этом курсе, Вы повысите свой «словарный запас» встроенных функций MS Excel в рамках категории «Ссылки и массивы», а в совокупности с формулами массивов перед Вами откроются новые возможности обработки данных. Вы научитесь создавать нестандартные сложные диаграммы, которые помогут визуализировать данные, сделать их запоминающимися и легкими в управлении. Вы узнаете о новых типах диаграмм, которые появились только в Microsoft Excel 2016.<br>
<b><span style="color: #f16522;"><br>
</span></b><b><span style="color: #f16522;">По окончании курса Вы будете уметь:<br>
</span></b><br>
<ul>
<li>Создавать сложные формулы массивов для обработки данных с использованием встроенных функций разных категорий</li>
<li>
Выбирать оптимальные стратегии решений с помощью Сценариев и Таблиц данных</li>
<li>
Решать задачи одно- и многокритериальной оптимизации</li>
<li>
Строить нестандартные типы диаграмм для наглядного сравнения и анализа числовых данных.</li>
<li>
Управлять данными диаграммы с помощью пользовательских элементов управления</li>
<li>
Прогнозировать развитие ситуаций разными способами, в том числе с учетом сезонности</li>
<li>
Использовать быстрый прогноз с использованием листа прогноза</li>
<li>
Импортировать данные из внешних источников: web, текстовых файлов (*.txt, *.csv)</li>
<li>
Создавать запросы к внешним данным с использованием редактора Microsoft Query</li>
<li>
Строить отчеты сводных таблиц по данным OLAP-куба</li>
</ul><p>
В рамках данного курса будут рассмотрены вопросы как быстро и эффективно создавать сложные, но наглядные интерактивные диаграммы для визуализации ваших отчетов и данных.
</p>
<p>
Пройдя обучение на этом курсе, Вы повысите свой «словарный запас» встроенных функций MS Excel в рамках категории «Ссылки и массивы», а в совокупности с формулами массивов перед Вами откроются новые возможности обработки данных. Вы научитесь создавать нестандартные сложные диаграммы, которые помогут визуализировать данные, сделать их запоминающимися и легкими в управлении. Вы узнаете о новых типах диаграмм, которые появились только в Microsoft Excel 2019/2016<br>
</p>
[ELEMENT_META_TITLE] => Microsoft Excel 2019/2016. Анализ и визуализация данных
)
)
Пользователь Microsoft Windows/Office
Microsoft Excel 2019/2016. Макросы на VBA
Excel_VBA
Академия АйТи
3 дня /24 час
Excel_VBA
Академия АйТи
3 дня /24 час
Физлицам
17900 ₽
Юрлицам
19900 ₽
- Использовать автоматическую запись макроса в Excel и исправлять недостатки автоматически генерируемого программного кода
- Создавать проекты в редакторе VBA, редактировать, отлаживать и выполнять программный код
- Программировать работу с переменными, условные переходы и циклы, диалоги для ввода значений и вывода сообщений
- Программировать доступ и управление объектами Excel (такими как рабочая книга, рабочие листы и диапазоны ячеек)
- Создавать и применять пользовательские функции
По окончании курса Вы будете уметь:
- Использовать автоматическую запись макроса в Excel и исправлять недостатки автоматически генерируемого программного кода
- Создавать проекты в редакторе VBA, редактировать, отлаживать и выполнять программный код
- Программировать работу с переменными, условные переходы и циклы, диалоги для ввода значений и вывода сообщений
- Программировать доступ и управление объектами Excel (такими как рабочая книга, рабочие листы и диапазоны ячеек)
- Создавать и применять пользовательские функции
Пользователь 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. Углубленное программирование
)
)
2 отзывов
Акционерное общество «Промышленная группа «Метран» выражает искреннюю благодарность всему коллективу Академии АйТи за профессиональное отношение и индивидуальный подход в оказании образовательных услуг по пользовательским курсам Microsoft Office 2013/2016.
Хотим отметить высокий уровень проведения обучения, удобство и простоту предоставления учебного материала, гибкое администрирование курсов, в целом квалифицированное и профессиональное отношение сотрудников Академии АйТи к своим обязанностям.
Выражаем благодарность всему коллективу Академии АйТи. Уверены, что наше деловое и конструктивное сотрудничество будут продолжено.
Кузьмина А.Е., Руководитель Центра обучения и развития. АО “ПГ “Метран”
10.10.2017
Чтобы оставить отзыв необходимо авторизоваться на сайте или зарегистрироваться.
В период с февраля по март 2019 года сотрудники АНО "Агентство по развитию кластерной политики и предпринимательства Нижегородской области" проходили обучение в Волго-Вятском филиале АНО ДПО "Академия АйТи" по следующим курсам: "Microsoft Exel 2016/2013. Продвинутый уровень", "Microsoft PowerPoint 2016/2013. Дизайн и успешное проведение презентаций", "Microsoft Office Word 2016/2013 для квалифицированного пользователя".
По результатам пройденных курсов отмечен высокий методический уровень организации обучения и мастерство преподавателя, который смог донести до слушателей достаточно сложную информацию в доступной и понятной форме, открытое взаимодействие в процессе обучения, а также помощь в решении возникающих вопросов.
Обучение по данной программе позволило повысить уровень профессиональной подготовки сотрудников и систематизировать уже имеющиеся знания.
АНО "Агентство по развитию кластерной политики и предпринимательства Нижегородской области" благодарит коллектив Волго-Вятского филиала АНО ДПО "Академия АйТи" за высокий уровень организации обучения и внимательное отношение к слушателям и надеется на дальнейшее сотрудничество.
Н.Г Данилов
И.о. директора
По результатам пройденных курсов отмечен высокий методический уровень организации обучения и мастерство преподавателя, который смог донести до слушателей достаточно сложную информацию в доступной и понятной форме, открытое взаимодействие в процессе обучения, а также помощь в решении возникающих вопросов.
Обучение по данной программе позволило повысить уровень профессиональной подготовки сотрудников и систематизировать уже имеющиеся знания.
АНО "Агентство по развитию кластерной политики и предпринимательства Нижегородской области" благодарит коллектив Волго-Вятского филиала АНО ДПО "Академия АйТи" за высокий уровень организации обучения и внимательное отношение к слушателям и надеется на дальнейшее сотрудничество.
Н.Г Данилов
И.о. директора
АНО "Агентство по развитию кластерной политики и предпринимательства Нижегородской области"
Чтобы оставить отзыв необходимо авторизоваться на сайте или зарегистрироваться.
