Coursera Plus Annual is 40% Off — Ends July 13.

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel: Macros and VBA for Beginners

via LinkedIn Learning

Write review
University of the People Ad

Earn Your Business Degree, Tuition-Free, 100% Online!

Learn More → Simplilearn Ad

Pass the PMP® Exam on Your First Try — Expert-Led Training

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Any Excel user, regardless of expertise level, can learn how to save time by automating tasks using Excel macros and Visual Basic for Applications (VBA).

Syllabus

Introduction
  • Macros and VBA for beginners
1. The World of Macros and VBA
  • Making the case: Why a macro and not regular Excel?
2. Record a Basic Macro
  • Add the Developer tab to your ribbon
  • Record the macro and review the code
  • Stepping through the code
3. Other Things to Know before Creating Macros
  • Warnings about VBA and macros: There is no undo
  • Warnings about VBA and macros: Recorded macros are literal
  • Warnings about VBA and macros: Errors
  • The VBA environment
  • Four ways to launch macros
Conclusion
  • You can do anything with VBA

Taught by

Oz du Soleil

Reviews

4.7 rating at LinkedIn Learning based on 2408 ratings

Start your review of Excel: Macros and VBA for Beginners

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.