Excel 365 VBA
Advanced
5h
By: Andy Altaner
Overview
This course will teach students proper Visual Basic programming techniques along with an understanding of Excel’s object structure. Students will learn how to work with variables, how to use various conditional logic statements such as If and Else, and how to work with string functions. Students will also learn how to work with various loops such as next loops and each loops, as well as how to create user forms. Finally, students will get an in-depth understanding of the debugging tools available and how to effectively debug their code.
Modules
1. Introduction
1.1 Excel 365 VBA Introduction3 min
2. Getting Started with VBA
2.1 Adding the Developer Toolbar5 min
2.2 Understanding the VBA Editor11 min
2.3 Recording a Macro in Personal10 min
2.4 Understanding the Elements of the VBA Language7 min
2.5 Understanding Methods5 min
2.6 Understanding Comments6 min
2.7 Working with the Range Property and Worksheet Object7 min
2.8 Adding a Macro Button to a Spreadsheet3 min
2.9 Working with the ActiveCell Object2 min
2.10 Working with the Offset Property8 min
3. Working with Variables
3.1 Understanding Variables7 min
3.2 Working with Integer Variables3 min
3.3 Understanding Option Explicit5 min
3.4 Working with Other Variable Types7 min
4. Working with Conditional Logic
4.1 Working with IF Statements4 min
4.2 Working with ELSE3 min
4.3 Working with ELSEIF3 min
4.4 Understanding Conditional Operators6 min
4.5 Working with NOT, AND, and OR7 min
4.6 Working with Nested IF4 min
4.7 Working with Select Case6 min
4.8 Working with WITH and END WITH5 min
5. Working with Strings and String Functions
5.1 Working with Text Strings5 min
5.2 Working with LCASE and UCASE Functions5 min
5.3 Working with LEN and TRIM Functions7 min
5.4 Working with LEFT, RIGHT, and MID Functions7 min
6. Working with Loops
6.1 Understanding Loops2 min
6.2 Working with For Next Loops7 min
6.3 Working with For Each Loops6 min
6.4 Working with Cells Property8 min
6.5 Working with Do Until Loops9 min
6.6 Working with Do While Loops5 min
7. Working with Sub Procedures Options and Functions
7.1 Calling Sub Procedures5 min
7.2 Working with Exit Sub4 min
7.3 Working with Message Boxes8 min
7.4 Working with Input Boxes8 min
7.5 Working with VBA Functions12 min
7.6 Working with Object Variable and Set6 min
8. Working with User Forms
8.1 Understanding and Creating a User Form8 min
8.2 Adding Controls to a User Form16 min
8.3 Adding Code for a User Form10 min
8.4 Launching a User Form from Excel5 min
9. Debugging Your Code
9.1 Getting Started with Debugging10 min
9.2 Stepping Through Your Code6 min
9.3 Working with Breakpoints3 min
9.4 Working with the Immediate Window5 min
9.5 Working with the Locals Window5 min
9.6 Working with the Err Object6 min
10. Conclusion
10.1 Excel 365 VBA Recap2 min
Ready to Elevate Your Team's Learning?
Talk with our sales team to see how StormWind can transform the way your organization trains and grows.
CONTACT SALES