Description

Excel VBA Class

The Excel VBA training teaches the strengths and weaknesses of recording macros, how to use and pass variables, if/then statements and loops like for/next and do/while. You will also learn how to call functions, how to write your own functions, how to use workbook events. No other school offers students access to a video library for you to review the class at your leisure!

The objectives of the Excel Visual Basic Applications Class include:

* Macros: Strengths and Weaknesses

* How to Debug and Fix Macros, How to Handle Errors

* How to use Variables and Arrays

* How to Write Programs With the Visual Basic Editor

* How to Use If/Then and For/Next Conditional Control Structures to Loop and Make Decisions

* How to Call Excel Functions and Write New Functions

* How to Call Excel Dialogs