August 2019
Intermediate
17h 19m
English
Closed Captioning available in English
Overview
In this comprehensive 17-hour course, you will delve into the world of Excel VBA programming. Starting from the basics and progressing to advanced topics, this course teaches you to harness the power of VBA for automating repetitive tasks and mastering Excel's Object Model to develop efficient macros.
What I will be able to do after this course
- Understand and apply the basics of VBA programming to automate repetitive Excel tasks.
- Master the use of the Excel Object Model to interact programmatically with Excel elements.
- Develop the skills to create custom functions and user forms for more advanced solutions.
- Leverage conditional logic and iteration to create robust automated workflows.
- Gain proficiency in debugging VBA code and identifying solutions to complex problems.
Course Instructor(s)
Boris Paskhaver, an experienced Excel VBA developer and educator, has been teaching professionals to optimize their Excel workflows for years. His teaching philosophy emphasizes understanding core concepts thoroughly, illustrated with practical examples, helping students of all levels to succeed.
Who is it for?
This course is ideal for business analysts seeking to eliminate repetitive Excel tasks, skilled spreadsheet users wanting to unlock the potential of VBA, and individuals looking to explore programming within a trusted application environment.