Excel VBA Macros: Automating Tasks

Overview

This course will be useful to anyone who wants to gain the skills necessary to use Visual Basic for Applications (VBA) to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. You will begin by identifying components of macro-enabled workbooks and configuring the Excel VBA environment. You'll also automate repetitive tasks by using the macro recorder, recording a macro with relative addressing, deleting macros and modules, and identifying strategies for using the macro recorded. Then, you'll use VBA help, use the object browser, and use the immediate window to explore object properties and methods. This is the first course in a multi-course Specialization. All of the courses in this Specialization require that you have a recent version of Microsoft Excel installed. The course setup instructions provided in the first module of this course go into more detail about the hardware and software requirements.

Syllabus

Using VBA to Solve Business Problems

When used appropriately, VBA is a powerful tool that can help you solve a wide array of business problems.

Automating Repetitive Tasks

You've run macros that automate repetitive tasks in Microsoft® Excel®. Now you will create your own macros by using Excel's macro recorder.

Getting Help on VBA

In the Microsoft® Excel® VBA programming environment, you'll find that often you know what you want to do, but you just don't know what objects are provided to get the job done, or how they work. The sheer volume of objects, properties, and methods in VBA means that you may never memorize all their names and syntax, but fortunately you don't have to. VBA includes a variety of tools that provide help as you need it.