Course Information
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Course Overview
This course introduces the user to Excel 2010 macro programming using Microsoft’s Visual Basic for Application (VBA).
The overall focus of this course is to teach the user proper Visual Basic programming techniques along with an understanding of Excel’s object structure. Other topics in this course include; proper variable declaration, control structure use, looping, and Userform creation. The final section deals with the debugging tools included in the Microsoft VBA editor and methods on how to effectively use them.
With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs.
Like most of our courses, closed caption subtitles are available for this course in: Arabic, English, Simplified Chinese, German, Russian, Portuguese (Brazil), Japanese, Spanish (Latin America), Hindi, and French.
Course Content
- 8 section(s)
- 31 lecture(s)
- Section 1 Introduction
- Section 2 Macro Development Basics
- Section 3 VBA Programming Fundamentals
- Section 4 Working with Control Structures
- Section 5 Using VBA Functions
- Section 6 Creating UserForms
- Section 7 Debugging Techniques
- Section 8 Conclusion
What You’ll Learn
- This course will introduces the user to Excel 2010 macro programming using Microsoft’s Visual Basic for Application (VBA)
Skills covered in this course
Reviews
-
PPaolo Chilosi
up to now good experience, the teacher has good pace and very clear pronunciation. and I confirm my judgment
-
BBhushan Gosavi
Yes, this is a very detailed and versatile beginners course. All the notes are pointed out in a very professional and easy to understand manner. Thank you for all your efforts to build this course.
-
AAna Fernandez Pablo
The explanations are really clear and you can learn a lot through the course. However it would be great if we could put in practice all the knowledge. I would rate the course 5 stars if it includes exercises to ensure that everything is understood.
-
DDavid Grubaugh
Would like to have the code he is referencing in the course.