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.mp4

1. What You'll Learn (& Should be Aware of..).mp4

1. What You'll Learn (& Should be Aware of..).vtt

2. Project Overview Regional Sales Reporting Tool.mp4

2. Project Overview Regional Sales Reporting Tool.vtt

2.1 Sales_Document_UrbanRight.xlsx.xlsx

2.2 Sales_Document_LucasBasics.xlsx.xlsx

2.3 Monthly_Sales_Reporting_Template_Tool_Start.xlsm.xlsm

2.4 Sales_Document_MetaCreations.xlsx.xlsx

2.5 Sales_Document_BereKleid.xlsx.xlsx

3. Importing Data from Multiple Files using MultiSelect.mp4

3. Importing Data from Multiple Files using MultiSelect.vtt

4. Setting up a Template as the Basis for Different Reports.vtt

4.1 Excel IF Function.html

4.2 PivotTable with Pivot Chart & Slicers.html

4.3 VLOOKUP Explained.html

4.4 PivotTable with Slicers.html

5. Exporting Reports as Excel files (Pivot Table & Hard Coded Reports).mp4

5. Exporting Reports as Excel files (Pivot Table & Hard Coded Reports).vtt

6. Fine-tuning Report Export Procedure (Double-check if user wants to overwrite).mp4

6. Fine-tuning Report Export Procedure (Double-check if user wants to overwrite).vtt

7. Setting up Automatic Export of Text File (Fix delimiter in CSV to Semicolon).mp4

7. Setting up Automatic Export of Text File (Fix delimiter in CSV to Semicolon).vtt

8. Track the List of Tasks Completed with VBA.mp4

8. Track the List of Tasks Completed with VBA.vtt

9. Final Touches & Creating Interface to Hide Specific Tabs with a Password.mp4

9. Final Touches & Creating Interface to Hide Specific Tabs with a Password.vtt

10. Key Takeaways & Tips for VBA based Excel Tools.mp4

10. Key Takeaways & Tips for VBA based Excel Tools.vtt

10.1 Monthly_Sales_Reporting_Template_Tool.xlsm.xlsm

11. Second Milestone Completed!.html

/

Visit Coursedrive.net.url

Course Downloaded from coursedrive.net.txt

/Unlock Excel VBA and Excel Macros/

ReadMe.txt

Visit Coursedrive.net.url

/1. Introduction & Scope/

1. Course Structure & Content.mp4

1. Course Structure & Content.vtt

2. Important Compatibility & Setup Information.mp4

2. Important Compatibility & Setup Information.vtt

3. Download Course Project Files.mp4

3. Download Course Project Files.vtt

3.1 IconSets.xlsx.xlsx

3.2 Excel_VBA_Course_Slides.pdf.pdf

3.3 How_to_Ask_Questions.pdf.pdf

3.4 VBA_Project_Guide.pdf.pdf

3.5 ALL_VBA_Section_Milestone_Files_In_One_Place.zip.zip

4. Course Expectations.mp4

4. Course Expectations.vtt

Must Read.txt

Visit Coursedrive.net.url

/.../2. Your First Macro/

1. Overview Macros & Visual Basic Editor (VBE).mp4

1. Overview Macros & Visual Basic Editor (VBE).vtt

1.1 S2_RecordMacros.xlsm.xlsm

1.2 S2_RecordMacros_Start.xlsx.xlsx

2. Steps to Your First Macro Recording.mp4

2. Steps to Your First Macro Recording.vtt

3. Visual Basic Editor What You Need to Know.mp4

3. Visual Basic Editor What You Need to Know.vtt

4. Project Dynamic Cell Selection (Special Cells) - Perfect for Flexible Macros.mp4

4. Project Dynamic Cell Selection (Special Cells) - Perfect for Flexible Macros.vtt

5. Project Copy (Consolidate) Data - Absolute versus Relative Macro Recording.mp4

5. Project Copy (Consolidate) Data - Absolute versus Relative Macro Recording.vtt

6. 7 Ways to Run Macros VBA code (incl. creative & modern buttons).mp4

6. 7 Ways to Run Macros VBA code (incl. creative & modern buttons).vtt

6.1 IconSets.xlsx.xlsx

7. Activity Record a Macro that Deletes all Comments.html

8. What's the Difference Between Macros and VBA.html

9. Quiz Test Your Knowledge on Macros.html

/.../3. The Object Model/

1. Overview VBA Object Model (What you need to become an expert in VBA).mp4

1. Overview VBA Object Model (What you need to become an expert in VBA).vtt

2. VBA's Code Reference Object Library.mp4

2. VBA's Code Reference Object Library.vtt

3. VB Color Guidelines & Keyboard Shortcuts.mp4

3. VB Color Guidelines & Keyboard Shortcuts.vtt

4. Excel VBA Object Model.mp4

4. Excel VBA Object Model.vtt

5. Object Properties.mp4

5. Object Properties.vtt

6. Object Methods.mp4

6. Object Methods.vtt

7. How to Find the Object, Property & Method.mp4

7. How to Find the Object, Property & Method.vtt

8. Test Your Knowledge about the Object Model.html

9. Conclusion Key Takeaways & Message from Me.mp4

9. Conclusion Key Takeaways & Message from Me.vtt

/.../4. Referencing Ranges, Worksheets & Workbooks with VBA/

1. Overview Referencing Ranges, Worksheets & Workbooks.mp4

1. Overview Referencing Ranges, Worksheets & Workbooks.vtt

1.1 S4_ReferencingRanges.xlsm.xlsm

1.2 S4_ReferencingRanges_Start.xlsx.xlsx

2. Referring to Ranges & Writing to Cells in VBA.mp4

2. Referring to Ranges & Writing to Cells in VBA.vtt

3. Most Useful Range Properties & Methods.mp4

3. Most Useful Range Properties & Methods.vtt

4. 4 Methods to Find the Last Row of your Range.mp4

4. 4 Methods to Find the Last Row of your Range.vtt

5. Copying & resizing a variably sized range.mp4

5. Copying & resizing a variably sized range.vtt

6. Properly Referencing Worksheets.mp4

6. Properly Referencing Worksheets.vtt

7. Properly Referencing Workbooks.mp4

7. Properly Referencing Workbooks.vtt

8. Activity Save a Hard-coded Copy of Workbook.html

9. Project Save Hard-coded Copy & Macro-free version of workbook.mp4

9. Project Save Hard-coded Copy & Macro-free version of workbook.vtt

10. Key Takeaways for Referencing Ranges.mp4

10. Key Takeaways for Referencing Ranges.vtt

/.../5. Working with Variables/

1. Overview Role of Assignment & Variables.mp4

1. Overview Role of Assignment & Variables.vtt

1.1 S5_Variables_Start.xlsx.xlsx

1.2 S5_Variables.xlsm.xlsm

2. Data Types for Better Performance.mp4

2. Data Types for Better Performance.vtt

3. Declaring Variables, Arrays & Constants (Role of Option Explicit).mp4

3. Declaring Variables, Arrays & Constants (Role of Option Explicit).vtt

4. Using Object Variables (Set statement).mp4

4. Using Object Variables (Set statement).vtt

5. Scoping Variables.mp4

5. Scoping Variables.vtt

6. Activity Revisit Hard-coded Workbook Project & Use Variable Assignment.html

7. Test Your Knowledge on Variables and data types.html

8. Key Takeaways for Working with Variables.mp4

8. Key Takeaways for Working with Variables.vtt

/.../6. Looping through Collections & Making Decisions/

1. Overview Why Collections are a VBA Essential.mp4

1. Overview Why Collections are a VBA Essential.vtt

1.1 S6_Collections_With_IF.xlsm.xlsm

1.2 S6_Collections_With_IF_Start.xlsx.xlsx

2. With & End With for Easier Code Writing.mp4

2. With & End With for Easier Code Writing.vtt

3. For Each to Loop Through Collections (sheets, ranges etc.) in one go.mp4

3. For Each to Loop Through Collections (sheets, ranges etc.) in one go.vtt

4. IF Then (Else, ElseIF) for Conditional Outcomes.mp4

4. IF Then (Else, ElseIF) for Conditional Outcomes.vtt

5. Select Case as Alternative for Many IF Statements.mp4

5. Select Case as Alternative for Many IF Statements.vtt

6. Goto Statement to Change Program Flow.mp4

6. Goto Statement to Change Program Flow.vtt

7. Activity Get the Number of Formulas on the worksheet.html

8. Project Get the Number of Formulas on the Worksheet.mp4

8. Project Get the Number of Formulas on the Worksheet.vtt

9. Bonus Unhide All Sheets in One Go.mp4

9. Bonus Unhide All Sheets in One Go.vtt

10. Key Takeaways for Collections & Decision Making in VBA.html

/.../7. Useful Built-in Functions/

1. Overview VBA versus Worksheet Functions.mp4

1. Overview VBA versus Worksheet Functions.vtt

1.1 S7_BuiltinFunctions_Start.xlsx.xlsx

1.2 S7_BuiltinFunctions.xlsm.xlsm

2. Most Useful VBA Functions.mp4

2. Most Useful VBA Functions.vtt

3. Message Box (also with Yes, No buttons).mp4

3. Message Box (also with Yes, No buttons).vtt

4. Input Box (VBA InputBox Function).mp4

4. Input Box (VBA InputBox Function).vtt

5. Input Box that can Select Ranges (Excel InputBox Method).mp4

5. Input Box that can Select Ranges (Excel InputBox Method).vtt

6. Activity Show Top 3 Values in a Message Box Based on Range Selected.html

7. Project Show Top 3 Values in a Message box based on Range Selected.mp4

7. Project Show Top 3 Values in a Message box based on Range Selected.vtt

8. Key Takeaways Built-in Functions.html

/.../8. Debugging, Error Handling & Procedure Scope/

1. Overview Debugging, Handling Errors & Procedure Scope.mp4

1. Overview Debugging, Handling Errors & Procedure Scope.vtt

1.1 S8_ErrorHandling_Start.xlsm.xlsm

1.2 S8_ErrorHandling.xlsm.xlsm

2. Debugging Options Watch, Locals, Immediate Windows & More.mp4

2. Debugging Options Watch, Locals, Immediate Windows & More.vtt

3. Error Handling Different Methods.mp4

3. Error Handling Different Methods.vtt

4. Faster Code by Suppressing Pop-ups & Flickering Screen.mp4

4. Faster Code by Suppressing Pop-ups & Flickering Screen.vtt

5. Procedure Scope & Running one Sub from Another.mp4

5. Procedure Scope & Running one Sub from Another.vtt

6. Passing Arguments to Sub Procedures (By Ref, By Val).mp4

6. Passing Arguments to Sub Procedures (By Ref, By Val).vtt

7. Activity Get the Total Number of Formulas (or Comments) Used in a Workbook.html

8. Project Get the Total Number of Formulas (or Comments) Used in a Workbook.mp4

8. Project Get the Total Number of Formulas (or Comments) Used in a Workbook.vtt

9. Key Takeaways Debugging, Error Handling & Course Map Status.mp4

9. Key Takeaways Debugging, Error Handling & Course Map Status.vtt

ReadMe.txt

Visit Coursedrive.net.url

/.../9. Main Project #1 Create a Tool to Automate Table of Contents/

1. Project overivew Table of Contents (TOC) with one click.mp4

1. Project overivew Table of Contents (TOC) with one click.vtt

2. TOC Project The Basics.mp4

2. TOC Project The Basics.vtt

3. TOC Project Adding Hyperlinks.mp4

3. TOC Project Adding Hyperlinks.vtt

4. TOC Project Testing the VBA Code.mp4

4. TOC Project Testing the VBA Code.vtt

5. TOC Project Adding Error Handling & More Checks.mp4

5. TOC Project Adding Error Handling & More Checks.vtt

6. TOC Project Adding to Personal Macro Workbook (Make it Available to all Files).mp4

6. TOC Project Adding to Personal Macro Workbook (Make it Available to all Files).vtt

6.1 Project_Automatic_TableOfContent.xlsm.xlsm

7. First Milestone Completed!.html

/.../10. Looping in VBA (Controlling the Flow of Code)/

1. Section Overview Looping in VBA.mp4

1. Section Overview Looping in VBA.vtt

1.1 S10_Looping_Start.xlsx.xlsx

1.2 S10_Looping.xlsm.xlsm

2. For Next Counter Loops (Simple Example).mp4

2. For Next Counter Loops (Simple Example).vtt

3. For Next Nested Loop (Loop through Text & Cells).mp4

3. For Next Nested Loop (Loop through Text & Cells).vtt

4. For Next Reverse Loop (Delete FilteredHidden Rows).mp4

4. For Next Reverse Loop (Delete FilteredHidden Rows).vtt

5. Do Until & Do While Loop.mp4

5. Do Until & Do While Loop.vtt

6. Practical Example of Do Loop (with Inputbox).mp4

6. Practical Example of Do Loop (with Inputbox).vtt

7. Find Method for Quicker Lookup Results.mp4

7. Find Method for Quicker Lookup Results.vtt

8. Find Method with Do Loop - Multiple Matches.mp4

8. Find Method with Do Loop - Multiple Matches.vtt

9. Add a Timer to Test & Speech to Inform.mp4

9. Add a Timer to Test & Speech to Inform.vtt

10. Activity Document all Comments in Workbook in a Sheet.html

11. Project Document all Comments in Workbook in a Sheet.mp4

11. Project Document all Comments in Workbook in a Sheet.vtt

12. Useful VBA Statements & Key takeaways for Looping in VBA.mp4

12. Useful VBA Statements & Key takeaways for Looping in VBA.vtt

/.../11. Working with Arrays/

1. Overview Working with Arrays in VBA.mp4

1. Overview Working with Arrays in VBA.vtt

1.1 S11_Arrays_Start.xlsx.xlsx

1.2 S11_Arrays.xlsm.xlsm

2. One Dimensional Arrays (and transferring back to sheet).mp4

2. One Dimensional Arrays (and transferring back to sheet).vtt

3. Dynamic Arrays (size adjusts depending on a condition).mp4

3. Dynamic Arrays (size adjusts depending on a condition).vtt

4. Preserving Dynamic Arrays (adding more elements to the existing array).mp4

4. Preserving Dynamic Arrays (adding more elements to the existing array).vtt

5. Two Dimensional Arrays.mp4

5. Two Dimensional Arrays.vtt

6. Variant Arrays Quick Method to Write to Cells.mp4

6. Variant Arrays Quick Method to Write to Cells.vtt

7. Activity Create a New Worksheet per Company with Specific Information.html

8. Project Create a New Worksheet per Company with Specific Information.mp4

8. Project Create a New Worksheet per Company with Specific Information.vtt

9. Key Takeaways Arrays.html

/.../12. Working with Files, Folders & Text Files/

1. Overview Working with Folders & Files.mp4

1. Overview Working with Folders & Files.vtt

1.1 S12_Folders_Files.xlsm.xlsm

1.2 S12_Folders_Files_Start.xlsx.xlsx

1.3 TestTextCSV.csv.csv

1.4 Test_data.xlsx.xlsx

2. DIR Function Check if Files or Folders Exist.mp4

2. DIR Function Check if Files or Folders Exist.vtt

3. GetOpenFileName Method User Selects a File.mp4

3. GetOpenFileName Method User Selects a File.vtt

4. FileDialog Property Loop Inside a Folder.mp4

4. FileDialog Property Loop Inside a Folder.vtt

5. Create CSV File from Data in Excel.mp4

5. Create CSV File from Data in Excel.vtt

6. Printing & Writing to Text Files for More Control.mp4

6. Printing & Writing to Text Files for More Control.vtt

7. Activity Export Data to Text file (fix Delimiter to Semicolon).html

8. Project Export Data to Text file (fix Delimiter to Semicolon).mp4

8. Project Export Data to Text file (fix Delimiter to Semicolon).vtt

9. Key Takeaways Files & Folders.html

/.../13. Excel Tables, Formulas & Pivot Tables/

1. Overview (Pivot) Tables & Formulas.mp4

1. Overview (Pivot) Tables & Formulas.vtt

1.1 S13_Formulas_Tables_Pivot_Start.xlsx.xlsx

1.2 S13_Formulas_Tables_Pivot.xlsm.xlsm

2. Using Excel Formulas in VBA.mp4

2. Using Excel Formulas in VBA.vtt

3. Excel Tables Use the Right Syntax.mp4

3. Excel Tables Use the Right Syntax.vtt

4. Pivot Tables & VBA What you Need to Know.mp4

4. Pivot Tables & VBA What you Need to Know.vtt

5. Activity Update Existing Formulas with VBA by Adding IFERROR.html

6. Project Update Existing Formulas with VBA by Adding IFERROR.mp4

6. Project Update Existing Formulas with VBA by Adding IFERROR.vtt

7. Key Takeaways (Pivot) Tables & Formula.html

/.../15. Interacting with Other Applications (Word, PowerPoint etc.)/

1. Overview & Important Concepts when Interacting with Other Applications.mp4

1. Overview & Important Concepts when Interacting with Other Applications.vtt

1.1 S15_Other_Applications_Start.xlsx.xlsx

1.2 S15_Other_Applications.xlsm.xlsm

1.3 Regional Report PowerPoint.pptx.pptx

1.4 Letter_Word.docx.docx

2. Project PDF Save Specific Sheets as a PDF File.mp4

2. Project PDF Save Specific Sheets as a PDF File.vtt

3. Project Email Automatically Create Personalized Emails with Attachments.mp4

3. Project Email Automatically Create Personalized Emails with Attachments.vtt

4. Project Microsoft Word Create Personalized Letters in Word from Excel.mp4

4. Project Microsoft Word Create Personalized Letters in Word from Excel.vtt

5. Project Microsoft PowerPoint Export Excel Sheets to PowerPoint Presentation.mp4

5. Project Microsoft PowerPoint Export Excel Sheets to PowerPoint Presentation.vtt

6. Key Takeaways when Working with other Applications.html

ReadMe.txt

Visit Coursedrive.net.url

/.../16. Workbook and Worksheet Events/

1. Overview & What are Event Procedures.mp4

1. Overview & What are Event Procedures.vtt

1.1 S16_Events.xlsm.xlsm

1.2 S16_Events_Start.xlsx.xlsx

2. Workbook Events, Toggle Full Screen (Activate, Deactivate, Open, Close).mp4

2. Workbook Events, Toggle Full Screen (Activate, Deactivate, Open, Close).vtt

3. Worksheet Selection Change Dynamic Font Color of Selected Range.mp4

3. Worksheet Selection Change Dynamic Font Color of Selected Range.vtt

4. Refresh PivotTables Automatically & Concept of Range Intersection.mp4

4. Refresh PivotTables Automatically & Concept of Range Intersection.vtt

5. Resetting a Dependent Drop-down when the first Drop-down is Changed.mp4

5. Resetting a Dependent Drop-down when the first Drop-down is Changed.vtt

5.1 INDEX MATCH Basics video.html

6. Activity Link Page Header to Cell Value (BeforePrint Event).html

7. Project Link Page Header to Cell Value (BeforePrint Event).mp4

7. Project Link Page Header to Cell Value (BeforePrint Event).vtt

8. 2 Useful Tips when Working with Events & Key Takeaways.mp4

8. 2 Useful Tips when Working with Events & Key Takeaways.vtt

/.../17. Working with Userforms & ActiveX Controls/

1. Overivew UserForms & ActiveX Controls.mp4

1. Overivew UserForms & ActiveX Controls.vtt

1.1 S17_UserForms_ActiveX_Start.xlsx.xlsx

1.2 S17_PictureClip.zip.zip

1.3 S17_UserForms_ActiveX.xlsm.xlsm

2. ActiveX Controls What you Need to Know.mp4

2. ActiveX Controls What you Need to Know.vtt

3. ActiveX Check Box to Fix Scroll Area & Toggle Screen Settings.mp4

3. ActiveX Check Box to Fix Scroll Area & Toggle Screen Settings.vtt

4. ActiveX to Show and Hide Help.mp4

4. ActiveX to Show and Hide Help.vtt

5. ActiveX Combo Box for Easy Sheet Navigation (Great for Larger Workbooks).mp4

5. ActiveX Combo Box for Easy Sheet Navigation (Great for Larger Workbooks).vtt

6. ActiveX to Show or Hide Other ActiveX controls (eg. Actual & Budget reporting).mp4

6. ActiveX to Show or Hide Other ActiveX controls (eg. Actual & Budget reporting).vtt

7. UserForm Basics What You Need to Get Started.mp4

7. UserForm Basics What You Need to Get Started.vtt

8. UserForm for Data Entry (Input & Check Boxes).mp4

8. UserForm for Data Entry (Input & Check Boxes).vtt

9. UserForm to Document External Links & Comments (Combo Box & Option button).mp4

9. UserForm to Document External Links & Comments (Combo Box & Option button).vtt

10. UserForm Checklist & Course Map Status.html

/.../18. Main Project #3 Invoice Generation Tool/

1. Tool Overview What You Will Learn.mp4

1. Tool Overview What You Will Learn.vtt

2. Setting up an Input UserForm to Collect Master Data.mp4

2. Setting up an Input UserForm to Collect Master Data.vtt

2.1 Invoice_Generator_Start.xlsm.xlsm

3. Working with Multi-Column ListBoxes.mp4

3. Working with Multi-Column ListBoxes.vtt

4. Edit Master Data with UserForm.mp4

4. Edit Master Data with UserForm.vtt

5. Searchable ListBox (with Selection Change event).mp4

5. Searchable ListBox (with Selection Change event).vtt

6. Enhanced Searchable ListBox Write Selection back to Excel Table.mp4

6. Enhanced Searchable ListBox Write Selection back to Excel Table.vtt

7. MultiPage UserForm to Create Invoices & Email (Setup).mp4

7. MultiPage UserForm to Create Invoices & Email (Setup).vtt

8. Export PDF & Excel Workbook for Each Invoice based on ListBox Selection.mp4

8. Export PDF & Excel Workbook for Each Invoice based on ListBox Selection.vtt

9. Create Email in Outlook & Attach PDF Invoice.mp4

9. Create Email in Outlook & Attach PDF Invoice.vtt

10. Final Updates & Debugging.mp4

10. Final Updates & Debugging.vtt

10.1 Invoice_Generator.xlsm.xlsm

11. Last Milestone Completed!.html

/.../19. Create your own Custom Functions/

1. Section Overview Function Procedures.mp4

1. Section Overview Function Procedures.vtt

1.1 S19_FunctionProcedures.xlsm.xlsm

1.2 S19_FunctionProcedures_Start.xlsx.xlsx

2. Setting up a Simple Function (including Optional Arguments).mp4

2. Setting up a Simple Function (including Optional Arguments).vtt

3. Function to Calculate Age (Result in Years & Months).mp4

3. Function to Calculate Age (Result in Years & Months).vtt

4. Functions that Split Text and Numbers from Cell Value.mp4

4. Functions that Split Text and Numbers from Cell Value.vtt

5. Using Functions in Sub Procedures.mp4

5. Using Functions in Sub Procedures.vtt

6. Activity Function That Sums based on Cell Color.html

7. Project Function That Sums based on Cell Color.mp4

7. Project Function That Sums based on Cell Color.vtt

8. Key Takeaways Function Procedures in VBA & Course Map Status.html

/.../20. Working with Charts/

1. The Chart Object Library & Section Overview.mp4

1. The Chart Object Library & Section Overview.vtt

1.1 S20_Charts.xlsm.xlsm

1.2 S20_Charts_Start.xlsx.xlsx

2. Create and Modify a Chart with VBA.mp4

2. Create and Modify a Chart with VBA.vtt

3. Animated Charts Different Methods.mp4

3. Animated Charts Different Methods.vtt

4. Show Charts inside UserForms.mp4

4. Show Charts inside UserForms.vtt

5. Key Takeaways Charts.html

/.../21. Summary & Final Words/

1. Your Next Steps & more Learning.mp4

1. Your Next Steps & more Learning.vtt

2. BONUS Lecture More from Leila.html

ReadMe.txt

Visit Coursedrive.net.url

Total files 382