Learn VBA and Macros For MS Excel Video Tutorial DVD

 
 Duration: 7 Hours, 50 Min



Table of Contents: 

Part 1: Recording Macros 
Lesson 1: Enable Developer Tab & Adjust Macro Security 
Lesson 2: Recording your first macro 
Lesson 3: Running a Macro 
Lesson 4: Using Relative References 
Lesson 5: Dealing with a variable number of rows 
Lesson 6 : Never use AutoSum 
Lesson 7: Saving & Later Opening a Macro: Trust Center Settings 

Part 2: The VBA Editor 
Lesson 8: The by Project Explorer, Code Pane, and Properties Window 
Lesson 9: VBA Help 
Lesson 10: The Object Browser 
Lesson 11: Debugging Tools - Step through below code 
Lesson 12: The Immediate Pane 
Lesson 13: The Watch Window 
Lesson 14: Debugging Tools - Breakpoints 

Part 3: VBA Parts of Speech 
Lesson 15: Soccer Analogy 
Lesson 16: Regular Variables 
Lesson 17: Object Variables 
Lesson 18: Better Ways to Refer to Cells 
Lesson 19: Declaring Variables & Scope 

Part 4: Making Decisions 
Lesson 20: Simple If Then 
Lesson 21: If Then Else 
Lesson 22: Case Select 

Part 5: Looping 
Lesson 23: Find the last row in the data set today 
Lesson 24: The basic For-Next Loop 
Lesson 25: Typical Loop Example 
Lesson 26: Loops when you have to delete 
Lesson 27: Loops to do every other row 
Lesson 28: Other loops like While, Do, etc 
Lesson 29: The VBA Loop: For Each 

Part 6: Dealing with Multiple Worksheets & Workbooks 
Lesson 30: Creating new Worksheets 
Lesson 31: Creating new workbooks 
Lesson 32: Looping through all files in a folder 
Lesson 33: Combining All Files in a Folder 

Part 7: Formulas and VBA 
Lesson 34: Entering Formulas in a Worksheet - A1 
Lesson 35: Entering Formulas in a Worksheet - R1C1 
Lesson 36: Using an Excel Function in your Code 
Lesson 37: Creating a User Defined Function 

Part 8: Power Tools 
Lesson 38: Advanced Filter 
Lesson 39 : Filter instead of Looping 
Lesson 40: Pivot Tables 
Lesson 41: Charts Lesson 42: Event Handler Macros 

Part 9: Interacting 
Lesson 43: Interacting Msgbox, Statusbar, InputBox 
Lesson 44: GetOpenFileName, GetSaveAsFileName 
Lesson 45: Userforms Lesson 46: Error Handling 
Lesson 47 : Application.Displayalerts 
Lesson 48: Application.ScreenUpdating 

Part 10: Best Practices 
Lesson 49: Two-System Workbook: Code and Data Workbook Workbook 
Lesson 50: Cleaning up Recorded Code