VBA Big Picture
This is not a course focused on VBA grammar. This is a course that will help you understand the entire structure of VBA at a glance.
This course is prepared for Basic Learners.
What you will learn!
1. Procedures can be structured efficiently.
2. You can learn skills that can increase processing speed.
3. Error handling
4. I can draw a picture of what modules and macros I can use to create the automation pg I want.
• Automation of daily repetitive tasks
• A variety of skills that can increase productivity
• Efficient handling of complex modifications
• How to reduce overtime and leave work on time
Learn how to create macros with an efficient structure by organizing VBA concepts through practice.
Why should I learn?
What do we do when we go to a place for the first time?
Are you just moving forward without even knowing your destination?
There will be an order to your actions to move from place to place effectively!
1. Open the map app
2. Choose the transportation you want to use
3. After entering the destination
4. Figure out the route, time, etc. and take action!
The same goes for developing macros with VBA. If you focus too much on grammar while developing,
The code is a mess and you'll encounter a lot of errors. 
Therefore, this course will teach you concepts and methods that can efficiently structure VBA that you have never encountered before.
What you will learn in this course
I can now see at a glance which modules and macros can be used to create the automation program I want to develop.
Course Features
1. You can learn easily using examples even if you don't know basic grammar.
2. You can practice and learn through simple and easy examples. The code of the example is quite simple. This is because the complex is clearly melted into simplicity.
Section Introduction
1. How to set up the best VBE environment
= How to use multiple windows smartly
2. Which modules and macros can I use to write my PG logic?
= How to use hybrid macros
3. How should we structure our procedures to make them efficient?
= Data type in declaration
4. 10 ways to increase processing speed
5. Understanding and applying arrays and new collections that boast fast processing
6. Should I use the phrase 'Option Base 1' or not?
7. Essential skills when debugging
8. How to deal with errors that are bound to occur?
🛠 Tools covered here
Excel 2010 or later
🙋🏻♂️ QnA
Q. What are the benefits of taking 'VBA Big Picture'?
A. Is it possible to develop the Excel task you want to automate using VBA?
You will have to decide which modules and which macros to develop.
Also, during development, how can we structure it efficiently,
You can learn what coding skills can help you increase your processing speed.
Additionally, skills for handling errors are clearly outlined.
Recommended for
these people!
Who is this course right for?
1. Those who studied VBA on their own
2. For those who are starting to study VBA
3. Those who are not sure about the overall structure of VBA
Need to know before starting?
Introduction to VBA
8,342
Students
313
Reviews
210
Answers
4.8
Rating
6
Courses
안녕하세요, 반갑습니다.
VBA 강사 및 개발자 배영자입니다.
유튜브 '엑셀디자인' 채널 운영 중.
Curriculum
All
9 lectures ∙ (2hr 57min)
Course Materials: