VBA for Excel

In this VBA for Excel training course, you will learn how to apply the VBA programming language to make your Excel spreadsheets much more powerful. Seasoned Microsoft trainer Guy Vaccaro starts you out with the basics of VB programming, and teaches you to use it to its fullest potential within Excel. Guy extends your knowledge past editing odd Macro, directly into creating custom scripts using the VBA Programming Language.

This tutorial will teach you about VBA structures, the difference between Functions and Subroutines, how to manipulate Excel Cells, interacting with the user and very importantly, error handling. Designed for the beginner, you do not have to be a programmer already to understand, and implement what you will learn in this software training course. By the conclusion of this Visual Basic for Excel training course, you will be familiar with the VBA programming language, as it applies to Microsoft Excel.

You will be able to apply this knowledge to make interactive and fully functional spreadsheets. Working files are included to let you work alongside the author as you learn VBA for Microsoft Excel in this video tutorial.

Contents Include:

1. Getting Started
2. Macros
3. Procedures And Functions
4. Getting Started With VBA Programming
5. Manipulating Excel Objects
6. Working With Excel VBA Functions
7. Controlling Program Flow And Execution
8. Events
9. Debugging And Error Handling
10. Interacting With Users Through Forms
11. Running And Storing VBA Code
12. Summary