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
DataCamp Ad

Power BI Fundamentals - Create visualizations and dashboards from scratch

Learn More → Great Learning Ad

Learn Python with Generative AI - Self Paced Online

Learn More →

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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.