Microsoft Excel - Recording Macros

Learn to build Macros to carry out repetitive tasks and learn to work with macros within different workbooks.

Created byeLearnExcel

Last updated 9/2013

English

What you'll learn

This course will help you learn how to work with and manipulate Macros recorded in Excel. It will introduce you to the VBA Development environment to make basic alterations to recorded Macros. The course also provides examples of useful recorded Macros.

Course content

1 section • 14 lectures • 43m total length

Introduction0:46
This section includes the exercise files for Excel Macros. Please download these before you start the course.
Opening the Developer Tab2:02
Running an existing macro1:51
Record a macro to this workbook4:14
Saving a workbook that holds a macro2:17
Abolute and relative macros3:41
Step into an existing macro3:11
Copying a Macro from one workbook to anothe3:32
Deleting a macro from this workbook1:02
Record a macro to the Personal Macro Workbook4:23
Deleting a macro from the personal macro workbook3:30
Assigning a macro to a button on the sheet3:48
Assigning a macro to an icon on a ribbon4:09
Creating your own tab and ribbon5:08

Requirements

Advanced knowledge of Excel

Description

This course focuses on how to record and re-use Macros in Excel without programming skills. You’ll learn to work in Excel’s Developer Tab and learn where macros are stored. You look at the differences between absolute and relative macros and how to move macros between workbooks.

Who this course is for:

If you are an extensive user of Excel, have completed Excel Level 3 – Advanced, and use the programme daily for completing repetitive tasks, then this course is ideal for you. Completing this course will save you many hours at work through the automation of tasks.