:Search:

Udemy - Unlock Excel VBA and Excel Macros [FreeAllCourse]

Torrent:
Info Hash: 712ED6BB798AA1BDD155113EB4BA5F70C89CDD96
Thumbnail:
Similar Posts:
Uploader: LMorningStar
Source: 1 Logo 1337x
Downloads: 150
Type: Tutorials
Images:
Udemy - Unlock Excel VBA and Excel Macros [FreeAllCourse]
Language: English
Category: Other
Size: 11.7 GB
Added: June 2, 2023, 5:39 a.m.
Peers: Seeders: 1, Leechers: 2 (Last updated: 7 months, 1 week ago)
Tracker Data:
Tracker Seeders Leechers Completed
udp://open.stealth.si:80/announce 0 0 0
udp://exodus.desync.com:6969/announce (Failed to scrape UDP tracker) 0 0 0
udp://tracker.cyberia.is:6969/announce (Failed to scrape UDP tracker) 0 0 0
udp://tracker.opentrackr.org:1337/announce 1 0 150
udp://tracker.torrent.eu.org:451/announce 0 0 0
udp://explodie.org:6969/announce (Failed to scrape UDP tracker) 0 0 0
udp://tracker.birkenwald.de:6969/announce 0 2 0
udp://tracker.moeking.me:6969/announce (Failed to scrape UDP tracker) 0 0 0
udp://ipv4.tracker.harry.lu:80/announce (Failed to scrape UDP tracker) 0 0 0
udp://tracker.therarbg.to:6969/announce 0 0 0
Files:
  1. 1. Course Structure & Content.mp4 60.1 MB
  2. 1. Course Structure & Content.srt 6.0 KB
  3. 2. Important Compatibility & Setup Information.mp4 51.4 MB
  4. 2. Important Compatibility & Setup Information.srt 5.3 KB
  5. 3. Course Resources Download Course Project Files.mp4 30.5 MB
  6. 3. Course Resources Download Course Project Files.srt 2.6 KB
  7. 3.1 VBA_Project_Guide.pdf.pdf 184.5 KB
  8. 3.2 ALL_VBA_Section_Milestone_Files_In_One_Place.zip.zip 3.3 MB
  9. 3.3 IconSets.xlsx.xlsx 838.6 KB
  10. 3.4 Excel_VBA_Course_Slides.pdf.pdf 2.0 MB
  11. 3.5 How_to_Ask_Questions.pdf.pdf 229.9 KB
  12. 4. Course Expectations.mp4 52.5 MB
  13. 4. Course Expectations.srt 4.0 KB
  14. 5. Course Outline for Quick Reference.html 505 bytes
  15. 5.1 Detailed_VBA_Course_Outline.xlsx.xlsx 22.8 KB
  16. 1. Section Overview Looping in VBA.mp4 18.0 MB
  17. 1. Section Overview Looping in VBA.srt 3.2 KB
  18. 1.1 S10_Looping_Start.xlsx.xlsx 313.5 KB
  19. 1.2 S10_Looping.xlsm.xlsm 333.3 KB
  20. 10. Activity Document all Comments in Workbook in a Sheet.html 1.1 KB
  21. 11. Project Document all Comments in Workbook in a Sheet.mp4 51.0 MB
  22. 11. Project Document all Comments in Workbook in a Sheet.srt 10.5 KB
  23. 12. Useful VBA Statements & Key takeaways for Looping in VBA.mp4 33.2 MB
  24. 12. Useful VBA Statements & Key takeaways for Looping in VBA.srt 4.9 KB
  25. 2. For Next Counter Loops (Simple Example).mp4 16.3 MB
  26. 2. For Next Counter Loops (Simple Example).srt 10.7 KB
  27. 3. For Next Nested Loop (Loop through Text & Cells).mp4 208.3 MB
  28. 3. For Next Nested Loop (Loop through Text & Cells).srt 19.4 KB
  29. 4. For Next Reverse Loop (Delete FilteredHidden Rows).mp4 25.9 MB
  30. 4. For Next Reverse Loop (Delete FilteredHidden Rows).srt 11.3 KB
  31. 5. Do Until & Do While Loop.mp4 98.1 MB
  32. 5. Do Until & Do While Loop.srt 12.4 KB
  33. 6. Practical Example of Do Loop (with Inputbox).mp4 6.6 MB
  34. 6. Practical Example of Do Loop (with Inputbox).srt 4.2 KB
  35. 7. Find Method for Quicker Lookup Results.mp4 20.3 MB
  36. 7. Find Method for Quicker Lookup Results.srt 11.6 KB
  37. 8. Find Method with Do Loop - Multiple Matches.mp4 14.5 MB
  38. 8. Find Method with Do Loop - Multiple Matches.srt 8.2 KB
  39. 9. Add a Timer to Test & Speech to Inform.mp4 14.7 MB
  40. 9. Add a Timer to Test & Speech to Inform.srt 14.7 MB
  41. 1. Overview Working with Arrays in VBA.mp4 6.2 MB
  42. 1. Overview Working with Arrays in VBA.srt 2.1 KB
  43. 1.1 S11_Arrays.xlsm.xlsm 77.2 KB
  44. 1.2 S11_Arrays_Start.xlsx.xlsx 54.6 KB
  45. 2. One Dimensional Arrays (and transferring back to sheet).mp4 138.8 MB
  46. 2. One Dimensional Arrays (and transferring back to sheet).srt 17.4 KB
  47. 3. Dynamic Arrays (size adjusts depending on a condition).mp4 13.0 MB
  48. 3. Dynamic Arrays (size adjusts depending on a condition).srt 8.4 KB
  49. 4. Preserving Dynamic Arrays (adding more elements to the existing array).mp4 44.7 MB
  50. 4. Preserving Dynamic Arrays (adding more elements to the existing array).srt 5.0 KB
  51. 5. Two Dimensional Arrays.mp4 75.6 MB
  52. 5. Two Dimensional Arrays.srt 9.3 KB
  53. 6. Variant Arrays Quick Method to Write to Cells.mp4 17.1 MB
  54. 6. Variant Arrays Quick Method to Write to Cells.srt 10.5 KB
  55. 7. Activity Create a New Worksheet per Company with Specific Information.html 915 bytes
  56. 8. Project Create a New Worksheet per Company with Specific Information.mp4 159.8 MB
  57. 8. Project Create a New Worksheet per Company with Specific Information.srt 11.4 KB
  58. 9. Key Takeaways Arrays.html 425 bytes
  59. 1. Overview Working with Folders & Files.mp4 50.5 MB
  60. 1. Overview Working with Folders & Files.srt 3.8 KB
  61. 1.1 TestTextCSV.csv.csv 724 bytes
  62. 1.2 S12_Folders_Files.xlsm.xlsm 90.1 KB
  63. 1.3 S12_Folders_Files_Start.xlsx.xlsx 58.2 KB
  64. 1.4 Test_data.xlsx.xlsx 9.1 KB
  65. 2. DIR Function Check if Files or Folders Exist.mp4 76.4 MB
  66. 2. DIR Function Check if Files or Folders Exist.srt 11.0 KB
  67. 3. GetOpenFileName Method User Selects a File.mp4 95.8 MB
  68. 3. GetOpenFileName Method User Selects a File.srt 11.7 KB
  69. 4. FileDialog Property Loop Inside a Folder.mp4 166.1 MB
  70. 4. FileDialog Property Loop Inside a Folder.srt 20.7 KB
  71. 5. Create CSV File from Data in Excel.mp4 90.5 MB
  72. 5. Create CSV File from Data in Excel.srt 8.9 KB
  73. 6. Printing & Writing to Text Files for More Control.mp4 44.6 MB
  74. 6. Printing & Writing to Text Files for More Control.srt 8.8 KB
  75. 7. Activity Export Data to Text file (fix Delimiter to Semicolon).html 741 bytes
  76. 8. Project Export Data to Text file (fix Delimiter to Semicolon).mp4 224.9 MB
  77. 8. Project Export Data to Text file (fix Delimiter to Semicolon).srt 15.6 KB
  78. 9. Key Takeaways Files & Folders.html 413 bytes
  79. 1. Overview (Pivot) Tables & Formulas.mp4 43.4 MB
  80. 1. Overview (Pivot) Tables & Formulas.srt 3.0 KB
  81. 1.1 S13_Formulas_Tables_Pivot.xlsm.xlsm 86.1 KB
  82. 1.2 S13_Formulas_Tables_Pivot_Start.xlsx.xlsx 59.4 KB
  83. 2. Using Excel Formulas in VBA.mp4 165.5 MB
  84. 2. Using Excel Formulas in VBA.srt 17.6 KB
  85. 3. Excel Tables Use the Right Syntax.mp4 190.4 MB
  86. 3. Excel Tables Use the Right Syntax.srt 17.8 KB
  87. 4. Pivot Tables & VBA What you Need to Know.mp4 226.6 MB
  88. 4. Pivot Tables & VBA What you Need to Know.srt 24.4 KB
  89. 5. Activity Update Existing Formulas with VBA by Adding IFERROR.html 919 bytes
  90. 6. Project Update Existing Formulas with VBA by Adding IFERROR.mp4 138.5 MB
  91. 6. Project Update Existing Formulas with VBA by Adding IFERROR.srt 9.2 KB
  92. 7. Key Takeaways (Pivot) Tables & Formula.html 415 bytes
  93. 1. What You'll Learn (& Should be Aware of..).mp4 41.4 MB
  94. 1. What You'll Learn (& Should be Aware of..).srt 5.2 KB
  95. 10. Key Takeaways & Tips for VBA based Excel Tools.mp4 44.3 MB
  96. 10. Key Takeaways & Tips for VBA based Excel Tools.srt 3.5 KB
  97. 10.1 Monthly_Sales_Reporting_Template_Tool.xlsm.xlsm 136.1 KB
  98. 11. Second Milestone Completed!.html 553 bytes
  99. 2. Project Overview Regional Sales Reporting Tool.mp4 159.2 MB
  100. 2. Project Overview Regional Sales Reporting Tool.srt 18.2 KB
  101. 2.1 Sales_Document_BereKleid.xlsx.xlsx 10.8 KB
  102. 2.2 Sales_Document_LucasBasics.xlsx.xlsx 10.7 KB
  103. 2.3 Sales_Document_UrbanRight.xlsx.xlsx 10.9 KB
  104. 2.4 Monthly_Sales_Reporting_Template_Tool_Start.xlsm.xlsm 38.2 KB
  105. 2.5 Sales_Document_MetaCreations.xlsx.xlsx 10.3 KB
  106. 3. Importing Data from Multiple Files using MultiSelect.mp4 208.5 MB
  107. 3. Importing Data from Multiple Files using MultiSelect.srt 11.9 KB
  108. 4. Setting up a Template as the Basis for Different Reports.mp4 310.4 MB
  109. 4. Setting up a Template as the Basis for Different Reports.srt 32.3 KB
  110. 4.1 PivotTable with Pivot Chart & Slicers.html 89 bytes
  111. 4.2 Excel IF Function.html 89 bytes
  112. 4.3 VLOOKUP Explained.html 89 bytes
  113. 4.4 PivotTable with Slicers.html 89 bytes
  114. 5. Exporting Reports as Excel files (Pivot Table & Hard Coded Reports).mp4 188.2 MB
  115. 5. Exporting Reports as Excel files (Pivot Table & Hard Coded Reports).srt 20.8 KB
  116. 6. Fine-tuning Report Export Procedure (Double-check if user wants to overwrite).mp4 114.6 MB
  117. 6. Fine-tuning Report Export Procedure (Double-check if user wants to overwrite).srt 13.2 KB
  118. 7. Setting up Automatic Export of Text File (Fix delimiter in CSV to Semicolon).mp4 95.6 MB
  119. 7. Setting up Automatic Export of Text File (Fix delimiter in CSV to Semicolon).srt 9.9 KB
  120. 8. Track the List of Tasks Completed with VBA.mp4 113.0 MB
  121. 8. Track the List of Tasks Completed with VBA.srt 12.8 KB
  122. 9. Final Touches & Creating Interface to Hide Specific Tabs with a Password.mp4 112.4 MB
  123. 9. Final Touches & Creating Interface to Hide Specific Tabs with a Password.srt 13.5 KB
  124. 1. Overview & Important Concepts when Interacting with Other Applications.mp4 54.2 MB
  125. 1. Overview & Important Concepts when Interacting with Other Applications.srt 6.5 KB
  126. 1.1 S15_Other_Applications.xlsm.xlsm 118.6 KB
  127. 1.2 Regional Report PowerPoint.pptx.pptx 43.9 KB
  128. 1.3 S15_Other_Applications_Start.xlsx.xlsx 99.0 KB
  129. 1.4 Letter_Word.docx.docx 58.8 KB
  130. 2. Project PDF Save Specific Sheets as a PDF File.mp4 135.5 MB
  131. 2. Project PDF Save Specific Sheets as a PDF File.srt 18.1 KB
  132. 3. Project Email Automatically Create Personalized Emails with Attachments.mp4 87.0 MB
  133. 3. Project Email Automatically Create Personalized Emails with Attachments.srt 11.7 KB
  134. 4. Project Microsoft Word Create Personalized Letters in Word from Excel.mp4 169.7 MB
  135. 4. Project Microsoft Word Create Personalized Letters in Word from Excel.srt 19.1 KB
  136. 5. Project Microsoft PowerPoint Export Excel Sheets to PowerPoint Presentation.mp4 185.4 MB
  137. 5. Project Microsoft PowerPoint Export Excel Sheets to PowerPoint Presentation.srt 22.8 KB
  138. 6. Key Takeaways when Working with other Applications.html 434 bytes
  139. 1. Overview & What are Event Procedures.mp4 39.0 MB
  140. 1. Overview & What are Event Procedures.srt 4.3 KB
  141. 1.1 S16_Events.xlsm.xlsm 89.5 KB
  142. 1.2 S16_Events_Start.xlsx.xlsx 69.3 KB
  143. 2. Workbook Events, Toggle Full Screen (Activate, Deactivate, Open, Close).mp4 141.5 MB
  144. 2. Workbook Events, Toggle Full Screen (Activate, Deactivate, Open, Close).srt 16.6 KB
  145. 3. Worksheet Selection Change Dynamic Font Color of Selected Range.mp4 56.3 MB
  146. 3. Worksheet Selection Change Dynamic Font Color of Selected Range.srt 8.0 KB
  147. 4. Refresh PivotTables Automatically & Concept of Range Intersection.mp4 154.9 MB
  148. 4. Refresh PivotTables Automatically & Concept of Range Intersection.srt 16.4 KB
  149. 5. Resetting a Dependent Drop-down when the first Drop-down is Changed.mp4 116.0 MB
  150. 5. Resetting a Dependent Drop-down when the first Drop-down is Changed.srt 15.1 KB
  151. 5.1 INDEX MATCH Basics video.html 89 bytes
  152. 6. Activity Link Page Header to Cell Value (BeforePrint Event).html 803 bytes
  153. 7. Project Link Page Header to Cell Value (BeforePrint Event).mp4 144.9 MB
  154. 7. Project Link Page Header to Cell Value (BeforePrint Event).srt 10.3 KB
  155. 8. 2 Useful Tips when Working with Events & Key Takeaways.mp4 38.0 MB
  156. 8. 2 Useful Tips when Working with Events & Key Takeaways.srt 4.4 KB
  157. 1. Overview UserForms & ActiveX Controls.mp4 31.7 MB
  158. 1. Overview UserForms & ActiveX Controls.srt 2.5 KB
  159. 1.1 S17_UserForms_ActiveX.xlsm.xlsm 124.8 KB
  160. 1.2 S17_PictureClip.zip.zip 3.1 KB
  161. 1.3 S17_UserForms_ActiveX_Start.xlsx.xlsx 71.8 KB
  162. 10. Bonus ListBox to Print Multiple Pages in ONE GO.mp4 73.1 MB
  163. 10. Bonus ListBox to Print Multiple Pages in ONE GO.srt 16.2 KB
  164. 10.1 S17_Bonus_ListBox_PrintOut_Start.xlsx.xlsx 49.8 KB
  165. 10.2 S17_Bonus_ListBox_PrintOut.xlsm.xlsm 75.5 KB
  166. 11. UserForm Checklist & Course Map Status.html 614 bytes
  167. 2. ActiveX Controls What you Need to Know.mp4 59.5 MB
  168. 2. ActiveX Controls What you Need to Know.srt 9.5 KB
  169. 3. ActiveX Check Box to Fix Scroll Area & Toggle Screen Settings.mp4 77.1 MB
  170. 3. ActiveX Check Box to Fix Scroll Area & Toggle Screen Settings.srt 9.7 KB
  171. 4. ActiveX to Show and Hide Help.mp4 56.7 MB
  172. 4. ActiveX to Show and Hide Help.srt 7.9 KB
  173. 5. ActiveX Combo Box for Easy Sheet Navigation (Great for Larger Workbooks).mp4 92.5 MB
  174. 5. ActiveX Combo Box for Easy Sheet Navigation (Great for Larger Workbooks).srt 13.2 KB
  175. 6. ActiveX to Show or Hide Other ActiveX controls (eg. Actual & Budget reporting).mp4 132.4 MB
  176. 6. ActiveX to Show or Hide Other ActiveX controls (eg. Actual & Budget reporting).srt 16.7 KB
  177. 7. UserForm Basics What You Need to Get Started.mp4 193.1 MB
  178. 7. UserForm Basics What You Need to Get Started.srt 26.2 KB
  179. 8. UserForm for Data Entry (Input & Check Boxes).mp4 126.8 MB
  180. 8. UserForm for Data Entry (Input & Check Boxes).srt 17.1 KB
  181. 9. UserForm to Document External Links & Comments (Combo Box & Option button).mp4 234.3 MB
  182. 9. UserForm to Document External Links & Comments (Combo Box & Option button).srt 27.0 KB
  183. 1. Tool Overview What You Will Learn.mp4 132.8 MB
  184. 1. Tool Overview What You Will Learn.srt 19.3 KB
  185. 10. Final Updates & Debugging.mp4 238.8 MB
  186. 10. Final Updates & Debugging.srt 25.2 KB
  187. 10.1 Invoice_Generator.xlsm.xlsm 347.2 KB
  188. 11. Last Milestone Completed!.html 459 bytes
  189. 2. Setting up an Input UserForm to Collect Master Data.mp4 178.1 MB
  190. 2. Setting up an Input UserForm to Collect Master Data.srt 21.9 KB
  191. 2.1 Invoice_Generator_Start.xlsm.xlsm 234.4 KB
  192. 3. Working with Multi-Column ListBoxes.mp4 130.5 MB
  193. 3. Working with Multi-Column ListBoxes.srt 13.2 KB
  194. 4. Edit Master Data with UserForm.mp4 85.4 MB
  195. 4. Edit Master Data with UserForm.srt 8.4 KB
  196. 5. Searchable ListBox (with Selection Change event).mp4 160.9 MB
  197. 5. Searchable ListBox (with Selection Change event).srt 20.9 KB
  198. 6. Enhanced Searchable ListBox Write Selection back to Excel Table.mp4 204.2 MB
  199. 6. Enhanced Searchable ListBox Write Selection back to Excel Table.srt 20.0 KB
  200. 7. MultiPage UserForm to Create Invoices & Email (Setup).mp4 218.9 MB
  201. 7. MultiPage UserForm to Create Invoices & Email (Setup).srt 23.2 KB
  202. 8. Export PDF & Excel Workbook for Each Invoice based on ListBox Selection.mp4 280.5 MB
  203. 8. Export PDF & Excel Workbook for Each Invoice based on ListBox Selection.srt 30.8 KB
  204. 9. Create Email in Outlook & Attach PDF Invoice.mp4 134.0 MB
  205. 9. Create Email in Outlook & Attach PDF Invoice.srt 17.7 KB
  206. 1. Section Overview Function Procedures.mp4 32.3 MB
  207. 1. Section Overview Function Procedures.srt 2.7 KB
  208. 1.1 S19_FunctionProcedures_Start.xlsx.xlsx 50.0 KB
  209. 1.2 S19_FunctionProcedures.xlsm.xlsm 70.3 KB
  210. 2. Setting up a Simple Function (including Optional Arguments).mp4 64.3 MB
  211. 2. Setting up a Simple Function (including Optional Arguments).srt 7.3 KB
  212. 3. Function to Calculate Age (Result in Years & Months).mp4 76.3 MB
  213. 3. Function to Calculate Age (Result in Years & Months).srt 7.7 KB
  214. 4. Functions that Split Text and Numbers from Cell Value.mp4 97.5 MB
  215. 4. Functions that Split Text and Numbers from Cell Value.srt 11.4 KB
  216. 5. Using Functions in Sub Procedures.mp4 82.2 MB
  217. 5. Using Functions in Sub Procedures.srt 8.0 KB
  218. 6. Activity Function That Sums based on Cell Color.html 727 bytes
  219. 7. Project Function That Sums based on Cell Color.mp4 182.0 MB
  220. 7. Project Function That Sums based on Cell Color.srt 14.1 KB
  221. 8. Key Takeaways Function Procedures in VBA & Course Map Status.html 493 bytes
  222. 1. Overview Macros & Visual Basic Editor (VBE).mp4 7.1 MB
  223. 1. Overview Macros & Visual Basic Editor (VBE).srt 2.3 KB
  224. 1.1 S2_RecordMacros.xlsm.xlsm 87.0 KB
  225. 1.2 S2_RecordMacros_Start.xlsx.xlsx 65.7 KB
  226. 10. Quiz Test Your Knowledge on Macros.html 138 bytes
  227. 2. Steps to Your First Macro Recording.mp4 11.7 MB
  228. 2. Steps to Your First Macro Recording.srt 8.4 KB
  229. 3. Visual Basic Editor What You Need to Know.mp4 101.9 MB
  230. 3. Visual Basic Editor What You Need to Know.srt 16.6 KB
  231. 4. Project Dynamic Cell Selection (Special Cells) - Perfect for Flexible Macros.mp4 201.4 MB
  232. 4. Project Dynamic Cell Selection (Special Cells) - Perfect for Flexible Macros.srt 14.0 KB
  233. 5. Project Copy (Consolidate) Data - Absolute versus Relative Macro Recording.mp4 47.2 MB
  234. 5. Project Copy (Consolidate) Data - Absolute versus Relative Macro Recording.srt 12.7 KB
  235. 6. 7 Ways to Run Macros VBA code (incl. creative & modern buttons).mp4 23.9 MB
  236. 6. 7 Ways to Run Macros VBA code (incl. creative & modern buttons).srt 16.1 KB
  237. 6.1 IconSets.xlsx.xlsx 838.6 KB
  238. 7. OFFICE 365 Update Change from Excel Comments to Notes.html 1.3 KB
  239. 8. Activity Record a Macro that Deletes all Comments.html 1.3 KB
  240. 9. What's the Difference Between Macros and VBA.html 1.8 KB
  241. 1. The Chart Object Library & Section Overview.mp4 32.3 MB
  242. 1. The Chart Object Library & Section Overview.srt 4.7 KB
  243. 1.1 S20_Charts.xlsm.xlsm 124.4 KB
  244. 1.2 S20_Charts_Start.xlsx.xlsx 77.7 KB
  245. 2. Create and Modify a Chart with VBA.mp4 143.8 MB
  246. 2. Create and Modify a Chart with VBA.srt 16.6 KB
  247. 3. Animated Charts Different Methods.mp4 121.2 MB
  248. 3. Animated Charts Different Methods.srt 15.8 KB
  249. 4. Show Charts inside UserForms.mp4 149.6 MB
  250. 4. Show Charts inside UserForms.srt 16.6 KB
  251. 5. Key Takeaways Charts.html 672 bytes
  252. 1. Your Next Steps & more Learning.mp4 45.9 MB
  253. 1. Your Next Steps & more Learning.srt 3.6 KB
  254. 2. BONUS Lecture More from Leila.html 3.9 KB
  255. 1. Overview VBA Object Model (What you need to become an expert in VBA).mp4 7.4 MB
  256. 1. Overview VBA Object Model (What you need to become an expert in VBA).srt 2.3 KB
  257. 2. VBA's Code Reference Object Library.mp4 8.8 MB
  258. 2. VBA's Code Reference Object Library.srt 5.5 KB
  259. 3. VB Color Guidelines & Keyboard Shortcuts.mp4 126.4 MB
  260. 3. VB Color Guidelines & Keyboard Shortcuts.srt 16.4 KB
  261. 4. Excel VBA Object Model.mp4 11.3 MB
  262. 4. Excel VBA Object Model.srt 8.5 KB
  263. 5. Object Properties.mp4 9.3 MB
  264. 5. Object Properties.srt 6.3 KB
  265. 6. Object Methods.mp4 12.8 MB
  266. 6. Object Methods.srt 8.2 KB
  267. 7. How to Find the Object, Property & Method.mp4 16.8 MB
  268. 7. How to Find the Object, Property & Method.srt 10.7 KB
  269. 8. Test Your Knowledge about the Object Model.html 138 bytes
  270. 9. Conclusion Key Takeaways & Message from Me.mp4 7.1 MB
  271. 9. Conclusion Key Takeaways & Message from Me.srt 3.7 KB
  272. 1. Overview Referencing Ranges, Worksheets & Workbooks.mp4 5.0 MB
  273. 1. Overview Referencing Ranges, Worksheets & Workbooks.srt 1.6 KB
  274. 1.1 S4_ReferencingRanges_Start.xlsx.xlsx 64.8 KB
  275. 1.2 S4_ReferencingRanges.xlsm.xlsm 88.1 KB
  276. 10. Key Takeaways for Referencing Ranges.mp4 8.6 MB
  277. 10. Key Takeaways for Referencing Ranges.srt 3.8 KB
  278. 2. Referring to Ranges & Writing to Cells in VBA.mp4 24.3 MB
  279. 2. Referring to Ranges & Writing to Cells in VBA.srt 20.5 KB
  280. 3. Most Useful Range Properties & Methods.mp4 34.4 MB
  281. 3. Most Useful Range Properties & Methods.srt 18.0 KB
  282. 4. 4 Methods to Find the Last Row of your Range.mp4 36.1 MB
  283. 4. 4 Methods to Find the Last Row of your Range.srt 19.7 KB
  284. 5. Copying & resizing a variably sized range.mp4 27.8 MB
  285. 5. Copying & resizing a variably sized range.srt 12.7 KB
  286. 6. Properly Referencing Worksheets.mp4 48.7 MB
  287. 6. Properly Referencing Worksheets.srt 19.7 KB
  288. 7. Properly Referencing Workbooks.mp4 27.6 MB
  289. 7. Properly Referencing Workbooks.srt 14.0 KB
  290. 8. Activity Save a Hard-coded Copy of Workbook.html 1.7 KB
  291. 9. Project Save Hard-coded Copy & Macro-free version of workbook.mp4 55.3 MB
  292. 9. Project Save Hard-coded Copy & Macro-free version of workbook.srt 15.7 KB
  293. 1. Overview Role of Assignment & Variables.mp4 9.6 MB
  294. 1. Overview Role of Assignment & Variables.srt 3.8 KB
  295. 1.1 S5_Variables.xlsm.xlsm 63.5 KB
  296. 1.2 S5_Variables_Start.xlsx.xlsx 49.1 KB
  297. 2. Data Types for Better Performance.mp4 7.4 MB
  298. 2. Data Types for Better Performance.srt 4.4 KB
  299. 3. Declaring Variables, Arrays & Constants (Role of Option Explicit).mp4 90.1 MB
  300. 3. Declaring Variables, Arrays & Constants (Role of Option Explicit).srt 17.4 KB
  301. 4. Using Object Variables (Set statement).mp4 65.2 MB
  302. 4. Using Object Variables (Set statement).srt 8.8 KB
  303. 5. Scoping Variables.mp4 12.1 MB
  304. 5. Scoping Variables.srt 8.3 KB
  305. 6. Activity Revisit Hard-coded Workbook Project & Use Variable Assignment.html 1.2 KB
  306. 7. Test Your Knowledge on Variables and data types.html 138 bytes
  307. 8. Key Takeaways for Working with Variables.mp4 23.4 MB
  308. 8. Key Takeaways for Working with Variables.srt 2.8 KB
  309. 1. Overview Why Collections are a VBA Essential.mp4 29.4 MB
  310. 1. Overview Why Collections are a VBA Essential.srt 1.8 KB
  311. 1.1 S6_Collections_With_IF.xlsm.xlsm 93.3 KB
  312. 1.2 S6_Collections_With_IF_Start.xlsx.xlsx 60.0 KB
  313. 10. Key Takeaways for Collections & Decision Making in VBA.html 450 bytes
  314. 2. With & End With for Easier Code Writing.mp4 16.9 MB
  315. 2. With & End With for Easier Code Writing.srt 8.1 KB
  316. 3. For Each to Loop Through Collections (sheets, ranges etc.) in one go.mp4 98.0 MB
  317. 3. For Each to Loop Through Collections (sheets, ranges etc.) in one go.srt 12.9 KB
  318. 4. IF Then (Else, ElseIF) for Conditional Outcomes.mp4 25.7 MB
  319. 4. IF Then (Else, ElseIF) for Conditional Outcomes.srt 13.0 KB
  320. 5. Select Case as Alternative for Many IF Statements.mp4 10.9 MB
  321. 5. Select Case as Alternative for Many IF Statements.srt 6.8 KB
  322. 6. Goto Statement to Change Program Flow.mp4 17.9 MB
  323. 6. Goto Statement to Change Program Flow.srt 9.9 KB
  324. 7. Activity Get the Number of Formulas on the worksheet.html 674 bytes
  325. 8. Project Get the Number of Formulas on the Worksheet.mp4 122.1 MB
  326. 8. Project Get the Number of Formulas on the Worksheet.srt 9.3 KB
  327. 9. Bonus Unhide All Sheets in One Go.mp4 91.6 MB
  328. 9. Bonus Unhide All Sheets in One Go.srt 14.3 KB
  329. 1. Overview VBA versus Worksheet Functions.mp4 44.2 MB
  330. 1. Overview VBA versus Worksheet Functions.srt 17.0 KB
  331. 1.1 S7_BuiltinFunctions.xlsm.xlsm 126.0 KB
  332. 1.2 S7_BuiltinFunctions_Start.xlsx.xlsx 106.3 KB
  333. 2. Most Useful VBA Functions.mp4 83.9 MB
  334. 2. Most Useful VBA Functions.srt 13.7 KB
  335. 3. Message Box (also with Yes, No buttons).mp4 20.6 MB
  336. 3. Message Box (also with Yes, No buttons).srt 11.2 KB
  337. 4. Input Box (VBA InputBox Function).mp4 18.0 MB
  338. 4. Input Box (VBA InputBox Function).srt 8.8 KB
  339. 5. Input Box that can Select Ranges (Excel InputBox Method).mp4 112.1 MB
  340. 5. Input Box that can Select Ranges (Excel InputBox Method).srt 15.3 KB
  341. 6. Activity Show Top 3 Values in a Message Box Based on Range Selected.html 1.2 KB
  342. 7. Project Show Top 3 Values in a Message box based on Range Selected.mp4 189.4 MB
  343. 7. Project Show Top 3 Values in a Message box based on Range Selected.srt 13.3 KB
  344. 8. Key Takeaways Built-in Functions.html 386 bytes
  345. 1. Overview Debugging, Handling Errors & Procedure Scope.mp4 12.4 MB
  346. 1. Overview Debugging, Handling Errors & Procedure Scope.srt 2.6 KB
  347. 1.1 S8_ErrorHandling.xlsm.xlsm 89.1 KB
  348. 1.2 S8_ErrorHandling_Start.xlsm.xlsm 78.9 KB
  349. 2. Debugging Options Watch, Locals, Immediate Windows & More.mp4 140.1 MB
  350. 2. Debugging Options Watch, Locals, Immediate Windows & More.srt 17.7 KB
  351. 3. Error Handling Different Methods.mp4 111.8 MB
  352. 3. Error Handling Different Methods.srt 14.2 KB
  353. 4. Faster Code by Suppressing Pop-ups & Flickering Screen.mp4 28.2 MB
  354. 4. Faster Code by Suppressing Pop-ups & Flickering Screen.srt 14.1 KB
  355. 5. Procedure Scope & Running one Sub from Another.mp4 15.0 MB
  356. 5. Procedure Scope & Running one Sub from Another.srt 7.5 KB
  357. 6. Passing Arguments to Sub Procedures (By Ref, By Val).mp4 24.1 MB
  358. 6. Passing Arguments to Sub Procedures (By Ref, By Val).srt 11.5 KB
  359. 7. Activity Get the Total Number of Formulas (or Comments) Used in a Workbook.html 959 bytes
  360. 8. Project Get the Total Number of Formulas (or Comments) Used in a Workbook.mp4 29.0 MB
  361. 8. Project Get the Total Number of Formulas (or Comments) Used in a Workbook.srt 13.1 KB
  362. 9. Key Takeaways Debugging, Error Handling & Course Map Status.mp4 22.7 MB
  363. 9. Key Takeaways Debugging, Error Handling & Course Map Status.srt 2.7 KB
  364. 1. Project overview Table of Contents (TOC) with one click.mp4 31.4 MB
  365. 1. Project overview Table of Contents (TOC) with one click.srt 2.8 KB
  366. 2. TOC Project The Basics.mp4 82.3 MB
  367. 2. TOC Project The Basics.srt 13.2 KB
  368. 3. TOC Project Adding Hyperlinks.mp4 11.0 MB
  369. 3. TOC Project Adding Hyperlinks.srt 8.1 KB
  370. 4. TOC Project Testing the VBA Code.mp4 8.8 MB
  371. 4. TOC Project Testing the VBA Code.srt 5.7 KB
  372. 5. TOC Project Adding Error Handling & More Checks.mp4 159.2 MB
  373. 5. TOC Project Adding Error Handling & More Checks.srt 16.8 KB
  374. 6. TOC Project Adding to Personal Macro Workbook (Make it Available to all Files).mp4 77.5 MB
  375. 6. TOC Project Adding to Personal Macro Workbook (Make it Available to all Files).srt 9.4 KB
  376. 6.1 Project_Automatic_TableOfContent.xlsm.xlsm 22.1 KB
  377. 7. First Milestone Completed!.html 544 bytes
  378. Read Me.txt 1015 bytes
  379. [FreeAllCourse.Com].url 52 bytes

Discussion