Excel VBA Practical Programming

Name: Excel VBA Practical Programming
Price: 69300 KRW
Rating: 5 (1 reviews)

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!

(5.0) 수강평 1개

강의소개.상단개요.수강생.short

난이도 초급

수강기한 무제한

xlwhy

Excel

VBA

Excel

VBA

강의상세_배울수있는것_타이틀

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 📚

2-Structure Transformation_Promotional.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.

강의소개.콘텐츠.추천문구

학습 대상은 누구일까요?

People who are tired of repetitive tasks in Excel
For those who want to learn what coding is (feat. Excel)

선수 지식, 필요할까요?

Excel Macro
Take my previous lecture (Excel Craftsman's Macro) first

강의소개.지공자소개

220

수강생

수강평

4.3

강의 평점

강의_other

--Development History--

Samsung Fire & Marine Insurance Co., Ltd.: Product Analysis Answer Key Development Project
Doosan Heavy Industries & Construction Co., Ltd.: BEP Simulator
KT Corporation: Job Competency Advancement Program
Yanggu-gun Forestry Association: Proxy Management Program
Kumho Tire Co., Inc.: Supply Chain Management (SCM) Program Excel Part
LG Electronics: Global Procurement Analysis System Excel Part
Samsung Electronics: Global SCM Demand Analysis System Excel Part
IBM Korea: Vendor Selection Program, Excel Training for Procurement Staff
KB Kookmin Bank: Next-Generation New Product Factory Excel Part
Woori FIS: Next-Generation Project Excel Part
K-water: Water and Sewage Construction Cost Estimation Program
Haenam-gun Agricultural Technology Center: Microorganism Management Program
Community Chest of Korea: Budgeting Program
I have developed hundreds of other projects and continue to work as an active Excel programmer.

--Books--

1. Excel Summary for Smart Work Life (Basic Book 3)
2. Excel Master's Macro VBA (Macro Book)
3. Excel Master's 2016 Mastering Book (Basic Book 2)
4. Excel Master's Excel Function Mastering Book
5. Excel Master's 2013 Mastering Book (Basic Book)

커리큘럼

전체

41개 ∙ (강의상세_런타임_시간 강의상세_런타임_분)

해당 강의에서 제공: [object Object]

섹션 1. VBA Introduction and Definition

1개 ∙ (강의상세_런타임_분)

1. 0 vba,object,method,property,currentregion,paste
06:49

섹션 2. Direct coding (Generate and send sheets using data and a template sheet)

3개 ∙ (강의상세_런타임_분)

섹션 3. Export filtered data to another sheet

1개 ∙ (강의상세_런타임_분)

5. 4 Advanced Filter
04:08

섹션 4. Organizing data into a converted structure

3개 ∙ (강의상세_런타임_분)

섹션 5. Import form input data from another file

1개 ∙ (강의상세_런타임_분)

섹션 6. Custom Form Partial Search Input/Select and Query, File Creation

3개 ∙ (강의상세_런타임_분)

섹션 7. Merging multiple files into one

2개 ∙ (강의상세_런타임_분)

섹션 8. Check sheet existence, advanced filter for criteria.

1개 ∙ (강의상세_런타임_분)

섹션 9. Check if the file exists

1개 ∙ (강의상세_런타임_분)

섹션 10. Delete Row, Insert Row

2개 ∙ (강의상세_런타임_분)

섹션 11. Color Processing, Creating and Using UDF (User Defined Function)

1개 ∙ (강의상세_런타임_분)

섹션 12. Merging cells (feat. loop)

1개 ∙ (강의상세_런타임_분)

섹션 13. Definition of Event, Coding Location, and Usage

5개 ∙ (강의상세_런타임_분)

섹션 14. Address Book (Labeling, DM) Automation

5개 ∙ (강의상세_런타임_분)

섹션 15. Sheet processing

3개 ∙ (강의상세_런타임_분)

섹션 16. Pivot Table object access

2개

섹션 17. Accessing Chart Objects and Adding/Using Form Controls

1개 ∙ (강의상세_런타임_분)

섹션 18. Print (Batch Statement Printing)

1개 ∙ (강의상세_런타임_분)

섹션 19. Processing Multiple Cell Values with Find

2개 ∙ (강의상세_런타임_분)

섹션 20. Save as specific format (pdf)

1개 ∙ (강의상세_런타임_분)

섹션 21. List all files by searching including subfolders

1개 ∙ (강의상세_런타임_분)

강의 게시일: 08/02/2022

마지막 업데이트일: 05/13/2025

수강평

전체

1개

5.0

1개의 수강평

jaeyoonhan4591
수강평 8
∙
평균 평점 5.0
09/13/2025
5
32% 수강 후 작성

xlwhy님의 다른 강의

지식공유자님의 다른 강의를 만나보세요!

Excel Craftsman's Macro

xlwhy

$42.90

28%

$30.80

Basic / Excel, MS-Office

4.3

(23)

100+

For Excel 2007, 2010, 2013, 2016, 2019, and 365 users, we will show you the power of Excel macros and the techniques and functions that can automate simple repetitive tasks without VBA coding.

Basic

Excel, MS-Office

Excel Craftsman's Macro

xlwhy

$42.90

28%

$30.80

Basic / Excel, MS-Office

4.3

(23)

100+

비슷한 강의

같은 분야의 다른 강의를 만나보세요!

Useful Excel macros without coding

Masocampus

$38.50

28%

$27.50

Basic / Excel, excel-macro, MS-Office

4.6

(5)

Active Replies

A course that covers how to conveniently handle work using the macro recorder without the burden of VBA coding! You can understand how to utilize macros in various ways through practice of simply converting data accumulated in the company into an Excel database and building a search system to find it.

Basic

Excel, excel-macro, MS-Office

Useful Excel macros without coding

Masocampus

$38.50

28%

$27.50

Basic / Excel, excel-macro, MS-Office

4.6

(5)

Active Replies

VBA Big Picture

exceldesign

$22.00

30%

$15.40

Basic / Excel, Business Productivity, VBA

4.9

(22)

100+

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.

Basic

Excel, Business Productivity, VBA

VBA Big Picture

exceldesign

$22.00

30%

$15.40

Basic / Excel, Business Productivity, VBA

4.9

(22)

100+

Excel 2013 VBA: Learn it fast and easily

officetutor

$59.40

29%

$41.80

Intermediate / MS-Office, VBA

5.0

(2)

Learn about tasks that can be done using Excel VBA. Learn about the basic syntax of VBA and objects, collections, properties, methods, and events, and create and use Visual Basic functions, Excel functions, and user-defined functions.

Intermediate

MS-Office, VBA

Excel 2013 VBA: Learn it fast and easily

officetutor

$59.40

29%

$41.80

Intermediate / MS-Office, VBA

5.0

(2)

[Basics] Even those with no coding experience can do it! Automating Google Sheets tasks in 90 minutes

workwithdugi

$15.40

28%

$11.00

Beginner / Business Productivity, Google Apps Script, Google Sheets, spreadsheets, Excel

4.8

(33)

200+

Even those with no coding experience can automate Google Sheets and Apps Script tasks! I will teach you the easiest way by creating examples that can be used in actual work.

Beginner

Business Productivity, Google Apps Script, Google Sheets

[Basics] Even those with no coding experience can do it! Automating Google Sheets tasks in 90 minutes

workwithdugi

$15.40

28%

$11.00

Beginner / Business Productivity, Google Apps Script, Google Sheets, spreadsheets, Excel

4.8

(33)

200+

PowerApps, Create the Mobile Apps Your Company Needs

omas

$26.40

29%

$18.70

Beginner / Power Apps, Excel, MS-Office, No-code

4.1

(18)

100+

You don't have to learn difficult development. After listening to this 1-hour lecture, you will be able to understand the basics of PowerApps and create a mobile app that can register and check problems in the conference room (office) that is available in our company.

Beginner

Power Apps, Excel, MS-Office

PowerApps, Create the Mobile Apps Your Company Needs

omas

$26.40

29%

$18.70

Beginner / Power Apps, Excel, MS-Office, No-code

4.1

(18)

100+

Efficient AI Utilization That Companies Want - Practical Data Processing Secrets Conquered with Structured Prompts

Masocampus

$53.90

28%

$38.50

Beginner / Excel, AI, ChatGPT, prompt engineering, Generative AI

5.0

(5)

Active Replies

AI Excel that automates perfectly for your work without company security concerns. From data preprocessing to visualization in just a few minutes, no coding knowledge required!

Beginner

Excel, AI, ChatGPT

Efficient AI Utilization That Companies Want - Practical Data Processing Secrets Conquered with Structured Prompts

Masocampus

$53.90

28%

$38.50

Beginner / Excel, AI, ChatGPT, prompt engineering, Generative AI

5.0

(5)

Active Replies

Master Excel Automation for Work Efficiency with ChatGPT

365ENM

$127.60

29%

$90.20

Beginner / Generative AI, ChatGPT, Excel

1.0

(1)

Through the synergy of Excel and generative AI (ChatGPT), this practical, hands-on training covers the entire spectrum including data aggregation, cleansing, visualization, report writing, template automation, code-free schedule creation, VBA automation, and Google Sheets integration, designed to enable learners from Excel beginners to intermediate users to develop skills that can be immediately applied in real-world work through step-by-step learning.

Beginner

Generative AI, ChatGPT, Excel

Master Excel Automation for Work Efficiency with ChatGPT

365ENM

$127.60

29%

$90.20

Beginner / Generative AI, ChatGPT, Excel

1.0

(1)

Effective business capacity enhancement, Python business data analysis expert course

Masocampus

$77.00

30%

$53.90

Basic / Python, Excel, Excel Power Pivot

5.0

(2)

Active Replies

Coding Excel Data in Python?! It's Not Hard~ Becoming a Leading Worker is Just a Matter of Time!

Basic

Python, Excel, Excel Power Pivot

Effective business capacity enhancement, Python business data analysis expert course

Masocampus

$77.00

30%

$53.90

Basic / Python, Excel, Excel Power Pivot

5.0

(2)

Active Replies

ChatGPT × Excel Practical Application: Easy Start to Work Automation for Everyone

iexceller

$63.80

29%

$45.10

Basic / Excel, VBA, ChatGPT

5.0

(7)

Covers how to properly use the new game-changer "ChatGPT" for "Excel utilization." You can learn to create Excel formulas for practical use, easily grasp Excel functions, and write macros and VBA code using ChatGPT.

Basic

Excel, VBA, ChatGPT

ChatGPT × Excel Practical Application: Easy Start to Work Automation for Everyone

iexceller

$63.80

29%

$45.10

Basic / Excel, VBA, ChatGPT

5.0

(7)

Efficient AI Utilization That Companies Want - Conquering Excel with AI Structured Prompts

Masocampus

$53.90

28%

$38.50

Beginner / ChatGPT, Excel, AI, prompt engineering, VBA

5.0

(10)

Active Replies

Is it possible to automate Excel without uploading company data? AI utilization secrets revealed that maintain security while reducing work hours!

Beginner

ChatGPT, Excel, AI

Efficient AI Utilization That Companies Want - Conquering Excel with AI Structured Prompts

Masocampus

$53.90

28%

$38.50

Beginner / ChatGPT, Excel, AI, prompt engineering, VBA

5.0

(10)

Active Replies