Excel 2007 VBA

January 2008

I can't believe what you can do with Excel 2007 VBA! This training got me up to speed!

Unleash the Power of Excel 2007 VBA

VBA is the macro language packaged with every version of Excel since 1995. Using VBA macros, you can do everything from automating redundant tasks for your own use to developing full applications for your co-workers. Even if you took a programming class 10 years ago, Excel VBA seems tough to learn. It is not like the BASIC you are used to. The recorded macros rarely work the way you want them to. This course, developed by college professor Dr. Gerard Verschuuren is the answer. He is author of Excel 2007 Expert and Excel 2007 for Scientists.

Developed and tested for business training, this CD-ROM is ideally suited for self-instruction using a screen shot approach versus an overabundance of text. More than 1,400 slides, with examples drawn from actual cases, are divided into three modules covering VBA basics, how to calculate with VBA, and letting VBA interact with the user.

Completely Visualized!

Learn Excel VBA in full color. Every slide has rich illustrations to demonstrate the concept.

Self-Paced with Self-Checks!

Click through the slides at your own pace. Every few slides, there will be a multiple choice question to ensure you've mastered recent concepts. These are the same concepts taught during Dr. Verschurren's Excel Seminars. He has taught Excel to 1000's of people. The next best thing to flying to New Hampshire or Massachusetts for the course, it to buy this CD!

Real World Examples

The examples used during the course are worth the cost of the course alone. Learn how to automate annoying Excel tasks in the process of taking the course.

Look at everything you will learn!

You get three complete modules on the CD covering 1,400 slides.

• Part 1

  1. Object Oriented
  2. Recording Macros
  3. Branch Statements
  4. Interaction
  5. Variables (Value Type)
  6. Variables (Object Type)
  7. Collections
  8. Loop Statements
  9. Variables as Arguments
  10. Pivot Tables and Charts

• Part 2

  11. Dates and Calendars
  12. The Current-Region
  13. Property WorksheetFunction
  14. Property Formula
  15. Property FormulaR1C1
  16. Custom Functions
  17. Array Functions
  18. 1D- and 2D-Arrays
  19. Customized Arrays
  20. Variant Arrays

• Part 3

  21. Importing and Exporting
  22. Buttons, Bars, Menus
  23. Application Events
  24. User Forms
  25. Custom Classes
  26. Class Collections
  27. Error Handling
  28. Recycling VBA code
  29. API and DLLs
  30. Digital Signatures