강의

멘토링

로드맵

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

85 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,520

Learners

129

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

  • snowsummer님의 프로필 이미지
    snowsummer

    Reviews 9

    Average Rating 5.0

    5

    100% enrolled

    It was nice to be able to learn a variety of useful functions^^

    • comt
      Instructor

      Thank you for your review. There are so many functions. Excel is a fun program to apply. I will also update the 100-lecture Excel course.

  • dj3416lee1723님의 프로필 이미지
    dj3416lee1723

    Reviews 5

    Average Rating 5.0

    5

    100% enrolled

    Thank you for the great class.

    • comt
      Instructor

      Thank you. If you use VBA well, there can be infinite results, so please apply it a lot^^

  • yuunagi1802191921님의 프로필 이미지
    yuunagi1802191921

    Reviews 2

    Average Rating 5.0

    5

    31% enrolled

    • twookim9667님의 프로필 이미지
      twookim9667

      Reviews 2

      Average Rating 5.0

      5

      92% enrolled

      • jihoonth9107님의 프로필 이미지
        jihoonth9107

        Reviews 60

        Average Rating 5.0

        5

        8% enrolled

        I am satisfied

        • comt
          Instructor

          Thank you so much for your review. Excel is a program that has a lot to learn, but macros and VBA are even more important for application, so I hope you can use them in various ways in your work. I hope you are always healthy and happy.

      Limited time deal ends in 8 days

      $17.60

      23%

      $23.10

      comt's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!