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

Overview

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).

If you’re a frequent user of Excel, chances are you have Excel tasks that you need to repeat often. Fortunately, you can automate these tasks by creating macros. Many people assume macros are complicated and reserved only for Excel power users. Not so! In this short course, Excel MVP Oz du Soleil first explains the best times to use a macro, and then how to use Visual Basic for Applications (VBA) to set up a basic macro in Excel to record your mouse clicks and keystrokes. Learn how to set up macros in Excel now, saving time later.

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

Related Courses

Reviews

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