Unlock Excel VBA and Excel Macros

1. Unlock Excel VBA and Excel Macros/14. Main Project #2 Sales Regional Reporting Tool/4. Setting up a Template as the Basis for Different Reports.mp4310.41MB
2. Unlock Excel VBA and Excel Macros/1. Introduction & Scope/1. Course Structure & Content.mp470.58MB
3. Unlock Excel VBA and Excel Macros/1. Introduction & Scope/2. Important Compatibility & Setup Information.mp451.38MB
4. Unlock Excel VBA and Excel Macros/1. Introduction & Scope/3. Download Course Project Files.mp434.38MB
5. Unlock Excel VBA and Excel Macros/1. Introduction & Scope/4. Course Expectations.mp452.54MB
6. Unlock Excel VBA and Excel Macros/2. Your First Macro/1. Overview Macros & Visual Basic Editor (VBE).mp47.09MB
7. Unlock Excel VBA and Excel Macros/2. Your First Macro/2. Steps to Your First Macro Recording.mp411.71MB
8. Unlock Excel VBA and Excel Macros/2. Your First Macro/3. Visual Basic Editor What You Need to Know.mp4101.92MB
9. Unlock Excel VBA and Excel Macros/2. Your First Macro/4. Project Dynamic Cell Selection (Special Cells) - Perfect for Flexible Macros.mp4201.43MB
10. Unlock Excel VBA and Excel Macros/2. Your First Macro/5. Project Copy (Consolidate) Data - Absolute versus Relative Macro Recording.mp447.24MB
11. Unlock Excel VBA and Excel Macros/2. Your First Macro/6. 7 Ways to Run Macros VBA code (incl. creative & modern buttons).mp423.91MB
12. Unlock Excel VBA and Excel Macros/3. The Object Model/1. Overview VBA Object Model (What you need to become an expert in VBA).mp47.43MB
13. Unlock Excel VBA and Excel Macros/3. The Object Model/2. VBA's Code Reference Object Library.mp48.77MB
14. Unlock Excel VBA and Excel Macros/3. The Object Model/3. VB Color Guidelines & Keyboard Shortcuts.mp4126.39MB
15. Unlock Excel VBA and Excel Macros/3. The Object Model/4. Excel VBA Object Model.mp411.33MB
16. Unlock Excel VBA and Excel Macros/3. The Object Model/5. Object Properties.mp49.26MB
17. Unlock Excel VBA and Excel Macros/3. The Object Model/6. Object Methods.mp412.79MB
18. Unlock Excel VBA and Excel Macros/3. The Object Model/7. How to Find the Object, Property & Method.mp416.75MB
19. Unlock Excel VBA and Excel Macros/3. The Object Model/9. Conclusion Key Takeaways & Message from Me.mp47.06MB
20. Unlock Excel VBA and Excel Macros/4. Referencing Ranges, Worksheets & Workbooks with VBA/1. Overview Referencing Ranges, Worksheets & Workbooks.mp45.01MB
21. Unlock Excel VBA and Excel Macros/4. Referencing Ranges, Worksheets & Workbooks with VBA/2. Referring to Ranges & Writing to Cells in VBA.mp424.33MB
22. Unlock Excel VBA and Excel Macros/4. Referencing Ranges, Worksheets & Workbooks with VBA/3. Most Useful Range Properties & Methods.mp434.45MB
23. Unlock Excel VBA and Excel Macros/4. Referencing Ranges, Worksheets & Workbooks with VBA/4. 4 Methods to Find the Last Row of your Range.mp436.14MB
24. Unlock Excel VBA and Excel Macros/4. Referencing Ranges, Worksheets & Workbooks with VBA/5. Copying & resizing a variably sized range.mp427.81MB
25. Unlock Excel VBA and Excel Macros/4. Referencing Ranges, Worksheets & Workbooks with VBA/6. Properly Referencing Worksheets.mp448.67MB
26. Unlock Excel VBA and Excel Macros/4. Referencing Ranges, Worksheets & Workbooks with VBA/7. Properly Referencing Workbooks.mp427.64MB
27. Unlock Excel VBA and Excel Macros/4. Referencing Ranges, Worksheets & Workbooks with VBA/9. Project Save Hard-coded Copy & Macro-free version of workbook.mp455.32MB
28. Unlock Excel VBA and Excel Macros/4. Referencing Ranges, Worksheets & Workbooks with VBA/10. Key Takeaways for Referencing Ranges.mp48.56MB
29. Unlock Excel VBA and Excel Macros/5. Working with Variables/1. Overview Role of Assignment & Variables.mp49.61MB
30. Unlock Excel VBA and Excel Macros/5. Working with Variables/2. Data Types for Better Performance.mp47.41MB
31. Unlock Excel VBA and Excel Macros/5. Working with Variables/3. Declaring Variables, Arrays & Constants (Role of Option Explicit).mp490.14MB
32. Unlock Excel VBA and Excel Macros/5. Working with Variables/4. Using Object Variables (Set statement).mp465.16MB
33. Unlock Excel VBA and Excel Macros/5. Working with Variables/5. Scoping Variables.mp412.08MB
34. Unlock Excel VBA and Excel Macros/5. Working with Variables/8. Key Takeaways for Working with Variables.mp423.37MB
35. Unlock Excel VBA and Excel Macros/6. Looping through Collections & Making Decisions/1. Overview Why Collections are a VBA Essential.mp429.42MB
36. Unlock Excel VBA and Excel Macros/6. Looping through Collections & Making Decisions/2. With & End With for Easier Code Writing.mp416.91MB
37. Unlock Excel VBA and Excel Macros/6. Looping through Collections & Making Decisions/3. For Each to Loop Through Collections (sheets, ranges etc.) in one go.mp498.04MB
38. Unlock Excel VBA and Excel Macros/6. Looping through Collections & Making Decisions/4. IF Then (Else, ElseIF) for Conditional Outcomes.mp425.66MB
39. Unlock Excel VBA and Excel Macros/6. Looping through Collections & Making Decisions/5. Select Case as Alternative for Many IF Statements.mp410.87MB
40. Unlock Excel VBA and Excel Macros/6. Looping through Collections & Making Decisions/6. Goto Statement to Change Program Flow.mp417.93MB
41. Unlock Excel VBA and Excel Macros/6. Looping through Collections & Making Decisions/8. Project Get the Number of Formulas on the Worksheet.mp4122.07MB
42. Unlock Excel VBA and Excel Macros/6. Looping through Collections & Making Decisions/9. Bonus Unhide All Sheets in One Go.mp491.58MB
43. Unlock Excel VBA and Excel Macros/7. Useful Built-in Functions/1. Overview VBA versus Worksheet Functions.mp444.16MB
44. Unlock Excel VBA and Excel Macros/7. Useful Built-in Functions/2. Most Useful VBA Functions.mp483.95MB
45. Unlock Excel VBA and Excel Macros/7. Useful Built-in Functions/3. Message Box (also with Yes, No buttons).mp420.57MB
46. Unlock Excel VBA and Excel Macros/7. Useful Built-in Functions/4. Input Box (VBA InputBox Function).mp417.97MB
47. Unlock Excel VBA and Excel Macros/7. Useful Built-in Functions/5. Input Box that can Select Ranges (Excel InputBox Method).mp4112.08MB
48. Unlock Excel VBA and Excel Macros/7. Useful Built-in Functions/7. Project Show Top 3 Values in a Message box based on Range Selected.mp4189.42MB
49. Unlock Excel VBA and Excel Macros/8. Debugging, Error Handling & Procedure Scope/1. Overview Debugging, Handling Errors & Procedure Scope.mp412.37MB
50. Unlock Excel VBA and Excel Macros/8. Debugging, Error Handling & Procedure Scope/2. Debugging Options Watch, Locals, Immediate Windows & More.mp4140.08MB
51. Unlock Excel VBA and Excel Macros/8. Debugging, Error Handling & Procedure Scope/3. Error Handling Different Methods.mp4111.83MB
52. Unlock Excel VBA and Excel Macros/8. Debugging, Error Handling & Procedure Scope/4. Faster Code by Suppressing Pop-ups & Flickering Screen.mp428.2MB
53. Unlock Excel VBA and Excel Macros/8. Debugging, Error Handling & Procedure Scope/5. Procedure Scope & Running one Sub from Another.mp415.02MB
54. Unlock Excel VBA and Excel Macros/8. Debugging, Error Handling & Procedure Scope/6. Passing Arguments to Sub Procedures (By Ref, By Val).mp424.13MB
55. Unlock Excel VBA and Excel Macros/8. Debugging, Error Handling & Procedure Scope/8. Project Get the Total Number of Formulas (or Comments) Used in a Workbook.mp428.99MB
56. Unlock Excel VBA and Excel Macros/8. Debugging, Error Handling & Procedure Scope/9. Key Takeaways Debugging, Error Handling & Course Map Status.mp422.71MB
57. Unlock Excel VBA and Excel Macros/9. Main Project #1 Create a Tool to Automate Table of Contents/1. Project overivew Table of Contents (TOC) with one click.mp431.41MB
58. Unlock Excel VBA and Excel Macros/9. Main Project #1 Create a Tool to Automate Table of Contents/2. TOC Project The Basics.mp482.32MB
59. Unlock Excel VBA and Excel Macros/9. Main Project #1 Create a Tool to Automate Table of Contents/3. TOC Project Adding Hyperlinks.mp411.04MB
60. Unlock Excel VBA and Excel Macros/9. Main Project #1 Create a Tool to Automate Table of Contents/4. TOC Project Testing the VBA Code.mp48.84MB
61. Unlock Excel VBA and Excel Macros/9. Main Project #1 Create a Tool to Automate Table of Contents/5. TOC Project Adding Error Handling & More Checks.mp4159.18MB
62. Unlock Excel VBA and Excel Macros/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).mp477.47MB
63. Unlock Excel VBA and Excel Macros/10. Looping in VBA (Controlling the Flow of Code)/1. Section Overview Looping in VBA.mp418.02MB
64. Unlock Excel VBA and Excel Macros/10. Looping in VBA (Controlling the Flow of Code)/2. For Next Counter Loops (Simple Example).mp416.3MB
65. Unlock Excel VBA and Excel Macros/10. Looping in VBA (Controlling the Flow of Code)/3. For Next Nested Loop (Loop through Text & Cells).mp4208.31MB
66. Unlock Excel VBA and Excel Macros/10. Looping in VBA (Controlling the Flow of Code)/4. For Next Reverse Loop (Delete FilteredHidden Rows).mp425.88MB
67. Unlock Excel VBA and Excel Macros/10. Looping in VBA (Controlling the Flow of Code)/5. Do Until & Do While Loop.mp498.11MB
68. Unlock Excel VBA and Excel Macros/10. Looping in VBA (Controlling the Flow of Code)/6. Practical Example of Do Loop (with Inputbox).mp46.59MB
69. Unlock Excel VBA and Excel Macros/10. Looping in VBA (Controlling the Flow of Code)/7. Find Method for Quicker Lookup Results.mp420.31MB
70. Unlock Excel VBA and Excel Macros/10. Looping in VBA (Controlling the Flow of Code)/8. Find Method with Do Loop - Multiple Matches.mp414.45MB
71. Unlock Excel VBA and Excel Macros/10. Looping in VBA (Controlling the Flow of Code)/9. Add a Timer to Test & Speech to Inform.mp414.64MB
72. Unlock Excel VBA and Excel Macros/10. Looping in VBA (Controlling the Flow of Code)/11. Project Document all Comments in Workbook in a Sheet.mp451.04MB
73. Unlock Excel VBA and Excel Macros/10. Looping in VBA (Controlling the Flow of Code)/12. Useful VBA Statements & Key takeaways for Looping in VBA.mp433.25MB
74. Unlock Excel VBA and Excel Macros/11. Working with Arrays/1. Overview Working with Arrays in VBA.mp46.23MB
75. Unlock Excel VBA and Excel Macros/11. Working with Arrays/2. One Dimensional Arrays (and transferring back to sheet).mp4138.82MB
76. Unlock Excel VBA and Excel Macros/11. Working with Arrays/3. Dynamic Arrays (size adjusts depending on a condition).mp413.03MB
77. Unlock Excel VBA and Excel Macros/11. Working with Arrays/4. Preserving Dynamic Arrays (adding more elements to the existing array).mp444.66MB
78. Unlock Excel VBA and Excel Macros/11. Working with Arrays/5. Two Dimensional Arrays.mp475.63MB
79. Unlock Excel VBA and Excel Macros/11. Working with Arrays/6. Variant Arrays Quick Method to Write to Cells.mp417.14MB
80. Unlock Excel VBA and Excel Macros/11. Working with Arrays/8. Project Create a New Worksheet per Company with Specific Information.mp4159.85MB
81. Unlock Excel VBA and Excel Macros/12. Working with Files, Folders & Text Files/1. Overview Working with Folders & Files.mp450.47MB
82. Unlock Excel VBA and Excel Macros/12. Working with Files, Folders & Text Files/2. DIR Function Check if Files or Folders Exist.mp476.43MB
83. Unlock Excel VBA and Excel Macros/12. Working with Files, Folders & Text Files/3. GetOpenFileName Method User Selects a File.mp495.85MB
84. Unlock Excel VBA and Excel Macros/12. Working with Files, Folders & Text Files/4. FileDialog Property Loop Inside a Folder.mp4166.07MB
85. Unlock Excel VBA and Excel Macros/12. Working with Files, Folders & Text Files/5. Create CSV File from Data in Excel.mp490.51MB
86. Unlock Excel VBA and Excel Macros/12. Working with Files, Folders & Text Files/6. Printing & Writing to Text Files for More Control.mp444.55MB
87. Unlock Excel VBA and Excel Macros/12. Working with Files, Folders & Text Files/8. Project Export Data to Text file (fix Delimiter to Semicolon).mp4224.89MB
88. Unlock Excel VBA and Excel Macros/13. Excel Tables, Formulas & Pivot Tables/1. Overview (Pivot) Tables & Formulas.mp443.36MB
89. Unlock Excel VBA and Excel Macros/13. Excel Tables, Formulas & Pivot Tables/2. Using Excel Formulas in VBA.mp4165.48MB
90. Unlock Excel VBA and Excel Macros/13. Excel Tables, Formulas & Pivot Tables/3. Excel Tables Use the Right Syntax.mp4190.36MB
91. Unlock Excel VBA and Excel Macros/13. Excel Tables, Formulas & Pivot Tables/4. Pivot Tables & VBA What you Need to Know.mp4226.63MB
92. Unlock Excel VBA and Excel Macros/13. Excel Tables, Formulas & Pivot Tables/6. Project Update Existing Formulas with VBA by Adding IFERROR.mp4138.49MB
93. Unlock Excel VBA and Excel Macros/14. Main Project #2 Sales Regional Reporting Tool/1. What You'll Learn (& Should be Aware of..).mp441.4MB
94. Unlock Excel VBA and Excel Macros/14. Main Project #2 Sales Regional Reporting Tool/2. Project Overview Regional Sales Reporting Tool.mp4159.17MB
95. Unlock Excel VBA and Excel Macros/14. Main Project #2 Sales Regional Reporting Tool/3. Importing Data from Multiple Files using MultiSelect.mp4208.54MB
96. Unlock Excel VBA and Excel Macros/14. Main Project #2 Sales Regional Reporting Tool/5. Exporting Reports as Excel files (Pivot Table & Hard Coded Reports).mp4188.2MB
97. Unlock Excel VBA and Excel Macros/14. Main Project #2 Sales Regional Reporting Tool/6. Fine-tuning Report Export Procedure (Double-check if user wants to overwrite).mp4114.6MB
98. Unlock Excel VBA and Excel Macros/14. Main Project #2 Sales Regional Reporting Tool/7. Setting up Automatic Export of Text File (Fix delimiter in CSV to Semicolon).mp495.59MB
99. Unlock Excel VBA and Excel Macros/14. Main Project #2 Sales Regional Reporting Tool/8. Track the List of Tasks Completed with VBA.mp4113.01MB
100. Unlock Excel VBA and Excel Macros/14. Main Project #2 Sales Regional Reporting Tool/9. Final Touches & Creating Interface to Hide Specific Tabs with a Password.mp4112.4MB
101. Unlock Excel VBA and Excel Macros/14. Main Project #2 Sales Regional Reporting Tool/10. Key Takeaways & Tips for VBA based Excel Tools.mp444.34MB
102. Unlock Excel VBA and Excel Macros/15. Interacting with Other Applications (Word, PowerPoint etc.)/1. Overview & Important Concepts when Interacting with Other Applications.mp454.16MB
103. Unlock Excel VBA and Excel Macros/15. Interacting with Other Applications (Word, PowerPoint etc.)/2. Project PDF Save Specific Sheets as a PDF File.mp4135.46MB
104. Unlock Excel VBA and Excel Macros/15. Interacting with Other Applications (Word, PowerPoint etc.)/3. Project Email Automatically Create Personalized Emails with Attachments.mp486.99MB
105. Unlock Excel VBA and Excel Macros/15. Interacting with Other Applications (Word, PowerPoint etc.)/4. Project Microsoft Word Create Personalized Letters in Word from Excel.mp4169.72MB
106. Unlock Excel VBA and Excel Macros/15. Interacting with Other Applications (Word, PowerPoint etc.)/5. Project Microsoft PowerPoint Export Excel Sheets to PowerPoint Presentation.mp4185.43MB
107. Unlock Excel VBA and Excel Macros/16. Workbook and Worksheet Events/1. Overview & What are Event Procedures.mp438.96MB
108. Unlock Excel VBA and Excel Macros/16. Workbook and Worksheet Events/2. Workbook Events, Toggle Full Screen (Activate, Deactivate, Open, Close).mp4141.5MB
109. Unlock Excel VBA and Excel Macros/16. Workbook and Worksheet Events/3. Worksheet Selection Change Dynamic Font Color of Selected Range.mp456.26MB
110. Unlock Excel VBA and Excel Macros/16. Workbook and Worksheet Events/4. Refresh PivotTables Automatically & Concept of Range Intersection.mp4154.86MB
111. Unlock Excel VBA and Excel Macros/16. Workbook and Worksheet Events/5. Resetting a Dependent Drop-down when the first Drop-down is Changed.mp4115.97MB
112. Unlock Excel VBA and Excel Macros/16. Workbook and Worksheet Events/7. Project Link Page Header to Cell Value (BeforePrint Event).mp4144.92MB
113. Unlock Excel VBA and Excel Macros/16. Workbook and Worksheet Events/8. 2 Useful Tips when Working with Events & Key Takeaways.mp438MB
114. Unlock Excel VBA and Excel Macros/17. Working with Userforms & ActiveX Controls/1. Overivew UserForms & ActiveX Controls.mp431.71MB
115. Unlock Excel VBA and Excel Macros/17. Working with Userforms & ActiveX Controls/2. ActiveX Controls What you Need to Know.mp459.52MB
116. Unlock Excel VBA and Excel Macros/17. Working with Userforms & ActiveX Controls/3. ActiveX Check Box to Fix Scroll Area & Toggle Screen Settings.mp477.12MB
117. Unlock Excel VBA and Excel Macros/17. Working with Userforms & ActiveX Controls/4. ActiveX to Show and Hide Help.mp456.74MB
118. Unlock Excel VBA and Excel Macros/17. Working with Userforms & ActiveX Controls/5. ActiveX Combo Box for Easy Sheet Navigation (Great for Larger Workbooks).mp492.5MB
119. Unlock Excel VBA and Excel Macros/17. Working with Userforms & ActiveX Controls/6. ActiveX to Show or Hide Other ActiveX controls (eg. Actual & Budget reporting).mp4132.38MB
120. Unlock Excel VBA and Excel Macros/17. Working with Userforms & ActiveX Controls/7. UserForm Basics What You Need to Get Started.mp4193.13MB
121. Unlock Excel VBA and Excel Macros/17. Working with Userforms & ActiveX Controls/8. UserForm for Data Entry (Input & Check Boxes).mp4126.84MB
122. Unlock Excel VBA and Excel Macros/17. Working with Userforms & ActiveX Controls/9. UserForm to Document External Links & Comments (Combo Box & Option button).mp4234.32MB
123. Unlock Excel VBA and Excel Macros/18. Main Project #3 Invoice Generation Tool/1. Tool Overview What You Will Learn.mp4132.83MB
124. Unlock Excel VBA and Excel Macros/18. Main Project #3 Invoice Generation Tool/2. Setting up an Input UserForm to Collect Master Data.mp4178.15MB
125. Unlock Excel VBA and Excel Macros/18. Main Project #3 Invoice Generation Tool/3. Working with Multi-Column ListBoxes.mp4130.49MB
126. Unlock Excel VBA and Excel Macros/18. Main Project #3 Invoice Generation Tool/4. Edit Master Data with UserForm.mp485.37MB
127. Unlock Excel VBA and Excel Macros/18. Main Project #3 Invoice Generation Tool/5. Searchable ListBox (with Selection Change event).mp4160.89MB
128. Unlock Excel VBA and Excel Macros/18. Main Project #3 Invoice Generation Tool/6. Enhanced Searchable ListBox Write Selection back to Excel Table.mp4204.17MB
129. Unlock Excel VBA and Excel Macros/18. Main Project #3 Invoice Generation Tool/7. MultiPage UserForm to Create Invoices & Email (Setup).mp4218.9MB
130. Unlock Excel VBA and Excel Macros/18. Main Project #3 Invoice Generation Tool/8. Export PDF & Excel Workbook for Each Invoice based on ListBox Selection.mp4280.47MB
131. Unlock Excel VBA and Excel Macros/18. Main Project #3 Invoice Generation Tool/9. Create Email in Outlook & Attach PDF Invoice.mp4175.58MB
132. Unlock Excel VBA and Excel Macros/18. Main Project #3 Invoice Generation Tool/10. Final Updates & Debugging.mp4238.84MB
133. Unlock Excel VBA and Excel Macros/19. Create your own Custom Functions/1. Section Overview Function Procedures.mp432.26MB
134. Unlock Excel VBA and Excel Macros/19. Create your own Custom Functions/2. Setting up a Simple Function (including Optional Arguments).mp464.26MB
135. Unlock Excel VBA and Excel Macros/19. Create your own Custom Functions/3. Function to Calculate Age (Result in Years & Months).mp476.28MB
136. Unlock Excel VBA and Excel Macros/19. Create your own Custom Functions/4. Functions that Split Text and Numbers from Cell Value.mp497.54MB
137. Unlock Excel VBA and Excel Macros/19. Create your own Custom Functions/5. Using Functions in Sub Procedures.mp482.21MB
138. Unlock Excel VBA and Excel Macros/19. Create your own Custom Functions/7. Project Function That Sums based on Cell Color.mp4182.03MB
139. Unlock Excel VBA and Excel Macros/20. Working with Charts/1. The Chart Object Library & Section Overview.mp432.28MB
140. Unlock Excel VBA and Excel Macros/20. Working with Charts/2. Create and Modify a Chart with VBA.mp4143.76MB
141. Unlock Excel VBA and Excel Macros/20. Working with Charts/3. Animated Charts Different Methods.mp4121.17MB
142. Unlock Excel VBA and Excel Macros/20. Working with Charts/4. Show Charts inside UserForms.mp4149.64MB
143. Unlock Excel VBA and Excel Macros/21. Summary & Final Words/1. Your Next Steps & more Learning.mp445.93MB