Excel VBA Macros: Automating Tasks

Excel VBA Macros: Automating Tasks

This course is part of Programming and Data Wrangling with VBA and Excel Specialization

Instructor: Bill Rosenthal

Access provided by BNP Paribas Cardif 1

4 modules

Gain insight into a topic and learn the fundamentals.

7 hours to complete

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

7 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

Prepare the Excel interface for developer workflows by adjusting macro security, managing trusted locations, and navigating the Visual Basic Editor.
Record and manage automated tasks using both absolute and relative cell positioning while analyzing underlying VBA code strings.
Leverage contextual help files, R1C1 reference notation, and the Object Browser to discover and experiment with object properties.
Learn by doing. Perform guided, step-by-step hands-on activities on your own computer.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

1 assignment

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Programming and Data Wrangling with VBA and Excel Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 4 modules in this course

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.

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

What's included

1 reading6 plugins

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

What's included

6 plugins

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.