本物の現業で使われる会社員の実務エクセル - データ加工から分析まで
엑셀디자인
現在、エクセルの最もトレンディな方法でデータを効率的、科学的に加工、分析するのに「標準」となるプロセスです。
중급이상
Excel, MS-Office
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.
Reviews from Early 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
• 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
8,944
Learners
343
Reviews
219
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
junhyeongkim5912Reviews 3
∙
Average Rating 3.7
5
44% enrolled- 엑셀디자인Instructor
ジュンヒョン様、ありがとうございます(✿◡‿◡) プロVBA開発者でない場合は、VBA必須文法のみを理解してください。 仕事に必要なコードは、生成AI（Copilot、ChatGPT）の助けを借りれば、はるかに効率的にデータ自動化を行うことができます。
- joinho10229613
Reviews 7
∙
Average Rating 5.0
- bubble23473001
Reviews 1
∙
Average Rating 5.0
- topswordk2512
Reviews 1
∙
Average Rating 5.0
5
100% enrolledとても役に立ちます。断片的に知っているコードの大きな絵を描くのが好きです。
- 엑셀디자인Instructor
AI の助けを借りれば、専門の開発者と同じくらい優れたマクロの結果を出せると思います。頑張ってください (∩^o^)⊃━☆
Limited time deal ends in 3 days
$2,603.00
25%
$22.00
엑셀디자인's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
![[セバシ] 上位1%フリーワーカーのワーライフバランスシステム作り | ドローアンドリュー강의 썸네일](https://cdn.inflearn.com/public/files/courses/338004/cover/01jzj0d70pvkr9qyp970a0c8jw?f=avif&w=420)
![[国内初] ChatGPT × Word 実務活用法：誰でも簡単に作る各種文書自動化강의 썸네일](https://cdn.inflearn.com/public/files/courses/338227/cover/01k0rxg0k0xk9q6vefywa4qnbn?f=avif&w=420)
![3日ぶりに終わる[ITQエクセルA漢方に合格する]강의 썸네일](https://cdn.inflearn.com/public/courses/329652/cover/b44e11b6-a47e-4993-86ea-a85da9836bb5/329652-eng.png?f=avif&w=420)
![[エピソード] Excel + Python (基礎)강의 썸네일](https://cdn.inflearn.com/public/courses/332174/cover/4bff11a1-9859-43f4-8e17-6374ee50e6d6/332174-eng.png?f=avif&w=420)
