[FreeCourseLab com] Udemy - Unlock Excel VBA and Excel Macros
File List
| File | Size |
|---|---|
| 1. Introduction & Scope/1. Course Structure & Content.mp4 | 70.59 MB |
| 1. Introduction & Scope/1. Course Structure & Content.vtt | 5 KB |
| 1. Introduction & Scope/2. Important Compatibility & Setup Information.mp4 | 51.38 MB |
| 1. Introduction & Scope/2. Important Compatibility & Setup Information.vtt | 4.48 KB |
| 1. Introduction & Scope/3. Download Course Project Files.mp4 | 34.38 MB |
| 1. Introduction & Scope/3. Download Course Project Files.vtt | 2.19 KB |
| 1. Introduction & Scope/3.1 Excel_VBA_Course_Slides.pdf.pdf | 2.53 MB |
| 1. Introduction & Scope/3.2 ALL_VBA_Section_Milestone_Files_In_One_Place.zip.zip | 3.32 MB |
| 1. Introduction & Scope/3.3 VBA_Project_Guide.pdf.pdf | 553.96 KB |
| 1. Introduction & Scope/3.4 How_to_Ask_Questions.pdf.pdf | 864.93 KB |
| 1. Introduction & Scope/3.5 IconSets.xlsx.xlsx | 838.61 KB |
| 1. Introduction & Scope/4. Course Expectations.mp4 | 52.54 MB |
| 1. Introduction & Scope/4. Course Expectations.vtt | 3.37 KB |
| 10. Looping in VBA (Controlling the Flow of Code)/1. Section Overview Looping in VBA.mp4 | 18.03 MB |
| 10. Looping in VBA (Controlling the Flow of Code)/1. Section Overview Looping in VBA.vtt | 2.72 KB |
| 10. Looping in VBA (Controlling the Flow of Code)/1.1 S10_Looping_Start.xlsx.xlsx | 313.49 KB |
| 10. Looping in VBA (Controlling the Flow of Code)/1.2 S10_Looping.xlsm.xlsm | 333.28 KB |
| 10. Looping in VBA (Controlling the Flow of Code)/10. Activity Document all Comments in Workbook in a Sheet.html | 1.14 KB |
| 10. Looping in VBA (Controlling the Flow of Code)/11. Project Document all Comments in Workbook in a Sheet.mp4 | 51.05 MB |
| 10. Looping in VBA (Controlling the Flow of Code)/11. Project Document all Comments in Workbook in a Sheet.vtt | 11.91 KB |
| 10. Looping in VBA (Controlling the Flow of Code)/12. Useful VBA Statements & Key takeaways for Looping in VBA.mp4 | 33.26 MB |
| 10. Looping in VBA (Controlling the Flow of Code)/12. Useful VBA Statements & Key takeaways for Looping in VBA.vtt | 4.13 KB |
| 10. Looping in VBA (Controlling the Flow of Code)/2. For Next Counter Loops (Simple Example).mp4 | 16.31 MB |
| 10. Looping in VBA (Controlling the Flow of Code)/2. For Next Counter Loops (Simple Example).vtt | 9.03 KB |
| 10. Looping in VBA (Controlling the Flow of Code)/3. For Next Nested Loop (Loop through Text & Cells).mp4 | 208.31 MB |
| 10. Looping in VBA (Controlling the Flow of Code)/3. For Next Nested Loop (Loop through Text & Cells).vtt | 16.14 KB |
| 10. Looping in VBA (Controlling the Flow of Code)/4. For Next Reverse Loop (Delete FilteredHidden Rows).mp4 | 25.88 MB |
| 10. Looping in VBA (Controlling the Flow of Code)/4. For Next Reverse Loop (Delete FilteredHidden Rows).vtt | 9.39 KB |
| 10. Looping in VBA (Controlling the Flow of Code)/5. Do Until & Do While Loop.mp4 | 98.12 MB |
| 10. Looping in VBA (Controlling the Flow of Code)/5. Do Until & Do While Loop.vtt | 10.28 KB |
| 10. Looping in VBA (Controlling the Flow of Code)/6. Practical Example of Do Loop (with Inputbox).mp4 | 6.58 MB |
| 10. Looping in VBA (Controlling the Flow of Code)/6. Practical Example of Do Loop (with Inputbox).vtt | 3.41 KB |
| 10. Looping in VBA (Controlling the Flow of Code)/7. Find Method for Quicker Lookup Results.mp4 | 20.32 MB |
| 10. Looping in VBA (Controlling the Flow of Code)/7. Find Method for Quicker Lookup Results.vtt | 9.75 KB |
| 10. Looping in VBA (Controlling the Flow of Code)/8. Find Method with Do Loop - Multiple Matches.mp4 | 14.45 MB |
| 10. Looping in VBA (Controlling the Flow of Code)/8. Find Method with Do Loop - Multiple Matches.vtt | 6.86 KB |
| 10. Looping in VBA (Controlling the Flow of Code)/9. Add a Timer to Test & Speech to Inform.mp4 | 14.65 MB |
| 10. Looping in VBA (Controlling the Flow of Code)/9. Add a Timer to Test & Speech to Inform.vtt | 8.78 KB |
| 11. Working with Arrays/1. Overview Working with Arrays in VBA.mp4 | 6.24 MB |
| 11. Working with Arrays/1. Overview Working with Arrays in VBA.vtt | 1.82 KB |
| 11. Working with Arrays/1.1 S11_Arrays_Start.xlsx.xlsx | 54.58 KB |
| 11. Working with Arrays/1.2 S11_Arrays.xlsm.xlsm | 77.22 KB |
| 11. Working with Arrays/2. One Dimensional Arrays (and transferring back to sheet).mp4 | 138.82 MB |
| 11. Working with Arrays/2. One Dimensional Arrays (and transferring back to sheet).vtt | 14.45 KB |
| 11. Working with Arrays/3. Dynamic Arrays (size adjusts depending on a condition).mp4 | 13.04 MB |
| 11. Working with Arrays/3. Dynamic Arrays (size adjusts depending on a condition).vtt | 7.12 KB |
| 11. Working with Arrays/4. Preserving Dynamic Arrays (adding more elements to the existing array).mp4 | 44.67 MB |
| 11. Working with Arrays/4. Preserving Dynamic Arrays (adding more elements to the existing array).vtt | 4.23 KB |
| 11. Working with Arrays/5. Two Dimensional Arrays.mp4 | 75.64 MB |
| 11. Working with Arrays/5. Two Dimensional Arrays.vtt | 7.86 KB |
| 11. Working with Arrays/6. Variant Arrays Quick Method to Write to Cells.mp4 | 17.14 MB |
| 11. Working with Arrays/6. Variant Arrays Quick Method to Write to Cells.vtt | 8.84 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.85 MB |
| 11. Working with Arrays/8. Project Create a New Worksheet per Company with Specific Information.vtt | 9.46 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.47 MB |
| 12. Working with Files, Folders & Text Files/1. Overview Working with Folders & Files.vtt | 3.24 KB |
| 12. Working with Files, Folders & Text Files/1.1 Test_data.xlsx.xlsx | 9.12 KB |
| 12. Working with Files, Folders & Text Files/1.2 S12_Folders_Files_Start.xlsx.xlsx | 58.17 KB |
| 12. Working with Files, Folders & Text Files/1.3 S12_Folders_Files.xlsm.xlsm | 90.06 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.44 MB |
| 12. Working with Files, Folders & Text Files/2. DIR Function Check if Files or Folders Exist.vtt | 9.22 KB |
| 12. Working with Files, Folders & Text Files/3. GetOpenFileName Method User Selects a File.mp4 | 95.86 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.08 MB |
| 12. Working with Files, Folders & Text Files/4. FileDialog Property Loop Inside a Folder.vtt | 17.46 KB |
| 12. Working with Files, Folders & Text Files/5. Create CSV File from Data in Excel.mp4 | 90.51 MB |
| 12. Working with Files, Folders & Text Files/5. Create CSV File from Data in Excel.vtt | 7.42 KB |
| 12. Working with Files, Folders & Text Files/6. Printing & Writing to Text Files for More Control.mp4 | 44.55 MB |
| 12. Working with Files, Folders & Text Files/6. Printing & Writing to Text Files for More Control.vtt | 7.35 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.06 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.35 MB |
| 13. Excel Tables, Formulas & Pivot Tables/1. Overview (Pivot) Tables & Formulas.vtt | 2.52 KB |
| 13. Excel Tables, Formulas & Pivot Tables/1.1 S13_Formulas_Tables_Pivot_Start.xlsx.xlsx | 59.36 KB |
| 13. Excel Tables, Formulas & Pivot Tables/1.2 S13_Formulas_Tables_Pivot.xlsm.xlsm | 86.09 KB |
| 13. Excel Tables, Formulas & Pivot Tables/2. Using Excel Formulas in VBA.mp4 | 165.49 MB |
| 13. Excel Tables, Formulas & Pivot Tables/2. Using Excel Formulas in VBA.vtt | 14.78 KB |
| 13. Excel Tables, Formulas & Pivot Tables/3. Excel Tables Use the Right Syntax.mp4 | 190.36 MB |
| 13. Excel Tables, Formulas & Pivot Tables/3. Excel Tables Use the Right Syntax.vtt | 14.94 KB |
| 13. Excel Tables, Formulas & Pivot Tables/4. Pivot Tables & VBA What you Need to Know.mp4 | 226.63 MB |
| 13. Excel Tables, Formulas & Pivot Tables/4. Pivot Tables & VBA What you Need to Know.vtt | 20.62 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.48 MB |
| 13. Excel Tables, Formulas & Pivot Tables/6. Project Update Existing Formulas with VBA by Adding IFERROR.vtt | 7.83 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.41 MB |
| 14. Main Project #2 Sales Regional Reporting Tool/1. What You'll Learn (& Should be Aware of..).vtt | 4.47 KB |
| 14. Main Project #2 Sales Regional Reporting Tool/10. Key Takeaways & Tips for VBA based Excel Tools.mp4 | 44.35 MB |
| 14. Main Project #2 Sales Regional Reporting Tool/10. Key Takeaways & Tips for VBA based Excel Tools.vtt | 2.91 KB |
| 14. Main Project #2 Sales Regional Reporting Tool/10.1 Monthly_Sales_Reporting_Template_Tool.xlsm.xlsm | 136.06 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.17 MB |
| 14. Main Project #2 Sales Regional Reporting Tool/2. Project Overview Regional Sales Reporting Tool.vtt | 15.48 KB |
| 14. Main Project #2 Sales Regional Reporting Tool/2.1 Sales_Document_MetaCreations.xlsx.xlsx | 10.28 KB |
| 14. Main Project #2 Sales Regional Reporting Tool/2.2 Sales_Document_BereKleid.xlsx.xlsx | 10.82 KB |
Trackers
No trackers found.