Introduction to Microsoft Office Excel Macro Programming

Microsoft Excel Macro Programming

This course is intended for advanced Microsoft Excel professionals that need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA).

 

Prerequisites

Knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data. Students are recommended to first take the Microsoft® Office Excel®: Part 1, Part 2 and/or Part 3 in preparation for this course.

 

Course Objectives

Upon successful completion of this course, students will be able to :

  • Record a macro
  • View macro code in VBA editor
  • Edit macro code
  • Run a macro

 

Lesson Contents

Lesson 1: Developing Macros

Topic 1A: Create a Macro Using the Macro Recorder
Topic 1B: Edit a Macro
Topic 1C: Debug a Macro
Topic 1D: Set Macro Security

Lesson 2: Formatting Worksheets Using Macros

Topic 2A: Insert Text
Topic 2B: Format Text
Topic 2C: Sort Data
Topic 2D: Duplicate Data

Lesson 3: Understanding Objects

Topic 3A: Insert, Copy, and Delete Worksheets
Topic 3B: Rename Worksheets

$99

Jul 17, 2019

This course is not yet scheduled, but we can notify you when it is.

Send Me Updates  

8:30 am - 4:30 pm


REGISTER

 

Discount Information
Refund Policy