 |
 |
| About MrExcel |
| Consulting Services |
| Learn Excel Resources |
| Challenge of the Month |
| MrExcel Seminars |
| MrExcel Store |
| Podcast |
| Search |
| Media |
| Contact |
| Home |
 |
|
|||
Excel 2007 VBA (Visual Training series) (CD-ROM)
Unleash the Power of Excel 2007 VBAVBA 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
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
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
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 If installing in Vista, read this note.
|
