Loading...

Course Description

Learn how to utilize Visual Basic for Application and how to construct programs with Excel in order to automate repetitive jobs or complex operations.

Related Courses

Who Should Attend

Individuals looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, anyone who already has knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Prerequisites

Proficient knowledge of Excel.

Attend and You Will Learn / Expected Outcome

Attend And You Will Learn

Introducing Visual Basic for Applications

  • Recording a macro
  • Running a macro
  • Understanding the VB editor
  • Using the menu bar
  • Using the standard toolbar
  • Using the Project Explorer
  • Using the properties window
  • Understanding the code window
  • Understanding the code window options
  • Editing code
  • Closing the visual basic editor

Introducing Objects

  • Understanding the object browser
  • Understanding objects
  • Understanding the object hierarchy
  • Referencing objects
  • Understanding collections
  • Using the Editing features
  • Using the immediate window
  • Using the auto list
  • Using auto quick info

Introducing Variables

  • Understanding variables
  • Declaring variables
  • Understanding data types
  • Storing values in variables
  • Storing objects in variables

Creating Procedures and Functions

  • Understanding procedures
  • Using the Macro Recorder to create sub procedures
  • Calling procedures from procedures
  • Using intrinsic functions
  • Using message boxes
  • Using input boxes
  • Creating functions
  • Passing arguments to a function

Working with Conditional Statements

  • Understanding conditional statement
  • Working with decision structures
  • Working with looping structures

Creating Applications

  • Useful commands for automation
  • Techniques and tips
  • Directing user action
  • Message box and input box
  • Conditional branching
  • Do loops

Debugging Your Application

  • Understanding errors
  • Debugging code
  • Debugging tools
  • Using the locals window
  • Using the watch window
  • Using breakpoints

Instructors

Loading...

Enroll Now - Select a section to enroll in

Section Title
Excel Programming
Type
In-Class
Days
T, W, Th
Time
9:00AM to 4:30PM
Dates
Apr 28, 2020 to Apr 29, 2020
Schedule and Location
Contact Hours
12.0
Location
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $545.00
Instructors