Your One Stop for Excel Tips & Solutions


 

 

MrExcel - Photos of MrExcel
Questions
About MrExcel
Consulting Services
Learn Excel Resources
Excel - Visual Learning
Challenge of the Month
MrExcel Seminars
Message Board
MrExcel Store
Learn Excel Blog
Search
Media
Contact
Home
Having an Excel Emergency?

MrExcel Quick Links

Read The Latest...

Learn Excel Blog   MrExcel on YouTube   Excel Daily News   Amazon MrExcel Books

Let's Connect

Twitter @MrExcel   Facebook MrExcel   LinkedIn Bill Jelen   Google+ Bill Jelen

LinkedIn - MrExcel.com   Google+ MrExcel.com   Facebook - Bill Jelen   Pinterest - Bill Jelen

GoodReads - Bill Jelen   About.Me Bill Jelen   RSS - MrExcel Forum Hot Topics   RSS - Learn Excel Blog

 

 


Click Add as Fan in top right
of our Facebook page

 

 

 
 
 

"Excel 2013 VBA", by Dr. Gerard M. Verschuuren

Dr. Gerard Verschuuren

Product Details
CD-ROM: Over 1200 Slides

CD: $99.99 USD

ISBN- 978-1-61547-031-0

Puchase This CD

Back

Excel 2013 VBA A Complete Course in Excel 2013


The "Excel 2013 VBA"  CD-ROM is not only an excellent learning tool to master VBA, but also a gold mine for very powerful and useful macros. The CD-ROM has more than 1200 PowerPoint slides that guide you through the learning process. In addition, it comes with Excel files for you to work on as well as files that have the VBA code all done.

 

 

"Excel VBA 2013", by Dr. Gerard M. Verschuuren

 

See the CD Content Table Here

 

"Excel VBA 2013", by Dr. Gerard M. Verschuuren

 

"Excel VBA 2013", by Dr. Gerard M. Verschuuren

 

 

Contents Table of CD:

 

  • Part 1: Basic Essentials

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: Formulas and Arrays

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: Buttons, Forms, and more

21. Importing and Exporting
22. Buttons, Bars, Menus
23. Application Events
24. User Forms
25. Data Entry + Mail Merge
26. Custom Classes
27. Class Collections
28. Error Handling
29. Distributing VBA code
30. VBA Monitoring VBA
 

Back to Top...

"Excel VBA 2013", by Dr. Gerard M. Verschuuren

 

"Excel VBA 2013", by Dr. Gerard M. Verschuuren

 

About the Author

Dr. Gerard Verschuuren Dr. Gerard M. Verschuuren is a Microsoft Certified Professional specialized in VB, VBA, and VB.NET. He is the author of many textbooks and has more than 20 years of experience in teaching at colleges and corporations. He holds master's degrees in Biology and in Philosophy, plus a Doctorate in the Philosophy of Science from Universities in Europe. He is author of VBScript 2013Excel 2007 VBA and Excel 2007 Expert .

 

Dr. Gerard Verschuuren

Product Details
CD-ROM: Over 1200 Slides

CD: $99.99 USD

ISBN- 978-1-61547-031-0

Puchase This CD

 

And be sure to check out other software training available at MrExcel.com - Click Here...

Back to Top...


There are over 150,000 pages at MrExcel.com
Use Google
to search our site:

 


The MrExcel Podcasts - The Latest on what YOU can do with Excel
 
Live Lessons with Bill Jelen a.k.a. MrExcel!
     
 

Excel is a registered trademark of the Microsoft® Corporation. ||  MrExcelTM is a registered trademark of Tickling Keys, Inc.
Holy Macro! BooksTM is a registered trademark of Tickling Keys, Inc.

All contents Copyright 1998-2014 by MrExcel Consulting | Domestic and International Copyright Applies | All Rights Reserved