Inflearn brand logo image
Inflearn brand logo image
Inflearn brand logo image
Productivity

/

Task Automation

Master Excel 2019 Macro VBA from the Basics

Learn Macro VBA with Excel 2019!! However, you can also practice with 2016 and 2013 versions. Macros and VBA fill in the gaps that Excel alone lacks.

(4.9) 14 reviews

84 learners

  • comt
Excel
VBA
Business Productivity

Reviews from Early Learners

What you will learn!

  • Writing and Editing Macros

  • Branching and looping statements

  • Key properties and methods

For big data and large-scale statistical work
A complete summary of new Excel 2019 features!

Essential for any job
Excel 2019!

To use Excel properly for work,
Macro and VBA skills are essential.

  • Batch process a series of repetitive Excel tasks and save them for repeated use.
  • Repeat processing is only possible for a given portion of the work

  • An abbreviation for Visual Basic Application, a type of scripting language derived from the Visual Basic program.
  • Built-in programs to overcome the limitations of office programs and achieve more flexible work results



1. When Excel's basic functions are not enough

  • When performing [special tasks of cells], [repetitive tasks], etc.!

2. When you want to create a function with calculation functions that are essential for your work.

  • When creating a special function like [Convert customer's lunar birthday to solar calendar]!

3. When you want to create an Excel automatic program

  • When setting up a [program for managing product registration and inquiries, etc.]!


Lecture materials
Provides.

  • We provide a PDF file summarizing the lecture contents. You can download the materials from [Section 0] - [How to write and run macros - Overview of macros and VBA, understanding the concepts] .
  • You can also download the source files (working files) used in the lecture from [Section 0] - [Macro Editing - Creating and Editing Filtering Task Macros] .

Recommended for
these people

Who is this course right for?

  • I know a little about Excel, but I want to learn about macro VBA.

  • People who work in statistics

Need to know before starting?

  • Excel

Hello
This is

1,470

Learners

120

Reviews

4

Answers

4.7

Rating

33

Courses

애플의 MAC이란 컴퓨터가 디자인을 더 잘할 수 있게 만들었던 시절.

Adobe에 포토샵과 일러스트레이터를 학원에서 강의를 시작했던 것이 25년이 훨씬 지나버렸네요~~^^

학원에서 강의를 했던 엄선생, 하선생, 구선생이란 부른는 대신 엄티, 구티라고 불렀던 시절이 생각나

그 선생들과 함께 컴퓨터티쳐를 줄여서 컴티라고 쓰게 되었네요!

앞으로도 배우는 분들을 위해 열심히 지식을 공유하는 컴퓨터티쳐가 되겠습니다.

 

감사해용!!

 

 

Curriculum

All

26 lectures ∙ (12hr 37min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

14 reviews

4.9

14 reviews

  • 이설하님의 프로필 이미지
    이설하

    Reviews 9

    Average Rating 5.0

    5

    100% enrolled

    다양하게 실속있는 함수를 배울수 있어서 좋았습니다^^

    • 컴티
      Instructor

      수강평 주셔서 감사해요. 정말 많은 함수들이 있는데 엑셀은 응용의 재미가 있는 프로그램입니다 . 100강 짜리 엑셀 강좌도 업데이트 하겠습니다.

  • 이동준님의 프로필 이미지
    이동준

    Reviews 5

    Average Rating 5.0

    5

    100% enrolled

    좋은 수강 감사드립니다.

    • 컴티
      Instructor

      감사합니다. vba를 잘 활용하시면 무궁무진한 결과를 없을 수 있으니 많이 응용해 보세요^^

  • JW hayashi님의 프로필 이미지
    JW hayashi

    Reviews 2

    Average Rating 5.0

    5

    31% enrolled

    • twoo.kim님의 프로필 이미지
      twoo.kim

      Reviews 2

      Average Rating 5.0

      5

      92% enrolled

      • 손지훈님의 프로필 이미지
        손지훈

        Reviews 60

        Average Rating 5.0

        5

        8% enrolled

        만족합니다

        • 컴티
          Instructor

          수강평 주셔서 정말 감사합니다. 엑셀은 참 배울게 많은 프로그램이기도 하지만 매크로와 VBA는 더 더욱 응용이 굉장히 중요하니 실무에서 다양하게 활용해 보시기 바랍니다. 늘 건강하시고 행복하시기 바랍니다.

      Limited time deal ends in 7 days

      $22,550.00

      24%

      $23.10

      comt's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!