강의

멘토링

커뮤니티

BEST
Productivity

/

Office

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

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

(4.8) 139 reviews

958 learners

  • onwings
Business Productivity
Excel
VBA

Reviews from Early Learners

What you will gain after the course

  • Learn the basics necessary to use macros and VBA

  • Create a task automation program using automatic macros

  • Create a program that automatically edits RawData and retrieves data

  • Create a program to separate data into sheets and files

  • Handling core control statements that control program execution

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

Lecture Introduction

Excel users are not programmers, so if you try to learn Visual Basic* syntax from the beginning, you'll get tired and easily give up . By making it possible to access macros using Excel's built-in features , you can easily learn macros step by step .
(* Visual Basic: Windows application development language developed by MS Soft )

Macros are a feature for creating programs in Excel, and those with programming experience can easily access them. However , for general Excel users without programming experience, they can't help but feel like they're in a completely different field from Excel .


This course is designed to teach Excel users how to use macros from the basics to their applications, allowing them to easily learn macros and create their own VBA programs . It consists of the most useful and highly applicable examples that can be used in representative departments within a company.

Lecture Structure

1. Learning the basics essential for using macros and VBA

2. [Project Example 1] Creating a program that displays only the performance of selected business units.


3. [Project Example 2] Creating a program that automatically edits raw data.

4. [Project Example 3] Creating a Data Retrieval Program Using Form Controls

5. [Project Example 4] Creating a Program to Automate Data Editing and Formatting

6. Learning the grammar required for VBA coding

7. [Project Example 5] Creating a practical program to separate data into sheets and files

8. Learning core control statements for program execution control

9. [Project Example 6] Creating an Employee Information Retrieval Program Using ActiveX Controls



10. [Project Example 7] Creating a Certificate of Employment Issuance Program Using ActiveX Controls

Tools covered here

All versions of Excel are available

Recommended for
these people

Who is this course right for?

  • Anyone who wants to automate simple repetitive tasks in Excel

  • For those who think that the basic functions or data analysis features provided by Excel are insufficient

  • People who are good at using Excel but have no experience in creating programs

  • Those who want to systematically learn Excel macros and VBA and create their own programs

  • Anyone who wants to do programming using Visual Basic in Excel

Need to know before starting?

  • Excel Basic User

Hello
This is

6,461

Learners

649

Reviews

158

Answers

4.9

Rating

6

Courses

김경자 / 컴피플 대표, 연성대학교 겸임교수, 엑셀여신(http://blog.naver.com/onwings)

LG전자 LearningCenter에 근무하면서 IT교육과 인연을 맺어 현재는 삼성그룹, 기아그룹, 유데미, 금융감독원, 김앤장, 국가공무원인재개발원 등에서 강의하고 있습니다. IT/정보화 교육 전문회사인 컴피플 대표이며 연성대학교 겸임교수로 재직중입니다.

<저서>
- 회사에서 통하는 엑셀 데이터 활용 분석(한빛미디어, 2025)
- 회사에서 엑셀로 살아남기 (한빛미디어, 2023)
- 엑셀 실무 함수 + 수식 (한빛미디어, 2021)
- 엑셀 실무 매크로와 VBA (한빛미디어, 2020)
- 엑셀 실무 데이터 활용+분석 (한빛미디어, 2019)
- 엑셀 2016 기본+실무완성 (북스홀릭, 2018)
- 실무통 엑셀 함수 실무 강의 (한빛미디어, 2017)
- 회사 실무에 힘을 주는 엑셀 2016 매크로와 VBA (정보문화사, 2016)
- 회사에서 바로 통하는 엑셀 데이터 활용+분석 (한빛미디어, 2016)
- 엑셀 2013 기본 실무완성 (북스홀릭, 2014)
- 키노트 & 넘버스 무작정 따라하기 (길벗, 2014)
- 엑셀 2010 매크로와 VBA (영진닷컴, 2012)
- 엑셀 2010 기본 실무완성 (북스홀릭, 2011)
- 엑셀 2007 매크로 & VBA 기본+실무 (성안당, 2009)
- 엑셀 2007 기본 + 실무 (성안당, 2007)
- 실무에 강한 엑셀 매크로와 VBA (사이버출판사, 2005)

Curriculum

All

39 lectures ∙ (6hr 2min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

139 reviews

4.8

139 reviews

  • ssch40840045님의 프로필 이미지
    ssch40840045

    Reviews 13

    Average Rating 4.9

    Edited

    5

    62% enrolled

    Really explains VBA from the basics, and when I don't understand something after listening, I Google it and ask GPT if my understanding is correct, which gradually broadens my perspective. I thought it would be difficult to master VBA with just one course, so I was looking for a course that would build a solid foundation, and I'm glad this course leads me in the direction I was hoping for.

    • hjlove4470님의 프로필 이미지
      hjlove4470

      Reviews 1

      Average Rating 5.0

      5

      100% enrolled

      It's so easy to understand, I think I'll be able to apply it to my work!!!

      • sroh8994님의 프로필 이미지
        sroh8994

        Reviews 1

        Average Rating 5.0

        5

        100% enrolled

        It was such a new world that I regret not having just come across VBA. You answered my questions quickly and it was so great. I will have to retake the course again. Thank you!!

        • nahv5972님의 프로필 이미지
          nahv5972

          Reviews 2

          Average Rating 5.0

          5

          100% enrolled

          The instructor's teaching skills are really great. Thanks to the great explanations, I was able to get started well~!^-^

          • fmlejl6009님의 프로필 이미지
            fmlejl6009

            Reviews 1

            Average Rating 5.0

            5

            41% enrolled

            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.

            $42.90

            onwings's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!