jaeyoon.han

엑셀 반복 업무에 지친 직장인들에게는 코딩을, 단순하게만 엑셀을 알고 있던 사람들에게는 그 강력함과 무궁무진함을 알려드립니다!

엑셀장인

엑셀VBA 실전 프로그래밍

하루 3시간! 하룻밤 만에 성장할 수 있는 강의만 모았어요!

3시간 만에 완강할 수 있는 강의 ⏰

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!

xlwhy

입문

초급

중급이상

엑셀

Excel

브이비에이

Excel VBA Practical Programming

VBA Introduction and Definition

Direct coding (Generate and send sheets using data and a template sheet)

Export filtered data to another sheet

Organizing data into a converted structure

Import form input data from another file

Custom Form Partial Search Input/Select and Query, File Creation

Merging multiple files into one

Check sheet existence, advanced filter for criteria.

Check if the file exists

Delete Row, Insert Row

Color Processing, Creating and Using UDF (User Defined Function)

Merging cells (feat. loop)

Definition of Event, Coding Location, and Usage

Address Book (Labeling, DM) Automation

Sheet processing

Pivot Table object access

Accessing Chart Objects and Adding/Using Form Controls

Print (Batch Statement Printing)

Processing Multiple Cell Values with Find

Save as specific format (pdf)

List all files by searching including subfolders