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
Tools
Excel
Course Level
Advanced
Credentials
Paths

Not Sure Which COURSE or PATH is right for you?

Take our customized survey to find the perfect courses & paths for your skill level and goals!

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

WHO SHOULD TAKE THIS COURSE?

  • 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

WHAT ARE THE COURSE REQUIREMENTS?

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

Are you ready to become a DATA ROCKSTAR? Start learning today with your FREE 7-Day trial!

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?

Sign up today for a 7-Day Free Trial and start learning today!

Sign Up for Free