Skip to main content
Macros and VBA

Introduction to Excel Macros

Automating your daily tasks is one of the quickest ways to free up your bandwidth. Macros extend the functionality of Excel, enabling you to automate certain tasks and create much more complex formulas. In this course, you’ll learn how they will save you time and are simple to execute.

Advanced        9 Lessons        90 Minutes        CPD Credits
TRY FOR FREEEXPLORE OUR LIBRARY

About This Course

Your time is your most valuable asset, so any feature that can offer more back in your day is worth mastering. Macros fit that category by automating the tasks you complete most often.

Across nine lessons, you’ll learn how the basics of how to program Macros in excel, including how to record, edit and delete them, along with troubleshooting issues you may face.

By the end of the course, you’ll know how to automate your most time-consuming tasks, freeing up your day for more detailed analysis.

GET STARTED

Learning Outcomes

  • Record VBA macros in Excel
  • Understand the security implications of macros
  • Edit and delete macros
  • Use absolute and relative references in your macros
  • Use variables in macros
  • Explain the benefits of using macros in Excel

Lessons

1. What are Macros and VBA?
2. Add Multiple Tasks to a Macro
3. Undo, Saving and Distributing Macros
4. Macros and Security Settings
5. Editing and Deleting Macros
6. Remove Blank Cells with Macros

Read More

7. Absolute and Relative References
8. Problems with Pasting Text
9. Should I Learn to Program in Visual Basic?
Learning Certificates

Showcase Your Skills

Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.

When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Become A Data Citizen

Ready yourself for the rapidly changing world