Excel 365 VBA: Expert

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. This course has an assessment which may be required for a certificate to be generated. This course aligns with the CAP Body of Knowledge and should be approved for 5 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.

Learning objectives:

• Get started with VBA
• Work with variables
• Work with strings and string functions
• Work with loops
• Work with sub procedures options and functions
• Work with user forms
• Debug your code