Udemy - Unlock Excel VBA and Excel Macros (12.2024)

Creation Time	April 9, 2026, 11:36 a.m.
Last Access Time	April 9, 2026, 12:09 p.m.
File Size	8.8 GB
Keywords	and VBA 12 - Excel Udemy 2024 Macros Unlock
Total Requests	3
Total Files	377
Magnet Link	Please wait ...
	Download (Magnet Link) Play (Watch Online)

14. Main Project #2 Sales Regional Reporting Tool/04. Setting up a Template as the Basis for Different Reports.mp4 245.8 MB
18. Main Project #3 Invoice Generation Tool/08. Export PDF & Excel Workbook for Each Invoice based on ListBox Selection.mp4 221.5 MB
18. Main Project #3 Invoice Generation Tool/10. Final Updates & Debugging.mp4 193.1 MB
17. Working with Userforms & ActiveX Controls/09. UserForm to Document External Links & Comments (Combo Box & Option button).mp4 166.3 MB
14. Main Project #2 Sales Regional Reporting Tool/03. Importing Data from Multiple Files using MultiSelect.mp4 162.4 MB
18. Main Project #3 Invoice Generation Tool/06. Enhanced Searchable ListBox Write Selection back to Excel Table.mp4 157.3 MB
10. Looping in VBA (Controlling the Flow of Code)/03. For Next Nested Loop (Loop through Text & Cells).mp4 149.2 MB
14. Main Project #2 Sales Regional Reporting Tool/05. Exporting Reports as Excel files (Pivot Table & Hard Coded Reports).mp4 147.1 MB
04. Referencing Ranges, Worksheets & Workbooks with VBA/04. 4 Methods to Find the Last Row of your Range.mp4 146.7 MB
12. Working with Files, Folders & Text Files/08. Project Export Data to Text file (fix Delimiter to Semicolon).mp4 146.2 MB
18. Main Project #3 Invoice Generation Tool/02. Setting up an Input UserForm to Collect Master Data.mp4 138.8 MB
18. Main Project #3 Invoice Generation Tool/09. Create Email in Outlook & Attach PDF Invoice.mp4 136.3 MB
15. Interacting with Other Applications (Word, PowerPoint etc.)/04. Project Microsoft Word Create Personalized Letters in Word from Excel.mp4 134.1 MB
04. Referencing Ranges, Worksheets & Workbooks with VBA/09. Project Save Hard-coded Copy & Macro-free version of workbook.mp4 133.2 MB
02. Your First Macro/04. Project Dynamic Cell Selection (Special Cells) - Perfect for Flexible Macros.mp4 132.2 MB
02. Your First Macro/05. Project Copy (Consolidate) Data - Absolute versus Relative Macro Recording.mp4 128.3 MB
13. Excel Tables, Formulas & Pivot Tables/04. Pivot Tables & VBA What you Need to Know.mp4 125.7 MB
14. Main Project #2 Sales Regional Reporting Tool/02. Project Overview Regional Sales Reporting Tool.mp4 118.7 MB
17. Working with Userforms & ActiveX Controls/07. UserForm Basics What You Need to Get Started.mp4 117.5 MB
16. Workbook and Worksheet Events/04. Refresh PivotTables Automatically & Concept of Range Intersection.mp4 117.0 MB
12. Working with Files, Folders & Text Files/04. FileDialog Property Loop Inside a Folder.mp4 116.7 MB
07. Useful Built-in Functions/01. Overview VBA versus Worksheet Functions.mp4 112.0 MB
15. Interacting with Other Applications (Word, PowerPoint etc.)/05. Project Microsoft PowerPoint Export Excel Sheets to PowerPoint Presentation.mp4 110.5 MB
18. Main Project #3 Invoice Generation Tool/05. Searchable ListBox (with Selection Change event).mp4 109.6 MB
16. Workbook and Worksheet Events/02. Workbook Events, Toggle Full Screen (Activate, Deactivate, Open, Close).mp4 108.1 MB
20. Working with Charts/04. Show Charts inside UserForms.mp4 105.3 MB
18. Main Project #3 Invoice Generation Tool/03. Working with Multi-Column ListBoxes.mp4 104.6 MB
04. Referencing Ranges, Worksheets & Workbooks with VBA/03. Most Useful Range Properties & Methods.mp4 102.7 MB
17. Working with Userforms & ActiveX Controls/06. ActiveX to Show or Hide Other ActiveX controls (eg. Actual & Budget reporting).mp4 98.1 MB
13. Excel Tables, Formulas & Pivot Tables/02. Using Excel Formulas in VBA.mp4 94.5 MB
10. Looping in VBA (Controlling the Flow of Code)/11. Project Document all Comments in Workbook in a Sheet.mp4 94.4 MB
09. Main Project #1 Create a Tool to Automate Table of Contents/05. TOC Project Adding Error Handling & More Checks.mp4 92.0 MB
07. Useful Built-in Functions/07. Project Show Top 3 Values in a Message box based on Range Selected.mp4 86.4 MB
20. Working with Charts/02. Create and Modify a Chart with VBA.mp4 85.4 MB
14. Main Project #2 Sales Regional Reporting Tool/09. Final Touches & Creating Interface to Hide Specific Tabs with a Password.mp4 85.3 MB
15. Interacting with Other Applications (Word, PowerPoint etc.)/02. Project PDF Save Specific Sheets as a PDF File.mp4 82.7 MB
10. Looping in VBA (Controlling the Flow of Code)/04. For Next Reverse Loop (Delete FilteredHidden Rows).mp4 82.4 MB
11. Working with Arrays/02. One Dimensional Arrays (and transferring back to sheet).mp4 81.3 MB
06. Looping through Collections & Making Decisions/09. Bonus Unhide All Sheets in One Go.mp4 80.7 MB
19. Create your own Custom Functions/07. Project Function That Sums based on Cell Color.mp4 80.5 MB
08. Debugging, Error Handling & Procedure Scope/02. Debugging Options Watch, Locals, Immediate Windows & More.mp4 78.9 MB
18. Main Project #3 Invoice Generation Tool/01. Tool Overview What You Will Learn.mp4 78.2 MB
07. Useful Built-in Functions/05. Input Box that can Select Ranges (Excel InputBox Method).mp4 77.9 MB
17. Working with Userforms & ActiveX Controls/08. UserForm for Data Entry (Input & Check Boxes).mp4 77.3 MB
04. Referencing Ranges, Worksheets & Workbooks with VBA/07. Properly Referencing Workbooks.mp4 73.9 MB
02. Your First Macro/03. Visual Basic Editor What You Need to Know.mp4 72.7 MB
19. Create your own Custom Functions/04. Functions that Split Text and Numbers from Cell Value.mp4 72.4 MB
11. Working with Arrays/06. Variant Arrays Quick Method to Write to Cells.mp4 72.1 MB
11. Working with Arrays/08. Project Create a New Worksheet per Company with Specific Information.mp4 71.5 MB
12. Working with Files, Folders & Text Files/03. GetOpenFileName Method User Selects a File.mp4 71.3 MB
04. Referencing Ranges, Worksheets & Workbooks with VBA/05. Copying & resizing a variably sized range.mp4 71.0 MB
17. Working with Userforms & ActiveX Controls/05. ActiveX Combo Box for Easy Sheet Navigation (Great for Larger Workbooks).mp4 70.2 MB
18. Main Project #3 Invoice Generation Tool/07. MultiPage UserForm to Create Invoices & Email (Setup).mp4 69.9 MB
12. Working with Files, Folders & Text Files/05. Create CSV File from Data in Excel.mp4 69.7 MB
14. Main Project #2 Sales Regional Reporting Tool/06. Fine-tuning Report Export Procedure (Double-check if user wants to overwrite).mp4 69.3 MB
14. Main Project #2 Sales Regional Reporting Tool/08. Track the List of Tasks Completed with VBA.mp4 67.6 MB
13. Excel Tables, Formulas & Pivot Tables/06. Project Update Existing Formulas with VBA by Adding IFERROR.mp4 67.0 MB
18. Main Project #3 Invoice Generation Tool/04. Edit Master Data with UserForm.mp4 66.7 MB
16. Workbook and Worksheet Events/05. Resetting a Dependent Drop-down when the first Drop-down is Changed.mp4 66.6 MB
08. Debugging, Error Handling & Procedure Scope/03. Error Handling Different Methods.mp4 64.1 MB
16. Workbook and Worksheet Events/07. Project Link Page Header to Cell Value (BeforePrint Event).mp4 64.0 MB
08. Debugging, Error Handling & Procedure Scope/04. Faster Code by Suppressing Pop-ups & Flickering Screen.mp4 59.9 MB
07. Useful Built-in Functions/02. Most Useful VBA Functions.mp4 58.9 MB
06. Looping through Collections & Making Decisions/03. For Each to Loop Through Collections (sheets, ranges etc.) in one go.mp4 58.2 MB
13. Excel Tables, Formulas & Pivot Tables/03. Excel Tables Use the Right Syntax.mp4 57.9 MB
19. Create your own Custom Functions/03. Function to Calculate Age (Result in Years & Months).mp4 57.9 MB
10. Looping in VBA (Controlling the Flow of Code)/07. Find Method for Quicker Lookup Results.mp4 57.4 MB
04. Referencing Ranges, Worksheets & Workbooks with VBA/06. Properly Referencing Worksheets.mp4 56.8 MB
10. Looping in VBA (Controlling the Flow of Code)/05. Do Until & Do While Loop.mp4 56.6 MB
09. Main Project #1 Create a Tool to Automate Table of Contents/06. TOC Project Adding to Personal Macro Workbook (Make it Available to all Files).mp4 54.7 MB
15. Interacting with Other Applications (Word, PowerPoint etc.)/03. Project Email Automatically Create Personalized Emails with Attachments.mp4 54.0 MB
04. Referencing Ranges, Worksheets & Workbooks with VBA/02. Referring to Ranges & Writing to Cells in VBA.mp4 53.7 MB
20. Working with Charts/03. Animated Charts Different Methods.mp4 53.3 MB
12. Working with Files, Folders & Text Files/02. DIR Function Check if Files or Folders Exist.mp4 53.3 MB
10. Looping in VBA (Controlling the Flow of Code)/02. For Next Counter Loops (Simple Example).mp4 53.3 MB
03. The Object Model/03. VB Color Guidelines & Keyboard Shortcuts.mp4 50.8 MB
01. Introduction & Scope/04. Course Expectations.mp4 48.6 MB
06. Looping through Collections & Making Decisions/08. Project Get the Number of Formulas on the Worksheet.mp4 47.3 MB
03. The Object Model/07. How to Find the Object, Property & Method.mp4 47.3 MB
17. Working with Userforms & ActiveX Controls/03. ActiveX Check Box to Fix Scroll Area & Toggle Screen Settings.mp4 46.4 MB
19. Create your own Custom Functions/05. Using Functions in Sub Procedures.mp4 46.3 MB
11. Working with Arrays/03. Dynamic Arrays (size adjusts depending on a condition).mp4 45.5 MB
10. Looping in VBA (Controlling the Flow of Code)/08. Find Method with Do Loop - Multiple Matches.mp4 45.3 MB
17. Working with Userforms & ActiveX Controls/02. ActiveX Controls What you Need to Know.mp4 45.1 MB
08. Debugging, Error Handling & Procedure Scope/08. Project Get the Total Number of Formulas (or Comments) Used in a Workbook.mp4 44.8 MB
07. Useful Built-in Functions/03. Message Box (also with Yes, No buttons).mp4 44.0 MB
08. Debugging, Error Handling & Procedure Scope/06. Passing Arguments to Sub Procedures (By Ref, By Val).mp4 42.3 MB
21. Summary & Final Words/01. Your Next Steps & more Learning.mp4 41.7 MB
06. Looping through Collections & Making Decisions/04. IF Then (Else, ElseIF) for Conditional Outcomes.mp4 40.9 MB
17. Working with Userforms & ActiveX Controls/10. Bonus ListBox to Print Multiple Pages in ONE GO.mp4 39.1 MB
16. Workbook and Worksheet Events/03. Worksheet Selection Change Dynamic Font Color of Selected Range.mp4 39.1 MB
19. Create your own Custom Functions/02. Setting up a Simple Function (including Optional Arguments).mp4 37.5 MB
05. Working with Variables/04. Using Object Variables (Set statement).mp4 37.4 MB
05. Working with Variables/03. Declaring Variables, Arrays & Constants (Role of Option Explicit).mp4 37.2 MB
06. Looping through Collections & Making Decisions/06. Goto Statement to Change Program Flow.mp4 36.6 MB
09. Main Project #1 Create a Tool to Automate Table of Contents/02. TOC Project The Basics.mp4 36.1 MB
09. Main Project #1 Create a Tool to Automate Table of Contents/03. TOC Project Adding Hyperlinks.mp4 35.3 MB
02. Your First Macro/06. 7 Ways to Run Macros VBA code (incl. creative & modern buttons).mp4 35.0 MB
17. Working with Userforms & ActiveX Controls/04. ActiveX to Show and Hide Help.mp4 34.0 MB
02. Your First Macro/02. Steps to Your First Macro Recording.mp4 33.0 MB
12. Working with Files, Folders & Text Files/06. Printing & Writing to Text Files for More Control.mp4 32.9 MB
10. Looping in VBA (Controlling the Flow of Code)/09. Add a Timer to Test & Speech to Inform.mp4 32.6 MB
14. Main Project #2 Sales Regional Reporting Tool/07. Setting up Automatic Export of Text File (Fix delimiter in CSV to Semicolon).mp4 30.9 MB
13. Excel Tables, Formulas & Pivot Tables/01. Overview (Pivot) Tables & Formulas.mp4 30.5 MB
19. Create your own Custom Functions/01. Section Overview Function Procedures.mp4 30.0 MB
09. Main Project #1 Create a Tool to Automate Table of Contents/04. TOC Project Testing the VBA Code.mp4 26.7 MB
06. Looping through Collections & Making Decisions/02. With & End With for Easier Code Writing.mp4 26.1 MB
11. Working with Arrays/04. Preserving Dynamic Arrays (adding more elements to the existing array).mp4 26.1 MB
07. Useful Built-in Functions/04. Input Box (VBA InputBox Function).mp4 25.7 MB
08. Debugging, Error Handling & Procedure Scope/05. Procedure Scope & Running one Sub from Another.mp4 25.6 MB
12. Working with Files, Folders & Text Files/01. Overview Working with Folders & Files.mp4 25.3 MB
03. The Object Model/08. Conclusion Key Takeaways & Message from Me.mp4 23.8 MB
11. Working with Arrays/01. Overview Working with Arrays in VBA.mp4 23.2 MB
14. Main Project #2 Sales Regional Reporting Tool/10. Key Takeaways & Tips for VBA based Excel Tools.mp4 22.8 MB
05. Working with Variables/05. Scoping Variables.mp4 22.3 MB
16. Workbook and Worksheet Events/08. 2 Useful Tips when Working with Events & Key Takeaways.mp4 20.5 MB
11. Working with Arrays/05. Two Dimensional Arrays.mp4 20.4 MB
10. Looping in VBA (Controlling the Flow of Code)/06. Practical Example of Do Loop (with Inputbox).mp4 20.1 MB
06. Looping through Collections & Making Decisions/05. Select Case as Alternative for Many IF Statements.mp4 19.3 MB
03. The Object Model/02. VBA's Code Reference Object Library.mp4 16.0 MB
03. The Object Model/06. Object Methods.mp4 15.4 MB
15. Interacting with Other Applications (Word, PowerPoint etc.)/01. Overview & Important Concepts when Interacting with Other Applications.mp4 15.2 MB
01. Introduction & Scope/01. Course Structure & Content.mp4 14.2 MB
14. Main Project #2 Sales Regional Reporting Tool/01. What You'll Learn (& Should be Aware of..).mp4 13.5 MB
03. The Object Model/04. Excel VBA Object Model.mp4 13.0 MB
10. Looping in VBA (Controlling the Flow of Code)/12. Useful VBA Statements & Key takeaways for Looping in VBA.mp4 12.3 MB
03. The Object Model/05. Object Properties.mp4 10.9 MB
10. Looping in VBA (Controlling the Flow of Code)/01. Section Overview Looping in VBA.mp4 10.4 MB
01. Introduction & Scope/02. Important Compatibility & Setup Information.mp4 10.0 MB
20. Working with Charts/01. The Chart Object Library & Section Overview.mp4 10.0 MB
09. Main Project #1 Create a Tool to Automate Table of Contents/01. Project overview Table of Contents (TOC) with one click.mp4 9.6 MB
16. Workbook and Worksheet Events/01. Overview & What are Event Procedures.mp4 9.2 MB
04. Referencing Ranges, Worksheets & Workbooks with VBA/10. Key Takeaways for Referencing Ranges.mp4 8.9 MB
05. Working with Variables/02. Data Types for Better Performance.mp4 8.6 MB
05. Working with Variables/01. Overview Role of Assignment & Variables.mp4 7.5 MB
17. Working with Userforms & ActiveX Controls/01. Overview UserForms & ActiveX Controls.mp4 7.1 MB
05. Working with Variables/07. Key Takeaways for Working with Variables.mp4 6.9 MB
08. Debugging, Error Handling & Procedure Scope/01. Overview Debugging, Handling Errors & Procedure Scope.mp4 6.0 MB
01. Introduction & Scope/03. Course Resources Download Course Project Files.mp4 5.5 MB
02. Your First Macro/01. Overview Macros & Visual Basic Editor (VBE).mp4 5.3 MB
03. The Object Model/01. Overview VBA Object Model (What you need to become an expert in VBA).mp4 5.3 MB
08. Debugging, Error Handling & Procedure Scope/09. Key Takeaways Debugging, Error Handling & Course Map Status.mp4 4.9 MB
06. Looping through Collections & Making Decisions/01. Overview Why Collections are a VBA Essential.mp4 4.4 MB
04. Referencing Ranges, Worksheets & Workbooks with VBA/01. Overview Referencing Ranges, Worksheets & Workbooks.mp4 3.8 MB
01. Introduction & Scope/assets/03. ALL-VBA-Section-Milestone-Files-In-One-Place.zip 3.3 MB
01. Introduction & Scope/assets/03. Excel-VBA-Course-Slides.pdf 1.8 MB
01. Introduction & Scope/assets/03. IconSets.xlsx 838.6 KB
02. Your First Macro/assets/06. IconSets.xlsx 838.6 KB
18. Main Project #3 Invoice Generation Tool/assets/10. Invoice-Generator.xlsm 347.2 KB
10. Looping in VBA (Controlling the Flow of Code)/assets/01. S10-Looping.xlsm 333.3 KB
10. Looping in VBA (Controlling the Flow of Code)/assets/01. S10-Looping-Start.xlsx 313.5 KB
18. Main Project #3 Invoice Generation Tool/assets/02. Invoice-Generator-Start.xlsm 234.4 KB
01. Introduction & Scope/assets/03. How-to-Ask-Questions.pdf 229.9 KB
01. Introduction & Scope/assets/03. VBA-Project-Guide.pdf 184.5 KB
14. Main Project #2 Sales Regional Reporting Tool/assets/10. Monthly-Sales-Reporting-Template-Tool.xlsm 136.1 KB
07. Useful Built-in Functions/assets/01. S7-BuiltinFunctions.xlsm 126.0 KB
17. Working with Userforms & ActiveX Controls/assets/01. S17-UserForms-ActiveX.xlsm 124.8 KB
20. Working with Charts/assets/01. S20-Charts.xlsm 124.4 KB
15. Interacting with Other Applications (Word, PowerPoint etc.)/assets/01. S15-Other-Applications.xlsm 118.6 KB
07. Useful Built-in Functions/assets/01. S7-BuiltinFunctions-Start.xlsx 106.3 KB
15. Interacting with Other Applications (Word, PowerPoint etc.)/assets/01. S15-Other-Applications-Start.xlsx 99.0 KB
06. Looping through Collections & Making Decisions/assets/01. S6-Collections-With-IF.xlsm 93.3 KB
12. Working with Files, Folders & Text Files/assets/01. S12-Folders-Files.xlsm 90.1 KB
16. Workbook and Worksheet Events/assets/01. S16-Events.xlsm 89.5 KB
08. Debugging, Error Handling & Procedure Scope/assets/01. S8-ErrorHandling.xlsm 89.1 KB
04. Referencing Ranges, Worksheets & Workbooks with VBA/assets/01. S4-ReferencingRanges.xlsm 88.1 KB
02. Your First Macro/assets/01. S2-RecordMacros.xlsm 87.0 KB
13. Excel Tables, Formulas & Pivot Tables/assets/01. S13-Formulas-Tables-Pivot.xlsm 86.1 KB
08. Debugging, Error Handling & Procedure Scope/assets/01. S8-ErrorHandling-Start.xlsm 78.9 KB
20. Working with Charts/assets/01. S20-Charts-Start.xlsx 77.7 KB
11. Working with Arrays/assets/01. S11-Arrays.xlsm 77.2 KB
17. Working with Userforms & ActiveX Controls/assets/10. S17-Bonus-ListBox-PrintOut.xlsm 75.5 KB
17. Working with Userforms & ActiveX Controls/assets/01. S17-UserForms-ActiveX-Start.xlsx 71.8 KB
19. Create your own Custom Functions/assets/01. S19-FunctionProcedures.xlsm 70.3 KB
16. Workbook and Worksheet Events/assets/01. S16-Events-Start.xlsx 69.3 KB
02. Your First Macro/assets/01. S2-RecordMacros-Start.xlsx 65.7 KB
04. Referencing Ranges, Worksheets & Workbooks with VBA/assets/01. S4-ReferencingRanges-Start.xlsx 64.8 KB
05. Working with Variables/assets/01. S5-Variables.xlsm 63.5 KB
06. Looping through Collections & Making Decisions/assets/01. S6-Collections-With-IF-Start.xlsx 60.0 KB
13. Excel Tables, Formulas & Pivot Tables/assets/01. S13-Formulas-Tables-Pivot-Start.xlsx 59.4 KB
15. Interacting with Other Applications (Word, PowerPoint etc.)/assets/01. Letter-Word.docx 58.8 KB
12. Working with Files, Folders & Text Files/assets/01. S12-Folders-Files-Start.xlsx 58.2 KB
11. Working with Arrays/assets/01. S11-Arrays-Start.xlsx 54.6 KB
19. Create your own Custom Functions/assets/01. S19-FunctionProcedures-Start.xlsx 50.0 KB
17. Working with Userforms & ActiveX Controls/assets/10. S17-Bonus-ListBox-PrintOut-Start.xlsx 49.8 KB
05. Working with Variables/assets/01. S5-Variables-Start.xlsx 49.1 KB
15. Interacting with Other Applications (Word, PowerPoint etc.)/assets/01. Regional-Report-PowerPoint.pptx 43.9 KB
14. Main Project #2 Sales Regional Reporting Tool/assets/02. Monthly-Sales-Reporting-Template-Tool-Start.xlsm 38.2 KB
14. Main Project #2 Sales Regional Reporting Tool/04. Setting up a Template as the Basis for Different Reports.vtt 29.7 KB
18. Main Project #3 Invoice Generation Tool/08. Export PDF & Excel Workbook for Each Invoice based on ListBox Selection.vtt 28.3 KB
17. Working with Userforms & ActiveX Controls/09. UserForm to Document External Links & Comments (Combo Box & Option button).vtt 24.7 KB
17. Working with Userforms & ActiveX Controls/07. UserForm Basics What You Need to Get Started.vtt 24.2 KB
18. Main Project #3 Invoice Generation Tool/10. Final Updates & Debugging.vtt 23.1 KB
05. Working with Variables/007 Test Your Knowledge on Variables and data types.html 22.9 KB
02. Your First Macro/010 Quiz Test Your Knowledge on Macros.html 22.9 KB
01. Introduction & Scope/assets/05. Detailed-VBA-Course-Outline.xlsx 22.8 KB
13. Excel Tables, Formulas & Pivot Tables/04. Pivot Tables & VBA What you Need to Know.vtt 22.4 KB
09. Main Project #1 Create a Tool to Automate Table of Contents/assets/06. Project-Automatic-TableOfContent.xlsm 22.1 KB
03. The Object Model/008 Test Your Knowledge about the Object Model.html 22.0 KB
18. Main Project #3 Invoice Generation Tool/07. MultiPage UserForm to Create Invoices & Email (Setup).vtt 21.4 KB
15. Interacting with Other Applications (Word, PowerPoint etc.)/05. Project Microsoft PowerPoint Export Excel Sheets to PowerPoint Presentation.vtt 21.0 KB
18. Main Project #3 Invoice Generation Tool/02. Setting up an Input UserForm to Collect Master Data.vtt 20.1 KB
14. Main Project #2 Sales Regional Reporting Tool/05. Exporting Reports as Excel files (Pivot Table & Hard Coded Reports).vtt 19.3 KB
18. Main Project #3 Invoice Generation Tool/05. Searchable ListBox (with Selection Change event).vtt 19.2 KB
12. Working with Files, Folders & Text Files/04. FileDialog Property Loop Inside a Folder.vtt 19.1 KB
04. Referencing Ranges, Worksheets & Workbooks with VBA/02. Referring to Ranges & Writing to Cells in VBA.vtt 18.8 KB
18. Main Project #3 Invoice Generation Tool/06. Enhanced Searchable ListBox Write Selection back to Excel Table.vtt 18.4 KB
04. Referencing Ranges, Worksheets & Workbooks with VBA/06. Properly Referencing Worksheets.vtt 18.1 KB
04. Referencing Ranges, Worksheets & Workbooks with VBA/04. 4 Methods to Find the Last Row of your Range.vtt 18.0 KB
18. Main Project #3 Invoice Generation Tool/01. Tool Overview What You Will Learn.vtt 17.8 KB
10. Looping in VBA (Controlling the Flow of Code)/03. For Next Nested Loop (Loop through Text & Cells).vtt 17.8 KB
15. Interacting with Other Applications (Word, PowerPoint etc.)/04. Project Microsoft Word Create Personalized Letters in Word from Excel.vtt 17.5 KB
14. Main Project #2 Sales Regional Reporting Tool/02. Project Overview Regional Sales Reporting Tool.vtt 16.8 KB
18. Main Project #3 Invoice Generation Tool/09. Create Email in Outlook & Attach PDF Invoice.vtt 16.7 KB
04. Referencing Ranges, Worksheets & Workbooks with VBA/03. Most Useful Range Properties & Methods.vtt 16.6 KB
15. Interacting with Other Applications (Word, PowerPoint etc.)/02. Project PDF Save Specific Sheets as a PDF File.vtt 16.5 KB
08. Debugging, Error Handling & Procedure Scope/02. Debugging Options Watch, Locals, Immediate Windows & More.vtt 16.3 KB
13. Excel Tables, Formulas & Pivot Tables/03. Excel Tables Use the Right Syntax.vtt 16.3 KB
13. Excel Tables, Formulas & Pivot Tables/02. Using Excel Formulas in VBA.vtt 16.2 KB
05. Working with Variables/03. Declaring Variables, Arrays & Constants (Role of Option Explicit).vtt 16.1 KB
11. Working with Arrays/02. One Dimensional Arrays (and transferring back to sheet).vtt 16.0 KB
17. Working with Userforms & ActiveX Controls/08. UserForm for Data Entry (Input & Check Boxes).vtt 15.7 KB
07. Useful Built-in Functions/01. Overview VBA versus Worksheet Functions.vtt 15.7 KB
02. Your First Macro/03. Visual Basic Editor What You Need to Know.vtt 15.4 KB
09. Main Project #1 Create a Tool to Automate Table of Contents/05. TOC Project Adding Error Handling & More Checks.vtt 15.4 KB
17. Working with Userforms & ActiveX Controls/06. ActiveX to Show or Hide Other ActiveX controls (eg. Actual & Budget reporting).vtt 15.3 KB
20. Working with Charts/02. Create and Modify a Chart with VBA.vtt 15.3 KB
16. Workbook and Worksheet Events/02. Workbook Events, Toggle Full Screen (Activate, Deactivate, Open, Close).vtt 15.3 KB
20. Working with Charts/04. Show Charts inside UserForms.vtt 15.3 KB
03. The Object Model/03. VB Color Guidelines & Keyboard Shortcuts.vtt 15.2 KB
16. Workbook and Worksheet Events/04. Refresh PivotTables Automatically & Concept of Range Intersection.vtt 15.0 KB
02. Your First Macro/06. 7 Ways to Run Macros VBA code (incl. creative & modern buttons).vtt 15.0 KB
17. Working with Userforms & ActiveX Controls/10. Bonus ListBox to Print Multiple Pages in ONE GO.vtt 14.8 KB
20. Working with Charts/03. Animated Charts Different Methods.vtt 14.5 KB
12. Working with Files, Folders & Text Files/08. Project Export Data to Text file (fix Delimiter to Semicolon).vtt 14.4 KB
04. Referencing Ranges, Worksheets & Workbooks with VBA/09. Project Save Hard-coded Copy & Macro-free version of workbook.vtt 14.4 KB
07. Useful Built-in Functions/05. Input Box that can Select Ranges (Excel InputBox Method).vtt 14.1 KB
16. Workbook and Worksheet Events/05. Resetting a Dependent Drop-down when the first Drop-down is Changed.vtt 13.9 KB
06. Looping through Collections & Making Decisions/09. Bonus Unhide All Sheets in One Go.vtt 13.2 KB
08. Debugging, Error Handling & Procedure Scope/03. Error Handling Different Methods.vtt 13.1 KB
10. Looping in VBA (Controlling the Flow of Code)/11. Project Document all Comments in Workbook in a Sheet.vtt 13.0 KB
02. Your First Macro/04. Project Dynamic Cell Selection (Special Cells) - Perfect for Flexible Macros.vtt 13.0 KB
19. Create your own Custom Functions/07. Project Function That Sums based on Cell Color.vtt 13.0 KB
08. Debugging, Error Handling & Procedure Scope/04. Faster Code by Suppressing Pop-ups & Flickering Screen.vtt 12.9 KB
04. Referencing Ranges, Worksheets & Workbooks with VBA/07. Properly Referencing Workbooks.vtt 12.9 KB
07. Useful Built-in Functions/02. Most Useful VBA Functions.vtt 12.7 KB
14. Main Project #2 Sales Regional Reporting Tool/09. Final Touches & Creating Interface to Hide Specific Tabs with a Password.vtt 12.4 KB
14. Main Project #2 Sales Regional Reporting Tool/06. Fine-tuning Report Export Procedure (Double-check if user wants to overwrite).vtt 12.2 KB
09. Main Project #1 Create a Tool to Automate Table of Contents/02. TOC Project The Basics.vtt 12.2 KB
07. Useful Built-in Functions/07. Project Show Top 3 Values in a Message box based on Range Selected.vtt 12.2 KB
18. Main Project #3 Invoice Generation Tool/03. Working with Multi-Column ListBoxes.vtt 12.2 KB
17. Working with Userforms & ActiveX Controls/05. ActiveX Combo Box for Easy Sheet Navigation (Great for Larger Workbooks).vtt 12.1 KB
08. Debugging, Error Handling & Procedure Scope/08. Project Get the Total Number of Formulas (or Comments) Used in a Workbook.vtt 12.0 KB
06. Looping through Collections & Making Decisions/04. IF Then (Else, ElseIF) for Conditional Outcomes.vtt 12.0 KB
06. Looping through Collections & Making Decisions/03. For Each to Loop Through Collections (sheets, ranges etc.) in one go.vtt 11.9 KB
14. Main Project #2 Sales Regional Reporting Tool/08. Track the List of Tasks Completed with VBA.vtt 11.9 KB
02. Your First Macro/05. Project Copy (Consolidate) Data - Absolute versus Relative Macro Recording.vtt 11.7 KB
04. Referencing Ranges, Worksheets & Workbooks with VBA/05. Copying & resizing a variably sized range.vtt 11.7 KB
10. Looping in VBA (Controlling the Flow of Code)/05. Do Until & Do While Loop.vtt 11.5 KB
14. Main Project #2 Sales Regional Reporting Tool/03. Importing Data from Multiple Files using MultiSelect.vtt 11.1 KB
14. Main Project #2 Sales Regional Reporting Tool/assets/02. Sales-Document-UrbanRight.xlsx 10.9 KB
14. Main Project #2 Sales Regional Reporting Tool/assets/02. Sales-Document-BereKleid.xlsx 10.8 KB
15. Interacting with Other Applications (Word, PowerPoint etc.)/03. Project Email Automatically Create Personalized Emails with Attachments.vtt 10.8 KB
12. Working with Files, Folders & Text Files/03. GetOpenFileName Method User Selects a File.vtt 10.8 KB
10. Looping in VBA (Controlling the Flow of Code)/07. Find Method for Quicker Lookup Results.vtt 10.7 KB
14. Main Project #2 Sales Regional Reporting Tool/assets/02. Sales-Document-LucasBasics.xlsx 10.7 KB
08. Debugging, Error Handling & Procedure Scope/06. Passing Arguments to Sub Procedures (By Ref, By Val).vtt 10.7 KB
19. Create your own Custom Functions/04. Functions that Split Text and Numbers from Cell Value.vtt 10.5 KB
11. Working with Arrays/08. Project Create a New Worksheet per Company with Specific Information.vtt 10.4 KB
10. Looping in VBA (Controlling the Flow of Code)/04. For Next Reverse Loop (Delete FilteredHidden Rows).vtt 10.4 KB
07. Useful Built-in Functions/03. Message Box (also with Yes, No buttons).vtt 10.3 KB
14. Main Project #2 Sales Regional Reporting Tool/assets/02. Sales-Document-MetaCreations.xlsx 10.3 KB
12. Working with Files, Folders & Text Files/02. DIR Function Check if Files or Folders Exist.vtt 10.1 KB
03. The Object Model/07. How to Find the Object, Property & Method.vtt 9.9 KB
10. Looping in VBA (Controlling the Flow of Code)/02. For Next Counter Loops (Simple Example).vtt 9.9 KB
11. Working with Arrays/06. Variant Arrays Quick Method to Write to Cells.vtt 9.7 KB
10. Looping in VBA (Controlling the Flow of Code)/09. Add a Timer to Test & Speech to Inform.vtt 9.7 KB
16. Workbook and Worksheet Events/07. Project Link Page Header to Cell Value (BeforePrint Event).vtt 9.5 KB
14. Main Project #2 Sales Regional Reporting Tool/07. Setting up Automatic Export of Text File (Fix delimiter in CSV to Semicolon).vtt 9.2 KB
06. Looping through Collections & Making Decisions/06. Goto Statement to Change Program Flow.vtt 9.1 KB
12. Working with Files, Folders & Text Files/assets/01. Test-data.xlsx 9.1 KB
17. Working with Userforms & ActiveX Controls/03. ActiveX Check Box to Fix Scroll Area & Toggle Screen Settings.vtt 9.0 KB
17. Working with Userforms & ActiveX Controls/02. ActiveX Controls What you Need to Know.vtt 8.8 KB
09. Main Project #1 Create a Tool to Automate Table of Contents/06. TOC Project Adding to Personal Macro Workbook (Make it Available to all Files).vtt 8.6 KB
11. Working with Arrays/05. Two Dimensional Arrays.vtt 8.6 KB
06. Looping through Collections & Making Decisions/08. Project Get the Number of Formulas on the Worksheet.vtt 8.6 KB
13. Excel Tables, Formulas & Pivot Tables/06. Project Update Existing Formulas with VBA by Adding IFERROR.vtt 8.6 KB
12. Working with Files, Folders & Text Files/05. Create CSV File from Data in Excel.vtt 8.2 KB
05. Working with Variables/04. Using Object Variables (Set statement).vtt 8.2 KB
07. Useful Built-in Functions/04. Input Box (VBA InputBox Function).vtt 8.2 KB
12. Working with Files, Folders & Text Files/06. Printing & Writing to Text Files for More Control.vtt 8.1 KB
03. The Object Model/04. Excel VBA Object Model.vtt 7.9 KB
02. Your First Macro/02. Steps to Your First Macro Recording.vtt 7.8 KB
18. Main Project #3 Invoice Generation Tool/04. Edit Master Data with UserForm.vtt 7.8 KB
11. Working with Arrays/03. Dynamic Arrays (size adjusts depending on a condition).vtt 7.7 KB
05. Working with Variables/05. Scoping Variables.vtt 7.7 KB
03. The Object Model/06. Object Methods.vtt 7.6 KB
10. Looping in VBA (Controlling the Flow of Code)/08. Find Method with Do Loop - Multiple Matches.vtt 7.6 KB
06. Looping through Collections & Making Decisions/02. With & End With for Easier Code Writing.vtt 7.5 KB
09. Main Project #1 Create a Tool to Automate Table of Contents/03. TOC Project Adding Hyperlinks.vtt 7.5 KB
19. Create your own Custom Functions/05. Using Functions in Sub Procedures.vtt 7.4 KB
16. Workbook and Worksheet Events/03. Worksheet Selection Change Dynamic Font Color of Selected Range.vtt 7.4 KB
17. Working with Userforms & ActiveX Controls/04. ActiveX to Show and Hide Help.vtt 7.3 KB
19. Create your own Custom Functions/03. Function to Calculate Age (Result in Years & Months).vtt 7.1 KB
08. Debugging, Error Handling & Procedure Scope/05. Procedure Scope & Running one Sub from Another.vtt 7.0 KB
19. Create your own Custom Functions/02. Setting up a Simple Function (including Optional Arguments).vtt 6.8 KB
06. Looping through Collections & Making Decisions/05. Select Case as Alternative for Many IF Statements.vtt 6.2 KB
15. Interacting with Other Applications (Word, PowerPoint etc.)/01. Overview & Important Concepts when Interacting with Other Applications.vtt 6.0 KB
03. The Object Model/05. Object Properties.vtt 5.8 KB
09. Main Project #1 Create a Tool to Automate Table of Contents/04. TOC Project Testing the VBA Code.vtt 5.3 KB
01. Introduction & Scope/01. Course Structure & Content.vtt 5.2 KB
03. The Object Model/02. VBA's Code Reference Object Library.vtt 5.1 KB
14. Main Project #2 Sales Regional Reporting Tool/01. What You'll Learn (& Should be Aware of..).vtt 4.9 KB
01. Introduction & Scope/02. Important Compatibility & Setup Information.vtt 4.6 KB
11. Working with Arrays/04. Preserving Dynamic Arrays (adding more elements to the existing array).vtt 4.6 KB
10. Looping in VBA (Controlling the Flow of Code)/12. Useful VBA Statements & Key takeaways for Looping in VBA.vtt 4.6 KB
20. Working with Charts/01. The Chart Object Library & Section Overview.vtt 4.4 KB
05. Working with Variables/02. Data Types for Better Performance.vtt 4.1 KB
16. Workbook and Worksheet Events/08. 2 Useful Tips when Working with Events & Key Takeaways.vtt 4.1 KB
16. Workbook and Worksheet Events/01. Overview & What are Event Procedures.vtt 4.0 KB
10. Looping in VBA (Controlling the Flow of Code)/06. Practical Example of Do Loop (with Inputbox).vtt 3.9 KB
04. Referencing Ranges, Worksheets & Workbooks with VBA/10. Key Takeaways for Referencing Ranges.vtt 3.6 KB
05. Working with Variables/01. Overview Role of Assignment & Variables.vtt 3.6 KB
12. Working with Files, Folders & Text Files/01. Overview Working with Folders & Files.vtt 3.6 KB
03. The Object Model/08. Conclusion Key Takeaways & Message from Me.vtt 3.5 KB
01. Introduction & Scope/04. Course Expectations.vtt 3.5 KB
14. Main Project #2 Sales Regional Reporting Tool/10. Key Takeaways & Tips for VBA based Excel Tools.vtt 3.2 KB
17. Working with Userforms & ActiveX Controls/assets/01. S17-PictureClip.zip 3.1 KB
21. Summary & Final Words/01. Your Next Steps & more Learning.vtt 3.1 KB
10. Looping in VBA (Controlling the Flow of Code)/01. Section Overview Looping in VBA.vtt 3.0 KB
13. Excel Tables, Formulas & Pivot Tables/01. Overview (Pivot) Tables & Formulas.vtt 2.8 KB
05. Working with Variables/07. Key Takeaways for Working with Variables.vtt 2.7 KB
09. Main Project #1 Create a Tool to Automate Table of Contents/01. Project overview Table of Contents (TOC) with one click.vtt 2.7 KB
08. Debugging, Error Handling & Procedure Scope/09. Key Takeaways Debugging, Error Handling & Course Map Status.vtt 2.6 KB
19. Create your own Custom Functions/01. Section Overview Function Procedures.vtt 2.5 KB
08. Debugging, Error Handling & Procedure Scope/01. Overview Debugging, Handling Errors & Procedure Scope.vtt 2.5 KB
17. Working with Userforms & ActiveX Controls/01. Overview UserForms & ActiveX Controls.vtt 2.4 KB
01. Introduction & Scope/03. Course Resources Download Course Project Files.vtt 2.3 KB
21. Summary & Final Words/02. SPECIAL BONUS Discover Exciting Offers!.html 2.2 KB
02. Your First Macro/01. Overview Macros & Visual Basic Editor (VBE).vtt 2.2 KB
03. The Object Model/01. Overview VBA Object Model (What you need to become an expert in VBA).vtt 2.0 KB
11. Working with Arrays/01. Overview Working with Arrays in VBA.vtt 2.0 KB
02. Your First Macro/09. What's the Difference Between Macros and VBA.html 1.8 KB
04. Referencing Ranges, Worksheets & Workbooks with VBA/08. Activity Save a Hard-coded Copy of Workbook.html 1.7 KB
06. Looping through Collections & Making Decisions/01. Overview Why Collections are a VBA Essential.vtt 1.7 KB
04. Referencing Ranges, Worksheets & Workbooks with VBA/01. Overview Referencing Ranges, Worksheets & Workbooks.vtt 1.5 KB
05. Working with Variables/06. Activity Revisit Hard-coded Workbook Project & Use Variable Assignment.html 1.3 KB
02. Your First Macro/07. OFFICE 365 Update Change from Excel Comments to Notes.html 1.3 KB
02. Your First Macro/08. Activity Record a Macro that Deletes all Comments.html 1.3 KB
10. Looping in VBA (Controlling the Flow of Code)/10. Activity Document all Comments in Workbook in a Sheet.html 1.2 KB
07. Useful Built-in Functions/06. Activity Show Top 3 Values in a Message Box Based on Range Selected.html 1.1 KB
08. Debugging, Error Handling & Procedure Scope/07. Activity Get the Total Number of Formulas (or Comments) Used in a Workbook.html 1003 bytes
13. Excel Tables, Formulas & Pivot Tables/05. Activity Update Existing Formulas with VBA by Adding IFERROR.html 936 bytes
11. Working with Arrays/07. Activity Create a New Worksheet per Company with Specific Information.html 908 bytes
16. Workbook and Worksheet Events/06. Activity Link Page Header to Cell Value (BeforePrint Event).html 790 bytes
12. Working with Files, Folders & Text Files/07. Activity Export Data to Text file (fix Delimiter to Semicolon).html 739 bytes
12. Working with Files, Folders & Text Files/assets/01. TestTextCSV.csv 724 bytes
19. Create your own Custom Functions/06. Activity Function That Sums based on Cell Color.html 718 bytes
06. Looping through Collections & Making Decisions/07. Activity Get the Number of Formulas on the worksheet.html 659 bytes
20. Working with Charts/05. Key Takeaways Charts.html 652 bytes
17. Working with Userforms & ActiveX Controls/11. UserForm Checklist & Course Map Status.html 568 bytes
14. Main Project #2 Sales Regional Reporting Tool/11. Second Milestone Completed!.html 561 bytes
09. Main Project #1 Create a Tool to Automate Table of Contents/07. First Milestone Completed!.html 540 bytes
01. Introduction & Scope/05. Course Outline for Quick Reference.html 490 bytes
19. Create your own Custom Functions/08. Key Takeaways Function Procedures in VBA & Course Map Status.html 471 bytes
18. Main Project #3 Invoice Generation Tool/11. Last Milestone Completed!.html 455 bytes
06. Looping through Collections & Making Decisions/10. Key Takeaways for Collections & Decision Making in VBA.html 432 bytes
11. Working with Arrays/09. Key Takeaways Arrays.html 401 bytes
13. Excel Tables, Formulas & Pivot Tables/07. Key Takeaways (Pivot) Tables & Formula.html 391 bytes
15. Interacting with Other Applications (Word, PowerPoint etc.)/06. Key Takeaways when Working with other Applications.html 388 bytes
12. Working with Files, Folders & Text Files/09. Key Takeaways Files & Folders.html 387 bytes
07. Useful Built-in Functions/08. Key Takeaways Built-in Functions.html 356 bytes
14. Main Project #2 Sales Regional Reporting Tool/external-links/04. Excel-IF-Function.url 54 bytes
14. Main Project #2 Sales Regional Reporting Tool/external-links/04. PivotTable-with-Pivot-Chart-Slicers.url 54 bytes
14. Main Project #2 Sales Regional Reporting Tool/external-links/04. PivotTable-with-Slicers.url 54 bytes
14. Main Project #2 Sales Regional Reporting Tool/external-links/04. VLOOKUP-Explained.url 54 bytes
16. Workbook and Worksheet Events/external-links/05. INDEX-MATCH-Basics-video.url 54 bytes

Udemy - Unlock Excel VBA and Excel Macros (12.2024)

File List

Download Torrent

Related Resources

Copyright Infringement