Linkedin Learning
Linkedin Learning Logo

Excel: Macros and VBA for Beginners 

  • Offered byLinkedin Learning

Excel: Macros and VBA for Beginners
 at 
Linkedin Learning 
Overview

Learn how to set up macros in Excel now, saving time later

Duration

1 hour

Total fee

1,150

Mode of learning

Online

Difficulty level

Beginner

Credential

Certificate

Excel: Macros and VBA for Beginners
 at 
Linkedin Learning 
Highlights

  • Earn a certificate of completion from LinkedIn Learning
Details Icon

Excel: Macros and VBA for Beginners
 at 
Linkedin Learning 
Course details

Skills you will learn
More about this course
  • 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

Excel: Macros and VBA for Beginners
 at 
Linkedin Learning 
Curriculum

Introduction

Macros and VBA for beginners

The World of Macros and VBA

Making the case: Why a macro and not regular Excel?

Record a Basic Macro

Add the Developer tab to your ribbon

Record the macro and review the code

Stepping through the code

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

Faculty Icon

Excel: Macros and VBA for Beginners
 at 
Linkedin Learning 
Faculty details

Oz du Soleil
He has been working with data and Excel for many years, and have developed a passion for clean data and reliable reporting.

Other courses offered by Linkedin Learning

– / –
1 hours
Intermediate
25 K
1 month
– / –
899
1 hours
Intermediate
– / –
1 hours
Advanced
View Other 504 CoursesRight Arrow Icon

Excel: Macros and VBA for Beginners
 at 
Linkedin Learning 
Students Ratings & Reviews

5/5
Verified Icon1 Rating
D
Dorothy Baruah
Excel: Macros and VBA for Beginners
Offered by Linkedin Learning
5
Learning Experience: Learning experience was good
Faculty: Instructors taught well Short and clear explanations
Course Support: Career support was helpful
Reviewed on 19 Apr 2022Read More
Thumbs Up IconThumbs Down Icon
View 1 ReviewRight Arrow Icon
qna

Excel: Macros and VBA for Beginners
 at 
Linkedin Learning 

Student Forum

chatAnything you would want to ask experts?
Write here...