Microsoft Excel 2019/2016. Бизнес - аналитика с использованием PowerPivot и PowerView
0 0
Забронировать курс
Спасибо за интерес к нашему курсу! Обратитесь через форму «Запросить информацию» для получения более точной информации о датах обучения.
-
Описание образовательной программы
Access, SQL-сервер, OLAP-куб, файлы Excel и т.д., загружая их в модель PowerPivot напрямую или предварительно обработав в PowerQuery. При необходимости создавать связи между всеми этими источниками, выполнять различные расчеты, как с использованием простых вычислений, так и с применением функций. Вы больше не будете зависеть от разработчиков, т.к. все отчеты Вы сможете строить сами.
Полученные данные можно будет представить в комбинированных отчетах сводных таблиц и сводных диаграмм, причем как зависимых, так и независимых друг от друга. Вы научитесь строить интуитивно понятные динамические отчеты PowerView для изучения, визуализации и представления данных как в табличном, так и графическом виде.
PowerPivot, PowerQuery, PowerView и PowerMap – это мощные современные инструменты анализа данных в Microsoft Excel!
По окончании курса Вы будете уметь:
- Загружать данные в модель данных PowerPivot из внешних источников
- Создавать связи между таблицами в модели данных
- Импортировать данные в модель PowerPivot с использованием PowerQuery
- Редактировать, создавать вычисления, объединять и добавлять запросы PowerQuery
- Выполнять анализ и моделирование данных с помощью PowerPivot
- Строить DAX-формулы для получения результатов обработки как по простым формулам, так и с применением функций различных категорий, создавая как вычисляемые поля, так и вычисляемые столбцы
- Выполнять построение комбинированных отчетов как в виде сводных таблиц, так и сводных диаграмм
- Создавать интуитивно понятные специализированные динамические отчеты Power View для представления данных в виде таблицы, матрицы, наборов различных диаграмм и управлять данными отчета
- Строить наглядные отчеты для анализа данных с привязкой к географическому расположению как с PowerView, так и с Power Map
Целевая аудитория
Опытные пользователи различных специальностей, в первую очередь аналитики, осуществляющие анализ внешних источников данных в целях быстрого предоставления отчетов для понимания ситуации
Содержание
Введение в PowerPivot. Источники
- Особенности и возможности PowerPivot
- Подключение надстройки PowerPivot
- Импорт данных из источников:
- Реляционные базы данных: Access, SQL-server
- Многомерные источники - службы Microsoft Analysis Services (OLAP-куб)
- Файлы Excel
- Текстовые файлы csv
- Фильтрация данных при импорте
- Управление моделями и создание связей
- Практические упражнения
Импорт данных с PowerQuery
- Импорт данных с веб-страницы, из текстового файла, из базы данных Microsoft Access, книг Excel
- Работа с импортированными данными: редактирование, создание вычисляемых полей, обновление
- Объединение и добавление запросов
- Практические упражнения
Вычисления в источниках PowerPivot
- Создание вычисляемых столбцов с использованием DAX-формул:
- Простейшие вычисление
- Использование функций категорий: Дата и время, Логические, Математические, Текстовые, Фильтр.
- Практические упражнения
Работа с отчетами
- Создание пользовательских иерархий для использования в отчете
- Создание отчетов различных видов: Сводная таблица, Сводная диаграмма, Диаграмма и таблица, Две диаграммы, Четыре диаграммы
- Анализ данных с помощью сводных таблиц
- Фильтрация данных: фильтры, срезы, временная шкала. Подключение фильтров к отчетам
- Скрытие/отображение полей из набора клиентских средств
- Создание и управление наборами
- Вычисления в сводных таблицах
- Форматирование отчета: макеты, условное форматирование
- Создание и управление ключевыми показателями эффективности
- Практические упражнения
Динамические отчеты PowerView
- Модель данных
- Создание таблицы
- Статистическая обработка числовых полей
- Преобразование таблиц в другие представления:
- Круговые, точечные, линейчатые и пузырьковые диаграммы
- Матрицы
- Мозаичные элементы
- Фильтрация, выделение, срезы
- Практические упражнения
Визуализация данных на географической карте с Power Map
- Источник для построения отчета
- Работа со слоями
- Создание/изменение визуализации:
- Карты
- Данных
- Создание видео по данным отчета
- Практические упражнения
-
Получаемый документ
-
Необходимая подготовка
Желательно прохождение курса Microsoft Excel 2019/2016. Продвинутый уровень
-
Цель курса
Формирование знаний и навыков, связанных с бизнес - аналитикой с использованием PowerPivot и PowerView.
Преподаватели
Рекомендуемые курсы
- Создавать сложные формулы массивов для обработки данных с использованием встроенных функций разных категорий
- Выбирать оптимальные стратегии решений с помощью Сценариев и Таблиц данных
- Решать задачи одно- и многокритериальной оптимизации
- Строить нестандартные типы диаграмм для наглядного сравнения и анализа числовых данных.
- Управлять данными диаграммы с помощью пользовательских элементов управления
- Прогнозировать развитие ситуаций разными способами, в том числе с учетом сезонности
- Использовать быстрый прогноз с использованием листа прогноза
- Импортировать данные из внешних источников: web, текстовых файлов (*.txt, *.csv)
- Создавать запросы к внешним данным с использованием редактора Microsoft Query
- Строить отчеты сводных таблиц по данным OLAP-куба
По окончании курса Вы будете уметь:
- Создавать сложные формулы массивов для обработки данных с использованием встроенных функций разных категорий
- Выбирать оптимальные стратегии решений с помощью Сценариев и Таблиц данных
- Решать задачи одно- и многокритериальной оптимизации
- Строить нестандартные типы диаграмм для наглядного сравнения и анализа числовых данных.
- Управлять данными диаграммы с помощью пользовательских элементов управления
- Прогнозировать развитие ситуаций разными способами, в том числе с учетом сезонности
- Использовать быстрый прогноз с использованием листа прогноза
- Импортировать данные из внешних источников: web, текстовых файлов (*.txt, *.csv)
- Создавать запросы к внешним данным с использованием редактора Microsoft Query
- Строить отчеты сводных таблиц по данным OLAP-куба
- Загружать данные в модель данных PowerPivot из внешних источников
- Создавать связи между таблицами в модели данных
- Импортировать данные в модель PowerPivot с использованием PowerQuery
- Редактировать, создавать вычисления, объединять и добавлять запросы PowerQuery
- Выполнять анализ и моделирование данных с помощью PowerPivot
- Строить DAX-формулы для получения результатов обработки как по простым формулам, так и с применением функций различных категорий, создавая как вычисляемые поля, так и вычисляемые столбцы
- Выполнять построение комбинированных отчетов как в виде сводных таблиц, так и сводных диаграмм
- Создавать интуитивно понятные специализированные динамические отчеты Power View для представления данных в виде таблицы, матрицы, наборов различных диаграмм и управлять данными отчета
- Строить наглядные отчеты для анализа данных с привязкой к географическому расположению как с PowerView, так и с Power Map
Полученные данные можно будет представить в комбинированных отчетах сводных таблиц и сводных диаграмм, причем как зависимых, так и независимых друг от друга. Вы научитесь строить интуитивно понятные динамические отчеты PowerView для изучения, визуализации и представления данных как в табличном, так и графическом виде.
PowerPivot, PowerQuery, PowerView и PowerMap – это мощные современные инструменты анализа данных в Microsoft Excel!
По окончании курса Вы будете уметь:
- Загружать данные в модель данных PowerPivot из внешних источников
- Создавать связи между таблицами в модели данных
- Импортировать данные в модель PowerPivot с использованием PowerQuery
- Редактировать, создавать вычисления, объединять и добавлять запросы PowerQuery
- Выполнять анализ и моделирование данных с помощью PowerPivot
- Строить DAX-формулы для получения результатов обработки как по простым формулам, так и с применением функций различных категорий, создавая как вычисляемые поля, так и вычисляемые столбцы
- Выполнять построение комбинированных отчетов как в виде сводных таблиц, так и сводных диаграмм
- Создавать интуитивно понятные специализированные динамические отчеты Power View для представления данных в виде таблицы, матрицы, наборов различных диаграмм и управлять данными отчета
- Строить наглядные отчеты для анализа данных с привязкой к географическому расположению как с PowerView, так и с Power Map
Формирование знаний и навыков, связанных с бизнес - аналитикой с использованием PowerPivot и PowerView.
[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>Microsoft Excel 2019/2016. Продвинутый уровень</b> [TYPE] => HTML ) [PROPERTY_VALUE_ID] => 20896348 [DESCRIPTION] => [~VALUE] => Array ( [TEXT] => Желательно прохождение курса Microsoft Excel 2019/2016. Продвинутый уровень [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="612" alt="Сертификат.jpg" src="/upload/medialibrary/b37/b370784d3f620d37311f6ecb970a4aec.jpg" height="420" title="Сертификат.jpg"> [TYPE] => HTML ) [PROPERTY_VALUE_ID] => 20901305 [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] => 20893825 [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] => 2852 [1] => 10420 [2] => 163 ) [PROPERTY_VALUE_ID] => Array ( [0] => 20901310 [1] => 20901311 [2] => 20901312 ) [DESCRIPTION] => Array ( [0] => [1] => [2] => ) [~VALUE] => Array ( [0] => 2852 [1] => 10420 [2] => 163 ) [~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] => 26254 ) [PROPERTY_VALUE_ID] => Array ( [0] => 21364366 ) [DESCRIPTION] => Array ( [0] => ) [~VALUE] => Array ( [0] => 26254 ) [~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] => 26255 [1] => 26256 [2] => 26257 [3] => 26258 [4] => 26259 [5] => 26260 ) [PROPERTY_VALUE_ID] => Array ( [0] => 21364367 [1] => 21364368 [2] => 21364369 [3] => 21364370 [4] => 21364371 [5] => 21364372 ) [DESCRIPTION] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => ) [~VALUE] => Array ( [0] => 26255 [1] => 26256 [2] => 26257 [3] => 26258 [4] => 26259 [5] => 26260 ) [~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] => 12260 [1] => 12257 [2] => 12256 [3] => 12258 ) [PROPERTY_VALUE_ID] => Array ( [0] => 20901313 [1] => 20901314 [2] => 20901315 [3] => 20901316 ) [DESCRIPTION] => Array ( [0] => [1] => [2] => [3] => ) [~VALUE] => Array ( [0] => 12260 [1] => 12257 [2] => 12256 [3] => 12258 ) [~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] => 21375247 [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_PP [PROPERTY_VALUE_ID] => 21337839 [DESCRIPTION] => [~VALUE] => Excel_PP [~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] => 21389981 [DESCRIPTION] => [~VALUE] => 3205 [~DESCRIPTION] => ) [POST_TEACHERS] => ) [DISPLAY_PROPERTIES] => Array ( ) [IPROPERTY_VALUES] => Array ( [ELEMENT_META_DESCRIPTION] => Access, SQL-сервер, OLAP-куб, файлы Excel и т.д., загружая их в модель PowerPivot напрямую или предварительно обработав в PowerQuery. При необходимости создавать связи между всеми этими источниками, выполнять различные расчеты, как с использованием простых вычислений, так и с применением функций. Вы больше не будете зависеть от разработчиков, т.к. все отчеты Вы сможете строить сами.<br> <br> Полученные данные можно будет представить в комбинированных отчетах сводных таблиц и сводных диаграмм, причем как зависимых, так и независимых друг от друга. Вы научитесь строить интуитивно понятные динамические отчеты PowerView для изучения, визуализации и представления данных как в табличном, так и графическом виде. <br> PowerPivot, PowerQuery, PowerView и PowerMap – это мощные современные инструменты анализа данных в Microsoft Excel!<br> <br> <b>По окончании курса Вы будете уметь:</b><br> <br> <ul> <li> Загружать данные в модель данных PowerPivot из внешних источников</li> <li> Создавать связи между таблицами в модели данных</li> <li> Импортировать данные в модель PowerPivot с использованием PowerQuery</li> <li> Редактировать, создавать вычисления, объединять и добавлять запросы PowerQuery</li> <li> Выполнять анализ и моделирование данных с помощью PowerPivot</li> <li> Строить DAX-формулы для получения результатов обработки как по простым формулам, так и с применением функций различных категорий, создавая как вычисляемые поля, так и вычисляемые столбцы</li> <li> Выполнять построение комбинированных отчетов как в виде сводных таблиц, так и сводных диаграмм</li> <li> Создавать интуитивно понятные специализированные динамические отчеты Power View для представления данных в виде таблицы, матрицы, наборов различных диаграмм и управлять данными отчета</li> <li> Строить наглядные отчеты для анализа данных с привязкой к географическому расположению как с PowerView, так и с Power Map</li> </ul> [ELEMENT_META_TITLE] => Microsoft Excel 2019/2016. Бизнес - аналитика с использованием PowerPivot и PowerView ) )
- программировать сложные процедуры с вложенными циклами, использующие массивы переменных
- автоматизировать работу с файловой системой, использовать диалоги для выбора файлов и папок
- автоматизировать создания 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 отзывов
Об этом курсе отзывов пока нет. Будьте первым.
Чтобы оставить отзыв необходимо авторизоваться на сайте или зарегистрироваться.