Модуль 2. Теория построения дашбордов/3. Цветовые палитры для стильных дашбордов/Палитры_для_дашбордов_и_диаграмм.xlsx 12.9 MB
Модуль 1. База по визуализации данных/1. Мастер-класс Визуализация данных для бизнеса/Вебинар РБК Pro_презентация.pdf 10.7 MB
Модуль 2. Теория построения дашбордов/2. Чек-листы и памятки по построению дашбордов/Структура дашборда.pdf 7.5 MB
Модуль 2. Теория построения дашбордов/2. Чек-листы и памятки по построению дашбордов/Алгоритм построения дашборда.pdf 6.4 MB
Модуль 2. Теория построения дашбордов/2. Чек-листы и памятки по построению дашбордов/Чек-лист хорошего дашборда.pdf 5.7 MB
Модуль 3. Практика строим дашборды с нуля/8. Дашборд 7. Финансовые показатели компании за три года/Дашборд7_Финансовые показатели_ГОТОВЫЙ ДАШБОРД.xlsx 4.0 MB
[TutsNode.net] - The Complete Microsoft Excel Course Basics to Programming/1 - Section 1 Course Overview Quick Reference and Resources/1 - Section 11 Introduction How to Take Course Selecting a Track.mp4 398.3 MB
[TutsNode.net] - The Complete Microsoft Excel Course Basics to Programming/16 - GA Section 56 Programming Part 5 Putting It All TogetherAdditional Topics/187 - GA Lecture 562 Case Study 2 ActiveX Form Controls Part 1 of 2.mp4 374.3 MB
[TutsNode.net] - The Complete Microsoft Excel Course Basics to Programming/16 - GA Section 56 Programming Part 5 Putting It All TogetherAdditional Topics/188 - GA Lecture 562 Case Study 2 ActiveX Form Controls Part 2 of 2.mp4 355.6 MB
[TutsNode.net] - The Complete Microsoft Excel Course Basics to Programming/14 - GA Section 54 Programming Part 4 Data Types Coding Structures/167 - GA Introduction to Section 54 Data Types Coding Structures Part 1 of 2.mp4 347.2 MB
[TutsNode.net] - The Complete Microsoft Excel Course Basics to Programming/16 - GA Section 56 Programming Part 5 Putting It All TogetherAdditional Topics/180 - GA Lecture 561 Case Study 1 Download Stock Data Part 1 of 5.mp4 336.3 MB
[TutsNode.net] - The Complete Microsoft Excel Course Basics to Programming/15 - GA Section 55 Programming Part 5 Functions BugsErrors/173 - GA Introduction to Section 55 Functions BugsErrors Part 1 of 2.mp4 324.7 MB
[TutsNode.net] - The Complete Microsoft Excel Course Basics to Programming/16 - GA Section 56 Programming Part 5 Putting It All TogetherAdditional Topics/181 - GA Lecture 561 Case Study 1 Download Stock Data Part 2 of 5.mp4 323.4 MB
[TutsNode.net] - The Complete Microsoft Excel Course Basics to Programming/15 - GA Section 55 Programming Part 5 Functions BugsErrors/174 - GA Introduction to Section 55 Functions BugsErrors Part 2 of 2.mp4 300.3 MB
[TutsNode.net] - The Complete Microsoft Excel Course Basics to Programming/13 - GA Section 53 Programming Part 3 Understanding the VB Interface Objects/146 - GA Lecture 533 Objects Go In Subs and Functions.mp4 284.8 MB
[TutsNode.net] - The Complete Microsoft Excel Course Basics to Programming/9 - IGA Section 43 Dashboards 101 Includes Reports/112 - IGA Lecture 433 Many DashboardsReports Case Studies.mp4 279.8 MB
[TutsNode.net] - The Complete Microsoft Excel Course Basics to Programming/14 - GA Section 54 Programming Part 4 Data Types Coding Structures/168 - GA Introduction to Section 54 Data Types Coding Structures Part 2 of 2.mp4 244.2 MB
[TutsNode.net] - The Complete Microsoft Excel Course Basics to Programming/16 - GA Section 56 Programming Part 5 Putting It All TogetherAdditional Topics/182 - GA Lecture 561 Case Study 1 Download Stock Data Part 3 of 5.mp4 241.7 MB
[TutsNode.net] - The Complete Microsoft Excel Course Basics to Programming/13 - GA Section 53 Programming Part 3 Understanding the VB Interface Objects/140 - GA Lecture 531 Modules Contain Subs and Functions.mp4 228.6 MB
[TutsNode.net] - The Complete Microsoft Excel Course Basics to Programming/16 - GA Section 56 Programming Part 5 Putting It All TogetherAdditional Topics/184 - GA Lecture 561 Case Study 1 Download Stock Data Part 5 of 5.mp4 220.8 MB
[TutsNode.net] - The Complete Microsoft Excel Course Basics to Programming/1 - Section 1 Course Overview Quick Reference and Resources/3 - BIGA Section 13 Help Videos More.mp4 217.8 MB
[TutsNode.net] - The Complete Microsoft Excel Course Basics to Programming/16 - GA Section 56 Programming Part 5 Putting It All TogetherAdditional Topics/183 - GA Lecture 561 Case Study 1 Download Stock Data Part 4 of 5.mp4 206.4 MB
[TutsNode.net] - The Complete Microsoft Excel Course Basics to Programming/11 - GA Section 51 Programming Part 1 Creating Our First Macro/126 - GA Lecture 514 Changing the Code the Macro Created.mp4 204.1 MB
[TutsNode.net] - The Complete Microsoft Excel Course Basics to Programming/16 - GA Section 56 Programming Part 5 Putting It All TogetherAdditional Topics/191 - GA Lecture 563 Additional VBA Topics.mp4 198.0 MB
[TutsNode.net] - The Complete Microsoft Excel Course Basics to Programming/10 - GA Section 5 Programming Using Visual Basic for Applications Macros and Con/115 - GA Section 5 Introduction What Why How We Will Learn Programming.mp4 196.2 MB
[TutsNode.net] - The Complete Microsoft Excel Course Basics to Programming/11 - GA Section 51 Programming Part 1 Creating Our First Macro/129 - GA Lecture 515 Adding Buttons Other Controls.mp4 194.0 MB
9. BBS OF SLAB ( ONE WAY , TWO WAY , DISTRIBUTION BAR, CRANK DISTRIBUTOR & CHAIR )/12. MANUAL CALCULATION OF ONE WAY CONTINOUS SLAB.mp4 310.8 MB
5. BAR BENDING SCHEDULE OF FOOTING ( EXCEL + MANUAL)/2. BBS OF FOOTING MANUALLY.mp4 252.2 MB
16. BRIEF QUANITY ESTIMATION OF HOUSE PROJECT (CASE STUDY )/1. ESTIMATION & COSTING OF 5 BHK PLAN.mp4 245.6 MB
1. SUB STRUCTURE & SUPER STRUCTURE QUANTITY ESTIMATION OF BUILDING ( MANUAL+EXCEL)/11. Plinth Beam PCC Quantity Estimation & Learn to Understand Industrial Drawings.mp4 221.6 MB
1. SUB STRUCTURE & SUPER STRUCTURE QUANTITY ESTIMATION OF BUILDING ( MANUAL+EXCEL)/7. Formwork Quantity for Neck Column Pedestal ( Highly Imformative ).mp4 220.0 MB
10. Staircase BBS/5. Staircase BBS Part 5.mp4 191.7 MB
1. SUB STRUCTURE & SUPER STRUCTURE QUANTITY ESTIMATION OF BUILDING ( MANUAL+EXCEL)/2. Calculate Excavation Quantity.mp4 191.1 MB
1. SUB STRUCTURE & SUPER STRUCTURE QUANTITY ESTIMATION OF BUILDING ( MANUAL+EXCEL)/12. Plinth Beam Formwork Quantity Calculation ( Highly Informative + All do Mistake).mp4 190.0 MB
10. Staircase BBS/4. Staircase BBS Part 4.mp4 183.3 MB
5. BAR BENDING SCHEDULE OF FOOTING ( EXCEL + MANUAL)/3. BBS of FOOTING ALONG SHORTER SPAN ( EXCEL CALCULATION ).mp4 182.8 MB
4. STAIRCASE ESTIMATION OF G+2 BUILDING/1. WHAT IS RISER, THREAD AND WAIST SLAB & HOW TO FIND ITS HEIGHT.mp4 179.5 MB
2. COMPLETE ESTIMATION OF G+2 HOSTEL BUILDING WITH INTERIORS ( LIVE PROJECT )/5. PCC Quantitiy & Material Price Calculation for Total Pcc of Hostel Buildiing.mp4 174.6 MB
10. Staircase BBS/2. Staircase BBS Part 2.mp4 174.5 MB
1. SUB STRUCTURE & SUPER STRUCTURE QUANTITY ESTIMATION OF BUILDING ( MANUAL+EXCEL)/15. Calculate Column Height Till 1st floor Roof Bottom Level (Highly Informative).mp4 162.0 MB
9. BBS OF SLAB ( ONE WAY , TWO WAY , DISTRIBUTION BAR, CRANK DISTRIBUTOR & CHAIR )/9. CUTTING LENGTH OF CRANK DISTRIBUTOR BAR ( MANUAL + PPT ).mp4 159.7 MB
3. FINISHING ACTIVITIES ( BRICKWORK, INSIDE & OUTSIDE PLASTERING, PAINITING, ETC)/20. FULL VIDEO OF G+2 HOSTEL BUILDING ( CONCRETE + SLAB + BRICKWORK + CENTERING ).mp4 158.2 MB
6. BAR BENDING SCHEDULE OF COLUMN UPTO PLINTH BEAM TOP ( NECK COLUMN )/5. CALCULATE COLUMN MASTER RING ( LATERAL TIES ) CUTTING LENGTH.mp4 152.2 MB
1. SUB STRUCTURE & SUPER STRUCTURE QUANTITY ESTIMATION OF BUILDING ( MANUAL+EXCEL)/16. Column Shuttering Calculation Till 1st floor Beam Bottom Roof Beam Bottom.mp4 152.0 MB
6. BAR BENDING SCHEDULE OF COLUMN UPTO PLINTH BEAM TOP ( NECK COLUMN )/11. COMPLETE BBS OF COLUMN WITH ALL CALCULATION ( MANUAL+EXCEL )-ESTIMATION OF STEEL.mp4 149.9 MB
[TutsNode.net] - Microsoft Excel - Excel from Beginner to Advanced/09 - Printing an Excel Worksheet/002 Changing the Margins, Scaling and Orientation.mp4 370.5 MB
[TutsNode.net] - Microsoft Excel - Excel from Beginner to Advanced/19 - Working with Excel's PowerPivot Tools/002 Why PowerPivot.mp4 340.3 MB
[TutsNode.net] - Microsoft Excel - Excel from Beginner to Advanced/17 - Importing and Exporting Data/004 NEW VERSION -- Import Data From Text Files into Excel.mp4 248.1 MB
[TutsNode.net] - Microsoft Excel - Excel from Beginner to Advanced/36 - Project #2 Moving Beyond the Basics and into VBA/003 Project #2 Prompting the User for Information.mp4 225.1 MB
[TutsNode.net] - Microsoft Excel - Excel from Beginner to Advanced/19 - Working with Excel's PowerPivot Tools/007 Excel Power Pivot KPIs.mp4 206.1 MB
[TutsNode.net] - Microsoft Excel - Excel from Beginner to Advanced/38 - Project #4 Using VBA to Automate Excel Formulas/005 Project #4 Loop the SUM() Function Over Multiple Worksheets.mp4 206.1 MB
[TutsNode.net] - Microsoft Excel - Excel from Beginner to Advanced/10 - Working with Excel Templates/002 Opening an Existing Template.mp4 200.0 MB
[TutsNode.net] - Microsoft Excel - Excel from Beginner to Advanced/37 - Project #3 Preparing and Cleaning Up Data with a Little VBA/005 Project #3 Putting it all Together with a Little VBA.mp4 195.0 MB
[TutsNode.net] - Microsoft Excel - Excel from Beginner to Advanced/36 - Project #2 Moving Beyond the Basics and into VBA/006 Project #2 Alerting the User of Errors.mp4 187.8 MB
[TutsNode.net] - Microsoft Excel - Excel from Beginner to Advanced/29 - Mastering Excel's What If Tools/002 Working with Excel's Solver Tool.mp4 187.1 MB
[TutsNode.net] - Microsoft Excel - Excel from Beginner to Advanced/25 - Working with Excel's Lookup Functions/001 Microsoft Excel VLOOKUP() Function.mp4 172.0 MB
[TutsNode.net] - Microsoft Excel - Excel from Beginner to Advanced/25 - Working with Excel's Lookup Functions/003 Microsoft Excel INDEX() Function.mp4 170.8 MB
[TutsNode.net] - Microsoft Excel - Excel from Beginner to Advanced/19 - Working with Excel's PowerPivot Tools/004 Creating Data Models with PowerPivot.mp4 166.2 MB
[TutsNode.net] - Microsoft Excel - Excel from Beginner to Advanced/06 - Formatting Data in an Excel Worksheet/008 Creating Styles to Format Data.mp4 166.0 MB
[TutsNode.net] - Microsoft Excel - Excel from Beginner to Advanced/40 - Project #6 Working with Excel VBA User Forms/008 Project #6 Adding VBA Code to the Create Report Button.mp4 159.8 MB
[TutsNode.net] - Microsoft Excel - Excel from Beginner to Advanced/25 - Working with Excel's Lookup Functions/006 Microsoft Excel INDEX() and MATCH() Function Combined Continued.mp4 154.1 MB
[TutsNode.net] - Microsoft Excel - Excel from Beginner to Advanced/25 - Working with Excel's Lookup Functions/004 Microsoft Excel MATCH() Function.mp4 153.0 MB
[TutsNode.net] - Microsoft Excel - Excel from Beginner to Advanced/18 - Excel PivotTables/002 Creating an Excel PivotTable.mp4 150.8 MB
[TutsNode.net] - Microsoft Excel - Excel from Beginner to Advanced/36 - Project #2 Moving Beyond the Basics and into VBA/005 Project #2 Building Logic into Your Macros.mp4 146.2 MB
[TutsNode.net] - Microsoft Excel - Excel from Beginner to Advanced/38 - Project #4 Using VBA to Automate Excel Formulas/002 Project #4 Automate the SUM() Function through Code.mp4 145.8 MB
microsoft-excel-2013-from-beginner-to-advanced-and-beyond/09 - Printing an Excel Worksheet/002 Changing the Margins, Scaling and Orientation.mp4 370.5 MB
microsoft-excel-2013-from-beginner-to-advanced-and-beyond/19 - Working with Excel's PowerPivot Tools/002 Why PowerPivot.mp4 340.3 MB
microsoft-excel-2013-from-beginner-to-advanced-and-beyond/17 - Importing and Exporting Data/004 NEW VERSION -- Import Data From Text Files into Excel.mp4 248.1 MB
microsoft-excel-2013-from-beginner-to-advanced-and-beyond/36 - Project #2 Moving Beyond the Basics and into VBA/003 Project #2 Prompting the User for Information.mp4 225.1 MB
microsoft-excel-2013-from-beginner-to-advanced-and-beyond/19 - Working with Excel's PowerPivot Tools/007 Excel Power Pivot KPIs.mp4 206.1 MB
microsoft-excel-2013-from-beginner-to-advanced-and-beyond/38 - Project #4 Using VBA to Automate Excel Formulas/005 Project #4 Loop the SUM() Function Over Multiple Worksheets.mp4 206.1 MB
microsoft-excel-2013-from-beginner-to-advanced-and-beyond/10 - Working with Excel Templates/002 Opening an Existing Template.mp4 200.0 MB
microsoft-excel-2013-from-beginner-to-advanced-and-beyond/37 - Project #3 Preparing and Cleaning Up Data with a Little VBA/005 Project #3 Putting it all Together with a Little VBA.mp4 195.0 MB
microsoft-excel-2013-from-beginner-to-advanced-and-beyond/36 - Project #2 Moving Beyond the Basics and into VBA/006 Project #2 Alerting the User of Errors.mp4 187.8 MB
microsoft-excel-2013-from-beginner-to-advanced-and-beyond/29 - Mastering Excel's What If Tools/002 Working with Excel's Solver Tool.mp4 187.1 MB
microsoft-excel-2013-from-beginner-to-advanced-and-beyond/25 - Working with Excel's Lookup Functions/001 Microsoft Excel VLOOKUP() Function.mp4 172.0 MB
microsoft-excel-2013-from-beginner-to-advanced-and-beyond/25 - Working with Excel's Lookup Functions/003 Microsoft Excel INDEX() Function.mp4 170.8 MB
microsoft-excel-2013-from-beginner-to-advanced-and-beyond/19 - Working with Excel's PowerPivot Tools/004 Creating Data Models with PowerPivot.mp4 166.2 MB
microsoft-excel-2013-from-beginner-to-advanced-and-beyond/06 - Formatting Data in an Excel Worksheet/008 Creating Styles to Format Data.mp4 166.0 MB
microsoft-excel-2013-from-beginner-to-advanced-and-beyond/40 - Project #6 Working with Excel VBA User Forms/008 Project #6 Adding VBA Code to the Create Report Button.mp4 159.8 MB
microsoft-excel-2013-from-beginner-to-advanced-and-beyond/25 - Working with Excel's Lookup Functions/006 Microsoft Excel INDEX() and MATCH() Function Combined Continued.mp4 154.1 MB
microsoft-excel-2013-from-beginner-to-advanced-and-beyond/25 - Working with Excel's Lookup Functions/004 Microsoft Excel MATCH() Function.mp4 153.0 MB
microsoft-excel-2013-from-beginner-to-advanced-and-beyond/18 - Excel PivotTables/002 Creating an Excel PivotTable.mp4 150.8 MB
microsoft-excel-2013-from-beginner-to-advanced-and-beyond/36 - Project #2 Moving Beyond the Basics and into VBA/005 Project #2 Building Logic into Your Macros.mp4 146.2 MB
microsoft-excel-2013-from-beginner-to-advanced-and-beyond/38 - Project #4 Using VBA to Automate Excel Formulas/002 Project #4 Automate the SUM() Function through Code.mp4 145.8 MB
2 - PLANILHAS PARTE 2/Cópia de Planilhas.zip 1.0 GB
2 - PLANILHAS PARTE 2/Cópia de MODELO - EXCEL-20221014T005945Z-001.zip 934.0 MB
4 - ENGENHARIA CIVIL/ESTRUTURA DE CONCRETO/PROJETOS ESTRUTURAIS/Cópia de Projetos Estruturais Parte 1.rar 747.0 MB
6 - CURSO EXCEL PRO FINANCEIRO/MOD 14 - BRINDES/Cópia de 01. Planejamento e Controle Financeiro Pessoal - Parte 1.ts 343.4 MB
6 - CURSO EXCEL PRO FINANCEIRO/MOD 14 - BRINDES/Cópia de 03. Curso Gráficos de Alto Impacto - Parte 3.ts 275.1 MB
6 - CURSO EXCEL PRO FINANCEIRO/MOD 14 - BRINDES/Cópia de 03. Curso Gráficos de Alto Impacto - Parte 2.ts 218.8 MB
6 - CURSO EXCEL PRO FINANCEIRO/MOD 14 - BRINDES/Cópia de 03. Curso Gráficos de Alto Impacto - Parte 1.ts 216.9 MB
4 - ENGENHARIA CIVIL/ESTRUTURA DE CONCRETO/PROJETOS ESTRUTURAIS/Cópia de Projetos Estruturais Parte 2.rar 182.4 MB
6 - CURSO EXCEL PRO FINANCEIRO/MOD 7 - AUTOMAÇÃO - CONSTRUINDO PLANILHAS COM FÓRMULAS 100_ AUTOMÁTICAS/Cópia de 25. Construindo o Projeto (Automação) - Parte 2.ts 128.5 MB
1 - PLANILHAS PARTE 1/Cópia de Dashboards - Planilhas.zip 117.8 MB
6 - CURSO EXCEL PRO FINANCEIRO/MOD 14 - BRINDES/Cópia de 01. Planejamento e Controle Financeiro Pessoal - Parte 3.ts 117.8 MB
6 - CURSO EXCEL PRO FINANCEIRO/MOD 8 - OUTPUT - FAÇA DASHBOARDS IMPECÁVEIS E AUTOMÁTICOS/Cópia de 23. Construindo o Projeto (Output) - Parte 1.ts 117.6 MB
6 - CURSO EXCEL PRO FINANCEIRO/MOD 12 - BÔNUS TABELA DINÂMICA AVANÇADA/Cópia de 13. Tipos de Filtros.ts 111.3 MB
6 - CURSO EXCEL PRO FINANCEIRO/MOD 14 - BRINDES/Cópia de 01. Planejamento e Controle Financeiro Pessoal - Parte 2.ts 109.1 MB
6 - CURSO EXCEL PRO FINANCEIRO/MOD 8 - OUTPUT - FAÇA DASHBOARDS IMPECÁVEIS E AUTOMÁTICOS/Cópia de 23. Construindo o Projeto (Output) - Parte 2.ts 104.5 MB
6 - CURSO EXCEL PRO FINANCEIRO/MOD 6 - INPUT - IMPORTAÇÃO AUTOMATICA DE DADOS PARA O EXCEL/Cópia de 18. Construindo o Projeto (Input) - Parte 3.ts 97.3 MB
6 - CURSO EXCEL PRO FINANCEIRO/MOD 8 - OUTPUT - FAÇA DASHBOARDS IMPECÁVEIS E AUTOMÁTICOS/Cópia de 23. Construindo o Projeto (Output) - Parte 3.ts 93.3 MB
6 - CURSO EXCEL PRO FINANCEIRO/MOD 12 - BÔNUS TABELA DINÂMICA AVANÇADA/Cópia de 15. Organizando Dados Segmentação de Dados e Linha do Tempo.ts 80.8 MB
6 - CURSO EXCEL PRO FINANCEIRO/MOD 7 - AUTOMAÇÃO - CONSTRUINDO PLANILHAS COM FÓRMULAS 100_ AUTOMÁTICAS/Cópia de 25. Construindo o Projeto (Automação) - Parte 1.ts 77.8 MB
6 - CURSO EXCEL PRO FINANCEIRO/MOD 7 - AUTOMAÇÃO - CONSTRUINDO PLANILHAS COM FÓRMULAS 100_ AUTOMÁTICAS/Cópia de 23. Atualizando Tabela Dinâmica - Parte 1.ts 77.7 MB
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.4 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
15. Interacting with Other Applications (Word, PowerPoint etc.)/4. Project Microsoft Word Create Personalized Letters in Word from Excel.mp4 178.0 MB
12. Working with Files, Folders & Text Files/4. FileDialog Property Loop Inside a Folder.mp4 174.1 MB
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.4 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.4 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
15. Interacting with Other Applications (Word, PowerPoint etc.)/4. Project Microsoft Word Create Personalized Letters in Word from Excel.mp4 178.0 MB
12. Working with Files, Folders & Text Files/4. FileDialog Property Loop Inside a Folder.mp4 174.1 MB
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