Filename Size 1. Introduction & Scope/1. Course Structure & Content.mp4 70.6 MB 1. Introduction & Scope/1. Course Structure & Content.vtt 5 KB 1. Introduction & Scope/2. Important Compatibility & Setup Information.mp4 51.4 MB 1. Introduction & Scope/2. Important Compatibility & Setup Information.vtt 4.5 KB 1. Introduction & Scope/3. Download Course Project Files.mp4 34.4 MB 1. Introduction & Scope/3. Download Course Project Files.vtt 2.2 KB 1. Introduction & Scope/3.1 Excel_VBA_Course_Slides.pdf.pdf 2.5 MB 1. Introduction & Scope/3.2 ALL_VBA_Section_Milestone_Files_In_One_Place.zip.zip 3.3 MB 1. Introduction & Scope/3.3 VBA_Project_Guide.pdf.pdf 554 KB 1. Introduction & Scope/3.4 How_to_Ask_Questions.pdf.pdf 864.9 KB 1. Introduction & Scope/3.5 IconSets.xlsx.xlsx 838.6 KB 1. Introduction & Scope/4. Course Expectations.mp4 52.5 MB 1. Introduction & Scope/4. Course Expectations.vtt 3.4 KB 10. Looping in VBA (Controlling the Flow of Code)/1. Section Overview Looping in VBA.mp4 18 MB 10. Looping in VBA (Controlling the Flow of Code)/1. Section Overview Looping in VBA.vtt 2.7 KB 10. Looping in VBA (Controlling the Flow of Code)/1.1 S10_Looping_Start.xlsx.xlsx 313.5 KB 10. Looping in VBA (Controlling the Flow of Code)/1.2 S10_Looping.xlsm.xlsm 333.3 KB 10. Looping in VBA (Controlling the Flow of Code)/10. Activity Document all Comments in Workbook in a Sheet.html 1.1 KB 10. Looping in VBA (Controlling the Flow of Code)/11. Project Document all Comments in Workbook in a Sheet.mp4 51.1 MB 10. Looping in VBA (Controlling the Flow of Code)/11. Project Document all Comments in Workbook in a Sheet.vtt 11.9 KB 10. Looping in VBA (Controlling the Flow of Code)/12. Useful VBA Statements & Key takeaways for Looping in VBA.mp4 33.3 MB 10. Looping in VBA (Controlling the Flow of Code)/12. Useful VBA Statements & Key takeaways for Looping in VBA.vtt 4.1 KB 10. Looping in VBA (Controlling the Flow of Code)/2. For Next Counter Loops (Simple Example).mp4 16.3 MB 10. Looping in VBA (Controlling the Flow of Code)/2. For Next Counter Loops (Simple Example).vtt 9 KB 10. Looping in VBA (Controlling the Flow of Code)/3. For Next Nested Loop (Loop through Text & Cells).mp4 208.3 MB 10. Looping in VBA (Controlling the Flow of Code)/3. For Next Nested Loop (Loop through Text & Cells).vtt 16.1 KB 10. Looping in VBA (Controlling the Flow of Code)/4. For Next Reverse Loop (Delete FilteredHidden Rows).mp4 25.9 MB 10. Looping in VBA (Controlling the Flow of Code)/4. For Next Reverse Loop (Delete FilteredHidden Rows).vtt 9.4 KB 10. Looping in VBA (Controlling the Flow of Code)/5. Do Until & Do While Loop.mp4 98.1 MB 10. Looping in VBA (Controlling the Flow of Code)/5. Do Until & Do While Loop.vtt 10.3 KB 10. Looping in VBA (Controlling the Flow of Code)/6. Practical Example of Do Loop (with Inputbox).mp4 6.6 MB 10. Looping in VBA (Controlling the Flow of Code)/6. Practical Example of Do Loop (with Inputbox).vtt 3.4 KB 10. Looping in VBA (Controlling the Flow of Code)/7. Find Method for Quicker Lookup Results.mp4 20.3 MB 10. Looping in VBA (Controlling the Flow of Code)/7. Find Method for Quicker Lookup Results.vtt 9.8 KB 10. Looping in VBA (Controlling the Flow of Code)/8. Find Method with Do Loop - Multiple Matches.mp4 14.5 MB 10. Looping in VBA (Controlling the Flow of Code)/8. Find Method with Do Loop - Multiple Matches.vtt 6.9 KB 10. Looping in VBA (Controlling the Flow of Code)/9. Add a Timer to Test & Speech to Inform.mp4 14.7 MB 10. Looping in VBA (Controlling the Flow of Code)/9. Add a Timer to Test & Speech to Inform.vtt 8.8 KB 11. Working with Arrays/1. Overview Working with Arrays in VBA.mp4 6.2 MB 11. Working with Arrays/1. Overview Working with Arrays in VBA.vtt 1.8 KB 11. Working with Arrays/1.1 S11_Arrays_Start.xlsx.xlsx 54.6 KB 11. Working with Arrays/1.2 S11_Arrays.xlsm.xlsm 77.2 KB 11. Working with Arrays/2. One Dimensional Arrays (and transferring back to sheet).mp4 138.8 MB 11. Working with Arrays/2. One Dimensional Arrays (and transferring back to sheet).vtt 14.5 KB 11. Working with Arrays/3. Dynamic Arrays (size adjusts depending on a condition).mp4 13 MB 11. Working with Arrays/3. Dynamic Arrays (size adjusts depending on a condition).vtt 7.1 KB 11. Working with Arrays/4. Preserving Dynamic Arrays (adding more elements to the existing array).mp4 44.7 MB 11. Working with Arrays/4. Preserving Dynamic Arrays (adding more elements to the existing array).vtt 4.2 KB 11. Working with Arrays/5. Two Dimensional Arrays.mp4 75.6 MB 11. Working with Arrays/5. Two Dimensional Arrays.vtt 7.9 KB 11. Working with Arrays/6. Variant Arrays Quick Method to Write to Cells.mp4 17.1 MB 11. Working with Arrays/6. Variant Arrays Quick Method to Write to Cells.vtt 8.8 KB 11. Working with Arrays/7. Activity Create a New Worksheet per Company with Specific Information.html 915 B 11. Working with Arrays/8. Project Create a New Worksheet per Company with Specific Information.mp4 159.8 MB 11. Working with Arrays/8. Project Create a New Worksheet per Company with Specific Information.vtt 9.5 KB 11. Working with Arrays/9. Key Takeaways Arrays.html 425 B 12. Working with Files, Folders & Text Files/1. Overview Working with Folders & Files.mp4 50.5 MB 12. Working with Files, Folders & Text Files/1. Overview Working with Folders & Files.vtt 3.2 KB 12. Working with Files, Folders & Text Files/1.1 Test_data.xlsx.xlsx 9.1 KB 12. Working with Files, Folders & Text Files/1.2 S12_Folders_Files_Start.xlsx.xlsx 58.2 KB 12. Working with Files, Folders & Text Files/1.3 S12_Folders_Files.xlsm.xlsm 90.1 KB 12. Working with Files, Folders & Text Files/1.4 TestTextCSV.csv.csv 724 B 12. Working with Files, Folders & Text Files/2. DIR Function Check if Files or Folders Exist.mp4 76.4 MB 12. Working with Files, Folders & Text Files/2. DIR Function Check if Files or Folders Exist.vtt 9.2 KB 12. Working with Files, Folders & Text Files/3. GetOpenFileName Method User Selects a File.mp4 95.9 MB 12. Working with Files, Folders & Text Files/3. GetOpenFileName Method User Selects a File.vtt 9.7 KB 12. Working with Files, Folders & Text Files/4. FileDialog Property Loop Inside a Folder.mp4 166.1 MB 12. Working with Files, Folders & Text Files/4. FileDialog Property Loop Inside a Folder.vtt 17.5 KB 12. Working with Files, Folders & Text Files/5. Create CSV File from Data in Excel.mp4 90.5 MB 12. Working with Files, Folders & Text Files/5. Create CSV File from Data in Excel.vtt 7.4 KB 12. Working with Files, Folders & Text Files/6. Printing & Writing to Text Files for More Control.mp4 44.6 MB 12. Working with Files, Folders & Text Files/6. Printing & Writing to Text Files for More Control.vtt 7.3 KB 12. Working with Files, Folders & Text Files/7. Activity Export Data to Text file (fix Delimiter to Semicolon).html 741 B 12. Working with Files, Folders & Text Files/8. Project Export Data to Text file (fix Delimiter to Semicolon).mp4 224.9 MB 12. Working with Files, Folders & Text Files/8. Project Export Data to Text file (fix Delimiter to Semicolon).vtt 13.1 KB 12. Working with Files, Folders & Text Files/9. Key Takeaways Files & Folders.html 413 B 13. Excel Tables, Formulas & Pivot Tables/1. Overview (Pivot) Tables & Formulas.mp4 43.4 MB 13. Excel Tables, Formulas & Pivot Tables/1. Overview (Pivot) Tables & Formulas.vtt 2.5 KB 13. Excel Tables, Formulas & Pivot Tables/1.1 S13_Formulas_Tables_Pivot_Start.xlsx.xlsx 59.4 KB 13. Excel Tables, Formulas & Pivot Tables/1.2 S13_Formulas_Tables_Pivot.xlsm.xlsm 86.1 KB 13. Excel Tables, Formulas & Pivot Tables/2. Using Excel Formulas in VBA.mp4 165.5 MB 13. Excel Tables, Formulas & Pivot Tables/2. Using Excel Formulas in VBA.vtt 14.8 KB 13. Excel Tables, Formulas & Pivot Tables/3. Excel Tables Use the Right Syntax.mp4 190.4 MB 13. Excel Tables, Formulas & Pivot Tables/3. Excel Tables Use the Right Syntax.vtt 14.9 KB 13. Excel Tables, Formulas & Pivot Tables/4. Pivot Tables & VBA What you Need to Know.mp4 226.6 MB 13. Excel Tables, Formulas & Pivot Tables/4. Pivot Tables & VBA What you Need to Know.vtt 20.6 KB 13. Excel Tables, Formulas & Pivot Tables/5. Activity Update Existing Formulas with VBA by Adding IFERROR.html 919 B 13. Excel Tables, Formulas & Pivot Tables/6. Project Update Existing Formulas with VBA by Adding IFERROR.mp4 138.5 MB 13. Excel Tables, Formulas & Pivot Tables/6. Project Update Existing Formulas with VBA by Adding IFERROR.vtt 7.8 KB 13. Excel Tables, Formulas & Pivot Tables/7. Key Takeaways (Pivot) Tables & Formula.html 415 B 14. Main Project #2 Sales Regional Reporting Tool/1. What You'll Learn (& Should be Aware of..).mp4 41.4 MB 14. Main Project #2 Sales Regional Reporting Tool/1. What You'll Learn (& Should be Aware of..).vtt 4.5 KB 14. Main Project #2 Sales Regional Reporting Tool/10. Key Takeaways & Tips for VBA based Excel Tools.mp4 44.4 MB 14. Main Project #2 Sales Regional Reporting Tool/10. Key Takeaways & Tips for VBA based Excel Tools.vtt 2.9 KB 14. Main Project #2 Sales Regional Reporting Tool/10.1 Monthly_Sales_Reporting_Template_Tool.xlsm.xlsm 136.1 KB 14. Main Project #2 Sales Regional Reporting Tool/11. Second Milestone Completed!.html 553 B 14. Main Project #2 Sales Regional Reporting Tool/2. Project Overview Regional Sales Reporting Tool.mp4 159.2 MB 14. Main Project #2 Sales Regional Reporting Tool/2. Project Overview Regional Sales Reporting Tool.vtt 15.5 KB 14. Main Project #2 Sales Regional Reporting Tool/2.1 Sales_Document_MetaCreations.xlsx.xlsx 10.3 KB