Featured resource
2026 Tech Forecast
2026 Tech Forecast

1,500+ tech insiders, business leaders, and Pluralsight Authors share their predictions on what’s shifting fastest and how to stay ahead.

Download the forecast
  • Course

Automate Microsoft Excel with VBA

Already developing simple VBA in Excel? Want to go to the next level? This course will teach you some advanced VBA, allowing you to automate processes and build small applications. You’ll also learn how to write efficient and compact code.

Intermediate
1h 8m

Created by Mike McQuillan

Last Updated Apr 28, 2026

Course Thumbnail
  • Course

Automate Microsoft Excel with VBA

Already developing simple VBA in Excel? Want to go to the next level? This course will teach you some advanced VBA, allowing you to automate processes and build small applications. You’ll also learn how to write efficient and compact code.

Intermediate
1h 8m

Created by Mike McQuillan

Last Updated Apr 28, 2026

Get started today

Access this course and other top-rated tech content with one of our business plans.

Try this course for free

Access this course and other top-rated tech content with one of our individual plans.

This course is included in the libraries shown below:

  • Data
What you'll learn

Do you want to write solid, reusable VBA and make small applications in Excel? In this course, Automate Microsoft Excel with VBA, you’ll gain the ability to write tight, performant, and reusable VBA code in Excel. First, you’ll explore how to create custom modules and functions involving data manipulation. Next, you’ll discover how to move data between workbooks using VBA, along with error handling techniques. Finally, you’ll learn how to build reusable code using class modules. When you’re finished with this course, you’ll have the skills and knowledge of Excel VBA needed to build small applications and processes that will eliminate your manual processes.

Automate Microsoft Excel with VBA
Intermediate
1h 8m
Table of contents

About the author
Mike McQuillan - Pluralsight course - Automate Microsoft Excel with VBA
Mike McQuillan
15 courses 4.5 author rating 610 ratings

Mike loves to mess around with data and programming problems, the bigger the better. He’s worked with a variety of companies, helping to build and improve systems of all shapes and sizes.

2025 Forrester Wave™ names Pluralsight as a Leader among tech skills dev platforms

See how our offering and strategy stack up.

forrester wave report