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 collaborates with organizations to help implement and adopt technology to its maximum potential. From our change management consulting to our learning and development services, Intellezy uses both culture and education to drive the ROI of any organization. Our online videos and quick reference guides are designed to educate and empower individuals, right when they need it. In today’s rapidly evolving workplace, it is imperative to make sure you have the skills and expertise required to succeed. Our library, recognized by top influencers such as eLearning Journal and The Craig Weiss Group, provides dynamic and task-focused videos right at your fingertips, right when you need them.