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 loop, 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.

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

  1. 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