academy@academyit.ru
Excel_F
Пользователь Microsoft Windows/Office
2 дня /16 часов
Microsoft Excel 2019/2016. Базовый уровень
0 0
Физлицам
8900 ₽
Юрлицам
9500 ₽
Очное обучение.
Курсы проводятся во всех региональных учебных центрах Академии АйТи или на базе заказчика.
Забронировать курс
Спасибо за интерес к нашему курсу! Обратитесь через форму «Запросить информацию» для получения более точной информации о датах обучения.
-
Аннотация
В курсе будет рассмотрен как функционал, общий для версий Microsoft Excel 2019/2016, так и новые возможности MS Excel 2016, такие как быстрый анализ таблиц и настройка диаграмм.
-
Описание образовательной программы
По окончании курса Вы будете уметь:
- Понимать структуру книги Excel
- Правильно вводить данные, использовать заполнение ячеек списками и данных прогрессий
- Осуществлять вычисления по формулам с использованием данных, находящихся как на одном, так и на разных листах
- Получать результаты расчета данных по функциям
- Оформлять таблицы в соответствии с любыми требованиями
- Строить диаграммы для наглядного представления табличных данных
- Осуществлять сортировку и фильтровку данных
- Подготовить и вывести на печать как таблицу, так и диаграмму
Целевая аудитория
Специалисты различного профиля, использующие электронные таблицы в своей деятельности
Содержание
1
Работа с листами книги. Ввод данных
- Интерфейс Microsoft Excel: лента, вкладки, группы, значки, помощник
- Вкладка Файл, панель Быстрого доступа
- Структура книги. Операции с листами: переименование, вставка, удаление, перемещение, копирование
- Основные действия с элементами листа: ячейками, строками, столбцами
- Особенности ввода данных. Редактирование
- Установка форматов данных
- Очистка содержимого и форматов
- Автоматическое заполнение ячеек листа данными:
- Прогрессии: арифметическая и геометрическая
- Списки: встроенные и пользовательские
2
Вычисления в Microsoft Excel
- Создание и редактирование формул
- Копирование формул
- Использование разных видов ссылок в расчетах:
- Относительные ссылки
- Абсолютные ссылки
- Ссылки на ячейки других листов
- Использование именованных ячеек в формулах
- Встроенные функции Excel:
- Логическая функция ЕСЛИ
- Математические и Статистические: СУММ, МИН, МАКС, СРЗНАЧ, СЧЁТ
- Ошибки в формулах: причины возникновения и действия по исправлению
3
Оформление таблиц. Построение диаграмм
- Оформление ячеек: формат числа, границы, заливка, выравнивание данных
- Автоформаты таблиц
- Условное форматирование
- Добавление примечаний к ячейкам. Изменение, копирование, просмотр и отображение примечаний
- Копирование форматов. Очистка форматирования
- Работа с диаграммами:
- Построение: рекомендуемые диаграммы, комбинированные диаграммы
- Настройка диаграммы: элементы диаграммы, стили диаграмм, фильтрация рядов и категорий
- Редактирование и удаление диаграммы
4
Обработка таблиц. Печать таблиц
- Быстрый анализ таблиц: форматирование, диаграммы, итоги, таблицы, спарклайны
- Сортировка данных:
- Сортировка по одному столбцу
- Многоуровневая сортировка
- Фильтрация (выбор) данных
- Закрепление областей для постоянного отображения строк/столбцов на экране
- Подготовка к печати:
- Колонтитулы: создание и форматирование.
- Настройка параметров страницы: поля, размер, ориентация
- Печать Сквозных строк/столбцов
- Настройка области печати
- Печать таблиц и диаграмм
-
Получаемый документ
-
Цель курса
Формирование знаний и практических навыков по использованию Microsoft Excel 2019/2016. Базовый уровень
Рекомендуемые курсы
Пользователь Microsoft Windows/Office
Microsoft Excel 2019/2016. Продвинутый уровень
Excel_A
Академия АйТи
2 дня /16 часов
Excel_A
Академия АйТи
2 дня /16 часов
8900 ₽
Пользователь 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. Углубленное программирование
)
)
0 отзывов
Об этом курсе отзывов пока нет. Будьте первым.
Чтобы оставить отзыв необходимо авторизоваться на сайте или зарегистрироваться.
