【한글자막】 Microsoft 엑셀 매크로 (Macros) 및 VBA 완벽 마스터

During this lecture you will be introduced to the first project you will be creating during this course.

• Using the Macro Recorder
• Inserting Text
• Formatting Text

During this lecture you will gain practical experience in using Excel's Macro Recorder tool to record your keystrokes to automate simple Excel tasks,

During this lecture you will create a Button on Excel's Quick Access Toolbar that can be used to run the Macro.

This lecture will prepare you for the next section, Project #2 by quickly introducing you to the Visual Basic Editor (VBE) window. Through the VBE window you will be able to make edits to your Macros.

This lecture will present you with practical everyday uses of Excel Macros.

프로젝트 #1 작업을 연습해보세요. 첨부된 파일을 다운로드 받는 것을 잊지 마세요.

Welcome to VBA

During this lecture you will be introduced to the VBA development environment within Excel, the Visual Basic Editor

During this lecture you will be introduced to an Excel VBA Module

During this lecture you will take advantage of the VBE window to create a custom Procedure

During this lecture you will be introduced to working with Excel VBA Variables

• Learn to how programmatically store data for immediate or later use
• Working with different types of data

During this lecture you will be introduced to one method of creating logic based code through the use of an IF Statement

During this lecture you will learn how to work with Loops within an Excel VBA procedure

• Repeat a single line or block of VBA code
• For Next Loop
• Do Loop

This lecture will build upon the concepts learned in the previous project by introducing you to the world of Visual Basic for Applications (VBA). You will take the Macro created in project #1 and add your own custom VBA code to make a more dynamic and re-usable Macro by presenting the user of the Macro with options.

Before we begin editing the code generated by the Macro Recorder, this lecture will walk you through what the recorder has done for you.

This lecture will introduce a few powerful concepts of programming in VBA.

• Using Variables
• Interacting with Users with an InputBox
• Editing a Macro
• Leaving Comments in Your Code

During this lecture you will learn how to build logic in your Excel Macros using an IF statement

This lecture will introduce you to a few more key programming concepts that you will rely on throughout your Excel VBA projects.

• Using a Message Box
• Using Conditional Statements to Direct Your Code

This lecture will present you with other practical uses of using these techniques in your Macros.

프로젝트 #2 작업을 연습해보세요. 첨부된 파일을 다운로드 받는 것을 잊지 마세요.

During this lecture you will be introduced to a completed version of Project #3.

During this lecture you will be introduce to best practice before using the Macro Recorder tool

During this lecture you will take advantage of using the Macro recorder to add headers to the data

During this lecture you will use the Macro Recorder to format the headers added by the previous macro

During this lecture you will take the previous macros, created using the Macro Recorder, and add a little bit of Visual Basic to get them all to work together

프로젝트 #3에서 다룬 개념들에 대한 여러분의 지식을 테스트 해보세요.

This lecture will introduce you to Project #4 and what you will be creating.

During this lecture you will learn how, through VBA, you programmatically SUM a column of data

During this lecture you will be introduced to using a LOOP to perform a series of actions across multiple worksheets

프로젝트 #4에서 다룬 개념들에 대한 여러분의 지식을 테스트 해보세요.

During this lecture you will be introduced to the Project you will be creating and matering

During this lecture you will learn how to take all the Macro/VBA Concepts you are learning and combine them all to create a Macro that will create a final report based on several worksheets of data

프로젝트 #5에서 다룬 개념들에 대한 여러분의 지식을 테스트 해보세요.

During this lecture you will be introduced to the project that you will be creating and mastering

During this lecture you will be introduced to creating Excel VBA forms within the VBA window

During this lecture you will be introduced to adding various controls to your Excel VBA form

During this lecture you will learn how to add VBA code to the form and the form controls

During this lecture you will learn how to run or display the form you have created.

프로젝트 #6에서 다룬 개념들에 대한 여러분의 지식을 테스트 해보세요.

During this lecture you will be introduced to a technique of importing a text file into an Excel Workbook. Text files attached to this lecture can be used to practice this technique

Congratulations!