Excel 2007 VBA
What you'll learn
- Understand the object model
- Create, edit and run recorded macros
- Understand the Visual Basic editor
- Understand programming basics
- Use Visual Basic functions
- Create and use cotnrol structures
- Create, use and edit UserForms
- Debug macros and trap for errors
Requirements
- Intermediate Microsoft Excel training or equivalent experience
Description
This course introduces you to Excel macro programming using Microsoft's Visual Basic for Application (VBA). The overall focus of this course is to teach you proper Visual Basic programming techniques along with an understanding of Excel's object structure. Other topics in this course include; recording macros, programming basics, proper variable declaration, Visual Basic functions, control structure use, looping, and Userform creation. The final section deals with the debugging tools included in the Microsoft VBA editor and methods on how to effectively use them.
Who this course is for:
- Intermediate and Advanced level users of Excel who need to automate worksheets and workbooks
Course content
- Preview02:43
Instructor
![Intellezy Trainers](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.4 Instructor Rating
- 39,585 Reviews
- 149,917 Students
- 226 Courses
At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.