Your browser is not supported. Please download another browser to be able to use all of the Maven features.

Self-Paced Course

Microsoft Excel: VBA & Macros

Automate tasks, build interactive tools, and develop your own custom Excel applications using Visual Basic for Applications (VBA).

Course Hours22.5 hours
Skills Learned
Data Prep
Data Analysis
Course Level

Course Description

For Excel users looking to push the limits, VBA (Visual Basic for Applications) is an incredibly valuable tool. This programming language allows you to automate tasks, integrate custom forms and controls, and even interact with other Microsoft applications like Word, Outlook and Powerpoint -- all from within Excel.

But VBA isn't just for programmers or hardcore developers; in this course, we'll teach you the core principles of VBA from the ground up. We'll review basic syntax, practice generating code using the macro recorder, and work through more than 50 real-world use cases, from importing/exporting data to generating automated reports and invoices.

If you're looking to automate your workflow, develop fully custom solutions, and become a certified Excel power user, this is the course for you.

Course Outline


  • Excel users hoping to automate tedious and time-consuming tasks (formatting workbooks, transforming data, producing files, etc)
  • Analysts seeking to improve productivity, minimize human error, and produce reports and analyses more efficiently
  • Programmers looking to develop their own custom Excel solutions


  • Microsoft Excel for PC/Windows, compatible with VBA (ideally 2007+)
  • Familiarity with core Excel functionality is strongly recommended

Start learning for FREE, no credit card required!

Every subscription includes access to the following course materials

  • Interactive Project files
  • Downloadable e-books
  • Graded quizzes and assessments
  • 1-on-1 Expert support
  • 100% satisfaction guarantee
  • Verified credentials & accredited badges
Sign Up Today

Ready to become a

data rockstar?

Start learning for free, no credit card required!

Sign Up for Free