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.
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
