jaeyoonhan4591

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 VBA Practical Programming

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

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

입문

초급

중급이상

엑셀

Excel

브이비에이

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