진짜 현업에서 쓰이는 직장인의 실무 엑셀 - 데이터 가공부터 분석까지
배영자
현재 엑셀의 가장 트렌디한 방법으로 데이터를 효율적, 과학적으로 가공, 분석함에 '표준'이 되는 과정입니다.
중급이상
Excel, MS-Office
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.
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
8,994
Learners
347
Reviews
219
Answers
4.9
Rating
6
Courses
안녕하세요, 반갑습니다.
VBA 강사 및 개발자 배영자입니다.
유튜브 '엑셀디자인' 채널 운영 중.
Curriculum
All
69 lectures ∙ (13hr 44min)
Published:
Last updated:
Reviews
All
52 reviews
4.8
52 reviews
odhkoreaReviews 5
∙
Average Rating 4.8
5
45% enrolled아버지가 혼자서 가게 매출과 현황을 수기로 일일이 작성하시는 것을 보고 엑셀로 자동화를 할 수 있는 관리 파일을 만들어 드렸습니다. 혼자서 네이버 검색해서 만들어서 엉성했는데 이 강의를 보고 100줄이 넘던 코드가 10줄로 줄어드는 마법이 벌어졌습니다... 진짜 유튜브, 블로그 등에서 중구난방으로 배우는 것과 다릅니다. 기초부터 차근차근 알려주셔서 이해도 잘 되고 바로바로 응용해서 쓰기도 좋습니다. 정말 감사드리고 추천하는 강의입니다!
- 배영자Instructor
어머나~~~ 이렇게 아름다운 'VBA 이야기'는 처음 입니다. 저도 경험해보지 못한 부분입니다. 가족과 동료를 배려하는 아름다운 매크로를 계속 만들어 가시길 응원합니다. 건강하십시오~ ♡
- John Y. Freeman
Reviews 2
∙
Average Rating 5.0
5
100% enrolled혼자서도 영상을 보면서 차근히 따라가면 이해하기 쉽게 구성된 것 같습니다. 꼭 알아야 하는 기초를 다지기 좋은 것 같네요.
- 배영자Instructor
감사합니다 :D 멋진 Excel Data Scientist 되실 겁니다.
Free
엑셀디자인's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
![[에피소드] 엑셀+파이썬(기초)강의 썸네일](https://cdn.inflearn.com/public/courses/332174/cover/4bff11a1-9859-43f4-8e17-6374ee50e6d6/332174-eng.png?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)
