Excel 2007 VBA

Name: Excel 2007 VBA
Rating: 4.4 (22 reviews)

Power up your workbooks with Visual Basic for Applications automation

(22 ratings)

192 students

Created by Intellezy Trainers

Last updated 10/2016

English

English [Auto]

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

Intellezy Trainers

Multi-Award-Winning eLearning Specialists

4.4 Instructor Rating
50,536 Reviews
180,357 Students
239 Courses

Intellezy collaborates with organizations to help implement and adopt technology to its full potential. Our online videos include 250+ courses designed to educate and empower individuals

Our library, recognized by top influencers such as The Craig Weiss Group, Training Industry and eLearning Journal, provides dynamic and task-focused videos, quick reference guides, and assessments right at your fingertips, right when you need them.

In today’s rapidly evolving workplace, it is imperative to make sure your team members have the skills and expertise required to succeed. Intellezy offers custom content development to ensure learning materials, and the delivery approach is aligned to meet intended outcomes and address your specific training needs without covering topics that may be unnecessary or irrelevant.