The lecture content is easy to understand and the pronunciation is accurate, so it goes right into my ears. After I finish this lecture, I will have to take other courses.

fmlejl6009

Automate complex tasks in a snap! Excel macros and VBA, from basics to practical use!

onwings

Complete mastery of Excel macros and VBA from basics to practical use

입문

초급

중급이상

Business Productivity

엑셀

Excel

브이비에이

Start the course

Learn the essential basics for using macros and VBA

(Project Example 1) Create a program that displays only the performance of selected business units

(Project Example 2) Creating a program that automatically edits RawData

(Project Example 3) Creating a data retrieval program using form controls

(Project Example 4) Create a program to automate data editing and formatting

Learn the grammar needed for VBA coding

(Project Example 5) Creating a practical program to separate data into sheets and files

Learn the core control statements that control program execution.

(Project Example 6) Create a program to retrieve employee information using ActiveX controls

(Project Example 7) Creating a program to issue a certificate of employment using ActiveX controls

Course End