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
12. Working with Files, Folders & Text Files/4. FileDialog Property Loop Inside a Folder.mp4 174.1 MB
13. Excel Tables, Formulas & Pivot Tables/2. Using Excel Formulas in VBA.mp4 173.5 MB
2. Your First Macro/3. Visual Basic Editor What You Need to Know.mp4 106.9 MB
10. Looping in VBA (Controlling the Flow of Code)/5. Do Until & Do While Loop.mp4 102.9 MB
6. Looping through Collections & Making Decisions/3. For Each to Loop Through Collections (sheets, ranges etc.) in one go.mp4 102.8 MB
19. Create your own Custom Functions/4. Functions that Split Text and Numbers from Cell Value.mp4 102.3 MB
12. Working with Files, Folders & Text Files/3. GetOpenFileName Method User Selects a File.mp4 100.5 MB
14. Main Project #2 Sales Regional Reporting Tool/7. Setting up Automatic Export of Text File (Fix delimiter in CSV to Semicolon).mp4 100.2 MB
17. Working with Userforms & ActiveX Controls/5. ActiveX Combo Box for Easy Sheet Navigation (Great for Larger Workbooks).mp4 97.0 MB
6. Looping through Collections & Making Decisions/9. Bonus Unhide All Sheets in One Go.mp4 96.0 MB
12. Working with Files, Folders & Text Files/5. Create CSV File from Data in Excel.mp4 94.9 MB
5. Working with Variables/3. Declaring Variables, Arrays & Constants (Role of Option Explicit).mp4 94.5 MB
15. Interacting with Other Applications (Word, PowerPoint etc.)/3. Project Email Automatically Create Personalized Emails with Attachments.mp4 91.2 MB
18. Main Project #3 Invoice Generation Tool/4. Edit Master Data with UserForm.mp4 89.5 MB
7. Useful Built-in Functions/2. Most Useful VBA Functions.mp4 88.0 MB
9. Main Project #1 Create a Tool to Automate Table of Contents/2. TOC Project The Basics.mp4 86.3 MB
19. Create your own Custom Functions/5. Using Functions in Sub Procedures.mp4 86.2 MB
9. Main Project #1 Create a Tool to Automate Table of Contents/6. TOC Project Adding to Personal Macro Workbook (Make it Available to all Files).mp4 81.2 MB
17. Working with Userforms & ActiveX Controls/3. ActiveX Check Box to Fix Scroll Area & Toggle Screen Settings.mp4 80.9 MB
12. Working with Files, Folders & Text Files/2. DIR Function Check if Files or Folders Exist.mp4 80.2 MB
19. Create your own Custom Functions/3. Function to Calculate Age (Result in Years & Months).mp4 80.0 MB
11. Working with Arrays/5. Two Dimensional Arrays.mp4 79.3 MB
14. Main Project #2 Sales Regional Reporting Tool/4. Setting up a Template as the Basis for Different Reports.vtt 27.9 kB
18. Main Project #3 Invoice Generation Tool/8. Export PDF & Excel Workbook for Each Invoice based on ListBox Selection.vtt 26.2 kB
17. Working with Userforms & ActiveX Controls/9. UserForm to Document External Links & Comments (Combo Box & Option button).vtt 23.1 kB
9. Main Project #1 Create a Tool to Automate Table of Contents/6.1 Project_Automatic_TableOfContent.xlsm.xlsm 22.7 kB
17. Working with Userforms & ActiveX Controls/7. UserForm Basics What You Need to Get Started.vtt 22.6 kB
18. Main Project #3 Invoice Generation Tool/10. Final Updates & Debugging.vtt 21.3 kB
13. Excel Tables, Formulas & Pivot Tables/4. Pivot Tables & VBA What you Need to Know.vtt 21.1 kB
18. Main Project #3 Invoice Generation Tool/7. MultiPage UserForm to Create Invoices & Email (Setup).vtt 19.9 kB
15. Interacting with Other Applications (Word, PowerPoint etc.)/5. Project Microsoft PowerPoint Export Excel Sheets to PowerPoint Presentation.vtt 19.6 kB
18. Main Project #3 Invoice Generation Tool/2. Setting up an Input UserForm to Collect Master Data.vtt 18.6 kB
14. Main Project #2 Sales Regional Reporting Tool/5. Exporting Reports as Excel files (Pivot Table & Hard Coded Reports).vtt 18.0 kB
10. Looping in VBA (Controlling the Flow of Code)/5. Do Until & Do While Loop.vtt 10.5 kB
14. Main Project #2 Sales Regional Reporting Tool/3. Importing Data from Multiple Files using MultiSelect.vtt 10.4 kB
15. Interacting with Other Applications (Word, PowerPoint etc.)/3. Project Email Automatically Create Personalized Emails with Attachments.vtt 10.1 kB
10. Looping in VBA (Controlling the Flow of Code)/7. Find Method for Quicker Lookup Results.vtt 10.0 kB
12. Working with Files, Folders & Text Files/3. GetOpenFileName Method User Selects a File.vtt 9.9 kB
8. Debugging, Error Handling & Procedure Scope/6. Passing Arguments to Sub Procedures (By Ref, By Val).vtt 9.8 kB
11. Working with Arrays/8. Project Create a New Worksheet per Company with Specific Information.vtt 9.7 kB
10. Looping in VBA (Controlling the Flow of Code)/4. For Next Reverse Loop (Delete FilteredHidden Rows).vtt 9.6 kB
19. Create your own Custom Functions/4. Functions that Split Text and Numbers from Cell Value.vtt 9.5 kB
12. Working with Files, Folders & Text Files/2. DIR Function Check if Files or Folders Exist.vtt 9.4 kB
7. Useful Built-in Functions/3. Message Box (also with Yes, No buttons).vtt 9.4 kB
12. Working with Files, Folders & Text Files/1.1 Test_data.xlsx.xlsx 9.3 kB
10. Looping in VBA (Controlling the Flow of Code)/2. For Next Counter Loops (Simple Example).vtt 9.2 kB
3. The Object Model/7. How to Find the Object, Property & Method.vtt 9.2 kB
11. Working with Arrays/6. Variant Arrays Quick Method to Write to Cells.vtt 9.0 kB
10. Looping in VBA (Controlling the Flow of Code)/9. Add a Timer to Test & Speech to Inform.vtt 9.0 kB
16. Workbook and Worksheet Events/7. Project Link Page Header to Cell Value (BeforePrint Event).vtt 8.8 kB
14. Main Project #2 Sales Regional Reporting Tool/7. Setting up Automatic Export of Text File (Fix delimiter in CSV to Semicolon).vtt 8.6 kB
6. Looping through Collections & Making Decisions/6. Goto Statement to Change Program Flow.vtt 8.5 kB
17. Working with Userforms & ActiveX Controls/3. ActiveX Check Box to Fix Scroll Area & Toggle Screen Settings.vtt 8.4 kB
17. Working with Userforms & ActiveX Controls/2. ActiveX Controls What you Need to Know.vtt 8.3 kB
11. Working with Arrays/5. Two Dimensional Arrays.vtt 8.1 kB
6. Looping through Collections & Making Decisions/8. Project Get the Number of Formulas on the Worksheet.vtt 8.0 kB
13. Excel Tables, Formulas & Pivot Tables/6. Project Update Existing Formulas with VBA by Adding IFERROR.vtt 8.0 kB
9. Main Project #1 Create a Tool to Automate Table of Contents/6. TOC Project Adding to Personal Macro Workbook (Make it Available to all Files).vtt 7.9 kB
12. Working with Files, Folders & Text Files/5. Create CSV File from Data in Excel.vtt 7.6 kB
5. Working with Variables/4. Using Object Variables (Set statement).vtt 7.6 kB