Microsoft Excel - Recording Macros
4.4 (13 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
83 students enrolled

Microsoft Excel - Recording Macros

Learn to build Macros to carry out repetitive tasks and learn to work with macros within different workbooks.
4.4 (13 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
83 students enrolled
Created by eLearnExcel
Last updated 9/2013
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 44 mins on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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.
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.
Course content
Expand 14 lectures 43:34
+ Recording Macros in Excel
14 lectures 43:34

This section includes the exercise files for Excel Macros. Please download these before you start the course.

Preview 00:46
Abolute and relative macros
03:41
Step into an existing macro
03:11
Copying a Macro from one workbook to anothe
03:32
Deleting a macro from this workbook
01:02
Record a macro to the Personal Macro Workbook
04:23
Deleting a macro from the personal macro workbook
03:30
Assigning a macro to a button on the sheet
03:48
Assigning a macro to an icon on a ribbon
04:09
Creating your own tab and ribbon
05:08