Skills You’ll Learn

Learn the basic skills necessary to use macros and VBA

Learn how to record automatic macros and how to modify and execute VBA code.

Business automation program using automated macros

Learn how to create an automation program through several project examples

Learn core VBA grammar

Systematically learn the concepts of objects, properties, and methods, as well as loops and conditional statements

Production of practical programs

Create programs that separate data into sheets and files.

Production of practical programs using ActiveX

Create a program that automatically issues certificates by searching with ActiveX controls

This course is a course of learning from “basics” to “use” so that Excel users can easily and quickly learn macros and create their own VBA programs.

Hello, I'm Kim Kyung-ja, the goddess of Excel.

<History>

(Current) Compipple CEO
Attended lectures at LG Electronics, Daewoo E&C, Shinsegae Food, Sampyo Foods, Korea Standards Association, Land Housing Corporation, National Civil Service Redevelopment Institute, Land, Infrastructure, Transport and Tourism Human Resources Development Institute, Korea Chamber of Commerce, Seoul National University, Central Education Center, etc., and developed a business innovation program using Excel VBA

<books>

<Excel Functions & Formulas> (Hanbit Media, 2021)
<Excel Practical Macros and VBA (Hanbit Media, 2020) >
<Excel Practical Data Utilization+Analysis (Hanbit Media, 2019) >
<Excel 2016 Basics+Practical Completion> (Books Holic, 2018)
<Excel Data Utilization+Analysis> (Hanbit Media, 2016)
<Excel 2016 Macro and VBA> (History of Information Culture, 2016)
<Excel 2013 Basic Practice Completion> (Books Holic Publishing, 2014)
<Excel 2010 Macro and VBA> (Youngjin.com, 2012)
<Excel 2010 Basic Practice Completion> (Books Holic, 2010)
<Excel 2007 Macro & VBA Basics+Practices> (Sungan-dang, 2009)

✅ Macro & VBA for easy and quick learning

Macros are a function for creating programs in Excel, and can be easily accessed by people with programming experience, but ordinary Excel users with no programming experience can't help but feel that it's a completely different field from Excel.

Excel users are not programmers, so once they learn Visual Basic grammar from the beginning, they get tired and give up easily.It is necessary to be able to access macros using the functions of Excel so that you can easily learn macros step by step.

프로젝트형 실무 예제 제공

▶ Provision of project-type practical examples

This course is a course to learn everything from basics to use so that Excel users can easily learn macros and create their own VBA programs. It is composed of the most useful and most useful examples that can be used by representative departments that make up an enterprise.

Class Kit · Coaching Session

PC with Excel 2013 or higher

Curriculum

Creator

EXEL Lady Kim

While working at LG Electronics LearningCenter, I have a relationship with IT education. Currently, I have been teaching and developing business innovation programs using Excel VBA for 20 years at LG Electronics, Daewoo E&C, Shinsegae Food, Sampyo Foods, Korea Standards Association, Land Housing Corporation, National Civil Service Redevelopment Institute, Korea Chamber of Commerce and Industry, Seoul National University, and Central Education Center. My books include <Excel Functions & Formules> (Hanbit Media, 2021), <Excel Practical Macro and VBA (Hanbit Media, 2020) >, <Excel Practical Data Utilization+Analysis (Hanbit Media, 2019) >, <Excel 2016 Basics+Practical Completion> (Booksholic, 2018), <Excel Data Utilization+Analysis> (Hanbit Media, 2016), <Excel 2016 Macro and VBA> (Information Culture History, 2016), <Excel 2013 Basic Practice Completion> (Booksholic Publishing, 2014), <Excel 2010 Macro and VBA> (Youngjin.com, 2012) There are <Excel 2010 Basic Practice Completion> (Books Holic, 2010), <Excel 2007 Macro & VBA Basics+Practice> (Sungan-dang, 2009).

onwings