All photography provided by Shutterstock
COURSE INFO:
Like any course, the material below is meant to build on previous concepts as the videos progress in difficulty. Find the pace that best suits you by speeding up or slowing down the videos.
If you have already dabbled in VBA I would still recommend watching the syntax videos to ensure you have a full understanding of how the language works. If a video doesn't have a hyperlink, the video is in progress so please be sure to check back soon.
Video Topic List:
- Welcome video!
- First time setup, the Developer Tab
- Recording and Running Code
- Syntax part 1: VBA Sentence Structure [download file]
- Syntax part 2: Objects vs Data types and Declaring Variables [download file]
- Syntax part 3: Methods and WorksheetFunctions
- Option Explicit
- Navigating the VBA Editor
- Find the last row and define the size of your data
- Construct a loop [download file]
- Infinite loops and how to get out of them
- IF, AND, OR statements [download file]
- Nested statements [download file]
- Error Handling and Debugging (Watch, Immediate and Locals windows) [download file]
- Setup the User Interface [download file]
- Formulas and Methods: Vlookup, Sumifs, Find
- String searching and manipulation
- Import external data to your workbook [download file]
- Name manager and dynamic lists
- Sorting data
- Filtering data
- Applying protection
- Building a function
- Input boxes and message boxes
- User forms
- Arrays (lists)
- How to speed up your code
“Do or do not. There is no try”