Microsoft Excel 2003, 2007 and 2010
For Beginners and Intermediates
|
This self-paced training CD contains 13 practical and easy to understand modules. Each module is standalone, so you can learn only the topics you choose and in the order you wish. Included are dozens and videos, practice questions, and comprehensive exercises to test your knowledge. |
|
CD & Online Access $69 |
Online Access Only $64 |
| Please contact us if you have any questions. | |
Create your own applications in Excel
VBA (Visual Basic for Applications) is the programming language for Excel. By mastering it, you will be able to automate routine tasks, manage databases, and interact with users (userforms, dialog boxes)... In short, you will push the limits of Excel!
The syllabus is built on 13 standalone modules that allow you to progress at your own pace and in the areas that interest you the most:
|
• Introduction • Your First Macro • Visual Basic Editor • Excel Programming Basics 1 • Excel Programming Basics 2 • Program Structures – Loops • Program Structures – Conditional & Logical Operators |
• User Interactions – Basic Message Boxes • User Interactions – UserForms (1) • User Interactions – UserForms (2) • User Interactions – UserForms (3) • Error Handling & Debugging • Overview of Intermediate & Advanced Techniques |
In total, dozens of videos and exercises with complete solutions illustrate the concepts of each module.
Finally, 7 summary exercises will validate the knowledge you acquired in the chapters studied.
Don't wait, customize Excel to your needs and develop your own tools by designing them yourself!
Testimonials
"Honestly? I am a fan! A clear and pleasant interface whose you can even change the colors! Easy navigation. But of course, all this is merely incidental. Because the most important thing is the instruction and concerning this, hats off Gaetan!
"Lessons are well-structured, progressive and... clear! It includes the famous animations (always meaningful) that made the success of Polykromy as well as numerous videos. Of course, written explanations are also available. In short, you can choose your mode of learning ... You can even test your progress thanks to the proposed solution and compare it to your own.
"What more can you ask for? Nothing because even the paintings beautifully illustrate each lesson."
From Top Assistante - a site dedicated to improving the knowledge of assistants and secretaries
------
"Here is a copy of the email I sent to G.Mourmant after testing his CD:
Well what Gaetan, work!
This is simply an awesome training CD.
Great in every sense:"It starts off at a level for beginners who will finally be able to discover the potential of VBA through videos and be carried away by a voice that explains things so simply and clearly. And then there are things that could be considered as details but which makes the interactive training tool so strong:
"- The interactive table of contents
- The table of procedures
..."All of which simplify non-linear learning and will allow a user to use this CD every day.
I'm am even going test your CD on those around me who know nothing about VBA but have good command of Excel and see what happens! 😉"In any event, I strongly believe in this CD.
Have you sent this to any PC magazine, SVM, etc. ...
I really think that you should!
Congratulations again for this beautiful BB!"
From Excel Downloads - a site specializing in Excel applications.
Course Summary
Click the link below to view the course syllabus.
