엑셀장인의 매크로
엑셀장인
엑셀 2007, 2010, 2013, 2016, 2019, 365 사용자를 위해 엑셀매크로의 강력함을 알려주고, VBA 코딩 없이 단순 반복작업을 자동화할 수 있는 기술과 기능을 알려드려요.
初級
Excel, MS-Office
Excel VBA Practical Programming
For office workers who are tired of repetitive Excel tasks, we will teach you coding, and for those who only know Excel in a simple way, we will teach you its power and infinite possibilities!
What you will learn!
Automating tasks that frequently appear in practice
Finish manual Excel work with one button
For those of you who are tired of repetitive Excel work
I highly recommend using Excel VBA in your work! 📗
Visual Basic for Applications (VBA)
As a programming language embedded in Microsoft Office,
This is a function that automates tasks.
Anyone who's ever used Excel has probably dreamed of learning Excel macros and VBA at least once! However, the high barrier to entry makes it difficult to actually use VBA in the workplace. This is especially true for VBA. In this course, we'll teach you how to code using Excel, a fundamental tool used in companies, and help you break free from repetitive manual tasks.
I recommend this to these people 🙋♂️
I'm unfamiliar with Excel VBA
For those who don't know how to write
If you get stuck while coding,
People who don't understand other people's code
Debugging window while running the program
People who give up when they come out
Features of this course ✍
- Automate specific tasks in a short period of time.
- The code is written to be as simple and short as possible without any unnecessary details.
- We will quickly proceed with only the key points, focusing on imparting knowledge.
- We frequently show you debugging techniques necessary to understand code written by others.
- Anyone can see and understand any of the 2007, 2010, 2013, 2016, 2019, 2021, or 365 versions.
- The theory is kept to a minimum and made strictly in the practical way of general workers.
What you'll learn 📚
.gif "4 Address Book - Labeling_Promotional (2).gif")
Expected Questions Q&A 💬
Q. Is there anything I need to prepare before attending the lecture?
You just need Excel for Windows installed on your computer. These days, most people use Excel 2010 or later, but any version higher than 2007 will do.
Q. Are there any pre-registration courses?
I recommend taking the Excel macro lecture. Try recording a lot of Excel macros.
Q. What are the benefits of taking a VBA course?
It's great for automating tasks like business or other large data volumes.
Recommended for
these people
Who is this course right for?
People who are tired of repetitive tasks in Excel
For those who want to learn what coding is (feat. Excel)
Need to know before starting?
Excel Macro
Take my previous lecture (Excel Craftsman's Macro) first
215
Learners
22
Reviews
4.4
Rating
2
Courses
--개발이력--
삼성화재해상보험(주): 상품 분석 정답지 개발 프로젝트
(주)두산중공업: BEP 시뮬레이터
(주)KT: 직무역량고도화 프로그램
양구군산림조합: 대리경영 관리프로그램
금호타이어(주): 공급망관리(SCM)프로그램 엑셀Part
LG전자: 글로벌구매분석시스템 엑셀Part
삼성전자: 글로벌SCM 수요분석시스템 엑셀Part
한국IBM: 발주업체선정프로그램, 구매부직원 엑셀교육
국민은행: 차세대신상품 팩토리 엑셀Part
우리금융시스템: 차세대프로젝트 엑셀Part
한국수자원공사: 상하수도 공사비추정프로그램
해남군농업기술센터: 미생물관리프로그램
사회복지공동모금회: 예산편성프로그램
기타 수백건의 프로젝트를 개발했으며, 현업에서 계속 엑셀프로그래머로 활동중입니다
--저서--
1. 슬기로운 직장생활을 위한 엑셀 써머리(기본서3)
2. 엑셀장인의 매크로VBA(매크로책)
3. 엑셀장인의 2016마스터링북(기본서2)
4. 엑셀장인의 엑셀 함수 마스터링북
5. 엑셀장인의 2013마스터링북(기본서)
Curriculum
All
41 lectures ∙ (2hr 15min)
Course Materials:
Lecture resources
Published:
Last updated:
Reviews
Not enough reviews.
Please write a valuable review that helps everyone!
$77.00
xlwhy's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
![[2025년 개정]이것이 진짜 한글자동화다[실전편]講義サムネイル](https://cdn.inflearn.com/public/courses/335094/cover/5083a23e-ff9f-4972-8fcd-39f45e66a3b6/335094.png?f=avif&w=420)
![[2024년] 지친 엑셀 유저를 위한 Power BI 기본 강의 (기초~중급 입문)講義サムネイル](https://cdn.inflearn.com/public/courses/333721/cover/5ded8f1c-907b-493d-85ae-2fd641384417/333721.png?f=avif&w=420)
![[2024년 개정]이것이 진짜 한글자동화다[기본편]講義サムネイル](https://cdn.inflearn.com/public/courses/335093/cover/830eee3a-faa8-4d1b-be61-67bbbe75de9f/335093.png?f=avif&w=420)
