excel -移花宫 -武林禁地，闲人禁止入内

«Excel Базовый» + «Excel Эксперт»

2. Эксперт/Блок 8/8.2 Среда программирования, отладчик. Конструкции языка/8-2.mp4 600.0 MB
2. Эксперт/Блок 3/3.2 Решение задач оптимизации с помощью «Поиск решения»/3-2.mp4 407.0 MB
1. Базовый/Блок 3/3.1 Работа с формулами. Простейшие формулы (арифметические действия, сложение строк)/3-1.mp4 397.2 MB
2. Эксперт/Блок 7/7.2 Просмотр и улучшение автоматически созданного кода/7-2.mp4 360.8 MB
2. Эксперт/Блок 7/7.1 Создание макросов через макрорекордер/7-1.mp4 314.4 MB
1. Базовый/Блок 4/4.1 Способы ввода функций. Мастер функций. Копирование ячеек с формулами. Функция ВПР/4-1.mp4 301.7 MB
2. Эксперт/Блок 6/6.2 Импорт, экспорт данных из БД/6-2.mp4 275.4 MB
2. Эксперт/Блок 5/5.3 Инструменты многофакторного прогнозирования/5-3.mp4 243.1 MB
1. Базовый/Блок 5/5.4 Функции СЧЁТЕСЛИМН, СУММЕСЛИМН. Операторы для выборки/5-4.mp4 239.3 MB
1. Базовый/Блок 7/7.4 Макеты и стили диаграмм/7-4.mp4 234.8 MB
2. Эксперт/Блок 1/1.3 Двухсторонний, многокритериальный поиск/1-3.mp4 192.7 MB
2. Эксперт/Блок 5/5.2 Многоуровневые диаграммы, проектные диаграммы/5-2.mp4 192.5 MB
1. Базовый/Блок 3/3.2 Виды функций. Способы ввода функций. Поиск функций для английской версии Excel/3-2.mp4 190.0 MB
1. Базовый/Блок 6/6.2 Ошибки в формулах, обработка. Функция ЕСЛИОШИБКА/6-2.mp4 176.6 MB
1. Базовый/Блок 2/2.2 Копирование, вырезание, вставка строк, столбцов и ячеек. Вставка вместо существующих данных, вставка со сдвигом/2-2.mp4 176.4 MB
1. Базовый/Блок 4/4.5 Текстовые формулы СЖПРОБЕЛЫ, ПРОПНАЧ, ЛЕВСИМВ, ПРАВСИМВ, ПРОПИСН/4-5.mp4 173.3 MB
2. Эксперт/Блок 6/6.1 Импорт, экспорт данных, обновление, изменение/6-1.mp4 171.4 MB
2. Эксперт/Блок 2/2.1 Расширенный фильтр (совокупность нескольких выборок)/2-1.mp4 171.3 MB
1. Базовый/Блок 6/6.1 Функции ИНДЕКС, ПОИСКПОЗ. Расширенный аналог функции ВПР/6-1.mp4 170.4 MB
1. Базовый/Блок 5/5.3 Функции СЧЁТЕСЛИ, СУММЕСЛИ. Подсчёт и подсуммирование записей по условию/5-3.mp4 166.1 MB

[磁力链接] 添加时间:2021-03-11 大小:9.2 GB 最近下载:2025-03-13 热度:15511

[DesireCourse.Com] Udemy - Microsoft Excel - The Xtreme Excel Pivot Tables Course

14. DATA MANAGEMENT/1.1 CHAPTER_13.zip.zip 114.0 MB
16. NEW EXCEL 2013 PIVOT TABLE FEATURES/6. Data Models.mp4 78.8 MB
16. NEW EXCEL 2013 PIVOT TABLE FEATURES/5. Timelime Slicers.mp4 40.5 MB
10. PIVOT CHARTS/22. CASE STUDY ~ FINANCIAL Pivot Table Slicer & Chart Dashboard.mp4 29.0 MB
1. Chapter 1/1. INTRODUCTION.mp4 27.4 MB
16. NEW EXCEL 2013 PIVOT TABLE FEATURES/3. Recommended Pivot Tables.mp4 26.7 MB
18. BONUS THE MYEXCELONLINE ACADEMY!/1. The MyExcelOnline Academy Online Course.mp4 23.3 MB
16. NEW EXCEL 2013 PIVOT TABLE FEATURES/2. Cosmetic changes in the PivotTable Tools Ribbon Menu.mp4 22.6 MB
16. NEW EXCEL 2013 PIVOT TABLE FEATURES/4. Distinct Count.mp4 21.2 MB
9. CALCULATED FIELDS & ITEMS/16. CASE STUDY ~ ACCOUNTING Creating a P&L Pivot Table Report.mp4 21.1 MB
15. BONUS VIDEOS/7. Interactive Balance Sheet Pivot Table.mp4 20.0 MB
17. NEW EXCEL 2016 PIVOT TABLE FEATURES/2. Group Periods.mp4 19.1 MB
17. NEW EXCEL 2016 PIVOT TABLE FEATURES/5. 3D Maps.mp4 19.0 MB
9. CALCULATED FIELDS & ITEMS/17. CASE STUDY ~ FINANCIAL Actuals v Plan with Calculated Fields.mp4 18.0 MB
10. PIVOT CHARTS/21. CASE STUDY ~ ACCOUNTING P&L Pivot Table report with Graphs.mp4 15.7 MB
5. GROUPING/17. CASE STUDY ~ ACCOUNTING Quarterly Comparative Report.mp4 15.0 MB
8. SLICERS (NEW IN EXCEL 2010)/12. TIP Interactive employee photos with Slicers! FUN!.mp4 13.9 MB
12. GETPIVOTDATA Formula/8. CASE STUDY ~ ACCOUNTING Live forecasting with GETPIVOTDATA.mp4 13.0 MB
10. PIVOT CHARTS/19. TIP Change Chart Type with Slicers! FUN!!!.mp4 12.7 MB
17. NEW EXCEL 2016 PIVOT TABLE FEATURES/4. Pivot Chart - Expand and Collapse fields.mp4 12.2 MB

[磁力链接] 添加时间:2021-03-11 大小:1.5 GB 最近下载:2025-03-12 热度:1260

[Tutorialsplanet.NET] Udemy - Advanced Excel Top Excel Tips & Formulas

3. Top 10 Excel Formulas for Quick & Dynamic Analysis/7. Formula 5 - INDEX & MATCH for Complex Real-Cases.mp4 199.6 MB
3. Top 10 Excel Formulas for Quick & Dynamic Analysis/11. Formula 7 - Excel's Top Date Functions.mp4 169.3 MB
3. Top 10 Excel Formulas for Quick & Dynamic Analysis/2. Formula 1 - SUMIFS, COUNTIFS, AVERAGEIFS to Account for Exceptions.mp4 142.8 MB
2. Top 10 Excel Tips to Save You Time/12. Tip 8 - Improve Presentation with Customized Number Formatting.mp4 135.2 MB
3. Top 10 Excel Formulas for Quick & Dynamic Analysis/10. Formula 6 - Advanced TEXT functions.mp4 129.5 MB
3. Top 10 Excel Formulas for Quick & Dynamic Analysis/5. Formula 4 - VLOOKUP & HLOOKUP For Dynamic Lookups.mp4 122.4 MB
3. Top 10 Excel Formulas for Quick & Dynamic Analysis/14. Formula 10 - SUMPRODUCT For the Gurus.mp4 116.3 MB
3. Top 10 Excel Formulas for Quick & Dynamic Analysis/9. Formula 6 - The Most Useful Text Functions.mp4 108.3 MB
3. Top 10 Excel Formulas for Quick & Dynamic Analysis/3. Formula 2 - IF (Nested Functions) Because Data Analysis is Often Not Simple.mp4 101.4 MB
2. Top 10 Excel Tips to Save You Time/16. Tip 10 - PivotTables Valuable Design Tips.mp4 96.0 MB
1. Introduction, Scope & Excel Files/1. Advanced Excel - Introduction & Scope.mp4 85.6 MB
3. Top 10 Excel Formulas for Quick & Dynamic Analysis/6. Formula 5 - INDEX & MATCH for Flexible Lookups.mp4 76.6 MB
2. Top 10 Excel Tips to Save You Time/8. Tip 5 - Use Protection Appropriately.mp4 75.6 MB
2. Top 10 Excel Tips to Save You Time/15. Tip 10 - PivotTables Calculated Fields, Slicers & Helpful Tricks.mp4 73.6 MB
3. Top 10 Excel Formulas for Quick & Dynamic Analysis/1. Overview of Top Excel Formulas.mp4 72.7 MB
2. Top 10 Excel Tips to Save You Time/3. Tip 2 - Master the Simpler Tasks Part 1.mp4 66.8 MB
3. Top 10 Excel Formulas for Quick & Dynamic Analysis/13. Formula 9 - FREQUENCY, SMALL & LARGE to Organize and Rank.mp4 65.6 MB
2. Top 10 Excel Tips to Save You Time/10. Tip 6 - Import Text, CSV & Web Data Properly.mp4 64.9 MB
2. Top 10 Excel Tips to Save You Time/14. Tip 10 - Use Excel PivotTables for Super Fast Analysis.mp4 62.2 MB
2. Top 10 Excel Tips to Save You Time/2. Tip 1 - Become Faster with Excel's Keyboard Shortcuts.mp4 57.2 MB

[磁力链接] 添加时间:2021-03-12 大小:2.6 GB 最近下载:2025-03-11 热度:862

Excel VBA programming by Examples (MS Excel 2016)

[TutsNode.com] - Excel VBA programming by Examples/3. Excel VBA workout examples/23. Workout Exp 13 - Recursive file size of all the files n folders within a folder.mp4 133.4 MB
[TutsNode.com] - Excel VBA programming by Examples/3. Excel VBA workout examples/24. Workout Exp 14 Combine multiple files through VBA.mp4 126.5 MB
[TutsNode.com] - Excel VBA programming by Examples/3. Excel VBA workout examples/14. Workout Example 8 - Part A- Using Pivot Table, VLOOKUP etc. inside a VBA code.mp4 40.1 MB
[TutsNode.com] - Excel VBA programming by Examples/3. Excel VBA workout examples/15. Workout Example 8 - Part B- Using Pivot Table, VLOOKUP etc. inside a VBA code.mp4 38.3 MB
[TutsNode.com] - Excel VBA programming by Examples/2. Understand VBA development environment and VBA syntax/3. Understand Excel VBA syntax continued .....mp4 35.8 MB
[TutsNode.com] - Excel VBA programming by Examples/3. Excel VBA workout examples/7. Workout Example 3 - Part B - One sheet per agent or product.mp4 35.4 MB
[TutsNode.com] - Excel VBA programming by Examples/3. Excel VBA workout examples/6. Workout Example 3 - Part A - One sheet per agent or product.mp4 33.7 MB
[TutsNode.com] - Excel VBA programming by Examples/2. Understand VBA development environment and VBA syntax/2. Understand Excel VBA syntax.mp4 32.1 MB
[TutsNode.com] - Excel VBA programming by Examples/2. Understand VBA development environment and VBA syntax/4. Understand conditional execution (if else conditions).mp4 28.8 MB
[TutsNode.com] - Excel VBA programming by Examples/3. Excel VBA workout examples/5. Workout Example 2 - Fetching data from MS Access database using Excel.mp4 28.4 MB
[TutsNode.com] - Excel VBA programming by Examples/3. Excel VBA workout examples/8. Workout Example 4 - Part A - Coupon Assignment and Inventory management.mp4 27.3 MB
[TutsNode.com] - Excel VBA programming by Examples/2. Understand VBA development environment and VBA syntax/1. Understand Excel VBA integrated development environment.mp4 27.3 MB
[TutsNode.com] - Excel VBA programming by Examples/1. Course Introduction and automation without coding/2. Automate without coding - recording macro with relative reference.mp4 26.0 MB
[TutsNode.com] - Excel VBA programming by Examples/3. Excel VBA workout examples/4. Workout Example 1 - Part C - Explanation of demo Excel VBA form & code.mp4 25.5 MB
[TutsNode.com] - Excel VBA programming by Examples/3. Excel VBA workout examples/9. Workout Example 4 - Part B - Coupon Assignment and Inventory management.mp4 25.5 MB
[TutsNode.com] - Excel VBA programming by Examples/3. Excel VBA workout examples/11. Workout Example 6 - Part A- Design survey form in excel VBA (deal with list etc..mp4 24.9 MB
[TutsNode.com] - Excel VBA programming by Examples/3. Excel VBA workout examples/2. Workout Example 1 - Part B 01- Design your first Excel VBA form.mp4 23.8 MB
[TutsNode.com] - Excel VBA programming by Examples/3. Excel VBA workout examples/3. Workout Example 1 - Part B 02- Design your first Excel VBA form.mp4 22.2 MB
[TutsNode.com] - Excel VBA programming by Examples/3. Excel VBA workout examples/18. Workout Exp 10 - Reading worksheet data into a table and Running SQL inside VBA,.mp4 20.6 MB
[TutsNode.com] - Excel VBA programming by Examples/3. Excel VBA workout examples/22. Workout Exp 12 - Schedule a VBA macro to run as per schedule.mp4 19.7 MB

[磁力链接] 添加时间:2021-03-12 大小:888.8 MB 最近下载:2025-03-12 热度:1960

Unlock Excel VBA and Excel Macros

Unlock Excel VBA and Excel Macros/14. Main Project #2 Sales Regional Reporting Tool/4. Setting up a Template as the Basis for Different Reports.mp4 325.5 MB
Unlock Excel VBA and Excel Macros/18. Main Project #3 Invoice Generation Tool/8. Export PDF & Excel Workbook for Each Invoice based on ListBox Selection.mp4 294.1 MB
Unlock Excel VBA and Excel Macros/18. Main Project #3 Invoice Generation Tool/10. Final Updates & Debugging.mp4 250.4 MB
Unlock Excel VBA and Excel Macros/17. Working with Userforms & ActiveX Controls/9. UserForm to Document External Links & Comments (Combo Box & Option button).mp4 245.7 MB
Unlock Excel VBA and Excel Macros/13. Excel Tables, Formulas & Pivot Tables/4. Pivot Tables & VBA What you Need to Know.mp4 237.6 MB
Unlock Excel VBA and Excel Macros/12. Working with Files, Folders & Text Files/8. Project Export Data to Text file (fix Delimiter to Semicolon).mp4 235.8 MB
Unlock Excel VBA and Excel Macros/18. Main Project #3 Invoice Generation Tool/7. MultiPage UserForm to Create Invoices & Email (Setup).mp4 229.5 MB
Unlock Excel VBA and Excel Macros/14. Main Project #2 Sales Regional Reporting Tool/3. Importing Data from Multiple Files using MultiSelect.mp4 218.7 MB
Unlock Excel VBA and Excel Macros/10. Looping in VBA (Controlling the Flow of Code)/3. For Next Nested Loop (Loop through Text & Cells).mp4 218.4 MB
Unlock Excel VBA and Excel Macros/18. Main Project #3 Invoice Generation Tool/6. Enhanced Searchable ListBox Write Selection back to Excel Table.mp4 214.1 MB
Unlock Excel VBA and Excel Macros/2. Your First Macro/4. Project Dynamic Cell Selection (Special Cells) - Perfect for Flexible Macros.mp4 211.2 MB
Unlock Excel VBA and Excel Macros/17. Working with Userforms & ActiveX Controls/7. UserForm Basics What You Need to Get Started.mp4 202.5 MB
Unlock Excel VBA and Excel Macros/13. Excel Tables, Formulas & Pivot Tables/3. Excel Tables Use the Right Syntax.mp4 199.6 MB
Unlock Excel VBA and Excel Macros/7. Useful Built-in Functions/7. Project Show Top 3 Values in a Message box based on Range Selected.mp4 198.6 MB
Unlock Excel VBA and Excel Macros/14. Main Project #2 Sales Regional Reporting Tool/5. Exporting Reports as Excel files (Pivot Table & Hard Coded Reports).mp4 197.3 MB
Unlock Excel VBA and Excel Macros/15. Interacting with Other Applications (Word, PowerPoint etc.)/5. Project Microsoft PowerPoint Export Excel Sheets to PowerPoint Presentation.mp4 194.4 MB
Unlock Excel VBA and Excel Macros/19. Create your own Custom Functions/7. Project Function That Sums based on Cell Color.mp4 190.9 MB
Unlock Excel VBA and Excel Macros/18. Main Project #3 Invoice Generation Tool/2. Setting up an Input UserForm to Collect Master Data.mp4 186.8 MB
Unlock Excel VBA and Excel Macros/18. Main Project #3 Invoice Generation Tool/9. Create Email in Outlook & Attach PDF Invoice.mp4 184.1 MB
Unlock Excel VBA and Excel Macros/15. Interacting with Other Applications (Word, PowerPoint etc.)/4. Project Microsoft Word Create Personalized Letters in Word from Excel.mp4 178.0 MB

[磁力链接] 添加时间:2021-03-12 大小:12.5 GB 最近下载:2025-03-13 热度:1580

Progredindo com Excel - Curso Excel Usuários Intermediários

25. Google Drive/4. Formulário.mp4 317.9 MB
6. Exercícios - Ninja Nível 3/1. Exercício Prático #1.mp4 298.4 MB
13. Funções - Texto/1. Visão Geral.mp4 286.2 MB
11. Funções - Lógica/6. VERDADEIRO & FALSO.mp4 280.7 MB
3. Trabalhando com Dados/7. Filtrar.mp4 266.6 MB
27. Bom Saber/1. Protegendo-se Online.mp4 264.0 MB
19. Funções - Informação/8. Top 10 Funções.mp4 261.5 MB
7. Exibindo Dados/2. Agrupar.mp4 256.3 MB
19. Funções - Informação/2. CÉL.mp4 255.7 MB
17. Funções - Proc & Referências/1. Visão Geral.mp4 251.2 MB
10. Exercícios - Ninja Nível 5/8. Exercício Prático #8.mp4 244.4 MB
5. Progredindo com Dados/2. Texto para Colunas.mp4 236.2 MB
7. Exibindo Dados/3. Subtotal.mp4 233.9 MB
5. Progredindo com Dados/9. Testes de Hipóteses - Tabela de Dados.mp4 233.5 MB
3. Trabalhando com Dados/6. Procv & Clasificar.mp4 230.7 MB
6. Exercícios - Ninja Nível 3/10. Exercício Prático #10.mp4 229.2 MB
15. Funções - Data & Hora/1. Data & Hora.mp4 228.7 MB
13. Funções - Texto/8. Cortando Texto.mp4 221.0 MB
25. Google Drive/1. Introdução.mp4 218.4 MB
7. Exibindo Dados/8. Formatando Gráficos II.mp4 217.6 MB

[磁力链接] 添加时间:2021-03-12 大小:23.2 GB 最近下载:2025-03-14 热度:2943

[ FreeCourseWeb.com ] Udemy - Excel for Data Analysis. Learn the Art of Excel Analytics.zip

[ FreeCourseWeb.com ] Udemy - Excel for Data Analysis. Learn the Art of Excel Analytics.zip 2.8 GB

[磁力链接] 添加时间:2021-03-12 大小:2.8 GB 最近下载:2025-03-10 热度:1911

[FreeCourseSite.com] Udemy - Microsoft Excel - Advanced Excel Formulas & Functions

10. Badass Bonus Functions/5. NEW Open Weather Map WEBSERVICE Demo.mp4 96.7 MB
4. Statistical Functions/9. NEW Combining COUNTIF & SUMPRODUCT.mp4 76.7 MB
10. Badass Bonus Functions/4. Tapping into Real-Time Data with WEBSERVICE & FILTERXML.mp4 75.3 MB
6. Text Functions/5. TEXTVALUE.mp4 58.1 MB
5. LookupReference Functions/8. NEW Fuzzy Match Lookups.mp4 48.7 MB
6. Text Functions/8. Combining RIGHT, LEN, and SEARCH.mp4 43.9 MB
5. LookupReference Functions/7. VLOOKUP Reference Array Options.mp4 42.1 MB
5. LookupReference Functions/5. Joining Data with VLOOKUP.mp4 39.6 MB
6. Text Functions/7. Categorizing Data with IF(ISNUMBER(SEARCH)).mp4 35.2 MB
4. Statistical Functions/6. NEW SUMPRODUCT Demo.mp4 32.8 MB
6. Text Functions/6. SEARCHFIND.mp4 32.6 MB
5. LookupReference Functions/16. PROJECT SHOWCASE Using OFFSET to create a dynamic scrolling chart.mp4 31.8 MB
10. Badass Bonus Functions/2. The INDIRECT Function.mp4 31.6 MB
3. Conditional Statements & Logical Operators/4. ANDOR Operators.mp4 29.6 MB
5. LookupReference Functions/12. Combining MATCH with VLOOKUP.mp4 27.9 MB
7. Date & Time Functions/10. PROJECT SHOWCASE Designing a Sample Budget Pacing Tool.mp4 27.4 MB
8. Formula-Based Formatting/5. Formatting Cells Using Statistical Functions.mp4 25.5 MB
5. LookupReference Functions/11. Using INDEX & MATCH together.mp4 24.9 MB
6. Text Functions/3. The CONCATENATE Function (&).mp4 24.8 MB
4. Statistical Functions/8. PROJECT SHOWCASE Building a Basic Dashboard with COUNTIFS & SUMIFS.mp4 24.7 MB

[磁力链接] 添加时间:2021-03-12 大小:1.6 GB 最近下载:2025-03-09 热度:2900

[Академия Excel] Дмитрий Якушев - Основы написания макросов в Excel (2019)

2. Макросы. Копируем, удаляем. Циклы/#2 из 6. Макросы. Копируем, удаляем. Циклы.mp4 658.4 MB
1. Макросы. Минимум необходимой теории/#1 из 6. Макросы. Минимум необходимой теории.mp4 621.2 MB
6. Графики OutLook Word/#6 из 6. Графики OutLook Word.mp4 520.6 MB
3. Макросы. Проверка условий.Циклы. Массовое формирование документов/#3 из 6. Макросы. Проверка условий.Циклы. Массовое формирова.mp4 510.3 MB
4. Работа с пользователями через UserForm/#4 из 6. Работа с пользователями через UserForm.mp4 506.8 MB
5. Ломаем файлы, делаем тесты/[#5 из 6. Ломаем файлы, делаем тесты.mp4 426.1 MB
0. Автоматизация рутины в Excel/Урок 2. Объектная модель/Урок 2.2. WorkBooks и Worksheets.mp4 78.3 MB
0. Автоматизация рутины в Excel/Урок 2. Объектная модель/Урок 2.5. Range_Cells (свойства).mp4 72.0 MB
0. Автоматизация рутины в Excel/Урок 2. Объектная модель/Урок 2.4. Range_Cells (обращение).mp4 63.5 MB
0. Автоматизация рутины в Excel/Урок 1. Основы написания макросов/1.4. Первый макрос. Пишем код с нуля.mp4 63.4 MB
0. Автоматизация рутины в Excel/Урок 1. Основы написания макросов/1.5. Макрорекодер - наш помощник.mp4 53.0 MB
0. Автоматизация рутины в Excel/Урок 2. Объектная модель/Урок 2.3. Свойства и методы (WorkBook и WorkSheets).mp4 43.7 MB
0. Автоматизация рутины в Excel/Урок 9. Диалог с пользователем/Урок 9.1. MsgBox (Part I - настраиваем внешний вид).mp4 43.5 MB
0. Автоматизация рутины в Excel/Урок 1. Основы написания макросов/1.3. Редактор VBE.mp4 41.7 MB
0. Автоматизация рутины в Excel/Урок 11. Строим сводные таблицы макросом/Урок 11.1. Создание КЭШ сводной и первый способ построения.mp4 38.9 MB
0. Автоматизация рутины в Excel/Урок 11. Строим сводные таблицы макросом/Урок 11.3. Построение (наполняем полями).mp4 37.1 MB
0. Автоматизация рутины в Excel/Урок 10. Функции VBA/Урок 10.7. Дата и время (Функции VBA).mp4 34.3 MB
0. Автоматизация рутины в Excel/Урок 10. Функции VBA/Урок 10.8. Дата и время (VBA - разбиваем на составные части).mp4 34.3 MB
0. Автоматизация рутины в Excel/Урок 2. Объектная модель/Урок 2.1. Объектная модель.mp4 33.9 MB
0. Автоматизация рутины в Excel/Урок 3. Свойства и методы Application, ActiveWorkbook, Worksheet/Урок 3.2. Свойства Application (Часть 2 - Отключаем системны.mp4 33.3 MB

[磁力链接] 添加时间:2021-03-13 大小:4.9 GB 最近下载:2025-03-12 热度:9345

[DMC.RIP] [Skillbox] «Excel Базовый» + «Excel Эксперт» (2019)

Эксперт/Блок 8/8.2 Среда программирования, отладчик. Конструкции языка/8-2.mp4 600.0 MB
Эксперт/Блок 3/3.2 Решение задач оптимизации с помощью «Поиск решения»/3-2.mp4 407.0 MB
Базовый/Блок 3/3.1 Работа с формулами. Простейшие формулы (арифметические действия, сложение строк)/3-1.mp4 397.2 MB
Эксперт/Блок 7/7.2 Просмотр и улучшение автоматически созданного кода/7-2.mp4 360.8 MB
Эксперт/Блок 7/7.1 Создание макросов через макрорекордер/7-1.mp4 314.4 MB
Базовый/Блок 4/4.1 Способы ввода функций. Мастер функций. Копирование ячеек с формулами. Функция ВПР/4-1.mp4 301.7 MB
Эксперт/Блок 6/6.2 Импорт, экспорт данных из БД/6-2.mp4 275.4 MB
Эксперт/Блок 1/1.2 Формулы массивов с функциями/1-2.mp4 274.1 MB
Эксперт/Блок 5/5.3 Инструменты многофакторного прогнозирования/5-3.mp4 243.1 MB
Базовый/Блок 5/5.4 Функции СЧЁТЕСЛИМН, СУММЕСЛИМН. Операторы для выборки/5-4.mp4 239.3 MB
Базовый/Блок 7/7.4 Макеты и стили диаграмм/7-4.mp4 234.8 MB
Эксперт/Блок 1/1.1 Применение простых формул массивов/1-1.mp4 202.8 MB
Эксперт/Блок 1/1.3 Двухсторонний, многокритериальный поиск/1-3.mp4 192.7 MB
Эксперт/Блок 5/5.2 Многоуровневые диаграммы, проектные диаграммы/5-2.mp4 192.5 MB
Базовый/Блок 3/3.2 Виды функций. Способы ввода функций. Поиск функций для английской версии Excel/3-2.mp4 190.0 MB
Базовый/Блок 6/6.2 Ошибки в формулах, обработка. Функция ЕСЛИОШИБКА/6-2.mp4 176.6 MB
Базовый/Блок 2/2.2 Копирование, вырезание, вставка строк, столбцов и ячеек. Вставка вместо существующих данных, вставка со сдвигом/2-2.mp4 176.4 MB
Базовый/Блок 4/4.5 Текстовые формулы СЖПРОБЕЛЫ, ПРОПНАЧ, ЛЕВСИМВ, ПРАВСИМВ, ПРОПИСН/4-5.mp4 173.3 MB
Эксперт/Блок 6/6.1 Импорт, экспорт данных, обновление, изменение/6-1.mp4 171.4 MB
Эксперт/Блок 2/2.1 Расширенный фильтр (совокупность нескольких выборок)/2-1.mp4 171.3 MB

[磁力链接] 添加时间:2021-03-13 大小:9.5 GB 最近下载:2025-03-11 热度:1844

[GigaCourse.com] Udemy - Microsoft Excel - Data Visualization، Excel Charts & Graphs

5. Next-Level Demos/7. DEMO Building a Dynamic Excel Dashboard (Part 1).mp4 171.4 MB
5. Next-Level Demos/6. DEMO Creating Interactive Area Charts to Show Changes Over Time.mp4 145.0 MB
5. Next-Level Demos/11. DEMO Building a Custom Excel Pacing Chart.mp4 130.8 MB
5. Next-Level Demos/8. DEMO Building a Dynamic Excel Dashboard (Part 2).mp4 127.7 MB
4. Mastering Basic Excel Charts & Graphs/9. DEMO Excel Pie Charts, Donuts & Race Tracks.mp4 117.0 MB
5. Next-Level Demos/5. DEMO Adding Scroll & Zoom Functionality Using Form Controls.mp4 111.3 MB
5. Next-Level Demos/10. DEMO Dynamically Highlighting Segments of Data.mp4 107.9 MB
5. Next-Level Demos/9. DEMO Dynamic Chart Formatting Based on Values.mp4 105.3 MB
4. Mastering Basic Excel Charts & Graphs/31. DEMO Common Excel Combo Charts.mp4 91.5 MB
4. Mastering Basic Excel Charts & Graphs/11. DEMO Excel Scatter Plots.mp4 87.7 MB
4. Mastering Basic Excel Charts & Graphs/23. DEMO Excel Stock Charts.mp4 86.5 MB
4. Mastering Basic Excel Charts & Graphs/1. DEMO Excel Bar & Columns Charts.mp4 86.0 MB
4. Mastering Basic Excel Charts & Graphs/27. DEMO Excel Surface & 3D Contour Charts.mp4 81.2 MB
4. Mastering Basic Excel Charts & Graphs/21. DEMO Excel Radar Charts.mp4 74.5 MB
4. Mastering Basic Excel Charts & Graphs/12. DEMO Excel Bubble Charts.mp4 71.2 MB
4. Mastering Basic Excel Charts & Graphs/29. DEMO Geo-Spatial Mapping with Excel Power Map.mp4 71.0 MB
5. Next-Level Demos/12. DEMO Designing a Custom Excel Gauge Chart.mp4 69.0 MB
3. Excel Chart Formatting & Customization/1. Customizing Chart Elements, Layouts & Styles.mp4 65.6 MB
4. Mastering Basic Excel Charts & Graphs/3. DEMO Excel Histograms & Pareto Charts (Office 365Excel 2016+).mp4 64.1 MB
4. Mastering Basic Excel Charts & Graphs/16. DEMO Excel Tree Maps & Sunburst Charts (Office 365Excel 2016+).mp4 63.9 MB

[磁力链接] 添加时间:2021-03-14 大小:2.6 GB 最近下载:2025-03-12 热度:1224

[ FreeCourseWeb.com ] Udemy - Microsoft Excel Secrets- Track Excel with Google Analytics.zip

[ FreeCourseWeb.com ] Udemy - Microsoft Excel Secrets- Track Excel with Google Analytics.zip 260.7 MB

[磁力链接] 添加时间:2021-03-14 大小:260.7 MB 最近下载:2025-03-09 热度:364

[ FreeCourseWeb.com ] Udemy - Become the Excel Hero with Advanced Excel Tricks for Job (updated 12-2019).zip

[ FreeCourseWeb.com ] Udemy - Become the Excel Hero with Advanced Excel Tricks for Job (updated 12-2019).zip 845.7 MB

[磁力链接] 添加时间:2021-03-14 大小:845.7 MB 最近下载:2025-03-10 热度:292

[ FreeCourseWeb.com ] Udemy - Excel VBA for Financial Modeling - Excel Automation.zip

[ FreeCourseWeb.com ] Udemy - Excel VBA for Financial Modeling - Excel Automation.zip 2.4 GB

[磁力链接] 添加时间:2021-03-15 大小:2.4 GB 最近下载:2025-03-13 热度:1759

[FreeAllCourse.Com] Udemy - Microsoft Excel - Advanced Excel Formulas & Functions

05 Lookup Reference Functions/050 DEMO Building Dashboards with XLOOKUP (Office 365 Only).mp4 180.9 MB
02 Excel Formulas 101/006 Excel Formula Syntax.mp4 120.0 MB
02 Excel Formulas 101/012 Saving Time with Function Shortcuts.mp4 108.7 MB
04 Common Excel Statistical Functions/034 PRO TIP Data Profiling with COUNT SUMPRODUCT.mp4 99.9 MB
10 Extra Bonus Functions/103 Real-Time Weather Conditions with WEBSERVICE FILTERXML (Part 2).mp4 96.7 MB
02 Excel Formulas 101/011 Navigating Excel Worksheets with Ctrl Shortcuts.mp4 93.7 MB
05 Lookup Reference Functions/040 Joining Data with VLOOKUP.mp4 85.8 MB
02 Excel Formulas 101/009 Formula Auditing Trace Precedents Dependents.mp4 84.3 MB
05 Lookup Reference Functions/051 Selecting List Items with CHOOSE.mp4 84.1 MB
04 Common Excel Statistical Functions/033 DEMO Counting Duplicates with COUNTIF SUMPRODUCT.mp4 76.7 MB
10 Extra Bonus Functions/102 Real-Time Weather Conditions with WEBSERVICE FILTERXML (Part 1).mp4 75.3 MB
06 Text Functions/060 Converting Text to Values with TEXT VALUE.mp4 58.1 MB
07 Date Time Functions/073 Defining Time Periods with WEEKDAY WORKDAY NETWORKDAYS.mp4 58.0 MB
04 Common Excel Statistical Functions/027 Extracting Values with SMALLLARGE RANKPERCENTRANK.mp4 56.9 MB
02 Excel Formulas 101/008 Common Excel Error Types.mp4 56.0 MB
02 Excel Formulas 101/010 Formula Auditing Evaluate Formula Error Checking (PC Only).mp4 55.7 MB
05 Lookup Reference Functions/039 Introduction to VLOOKUPHLOOKUP.mp4 54.3 MB
02 Excel Formulas 101/007 Writing Efficient Formulas with Fixed Relative References.mp4 53.1 MB
02 Excel Formulas 101/013 Accessing Tools with Alt Key Tips.mp4 51.5 MB
05 Lookup Reference Functions/043 Approximate Match Lookups.mp4 48.7 MB

[磁力链接] 添加时间:2021-03-16 大小:2.9 GB 最近下载:2025-01-11 热度:679

[Дмитрий Якушев] [Академия Excel] Формулы массива Excel (2020)

13/Excel-Array-13.mp4 69.0 MB
2/Excel-Array-01.mp4 59.3 MB
7/Excel-Array-06.mp4 43.7 MB
10/Excel-Array-10.mp4 42.6 MB
9/Excel-Array-09.mp4 36.5 MB
8/Excel-Array-07.mp4 31.8 MB
11/Excel-Array-11.mp4 29.3 MB
3/Excel-Array-02.mp4 28.4 MB
5/Excel-Array-04.mp4 28.3 MB
12/Excel-Array-12.mp4 22.2 MB
4/Excel-Array-03.mp4 21.1 MB
6/Excel-Array-05.mp4 20.8 MB
1/Формулы массива.xlsx 956.6 kB
1/05.3 - Функция СУММПРОИЗВ.xlsx 125.5 kB
1/05.2 - Функция ДВССЫЛ.xlsx 122.7 kB
13/описание.txt 5.0 kB
2/Описание.txt 3.3 kB
12/описание.txt 2.9 kB
4/Описание.txt 2.5 kB
11/описание.txt 2.5 kB

[磁力链接] 添加时间:2021-03-16 大小:434.1 MB 最近下载:2025-03-12 热度:2374

[Tutorialsplanet.NET] Udemy - Excel Charts - Data Visualization with Excel Graphs & Charts

2. Pictures and Clip Arts/1. Learning the HR Database.mp4 183.3 MB
4. Pie charts and Line charts/5. Analyzing on the Doughnut chart.mp4 138.6 MB
3. Excel Chart and Data Table/3. Applying groupings to database.mp4 137.1 MB
9. Tips/3. Sparklines.mp4 134.9 MB
2. Pictures and Clip Arts/3. Learning how to insert pictures.mp4 134.0 MB
8. Dashboard Chart/4. Map Chart.mp4 133.7 MB
7. Aspects of Scatter plot/2. Aspect of Scatter plot.mp4 133.1 MB
8. Dashboard Chart/3. Thermometer Chart.mp4 128.8 MB
3. Excel Chart and Data Table/1. Training on Charts.mp4 118.4 MB
9. Tips/1. Tips to Make Your Graph Perfect.mp4 115.4 MB
6. Pyramid charts and example/3. Mosaic or Mekko charts.mp4 114.3 MB
10. Smart Art/3. Picture List.mp4 112.4 MB
6. Pyramid charts and example/5. Sunburst chart a multilevel pie chart.mp4 104.6 MB
3. Excel Chart and Data Table/8. Understanding the Horizontal Bar Charts.mp4 103.3 MB
5. Bubble chart and surface chart/1. Area chart for illustrating the magnitude.mp4 98.0 MB
5. Bubble chart and surface chart/5. Example in surface chart.mp4 96.4 MB
4. Pie charts and Line charts/3. Line charts for trends over time.mp4 91.8 MB
3. Excel Chart and Data Table/4. Formulas in Excel Chart.mp4 90.8 MB
6. Pyramid charts and example/4. Graphical method in Radar chart.mp4 89.3 MB
9. Tips/2. Deciding Which Type of Chart to Use.mp4 86.6 MB

[磁力链接] 添加时间:2021-03-16 大小:4.2 GB 最近下载:2025-03-11 热度:495

[ FreeCourseWeb.com ] Skillshare - I love Excel - 80 easy lessons to build your Excel skills.zip

[ FreeCourseWeb.com ] Skillshare - I love Excel - 80 easy lessons to build your Excel skills.zip 1.7 GB

[磁力链接] 添加时间:2021-03-16 大小:1.7 GB 最近下载:2025-03-06 热度:813

Visual Basic for Excel - Microsoft VBA Excel Tutorial

9. Debugging And Error Handling/8. Speeding Up The VBA Tips.mp4 10.2 MB
8. Events/7. Using Application Events.mp4 9.5 MB
10. Interacting With Users Through Forms/17. Controlling Tab Order And Aligning Controls.mp4 8.6 MB
10. Interacting With Users Through Forms/11. UserForm Controls - ListBox AndOr Combo Box.mp4 8.4 MB
5. Manipulating Excel Objects/10. Common METHODS Of The RANGE Object.mp4 8.1 MB
8. Events/6. Other Useful Worksheet Triggers.mp4 6.8 MB
10. Interacting With Users Through Forms/14. Multiple Tabs On A UserForm.mp4 6.7 MB
8. Events/2. WorkBook Events - Open.mp4 6.6 MB
10. Interacting With Users Through Forms/10. UserForm Controls - The CheckBox.mp4 6.5 MB
10. Interacting With Users Through Forms/1. Using MSGBOX To Interact With Users.mp4 6.4 MB
10. Interacting With Users Through Forms/9. Calling Your UserForm And Validating Content.mp4 6.4 MB
10. Interacting With Users Through Forms/16. Scrollbar And Spin Controls.mp4 6.3 MB
11. Running And Storing VBA Code/6. Adding Code To The PERSONAL File.mp4 6.3 MB
7. Controlling Program Flow And Execution/6. The FOR NEXT Loop.mp4 6.0 MB
8. Events/3. Workbook Events - Closing And Saving.mp4 5.8 MB
11. Running And Storing VBA Code/5. Where To Store Your VBA Code.mp4 5.8 MB
5. Manipulating Excel Objects/6. A Number Of Read Only RANGE Properties.mp4 5.8 MB
6. Working With Excel VBA Functions/5. Using Worksheet Excel Functions In VBA Code.mp4 5.7 MB
10. Interacting With Users Through Forms/8. Adding The Code That Makes The Form Work.mp4 5.6 MB
4. Getting Started With VBA Programming/8. Excel VBA Operators.mp4 5.5 MB

[磁力链接] 添加时间:2021-03-16 大小:354.8 MB 最近下载:2025-03-14 热度:2453

[FreeCourseLab.com] Udemy - Unlock Excel VBA and Excel Macros

14. Main Project #2 Sales Regional Reporting Tool/4. Setting up a Template as the Basis for Different Reports.mp4 325.5 MB
18. Main Project #3 Invoice Generation Tool/8. Export PDF & Excel Workbook for Each Invoice based on ListBox Selection.mp4 294.1 MB
18. Main Project #3 Invoice Generation Tool/10. Final Updates & Debugging.mp4 250.5 MB
17. Working with Userforms & ActiveX Controls/9. UserForm to Document External Links & Comments (Combo Box & Option button).mp4 245.7 MB
13. Excel Tables, Formulas & Pivot Tables/4. Pivot Tables & VBA What you Need to Know.mp4 237.6 MB
12. Working with Files, Folders & Text Files/8. Project Export Data to Text file (fix Delimiter to Semicolon).mp4 235.8 MB
18. Main Project #3 Invoice Generation Tool/7. MultiPage UserForm to Create Invoices & Email (Setup).mp4 229.5 MB
14. Main Project #2 Sales Regional Reporting Tool/3. Importing Data from Multiple Files using MultiSelect.mp4 218.7 MB
10. Looping in VBA (Controlling the Flow of Code)/3. For Next Nested Loop (Loop through Text & Cells).mp4 218.4 MB
18. Main Project #3 Invoice Generation Tool/6. Enhanced Searchable ListBox Write Selection back to Excel Table.mp4 214.1 MB
2. Your First Macro/4. Project Dynamic Cell Selection (Special Cells) - Perfect for Flexible Macros.mp4 211.2 MB
17. Working with Userforms & ActiveX Controls/7. UserForm Basics What You Need to Get Started.mp4 202.5 MB
13. Excel Tables, Formulas & Pivot Tables/3. Excel Tables Use the Right Syntax.mp4 199.6 MB
7. Useful Built-in Functions/7. Project Show Top 3 Values in a Message box based on Range Selected.mp4 198.6 MB
14. Main Project #2 Sales Regional Reporting Tool/5. Exporting Reports as Excel files (Pivot Table & Hard Coded Reports).mp4 197.3 MB
15. Interacting with Other Applications (Word, PowerPoint etc.)/5. Project Microsoft PowerPoint Export Excel Sheets to PowerPoint Presentation.mp4 194.5 MB
19. Create your own Custom Functions/7. Project Function That Sums based on Cell Color.mp4 190.9 MB
18. Main Project #3 Invoice Generation Tool/2. Setting up an Input UserForm to Collect Master Data.mp4 186.8 MB
18. Main Project #3 Invoice Generation Tool/9. Create Email in Outlook & Attach PDF Invoice.mp4 184.1 MB
15. Interacting with Other Applications (Word, PowerPoint etc.)/4. Project Microsoft Word Create Personalized Letters in Word from Excel.mp4 178.0 MB

[磁力链接] 添加时间:2021-03-16 大小:12.5 GB 最近下载:2025-03-13 热度:2970