589689.xyz

[] Udemy - Unlock Excel VBA and Excel Macros

  • 收录时间:2019-03-01 20:01:22
  • 文件大小:12GB
  • 下载次数:123
  • 最近下载:2021-01-23 14:14:41
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 14. Main Project #2 Sales Regional Reporting Tool/4. Setting up a Template as the Basis for Different Reports.mp4 310MB
  2. 18. Main Project #3 Invoice Generation Tool/8. Export PDF & Excel Workbook for Each Invoice based on ListBox Selection.mp4 280MB
  3. 18. Main Project #3 Invoice Generation Tool/10. Final Updates & Debugging.mp4 239MB
  4. 17. Working with Userforms & ActiveX Controls/9. UserForm to Document External Links & Comments (Combo Box & Option button).mp4 234MB
  5. 13. Excel Tables, Formulas & Pivot Tables/4. Pivot Tables & VBA What you Need to Know.mp4 227MB
  6. 12. Working with Files, Folders & Text Files/8. Project Export Data to Text file (fix Delimiter to Semicolon).mp4 225MB
  7. 18. Main Project #3 Invoice Generation Tool/7. MultiPage UserForm to Create Invoices & Email (Setup).mp4 219MB
  8. 14. Main Project #2 Sales Regional Reporting Tool/3. Importing Data from Multiple Files using MultiSelect.mp4 209MB
  9. 10. Looping in VBA (Controlling the Flow of Code)/3. For Next Nested Loop (Loop through Text & Cells).mp4 208MB
  10. 18. Main Project #3 Invoice Generation Tool/6. Enhanced Searchable ListBox Write Selection back to Excel Table.mp4 204MB
  11. 2. Your First Macro/4. Project Dynamic Cell Selection (Special Cells) - Perfect for Flexible Macros.mp4 201MB
  12. 17. Working with Userforms & ActiveX Controls/7. UserForm Basics What You Need to Get Started.mp4 193MB
  13. 13. Excel Tables, Formulas & Pivot Tables/3. Excel Tables Use the Right Syntax.mp4 190MB
  14. 7. Useful Built-in Functions/7. Project Show Top 3 Values in a Message box based on Range Selected.mp4 189MB
  15. 14. Main Project #2 Sales Regional Reporting Tool/5. Exporting Reports as Excel files (Pivot Table & Hard Coded Reports).mp4 188MB
  16. 15. Interacting with Other Applications (Word, PowerPoint etc.)/5. Project Microsoft PowerPoint Export Excel Sheets to PowerPoint Presentation.mp4 185MB
  17. 19. Create your own Custom Functions/7. Project Function That Sums based on Cell Color.mp4 182MB
  18. 18. Main Project #3 Invoice Generation Tool/2. Setting up an Input UserForm to Collect Master Data.mp4 178MB
  19. 18. Main Project #3 Invoice Generation Tool/9. Create Email in Outlook & Attach PDF Invoice.mp4 176MB
  20. 15. Interacting with Other Applications (Word, PowerPoint etc.)/4. Project Microsoft Word Create Personalized Letters in Word from Excel.mp4 170MB
  21. 12. Working with Files, Folders & Text Files/4. FileDialog Property Loop Inside a Folder.mp4 166MB
  22. 13. Excel Tables, Formulas & Pivot Tables/2. Using Excel Formulas in VBA.mp4 165MB
  23. 18. Main Project #3 Invoice Generation Tool/5. Searchable ListBox (with Selection Change event).mp4 161MB
  24. 11. Working with Arrays/8. Project Create a New Worksheet per Company with Specific Information.mp4 160MB
  25. 9. Main Project #1 Create a Tool to Automate Table of Contents/5. TOC Project Adding Error Handling & More Checks.mp4 159MB
  26. 14. Main Project #2 Sales Regional Reporting Tool/2. Project Overview Regional Sales Reporting Tool.mp4 159MB
  27. 16. Workbook and Worksheet Events/4. Refresh PivotTables Automatically & Concept of Range Intersection.mp4 155MB
  28. 20. Working with Charts/4. Show Charts inside UserForms.mp4 150MB
  29. 16. Workbook and Worksheet Events/7. Project Link Page Header to Cell Value (BeforePrint Event).mp4 145MB
  30. 20. Working with Charts/2. Create and Modify a Chart with VBA.mp4 144MB
  31. 16. Workbook and Worksheet Events/2. Workbook Events, Toggle Full Screen (Activate, Deactivate, Open, Close).mp4 142MB
  32. 8. Debugging, Error Handling & Procedure Scope/2. Debugging Options Watch, Locals, Immediate Windows & More.mp4 140MB
  33. 11. Working with Arrays/2. One Dimensional Arrays (and transferring back to sheet).mp4 139MB
  34. 13. Excel Tables, Formulas & Pivot Tables/6. Project Update Existing Formulas with VBA by Adding IFERROR.mp4 138MB
  35. 15. Interacting with Other Applications (Word, PowerPoint etc.)/2. Project PDF Save Specific Sheets as a PDF File.mp4 135MB
  36. 18. Main Project #3 Invoice Generation Tool/1. Tool Overview What You Will Learn.mp4 133MB
  37. 17. Working with Userforms & ActiveX Controls/6. ActiveX to Show or Hide Other ActiveX controls (eg. Actual & Budget reporting).mp4 132MB
  38. 18. Main Project #3 Invoice Generation Tool/3. Working with Multi-Column ListBoxes.mp4 130MB
  39. 17. Working with Userforms & ActiveX Controls/8. UserForm for Data Entry (Input & Check Boxes).mp4 127MB
  40. 3. The Object Model/3. VB Color Guidelines & Keyboard Shortcuts.mp4 126MB
  41. 6. Looping through Collections & Making Decisions/8. Project Get the Number of Formulas on the Worksheet.mp4 122MB
  42. 20. Working with Charts/3. Animated Charts Different Methods.mp4 121MB
  43. 16. Workbook and Worksheet Events/5. Resetting a Dependent Drop-down when the first Drop-down is Changed.mp4 116MB
  44. 14. Main Project #2 Sales Regional Reporting Tool/6. Fine-tuning Report Export Procedure (Double-check if user wants to overwrite).mp4 115MB
  45. 14. Main Project #2 Sales Regional Reporting Tool/8. Track the List of Tasks Completed with VBA.mp4 113MB
  46. 14. Main Project #2 Sales Regional Reporting Tool/9. Final Touches & Creating Interface to Hide Specific Tabs with a Password.mp4 112MB
  47. 7. Useful Built-in Functions/5. Input Box that can Select Ranges (Excel InputBox Method).mp4 112MB
  48. 8. Debugging, Error Handling & Procedure Scope/3. Error Handling Different Methods.mp4 112MB
  49. 2. Your First Macro/3. Visual Basic Editor What You Need to Know.mp4 102MB
  50. 10. Looping in VBA (Controlling the Flow of Code)/5. Do Until & Do While Loop.mp4 98MB
  51. 6. Looping through Collections & Making Decisions/3. For Each to Loop Through Collections (sheets, ranges etc.) in one go.mp4 98MB
  52. 19. Create your own Custom Functions/4. Functions that Split Text and Numbers from Cell Value.mp4 98MB
  53. 12. Working with Files, Folders & Text Files/3. GetOpenFileName Method User Selects a File.mp4 96MB
  54. 14. Main Project #2 Sales Regional Reporting Tool/7. Setting up Automatic Export of Text File (Fix delimiter in CSV to Semicolon).mp4 96MB
  55. 17. Working with Userforms & ActiveX Controls/5. ActiveX Combo Box for Easy Sheet Navigation (Great for Larger Workbooks).mp4 93MB
  56. 6. Looping through Collections & Making Decisions/9. Bonus Unhide All Sheets in One Go.mp4 92MB
  57. 12. Working with Files, Folders & Text Files/5. Create CSV File from Data in Excel.mp4 91MB
  58. 5. Working with Variables/3. Declaring Variables, Arrays & Constants (Role of Option Explicit).mp4 90MB
  59. 15. Interacting with Other Applications (Word, PowerPoint etc.)/3. Project Email Automatically Create Personalized Emails with Attachments.mp4 87MB
  60. 18. Main Project #3 Invoice Generation Tool/4. Edit Master Data with UserForm.mp4 85MB
  61. 7. Useful Built-in Functions/2. Most Useful VBA Functions.mp4 84MB
  62. 9. Main Project #1 Create a Tool to Automate Table of Contents/2. TOC Project The Basics.mp4 82MB
  63. 19. Create your own Custom Functions/5. Using Functions in Sub Procedures.mp4 82MB
  64. 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 77MB
  65. 17. Working with Userforms & ActiveX Controls/3. ActiveX Check Box to Fix Scroll Area & Toggle Screen Settings.mp4 77MB
  66. 12. Working with Files, Folders & Text Files/2. DIR Function Check if Files or Folders Exist.mp4 76MB
  67. 19. Create your own Custom Functions/3. Function to Calculate Age (Result in Years & Months).mp4 76MB
  68. 11. Working with Arrays/5. Two Dimensional Arrays.mp4 76MB
  69. 1. Introduction & Scope/1. Course Structure & Content.mp4 71MB
  70. 5. Working with Variables/4. Using Object Variables (Set statement).mp4 65MB
  71. 19. Create your own Custom Functions/2. Setting up a Simple Function (including Optional Arguments).mp4 64MB
  72. 17. Working with Userforms & ActiveX Controls/2. ActiveX Controls What you Need to Know.mp4 60MB
  73. 17. Working with Userforms & ActiveX Controls/4. ActiveX to Show and Hide Help.mp4 57MB
  74. 16. Workbook and Worksheet Events/3. Worksheet Selection Change Dynamic Font Color of Selected Range.mp4 56MB
  75. 4. Referencing Ranges, Worksheets & Workbooks with VBA/9. Project Save Hard-coded Copy & Macro-free version of workbook.mp4 55MB
  76. 15. Interacting with Other Applications (Word, PowerPoint etc.)/1. Overview & Important Concepts when Interacting with Other Applications.mp4 54MB
  77. 1. Introduction & Scope/4. Course Expectations.mp4 53MB
  78. 1. Introduction & Scope/2. Important Compatibility & Setup Information.mp4 51MB
  79. 10. Looping in VBA (Controlling the Flow of Code)/11. Project Document all Comments in Workbook in a Sheet.mp4 51MB
  80. 12. Working with Files, Folders & Text Files/1. Overview Working with Folders & Files.mp4 50MB
  81. 4. Referencing Ranges, Worksheets & Workbooks with VBA/6. Properly Referencing Worksheets.mp4 49MB
  82. 2. Your First Macro/5. Project Copy (Consolidate) Data - Absolute versus Relative Macro Recording.mp4 47MB
  83. 21. Summary & Final Words/1. Your Next Steps & more Learning.mp4 46MB
  84. 11. Working with Arrays/4. Preserving Dynamic Arrays (adding more elements to the existing array).mp4 45MB
  85. 12. Working with Files, Folders & Text Files/6. Printing & Writing to Text Files for More Control.mp4 45MB
  86. 14. Main Project #2 Sales Regional Reporting Tool/10. Key Takeaways & Tips for VBA based Excel Tools.mp4 44MB
  87. 7. Useful Built-in Functions/1. Overview VBA versus Worksheet Functions.mp4 44MB
  88. 13. Excel Tables, Formulas & Pivot Tables/1. Overview (Pivot) Tables & Formulas.mp4 43MB
  89. 14. Main Project #2 Sales Regional Reporting Tool/1. What You'll Learn (& Should be Aware of..).mp4 41MB
  90. 16. Workbook and Worksheet Events/1. Overview & What are Event Procedures.mp4 39MB
  91. 16. Workbook and Worksheet Events/8. 2 Useful Tips when Working with Events & Key Takeaways.mp4 38MB
  92. 4. Referencing Ranges, Worksheets & Workbooks with VBA/4. 4 Methods to Find the Last Row of your Range.mp4 36MB
  93. 4. Referencing Ranges, Worksheets & Workbooks with VBA/3. Most Useful Range Properties & Methods.mp4 34MB
  94. 1. Introduction & Scope/3. Download Course Project Files.mp4 34MB
  95. 10. Looping in VBA (Controlling the Flow of Code)/12. Useful VBA Statements & Key takeaways for Looping in VBA.mp4 33MB
  96. 20. Working with Charts/1. The Chart Object Library & Section Overview.mp4 32MB
  97. 19. Create your own Custom Functions/1. Section Overview Function Procedures.mp4 32MB
  98. 17. Working with Userforms & ActiveX Controls/1. Overivew UserForms & ActiveX Controls.mp4 32MB
  99. 9. Main Project #1 Create a Tool to Automate Table of Contents/1. Project overivew Table of Contents (TOC) with one click.mp4 31MB
  100. 6. Looping through Collections & Making Decisions/1. Overview Why Collections are a VBA Essential.mp4 29MB
  101. 8. Debugging, Error Handling & Procedure Scope/8. Project Get the Total Number of Formulas (or Comments) Used in a Workbook.mp4 29MB
  102. 8. Debugging, Error Handling & Procedure Scope/4. Faster Code by Suppressing Pop-ups & Flickering Screen.mp4 28MB
  103. 4. Referencing Ranges, Worksheets & Workbooks with VBA/5. Copying & resizing a variably sized range.mp4 28MB
  104. 4. Referencing Ranges, Worksheets & Workbooks with VBA/7. Properly Referencing Workbooks.mp4 28MB
  105. 10. Looping in VBA (Controlling the Flow of Code)/4. For Next Reverse Loop (Delete FilteredHidden Rows).mp4 26MB
  106. 6. Looping through Collections & Making Decisions/4. IF Then (Else, ElseIF) for Conditional Outcomes.mp4 26MB
  107. 4. Referencing Ranges, Worksheets & Workbooks with VBA/2. Referring to Ranges & Writing to Cells in VBA.mp4 24MB
  108. 8. Debugging, Error Handling & Procedure Scope/6. Passing Arguments to Sub Procedures (By Ref, By Val).mp4 24MB
  109. 2. Your First Macro/6. 7 Ways to Run Macros VBA code (incl. creative & modern buttons).mp4 24MB
  110. 5. Working with Variables/8. Key Takeaways for Working with Variables.mp4 23MB
  111. 8. Debugging, Error Handling & Procedure Scope/9. Key Takeaways Debugging, Error Handling & Course Map Status.mp4 23MB
  112. 7. Useful Built-in Functions/3. Message Box (also with Yes, No buttons).mp4 21MB
  113. 10. Looping in VBA (Controlling the Flow of Code)/7. Find Method for Quicker Lookup Results.mp4 20MB
  114. 10. Looping in VBA (Controlling the Flow of Code)/1. Section Overview Looping in VBA.mp4 18MB
  115. 7. Useful Built-in Functions/4. Input Box (VBA InputBox Function).mp4 18MB
  116. 6. Looping through Collections & Making Decisions/6. Goto Statement to Change Program Flow.mp4 18MB
  117. 11. Working with Arrays/6. Variant Arrays Quick Method to Write to Cells.mp4 17MB
  118. 6. Looping through Collections & Making Decisions/2. With & End With for Easier Code Writing.mp4 17MB
  119. 3. The Object Model/7. How to Find the Object, Property & Method.mp4 17MB
  120. 10. Looping in VBA (Controlling the Flow of Code)/2. For Next Counter Loops (Simple Example).mp4 16MB
  121. 8. Debugging, Error Handling & Procedure Scope/5. Procedure Scope & Running one Sub from Another.mp4 15MB
  122. 10. Looping in VBA (Controlling the Flow of Code)/9. Add a Timer to Test & Speech to Inform.mp4 15MB
  123. 10. Looping in VBA (Controlling the Flow of Code)/8. Find Method with Do Loop - Multiple Matches.mp4 14MB
  124. 11. Working with Arrays/3. Dynamic Arrays (size adjusts depending on a condition).mp4 13MB
  125. 3. The Object Model/6. Object Methods.mp4 13MB
  126. 8. Debugging, Error Handling & Procedure Scope/1. Overview Debugging, Handling Errors & Procedure Scope.mp4 12MB
  127. 5. Working with Variables/5. Scoping Variables.mp4 12MB
  128. 2. Your First Macro/2. Steps to Your First Macro Recording.mp4 12MB
  129. 3. The Object Model/4. Excel VBA Object Model.mp4 11MB
  130. 9. Main Project #1 Create a Tool to Automate Table of Contents/3. TOC Project Adding Hyperlinks.mp4 11MB
  131. 6. Looping through Collections & Making Decisions/5. Select Case as Alternative for Many IF Statements.mp4 11MB
  132. 5. Working with Variables/1. Overview Role of Assignment & Variables.mp4 10MB
  133. 3. The Object Model/5. Object Properties.mp4 9MB
  134. 9. Main Project #1 Create a Tool to Automate Table of Contents/4. TOC Project Testing the VBA Code.mp4 9MB
  135. 3. The Object Model/2. VBA's Code Reference Object Library.mp4 9MB
  136. 4. Referencing Ranges, Worksheets & Workbooks with VBA/10. Key Takeaways for Referencing Ranges.mp4 9MB
  137. 3. The Object Model/1. Overview VBA Object Model (What you need to become an expert in VBA).mp4 7MB
  138. 5. Working with Variables/2. Data Types for Better Performance.mp4 7MB
  139. 2. Your First Macro/1. Overview Macros & Visual Basic Editor (VBE).mp4 7MB
  140. 3. The Object Model/9. Conclusion Key Takeaways & Message from Me.mp4 7MB
  141. 10. Looping in VBA (Controlling the Flow of Code)/6. Practical Example of Do Loop (with Inputbox).mp4 7MB
  142. 11. Working with Arrays/1. Overview Working with Arrays in VBA.mp4 6MB
  143. 4. Referencing Ranges, Worksheets & Workbooks with VBA/1. Overview Referencing Ranges, Worksheets & Workbooks.mp4 5MB
  144. 1. Introduction & Scope/3.2 ALL_VBA_Section_Milestone_Files_In_One_Place.zip.zip 3MB
  145. 1. Introduction & Scope/3.1 Excel_VBA_Course_Slides.pdf.pdf 3MB
  146. 1. Introduction & Scope/3.4 How_to_Ask_Questions.pdf.pdf 865KB
  147. 1. Introduction & Scope/3.5 IconSets.xlsx.xlsx 839KB
  148. 2. Your First Macro/6.1 IconSets.xlsx.xlsx 839KB
  149. 1. Introduction & Scope/3.3 VBA_Project_Guide.pdf.pdf 554KB
  150. 18. Main Project #3 Invoice Generation Tool/10.1 Invoice_Generator.xlsm.xlsm 347KB
  151. 10. Looping in VBA (Controlling the Flow of Code)/1.2 S10_Looping.xlsm.xlsm 333KB
  152. 10. Looping in VBA (Controlling the Flow of Code)/1.1 S10_Looping_Start.xlsx.xlsx 313KB
  153. 18. Main Project #3 Invoice Generation Tool/2.1 Invoice_Generator_Start.xlsm.xlsm 234KB
  154. 14. Main Project #2 Sales Regional Reporting Tool/10.1 Monthly_Sales_Reporting_Template_Tool.xlsm.xlsm 136KB
  155. 7. Useful Built-in Functions/1.1 S7_BuiltinFunctions.xlsm.xlsm 126KB
  156. 17. Working with Userforms & ActiveX Controls/1.2 S17_UserForms_ActiveX.xlsm.xlsm 125KB
  157. 20. Working with Charts/1.2 S20_Charts.xlsm.xlsm 124KB
  158. 15. Interacting with Other Applications (Word, PowerPoint etc.)/1.3 S15_Other_Applications.xlsm.xlsm 119KB
  159. 7. Useful Built-in Functions/1.2 S7_BuiltinFunctions_Start.xlsx.xlsx 106KB
  160. 15. Interacting with Other Applications (Word, PowerPoint etc.)/1.2 S15_Other_Applications_Start.xlsx.xlsx 99KB
  161. 6. Looping through Collections & Making Decisions/1.1 S6_Collections_With_IF.xlsm.xlsm 93KB
  162. 12. Working with Files, Folders & Text Files/1.3 S12_Folders_Files.xlsm.xlsm 90KB
  163. 16. Workbook and Worksheet Events/1.1 S16_Events.xlsm.xlsm 89KB
  164. 8. Debugging, Error Handling & Procedure Scope/1.2 S8_ErrorHandling.xlsm.xlsm 89KB
  165. 4. Referencing Ranges, Worksheets & Workbooks with VBA/1.1 S4_ReferencingRanges.xlsm.xlsm 88KB
  166. 2. Your First Macro/1.2 S2_RecordMacros.xlsm.xlsm 87KB
  167. 13. Excel Tables, Formulas & Pivot Tables/1.2 S13_Formulas_Tables_Pivot.xlsm.xlsm 86KB
  168. 8. Debugging, Error Handling & Procedure Scope/1.1 S8_ErrorHandling_Start.xlsm.xlsm 79KB
  169. 20. Working with Charts/1.1 S20_Charts_Start.xlsx.xlsx 78KB
  170. 11. Working with Arrays/1.2 S11_Arrays.xlsm.xlsm 77KB
  171. 17. Working with Userforms & ActiveX Controls/1.1 S17_UserForms_ActiveX_Start.xlsx.xlsx 72KB
  172. 19. Create your own Custom Functions/1.1 S19_FunctionProcedures.xlsm.xlsm 70KB
  173. 16. Workbook and Worksheet Events/1.2 S16_Events_Start.xlsx.xlsx 69KB
  174. 2. Your First Macro/1.1 S2_RecordMacros_Start.xlsx.xlsx 66KB
  175. 4. Referencing Ranges, Worksheets & Workbooks with VBA/1.2 S4_ReferencingRanges_Start.xlsx.xlsx 65KB
  176. 5. Working with Variables/1.1 S5_Variables.xlsm.xlsm 64KB
  177. 6. Looping through Collections & Making Decisions/1.2 S6_Collections_With_IF_Start.xlsx.xlsx 60KB
  178. 13. Excel Tables, Formulas & Pivot Tables/1.1 S13_Formulas_Tables_Pivot_Start.xlsx.xlsx 59KB
  179. 15. Interacting with Other Applications (Word, PowerPoint etc.)/1.1 Letter_Word.docx.docx 59KB
  180. 12. Working with Files, Folders & Text Files/1.2 S12_Folders_Files_Start.xlsx.xlsx 58KB
  181. 11. Working with Arrays/1.1 S11_Arrays_Start.xlsx.xlsx 55KB
  182. 19. Create your own Custom Functions/1.2 S19_FunctionProcedures_Start.xlsx.xlsx 50KB
  183. 5. Working with Variables/1.2 S5_Variables_Start.xlsx.xlsx 49KB
  184. 15. Interacting with Other Applications (Word, PowerPoint etc.)/1.4 Regional Report PowerPoint.pptx.pptx 44KB
  185. 14. Main Project #2 Sales Regional Reporting Tool/2.4 Monthly_Sales_Reporting_Template_Tool_Start.xlsm.xlsm 38KB
  186. 14. Main Project #2 Sales Regional Reporting Tool/4. Setting up a Template as the Basis for Different Reports.vtt 27KB
  187. 18. Main Project #3 Invoice Generation Tool/8. Export PDF & Excel Workbook for Each Invoice based on ListBox Selection.vtt 26KB
  188. 17. Working with Userforms & ActiveX Controls/9. UserForm to Document External Links & Comments (Combo Box & Option button).vtt 23KB
  189. 9. Main Project #1 Create a Tool to Automate Table of Contents/6.1 Project_Automatic_TableOfContent.xlsm.xlsm 22KB
  190. 17. Working with Userforms & ActiveX Controls/7. UserForm Basics What You Need to Get Started.vtt 22KB
  191. 18. Main Project #3 Invoice Generation Tool/10. Final Updates & Debugging.vtt 21KB
  192. 13. Excel Tables, Formulas & Pivot Tables/4. Pivot Tables & VBA What you Need to Know.vtt 21KB
  193. 18. Main Project #3 Invoice Generation Tool/7. MultiPage UserForm to Create Invoices & Email (Setup).vtt 19KB
  194. 15. Interacting with Other Applications (Word, PowerPoint etc.)/5. Project Microsoft PowerPoint Export Excel Sheets to PowerPoint Presentation.vtt 19KB
  195. 18. Main Project #3 Invoice Generation Tool/2. Setting up an Input UserForm to Collect Master Data.vtt 18KB
  196. 14. Main Project #2 Sales Regional Reporting Tool/5. Exporting Reports as Excel files (Pivot Table & Hard Coded Reports).vtt 18KB
  197. 18. Main Project #3 Invoice Generation Tool/5. Searchable ListBox (with Selection Change event).vtt 18KB
  198. 12. Working with Files, Folders & Text Files/4. FileDialog Property Loop Inside a Folder.vtt 17KB
  199. 4. Referencing Ranges, Worksheets & Workbooks with VBA/2. Referring to Ranges & Writing to Cells in VBA.vtt 17KB
  200. 18. Main Project #3 Invoice Generation Tool/6. Enhanced Searchable ListBox Write Selection back to Excel Table.vtt 17KB
  201. 4. Referencing Ranges, Worksheets & Workbooks with VBA/6. Properly Referencing Worksheets.vtt 16KB
  202. 4. Referencing Ranges, Worksheets & Workbooks with VBA/4. 4 Methods to Find the Last Row of your Range.vtt 16KB
  203. 18. Main Project #3 Invoice Generation Tool/1. Tool Overview What You Will Learn.vtt 16KB
  204. 10. Looping in VBA (Controlling the Flow of Code)/3. For Next Nested Loop (Loop through Text & Cells).vtt 16KB
  205. 15. Interacting with Other Applications (Word, PowerPoint etc.)/4. Project Microsoft Word Create Personalized Letters in Word from Excel.vtt 16KB
  206. 14. Main Project #2 Sales Regional Reporting Tool/2. Project Overview Regional Sales Reporting Tool.vtt 15KB
  207. 4. Referencing Ranges, Worksheets & Workbooks with VBA/3. Most Useful Range Properties & Methods.vtt 15KB
  208. 13. Excel Tables, Formulas & Pivot Tables/3. Excel Tables Use the Right Syntax.vtt 15KB
  209. 15. Interacting with Other Applications (Word, PowerPoint etc.)/2. Project PDF Save Specific Sheets as a PDF File.vtt 15KB
  210. 13. Excel Tables, Formulas & Pivot Tables/2. Using Excel Formulas in VBA.vtt 15KB
  211. 8. Debugging, Error Handling & Procedure Scope/2. Debugging Options Watch, Locals, Immediate Windows & More.vtt 15KB
  212. 5. Working with Variables/3. Declaring Variables, Arrays & Constants (Role of Option Explicit).vtt 15KB
  213. 18. Main Project #3 Invoice Generation Tool/9. Create Email in Outlook & Attach PDF Invoice.vtt 14KB
  214. 11. Working with Arrays/2. One Dimensional Arrays (and transferring back to sheet).vtt 14KB
  215. 17. Working with Userforms & ActiveX Controls/8. UserForm for Data Entry (Input & Check Boxes).vtt 14KB
  216. 7. Useful Built-in Functions/1. Overview VBA versus Worksheet Functions.vtt 14KB
  217. 16. Workbook and Worksheet Events/2. Workbook Events, Toggle Full Screen (Activate, Deactivate, Open, Close).vtt 14KB
  218. 17. Working with Userforms & ActiveX Controls/6. ActiveX to Show or Hide Other ActiveX controls (eg. Actual & Budget reporting).vtt 14KB
  219. 2. Your First Macro/3. Visual Basic Editor What You Need to Know.vtt 14KB
  220. 20. Working with Charts/2. Create and Modify a Chart with VBA.vtt 14KB
  221. 9. Main Project #1 Create a Tool to Automate Table of Contents/5. TOC Project Adding Error Handling & More Checks.vtt 14KB
  222. 20. Working with Charts/4. Show Charts inside UserForms.vtt 14KB
  223. 3. The Object Model/3. VB Color Guidelines & Keyboard Shortcuts.vtt 14KB
  224. 16. Workbook and Worksheet Events/4. Refresh PivotTables Automatically & Concept of Range Intersection.vtt 14KB
  225. 2. Your First Macro/6. 7 Ways to Run Macros VBA code (incl. creative & modern buttons).vtt 14KB
  226. 20. Working with Charts/3. Animated Charts Different Methods.vtt 13KB
  227. 4. Referencing Ranges, Worksheets & Workbooks with VBA/9. Project Save Hard-coded Copy & Macro-free version of workbook.vtt 13KB
  228. 12. Working with Files, Folders & Text Files/8. Project Export Data to Text file (fix Delimiter to Semicolon).vtt 13KB
  229. 7. Useful Built-in Functions/5. Input Box that can Select Ranges (Excel InputBox Method).vtt 13KB
  230. 16. Workbook and Worksheet Events/5. Resetting a Dependent Drop-down when the first Drop-down is Changed.vtt 13KB
  231. 6. Looping through Collections & Making Decisions/9. Bonus Unhide All Sheets in One Go.vtt 12KB
  232. 10. Looping in VBA (Controlling the Flow of Code)/11. Project Document all Comments in Workbook in a Sheet.vtt 12KB
  233. 19. Create your own Custom Functions/7. Project Function That Sums based on Cell Color.vtt 12KB
  234. 8. Debugging, Error Handling & Procedure Scope/3. Error Handling Different Methods.vtt 12KB
  235. 2. Your First Macro/4. Project Dynamic Cell Selection (Special Cells) - Perfect for Flexible Macros.vtt 12KB
  236. 8. Debugging, Error Handling & Procedure Scope/4. Faster Code by Suppressing Pop-ups & Flickering Screen.vtt 12KB
  237. 4. Referencing Ranges, Worksheets & Workbooks with VBA/7. Properly Referencing Workbooks.vtt 12KB
  238. 7. Useful Built-in Functions/2. Most Useful VBA Functions.vtt 11KB
  239. 14. Main Project #2 Sales Regional Reporting Tool/9. Final Touches & Creating Interface to Hide Specific Tabs with a Password.vtt 11KB
  240. 18. Main Project #3 Invoice Generation Tool/3. Working with Multi-Column ListBoxes.vtt 11KB
  241. 9. Main Project #1 Create a Tool to Automate Table of Contents/2. TOC Project The Basics.vtt 11KB
  242. 14. Main Project #2 Sales Regional Reporting Tool/6. Fine-tuning Report Export Procedure (Double-check if user wants to overwrite).vtt 11KB
  243. 7. Useful Built-in Functions/7. Project Show Top 3 Values in a Message box based on Range Selected.vtt 11KB
  244. 8. Debugging, Error Handling & Procedure Scope/8. Project Get the Total Number of Formulas (or Comments) Used in a Workbook.vtt 11KB
  245. 14. Main Project #2 Sales Regional Reporting Tool/2.3 Sales_Document_UrbanRight.xlsx.xlsx 11KB
  246. 14. Main Project #2 Sales Regional Reporting Tool/8. Track the List of Tasks Completed with VBA.vtt 11KB
  247. 17. Working with Userforms & ActiveX Controls/5. ActiveX Combo Box for Easy Sheet Navigation (Great for Larger Workbooks).vtt 11KB
  248. 6. Looping through Collections & Making Decisions/4. IF Then (Else, ElseIF) for Conditional Outcomes.vtt 11KB
  249. 14. Main Project #2 Sales Regional Reporting Tool/2.2 Sales_Document_BereKleid.xlsx.xlsx 11KB
  250. 6. Looping through Collections & Making Decisions/3. For Each to Loop Through Collections (sheets, ranges etc.) in one go.vtt 11KB
  251. 14. Main Project #2 Sales Regional Reporting Tool/2.5 Sales_Document_LucasBasics.xlsx.xlsx 11KB
  252. 2. Your First Macro/5. Project Copy (Consolidate) Data - Absolute versus Relative Macro Recording.vtt 11KB
  253. 4. Referencing Ranges, Worksheets & Workbooks with VBA/5. Copying & resizing a variably sized range.vtt 10KB
  254. 14. Main Project #2 Sales Regional Reporting Tool/2.1 Sales_Document_MetaCreations.xlsx.xlsx 10KB
  255. 10. Looping in VBA (Controlling the Flow of Code)/5. Do Until & Do While Loop.vtt 10KB
  256. 14. Main Project #2 Sales Regional Reporting Tool/3. Importing Data from Multiple Files using MultiSelect.vtt 10KB
  257. 15. Interacting with Other Applications (Word, PowerPoint etc.)/3. Project Email Automatically Create Personalized Emails with Attachments.vtt 10KB
  258. 10. Looping in VBA (Controlling the Flow of Code)/7. Find Method for Quicker Lookup Results.vtt 10KB
  259. 12. Working with Files, Folders & Text Files/3. GetOpenFileName Method User Selects a File.vtt 10KB
  260. 8. Debugging, Error Handling & Procedure Scope/6. Passing Arguments to Sub Procedures (By Ref, By Val).vtt 10KB
  261. 11. Working with Arrays/8. Project Create a New Worksheet per Company with Specific Information.vtt 9KB
  262. 10. Looping in VBA (Controlling the Flow of Code)/4. For Next Reverse Loop (Delete FilteredHidden Rows).vtt 9KB
  263. 19. Create your own Custom Functions/4. Functions that Split Text and Numbers from Cell Value.vtt 9KB
  264. 12. Working with Files, Folders & Text Files/2. DIR Function Check if Files or Folders Exist.vtt 9KB
  265. 7. Useful Built-in Functions/3. Message Box (also with Yes, No buttons).vtt 9KB
  266. 12. Working with Files, Folders & Text Files/1.1 Test_data.xlsx.xlsx 9KB
  267. 10. Looping in VBA (Controlling the Flow of Code)/2. For Next Counter Loops (Simple Example).vtt 9KB
  268. 3. The Object Model/7. How to Find the Object, Property & Method.vtt 9KB
  269. 11. Working with Arrays/6. Variant Arrays Quick Method to Write to Cells.vtt 9KB
  270. 10. Looping in VBA (Controlling the Flow of Code)/9. Add a Timer to Test & Speech to Inform.vtt 9KB
  271. 16. Workbook and Worksheet Events/7. Project Link Page Header to Cell Value (BeforePrint Event).vtt 9KB
  272. 14. Main Project #2 Sales Regional Reporting Tool/7. Setting up Automatic Export of Text File (Fix delimiter in CSV to Semicolon).vtt 8KB
  273. 6. Looping through Collections & Making Decisions/6. Goto Statement to Change Program Flow.vtt 8KB
  274. 17. Working with Userforms & ActiveX Controls/3. ActiveX Check Box to Fix Scroll Area & Toggle Screen Settings.vtt 8KB
  275. 17. Working with Userforms & ActiveX Controls/2. ActiveX Controls What you Need to Know.vtt 8KB
  276. 11. Working with Arrays/5. Two Dimensional Arrays.vtt 8KB
  277. 6. Looping through Collections & Making Decisions/8. Project Get the Number of Formulas on the Worksheet.vtt 8KB
  278. 13. Excel Tables, Formulas & Pivot Tables/6. Project Update Existing Formulas with VBA by Adding IFERROR.vtt 8KB
  279. 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 8KB
  280. 12. Working with Files, Folders & Text Files/5. Create CSV File from Data in Excel.vtt 7KB
  281. 5. Working with Variables/4. Using Object Variables (Set statement).vtt 7KB
  282. 7. Useful Built-in Functions/4. Input Box (VBA InputBox Function).vtt 7KB
  283. 12. Working with Files, Folders & Text Files/6. Printing & Writing to Text Files for More Control.vtt 7KB
  284. 18. Main Project #3 Invoice Generation Tool/4. Edit Master Data with UserForm.vtt 7KB
  285. 3. The Object Model/4. Excel VBA Object Model.vtt 7KB
  286. 11. Working with Arrays/3. Dynamic Arrays (size adjusts depending on a condition).vtt 7KB
  287. 2. Your First Macro/2. Steps to Your First Macro Recording.vtt 7KB
  288. 5. Working with Variables/5. Scoping Variables.vtt 7KB
  289. 10. Looping in VBA (Controlling the Flow of Code)/8. Find Method with Do Loop - Multiple Matches.vtt 7KB
  290. 6. Looping through Collections & Making Decisions/2. With & End With for Easier Code Writing.vtt 7KB
  291. 3. The Object Model/6. Object Methods.vtt 7KB
  292. 16. Workbook and Worksheet Events/3. Worksheet Selection Change Dynamic Font Color of Selected Range.vtt 7KB
  293. 9. Main Project #1 Create a Tool to Automate Table of Contents/3. TOC Project Adding Hyperlinks.vtt 7KB
  294. 17. Working with Userforms & ActiveX Controls/4. ActiveX to Show and Hide Help.vtt 7KB
  295. 19. Create your own Custom Functions/5. Using Functions in Sub Procedures.vtt 7KB
  296. 19. Create your own Custom Functions/3. Function to Calculate Age (Result in Years & Months).vtt 6KB
  297. 8. Debugging, Error Handling & Procedure Scope/5. Procedure Scope & Running one Sub from Another.vtt 6KB
  298. 19. Create your own Custom Functions/2. Setting up a Simple Function (including Optional Arguments).vtt 6KB
  299. 6. Looping through Collections & Making Decisions/5. Select Case as Alternative for Many IF Statements.vtt 6KB
  300. 15. Interacting with Other Applications (Word, PowerPoint etc.)/1. Overview & Important Concepts when Interacting with Other Applications.vtt 6KB
  301. 3. The Object Model/5. Object Properties.vtt 5KB
  302. 1. Introduction & Scope/1. Course Structure & Content.vtt 5KB
  303. 21. Summary & Final Words/2. BONUS Lecture More from Leila.html 5KB
  304. 9. Main Project #1 Create a Tool to Automate Table of Contents/4. TOC Project Testing the VBA Code.vtt 5KB
  305. 3. The Object Model/2. VBA's Code Reference Object Library.vtt 5KB
  306. 1. Introduction & Scope/2. Important Compatibility & Setup Information.vtt 4KB
  307. 14. Main Project #2 Sales Regional Reporting Tool/1. What You'll Learn (& Should be Aware of..).vtt 4KB
  308. 11. Working with Arrays/4. Preserving Dynamic Arrays (adding more elements to the existing array).vtt 4KB
  309. 10. Looping in VBA (Controlling the Flow of Code)/12. Useful VBA Statements & Key takeaways for Looping in VBA.vtt 4KB
  310. 20. Working with Charts/1. The Chart Object Library & Section Overview.vtt 4KB
  311. 16. Workbook and Worksheet Events/8. 2 Useful Tips when Working with Events & Key Takeaways.vtt 4KB
  312. 5. Working with Variables/2. Data Types for Better Performance.vtt 4KB
  313. 16. Workbook and Worksheet Events/1. Overview & What are Event Procedures.vtt 4KB
  314. 10. Looping in VBA (Controlling the Flow of Code)/6. Practical Example of Do Loop (with Inputbox).vtt 3KB
  315. 1. Introduction & Scope/4. Course Expectations.vtt 3KB
  316. 4. Referencing Ranges, Worksheets & Workbooks with VBA/10. Key Takeaways for Referencing Ranges.vtt 3KB
  317. 5. Working with Variables/1. Overview Role of Assignment & Variables.vtt 3KB
  318. 12. Working with Files, Folders & Text Files/1. Overview Working with Folders & Files.vtt 3KB
  319. 3. The Object Model/9. Conclusion Key Takeaways & Message from Me.vtt 3KB
  320. 17. Working with Userforms & ActiveX Controls/1.3 S17_PictureClip.zip.zip 3KB
  321. 21. Summary & Final Words/1. Your Next Steps & more Learning.vtt 3KB
  322. 14. Main Project #2 Sales Regional Reporting Tool/10. Key Takeaways & Tips for VBA based Excel Tools.vtt 3KB
  323. 10. Looping in VBA (Controlling the Flow of Code)/1. Section Overview Looping in VBA.vtt 3KB
  324. 13. Excel Tables, Formulas & Pivot Tables/1. Overview (Pivot) Tables & Formulas.vtt 3KB
  325. 5. Working with Variables/8. Key Takeaways for Working with Variables.vtt 2KB
  326. 9. Main Project #1 Create a Tool to Automate Table of Contents/1. Project overivew Table of Contents (TOC) with one click.vtt 2KB
  327. 8. Debugging, Error Handling & Procedure Scope/9. Key Takeaways Debugging, Error Handling & Course Map Status.vtt 2KB
  328. 19. Create your own Custom Functions/1. Section Overview Function Procedures.vtt 2KB
  329. 8. Debugging, Error Handling & Procedure Scope/1. Overview Debugging, Handling Errors & Procedure Scope.vtt 2KB
  330. 1. Introduction & Scope/3. Download Course Project Files.vtt 2KB
  331. 17. Working with Userforms & ActiveX Controls/1. Overivew UserForms & ActiveX Controls.vtt 2KB
  332. 3. The Object Model/1. Overview VBA Object Model (What you need to become an expert in VBA).vtt 2KB
  333. 2. Your First Macro/1. Overview Macros & Visual Basic Editor (VBE).vtt 2KB
  334. 11. Working with Arrays/1. Overview Working with Arrays in VBA.vtt 2KB
  335. 2. Your First Macro/8. What's the Difference Between Macros and VBA.html 2KB
  336. 4. Referencing Ranges, Worksheets & Workbooks with VBA/8. Activity Save a Hard-coded Copy of Workbook.html 2KB
  337. 6. Looping through Collections & Making Decisions/1. Overview Why Collections are a VBA Essential.vtt 2KB
  338. 4. Referencing Ranges, Worksheets & Workbooks with VBA/1. Overview Referencing Ranges, Worksheets & Workbooks.vtt 1KB
  339. 2. Your First Macro/7. Activity Record a Macro that Deletes all Comments.html 1KB
  340. 5. Working with Variables/6. Activity Revisit Hard-coded Workbook Project & Use Variable Assignment.html 1KB
  341. 7. Useful Built-in Functions/6. Activity Show Top 3 Values in a Message Box Based on Range Selected.html 1KB
  342. 10. Looping in VBA (Controlling the Flow of Code)/10. Activity Document all Comments in Workbook in a Sheet.html 1KB
  343. 8. Debugging, Error Handling & Procedure Scope/7. Activity Get the Total Number of Formulas (or Comments) Used in a Workbook.html 959B
  344. 13. Excel Tables, Formulas & Pivot Tables/5. Activity Update Existing Formulas with VBA by Adding IFERROR.html 919B
  345. 11. Working with Arrays/7. Activity Create a New Worksheet per Company with Specific Information.html 915B
  346. 16. Workbook and Worksheet Events/6. Activity Link Page Header to Cell Value (BeforePrint Event).html 803B
  347. 12. Working with Files, Folders & Text Files/7. Activity Export Data to Text file (fix Delimiter to Semicolon).html 741B
  348. 19. Create your own Custom Functions/6. Activity Function That Sums based on Cell Color.html 727B
  349. 12. Working with Files, Folders & Text Files/1.4 TestTextCSV.csv.csv 724B
  350. 6. Looping through Collections & Making Decisions/7. Activity Get the Number of Formulas on the worksheet.html 674B
  351. 20. Working with Charts/5. Key Takeaways Charts.html 672B
  352. 17. Working with Userforms & ActiveX Controls/10. UserForm Checklist & Course Map Status.html 614B
  353. 14. Main Project #2 Sales Regional Reporting Tool/11. Second Milestone Completed!.html 553B
  354. 9. Main Project #1 Create a Tool to Automate Table of Contents/7. First Milestone Completed!.html 544B
  355. 19. Create your own Custom Functions/8. Key Takeaways Function Procedures in VBA & Course Map Status.html 493B
  356. 18. Main Project #3 Invoice Generation Tool/11. Last Milestone Completed!.html 459B
  357. 6. Looping through Collections & Making Decisions/10. Key Takeaways for Collections & Decision Making in VBA.html 450B
  358. 15. Interacting with Other Applications (Word, PowerPoint etc.)/6. Key Takeaways when Working with other Applications.html 434B
  359. 11. Working with Arrays/9. Key Takeaways Arrays.html 425B
  360. 13. Excel Tables, Formulas & Pivot Tables/7. Key Takeaways (Pivot) Tables & Formula.html 415B
  361. 12. Working with Files, Folders & Text Files/9. Key Takeaways Files & Folders.html 413B
  362. 7. Useful Built-in Functions/8. Key Takeaways Built-in Functions.html 386B
  363. 2. Your First Macro/9. Quiz Test Your Knowledge on Macros.html 134B
  364. 3. The Object Model/8. Test Your Knowledge about the Object Model.html 134B
  365. 5. Working with Variables/7. Test Your Knowledge on Variables and data types.html 134B
  366. [FreeCourseLab.com].url 126B
  367. 14. Main Project #2 Sales Regional Reporting Tool/4.1 VLOOKUP Explained.html 89B
  368. 14. Main Project #2 Sales Regional Reporting Tool/4.2 Excel IF Function.html 89B
  369. 14. Main Project #2 Sales Regional Reporting Tool/4.3 PivotTable with Pivot Chart & Slicers.html 89B
  370. 14. Main Project #2 Sales Regional Reporting Tool/4.4 PivotTable with Slicers.html 89B
  371. 16. Workbook and Worksheet Events/5.1 INDEX MATCH Basics video.html 89B