FILENAME | SIZE |  | 1. Getting Started/1. Introduction.mp4 | 22.7 MB |
 | 1. Getting Started/1. Introduction.vtt | 18.8 KB |
 | 1. Getting Started/1.1 What's New for VBA in Office 2016.html | 158 B |
 | 1. Getting Started/1.2 Getting Started with VBA in Office.html | 159 B |
 | 1. Getting Started/10. The Visual Basic Editor.mp4 | 15.9 MB |
 | 1. Getting Started/10. The Visual Basic Editor.vtt | 14.2 KB |
 | 1. Getting Started/10.1 MSDN - Use the Properties Window.html | 155 B |
 | 1. Getting Started/10.2 MSDN - Use the Project Explorer.html | 154 B |
 | 1. Getting Started/10.3 MSDN - Use the Immediate Window.html | 154 B |
 | 1. Getting Started/11. VBA Basics.html | 128 B |
 | 1. Getting Started/2. Download Course Materials.html | 1.1 KB |
 | 1. Getting Started/2.1 vba-course.zip.zip | 1.6 MB |
 | 1. Getting Started/3. Enable the Developer Tab.mp4 | 15.6 MB |
 | 1. Getting Started/3. Enable the Developer Tab.vtt | 10.5 KB |
 | 1. Getting Started/3.1 Office Support - Show the Developer tab.html | 161 B |
 | 1. Getting Started/4. Excel File Types.mp4 | 8.2 MB |
 | 1. Getting Started/4. Excel File Types.vtt | 5.9 KB |
 | 1. Getting Started/4.1 Office Support - File formats that are supported in Excel.html | 179 B |
 | 1. Getting Started/4.2 Wikipedia - List of Microsoft Office filename extensions.html | 135 B |
 | 1. Getting Started/5. Macro Security.mp4 | 17.3 MB |
 | 1. Getting Started/5. Macro Security.vtt | 13.6 KB |
 | 1. Getting Started/5.1 Office Support - Change macro security settings in Excel.html | 178 B |
 | 1. Getting Started/6. The Macro Recorder.mp4 | 28.5 MB |
 | 1. Getting Started/6. The Macro Recorder.vtt | 23.8 KB |
 | 1. Getting Started/6.1 Getting Started with VBA in Office - To record a macro.html | 177 B |
 | 1. Getting Started/7. Record Macro to Change Worksheet Orientation.html | 130 B |
 | 1. Getting Started/8. Absolute vs. Relative References I.mp4 | 15.4 MB |
 | 1. Getting Started/8. Absolute vs. Relative References I.vtt | 11.9 KB |
 | 1. Getting Started/8.1 Dummies.com - How to Record Macros in Relative Mode and Absolute Mode in Excel 2016.html | 186 B |
 | 1. Getting Started/9. Absolute vs. Relative References II.mp4 | 16.5 MB |
 | 1. Getting Started/9. Absolute vs. Relative References II.vtt | 11.6 KB |
 | 10. Conditionals/1. Boolean Expressions.mp4 | 10.4 MB |
 | 10. Conditionals/1. Boolean Expressions.vtt | 9.6 KB |
 | 10. Conditionals/2. Boolean Expressions.html | 128 B |
 | 10. Conditionals/3. The If Then Statement.mp4 | 6.9 MB |
 | 10. Conditionals/3. The If Then Statement.vtt | 6.1 KB |
 | 10. Conditionals/3.1 Article How to use the IF-THEN-ELSE Statement.html | 116 B |
 | 10. Conditionals/4. The ElseIf and Else Statements.mp4 | 20.4 MB |
 | 10. Conditionals/4. The ElseIf and Else Statements.vtt | 16.1 KB |
 | 10. Conditionals/4.1 Official MSDN Article on Using If...Then...Else Statements.html | 157 B |
 | 10. Conditionals/5. Select Case.mp4 | 20.7 MB |
 | 10. Conditionals/5. Select Case.vtt | 15.4 KB |
 | 10. Conditionals/5.1 Official MSDN Article on Using Select Case Statements.html | 158 B |
 | 10. Conditionals/6. The AND & OR Logical Operators.mp4 | 12.5 MB |
 | 10. Conditionals/6. The AND & OR Logical Operators.vtt | 10.2 KB |
 | 10. Conditionals/6.1 Official MSDN Reference on the OR Operator.html | 154 B |
 | 10. Conditionals/6.2 Official MSDN Reference on the AND Operator.html | 155 B |
 | 10. Conditionals/7. Logical Operators.html | 128 B |
 | 10. Conditionals/8. The NOT Operator.mp4 | 13.9 MB |
 | 10. Conditionals/8. The NOT Operator.vtt | 11.9 KB |
 | 10. Conditionals/8.1 Official MSDN Reference on the NOT Operator.html | 155 B |
 | 11. Iteration/1. The For Next Loop.mp4 | 25.9 MB |
 | 11. Iteration/1. The For Next Loop.vtt | 19.9 KB |
 | 11. Iteration/1.1 Official MSDN Article on Using For Next Statements.html | 154 B |
 | 11. Iteration/2. The Step Keyword.mp4 | 13.5 MB |
 | 11. Iteration/2. The Step Keyword.vtt | 10.5 KB |
 | 11. Iteration/3. Deleting Rows.mp4 | 16.1 MB |
 | 11. Iteration/3. Deleting Rows.vtt | 16.5 KB |
 | 11. Iteration/4. Fill Empty Rows.html | 130 B |
 | 11. Iteration/5. The For Each-Next Construct.mp4 | 14.8 MB |
 | 11. Iteration/5. The For Each-Next Construct.vtt | 11.1 KB |
 | 11. Iteration/5.1 Official MSDN Article on Using For Each Next Statements.html | 159 B |
 | 11. Iteration/6. Iterating over a Range of Cells with For Each.mp4 | 10.5 MB |
 | 11. Iteration/6. Iterating over a Range of Cells with For Each.vtt | 9.9 KB |
 | 11. Iteration/7. The With-End With Construct.mp4 | 10.8 MB |
 | 11. Iteration/7. The With-End With Construct.vtt | 10.5 KB |
 | 11. Iteration/7.1 Official MSDN Article on Using With Statements.html | 151 B |
 | 11. Iteration/8. Exit For and Review of Exit Sub.mp4 | 19.5 MB |
 | 11. Iteration/8. Exit For and Review of Exit Sub.vtt | 18.5 KB |
 | 11. Iteration/8.1 Official MSDN Reference on the Exit Statement.html | 158 B |
 | 11. Iteration/9. Iteration.html | 128 B |
 | 12. Miscellaneous Features/1. The MsgBox Method In Depth, Part I.mp4 | 44 MB |
 | 12. Miscellaneous Features/1. The MsgBox Method In Depth, Part I.vtt | 13 KB |
 | 12. Miscellaneous Features/1.1 Official Visual Basic for Applications Reference for the MsgBox Function.html | 157 B |
 | 12. Miscellaneous Features/2. The MsgBox Method In Depth, Part II.mp4 | 49.5 MB |
 | 12. Miscellaneous Features/2. The MsgBox Method In Depth, Part II.vtt | 11.6 KB |
 | 12. Miscellaneous Features/3. MsgBox Options.html | 1.1 KB |
 | 12. Miscellaneous Features/4. StatusBar.mp4 | 36.6 MB |
 | 12. Miscellaneous Features/4. StatusBar.vtt | 9.7 KB |
 | 12. Miscellaneous Features/4.1 Official MSDN Documentation for the Application.StatusBar Property.html | 153 B |
 | 12. Miscellaneous Features/5. The Application.ScreenUpdating Property.mp4 | 6.2 MB |
 | 12. Miscellaneous Features/5. The Application.ScreenUpdating Property.vtt | 6.4 KB |
 | 12. Miscellaneous Features/5.1 Official MSDN Documentation for the Application.ScreenUpdating Property.html | 158 B |
 | 12. Miscellaneous Features/6. SpecialCells.mp4 | 8.3 MB |
 | 12. Miscellaneous Features/6. SpecialCells.vtt | 8.5 KB |
 | 12. Miscellaneous Features/6.1 Official MSDN Documentation for the Range.SpecialCells Method.html | 148 B |
 | 12. Miscellaneous Features/7. The InputBox Function.mp4 | 12.3 MB |
 | 12. Miscellaneous Features/7. The InputBox Function.vtt | 14.1 KB |
 | 12. Miscellaneous Features/8. The Application.InputBox Method.mp4 | 14.5 MB |
 | 12. Miscellaneous Features/8. The Application.InputBox Method.vtt | 14.2 KB |
 | 12. Miscellaneous Features/8.1 Official MSDN Documentation for the Application.InputBox Method.html | 150 B |
 | 13. Arrays/1. Intro to Arrays.mp4 | 8 MB |
 | 13. Arrays/1. Intro to Arrays.vtt | 10 KB |
 | 13. Arrays/1.1 Official MSDN Article on Using Arrays.html | 142 B |
 | 13. Arrays/1.2 Official MSDN Article on Declaring Arrays.html | 146 B |
 | 13. Arrays/2. Alternate Syntax for Fixed-Size Arrays.mp4 | 6.1 MB |
 | 13. Arrays/2. Alternate Syntax for Fixed-Size Arrays.vtt | 7.4 KB |
 | 13. Arrays/3. The Option Base 1 Syntax and Write Array Values to Cells.mp4 | 6.3 MB |
 | 13. Arrays/3. The Option Base 1 Syntax and Write Array Values to Cells.vtt | 6.5 KB |