강의

멘토링

커뮤니티

Productivity

/

Task Automation

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.

(4.9) 22 reviews

184 learners

  • exceldesign
3시간 만에 완강할 수 있는 강의 ⏰
Excel
Business Productivity
VBA

Reviews from Early Learners

What you will gain after the course

  • 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
• Various 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 we are visiting for the first time?
Are you just walking without knowing your destination?

There will be an order to your actions to move effectively!



1. Open the map app
2. Select the transportation you want to use
3. After entering the destination
4. Take action by figuring out the route, time, etc.!

The same goes for developing macros with VBA. If you focus too much on grammar,
The code is also a mess and you will encounter numerous 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.

Lecture 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 example code is quite simple, as it clearly distills complex concepts into simple concepts.

Section Introduction

1. How to best configure VBE
= How to use multiple windows smartly

2. Which modules and macros can I use to implement my PG's logic?
= How to use hybrid macros

3. How should we structure our procedures to create an efficient one?
= 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 for debugging

8. How should we handle the inevitable errors that we encounter?

🛠 Tools covered here

Excel 2010 or later

🙋🏻‍♂️ QnA

Q. What are the benefits of taking the 'VBA Big Picture' course?
A. Is it possible to develop the Excel task you want to automate using VBA?
You will be able to decide which modules and 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

Hello
This is

9,114

Learners

355

Reviews

223

Answers

4.9

Rating

6

Courses

안녕하세요, 반갑습니다.

VBA 강사 및 개발자 배영자입니다.

유튜브 '엑셀디자인' 채널 운영 중.

Curriculum

All

9 lectures ∙ (2hr 57min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

22 reviews

4.9

22 reviews

  • junhyeongkim5912님의 프로필 이미지
    junhyeongkim5912

    Reviews 3

    Average Rating 3.7

    5

    44% enrolled

    • exceldesign
      Instructor

      Junhyung, thank you (✿◡‿◡) If you are not a professional VBA developer, just learn the essential VBA grammar, and get help from AI (Copilot, ChatGPT) to generate the code you need for your work. You will be able to automate data much more efficiently.

  • joinho10229613님의 프로필 이미지
    joinho10229613

    Reviews 9

    Average Rating 5.0

    5

    100% enrolled

    You did a good job of making the lecture easy to understand. I wish you had given more in-depth examples.

    • exceldesign
      Instructor

      Thank you for your good opinion, joinho1022 ♪(^∇^*)

  • bubble23473001님의 프로필 이미지
    bubble23473001

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    It helped a lot~!

    • exceldesign
      Instructor

      Keep growing You will become an Excel Data Scientist!!! Stay healthy. Hope you will

  • mkddp5754님의 프로필 이미지
    mkddp5754

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    thank you

    • exceldesign
      Instructor

      Thank you. Thank you for your hard work. I believe you will continue to grow. Hope you will

  • topswordk2512님의 프로필 이미지
    topswordk2512

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    This is so helpful. It's great for drawing the big picture of codes I already know piecemeal.

    • exceldesign
      Instructor

      If you add the help of AI, I think you will be able to create excellent macro results that are just as good as those of professional developers. Good luck (∩^o^)⊃━☆

Limited time deal

$2,502.00

29%

$22.00

exceldesign's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!