A complete course in Excel VBA! This CD contains all 3 Modules of the self-paced Excel VBA Training by Dr. Gerard Verschuuren. It is completely visualized and is based on self-instruction with constantly recurring self-checks. The examples used are rooted in a wealth of real-life cases and have been extensively tested. Requires Windows - not compatible with Macintosh
For versions of Excel 2003 and earlier. For Excel 2007 VBA training - Check out the Excel 2007 VBA DVD!
There are 775 slides on the CD. You will love this CD and the easy method for learning Excel VBA:
- It is completely visualized and contains as little text as possible.
- It is based on self-instruction with constantly recurring self-checks.
- The examples used are rooted in a wealth of real-life cases.
- The material has been extensively tested during live training sessions.
- It has been widely praised as a very fine piece of curriculum development.
Look at all you will learn with this CD:
Basics of Excel VBA:
- 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.
How to Calculate with VBA:
- 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
Let VBA interact with the User
- 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.
This complete course is equivalent to a five-day instructor-led training course. Note: PowerPoint is required to view this course. PowerPoint 2000 or later with macros enabled is required for the self-tests.
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!
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.