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.
Overview
COURSE DIFFICULTY
COURSE DURATION
5h
Skills Learned
After completing this online training course, students will be able to:
Getting Started with VBA
Working with Variables
Working with Conditional Logic
Working with Strings and String Functions
Working with Loops
Working with Sub Procedures Options and Functions
Working with User Forms
Debugging your Code
Students who’d like to learn more about how to utilize Visual Basic techniques with Excel’s object structure.
Excel and VBA familiarity
01. Excel 365 VBA
- Introduction , Getting Started with VBA
- Working with Variables
- Working with Conditional Logic
- Working with Strings and String Functions
- Working with Loops
- Working with Sub Procedures Options and Functions
- Working with User Forms
- Debugging your Code
- Conclusion
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Getting Started with VBA
Working with Variables
Working with Conditional Logic
Working with Strings and String Functions
Working with Loops
Working with Sub Procedures Options and Functions
Working with User Forms
Debugging your Code
WHO SHOULD ATTEND
Students who’d like to learn more about how to utilize Visual Basic techniques with Excel’s object structure.
PREREQUISITES
Excel and VBA familiarity
COURSE OUTLINE
01. Excel 365 VBA
- Introduction , Getting Started with VBA
- Working with Variables
- Working with Conditional Logic
- Working with Strings and String Functions
- Working with Loops
- Working with Sub Procedures Options and Functions
- Working with User Forms
- Debugging your Code
- Conclusion
