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 VBA! This training got
me up to speed!"

Slide Your Way Through Excel VBA

Unleash the Power of Excel 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 Join the Excellers League and Excel for Scientists.

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 775 slides.

Module 1 - Basics of Excel VBA (233 slides)
  • Objects: Their properties and methods.
  • Recording Macros + Editing their code
  • Controlling code with If and Select
  • Methods vs. Functions
  • Use Message Boxes and Input boxes
  • Using Variables for values and objects
  • Controlling Charts and Pivot Tables.

Module 2 - How to Calculate with Excel VBA (273 slides)
  • Loops: Do / For / For Each
  • Manipulating cells and ranges
  • Using Functions in VBA Code
  • Using relative and absolute formulas
  • Using temporary arrays
  • Using array functions
  • Creating your own functions

Module 3 - Let VBA Interact with the User (269 slides)
  • Buttons
  • List Boxes
  • Combo Boxes
  • Creating User-Forms for User Interaction
  • Data Validation: Checking the user's data entry
  • Creating Custom Methods
  • More on Events: Having things done at the right moment
  • Error Handling: Making your application more professional.


Click here to order the CD!
Product Details
CD-ROM: 775 Pages;
System Requirements: PowerPoint 97 or later for self-tests; Excel 2003 or earlier
(For Excel 2007 VBA training DVD - Check out Excel 2007 VBA)
Publisher: Holy Macro! Books; ISBN 0-9724258-6-1
Price: $99

If installing in Vista, read this note.


Click here to order the CD!

Order
You can buy the complete course for $99 or any one module for $65.
Module 1 - Basics for $65
Module 2 - Calculate for $65
Module 3 - Interact for $65
Complete Course - $99

 

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.