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.
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
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!
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~♡
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.
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. ♡