강의

멘토링

커뮤니티

Productivity

/

Task Automation

Data Automation (with VBA)

1. You may experience the side effect of thinking about VBA codes while sleeping. 2. You may become a workaholic by choice due to the desire to automate repetitive Excel tasks one by one.

(4.8) 52 reviews

5,456 learners

  • exceldesign
Excel
VBA
Thumbnail

Reviews from Early Learners

What you will learn!

  • 1. VBA grammar and detailed explanation for complete macros

  • 2. Development Know-how

  • 3. Various practical examples from the field

When it comes to VBA coding, seeing is believing!


🗒 Course Introduction

In the fall of 2018, I was completely engrossed in BTS World Tour videos.
Then one day,
While following the flow of thought, thinking, "Should I try making videos too? What am I good at?"
I wanted to continue my studies and share the many difficulties I encountered with VBA.
It was my first start producing videos.
If you study the curriculum in order and persevere, you will be able to automate most of the repetitive tasks.


🗒 Tools covered here

Excel 2010 or later

🗒 Expected questions related to the lecture

Q. Why should I learn VBA?
A. You don't have to learn it. It's your choice.
But there will come a time when you will get angry at yourself for doing copy-and-paste work.

Q. What are the benefits of learning VBA?
A. You can become an Excel Data Scientist who can handle Excel data as you wish.
Excel is rapidly evolving to become a Business Intelligence Platform.
Examples include PowerQuery, data modeling, relationships, and tables, which are built into the basic functionality.
However, it is still difficult to automate repetitive tasks at once.
VBA covers this.

Q. Are there any special advantages to this course?
A. I majored in law, not computer science.
I started from scratch with VBA.
I have been lecturing in corporate settings for a long time.
So, people who are studying VBA have difficulty with some parts,
We also have a keen insight into the 'Excel lifestyle' of office workers in the field.
These field experiences are well incorporated into thematic videos and organized in an easy-to-understand format.

Recommended for
these people

Who is this course right for?

  • 1. Office workers who are tired of doing repetitive tasks every time.

  • 2. Those who have been studying VBA for a long time but still cannot grasp VBA clearly.

  • 3. For those who don't know what else to study for efficient VBA coding

Need to know before starting?

  • Excel Intermediate

  • Beginner level knowledge of VBA

Hello
This is

9,020

Learners

347

Reviews

222

Answers

4.9

Rating

6

Courses

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

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

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

Curriculum

All

69 lectures ∙ (13hr 44min)

Published: 
Last updated: 

Reviews

All

52 reviews

4.8

52 reviews

  • harryoh님의 프로필 이미지
    harryoh

    Reviews 5

    Average Rating 4.8

    5

    45% enrolled

    I saw my father writing down the sales and status of his store by hand, so I created a management file that could be automated with Excel. I made it by searching Naver and making it by myself, but after watching this lecture, the magic happened where the code that was over 100 lines was reduced to 10 lines... It's really different from learning from YouTube, blogs, etc. step by step from the basics, so it's easy to understand and it's good to apply and use right away. I'm really grateful and recommend this lecture!

    • exceldesign
      Instructor

      Oh my~~~ This is the first time I've heard such a beautiful 'VBA story'. I haven't experienced it myself. I hope you continue to create beautiful macros that are considerate of your family and colleagues. Stay healthy~♡

  • junouo120291님의 프로필 이미지
    junouo120291

    Reviews 1

    Average Rating 5.0

    5

    42% enrolled

    This is a helpful lecture.

    • exceldesign
      Instructor

      You've watched the whole long video. You're amazing!!! You'll become a great Excel Data Scientist. Stay healthy ♡

  • hypark02112448님의 프로필 이미지
    hypark02112448

    Reviews 2

    Average Rating 5.0

    5

    100% enrolled

    It seems like it's easy to understand if you watch the video and follow along. It seems like a good way to build up the basics that you absolutely need to know.

    • exceldesign
      Instructor

      Thank you :D You will be a great Excel Data Scientist.

  • yeanabang3046님의 프로필 이미지
    yeanabang3046

    Reviews 1

    Average Rating 5.0

    5

    48% enrolled

    I am getting rid of my VBA blindness thanks to your class. Thank you for such a great lecture :-)

    • exceldesign
      Instructor

      I applaud yeanabang's patience in holding on persistently. Data collection > processing > analysis > visualization > automation... You will soon be reborn as a wonderful Excel Data Scientist who can freely handle data. ♡

  • sw7kim님의 프로필 이미지
    sw7kim

    Reviews 9

    Average Rating 5.0

    5

    100% enrolled

    It was a great opportunity to learn about Excel VBA in general. Thank you for the kind explanation.

    • exceldesign
      Instructor

      You have endured a long time of studying. You are amazing\^o^/

Free

exceldesign's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!