Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
4 Hour(s) 14 Minute(s)
Language
English
Taught by
Intellezy Trainers
Rating
Course Overview
Power up your workbooks with Visual Basic for Applications automation
This course introduces you to Excel macro programming using Microsoft's Visual Basic for Application (VBA). The overall focus of this course is to teach you proper Visual Basic programming techniques along with an understanding of Excel's object structure. Other topics in this course include; recording macros, programming basics, proper variable declaration, Visual Basic functions, 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.
Course Content
- 10 section(s)
- 47 lecture(s)
- Section 1 Introduction
- Section 2 Understanding the Excel Object Model
- Section 3 Creating Recorded Macros
- Section 4 Understanding the Visual Basic Editor
- Section 5 Understanding Programming Basics
- Section 6 Using Visual Basic Functions
- Section 7 Working with Control Structures
- Section 8 Creating UserForms
- Section 9 Debugging your Macros
- Section 10 Conclusion
What You’ll Learn
- Understand the object model
- Create, edit and run recorded macros
- Understand the Visual Basic editor
- Understand programming basics
- Use Visual Basic functions
- Create and use cotnrol structures
- Create, use and edit UserForms
- Debug macros and trap for errors
Skills covered in this course
Reviews
-
HHeli Balassiano
i think that its very clear and help me very much to learn what i planed to learn. thanks a lot i like it:)
-
JJan E
Very clear instructions. Instructor never use any filler words or say anything that is not on topic ... Hope it continues like this
-
GGergely Kocsis
Everything was clear, I got all the explanations in every lesson. Maybe the only thing I miss is the downloadable content per lessons, e.g. a text file which contains the macro which is being presented. But it may not do things faster. Thank you.
-
WWomberbat
Good video, very easy to follow along
