Back

About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store
Podcast
Search
Media
Contact
Home

 

 


Click here to order the CD!

 

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

Excel 2007 VBA (Visual Training series) (CD-ROM)

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!


Click here to order the 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


Click here to order the CD!

Product Details
CD-ROM: 1,400 slides
System Requirements: PowerPoint 2007 or later for self-tests
Publisher: Holy Macro! Books; Cdr edition (June 1, 2008)
ISBN-10: 1932802339
ISBN-13: 978-1932802337
Price: $99

If installing in Vista, read this note.

Click here to order the CD!


 

Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

All contents Copyright 1998-2008 by MrExcel Consulting.