Microsoft Excel - Recording Macros
4.6 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
46 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel - Recording Macros to your Wishlist.

Add to Wishlist

Microsoft Excel - Recording Macros

Learn to build Macros to carry out repetitive tasks and learn to work with macros within different workbooks.
4.6 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
46 students enrolled
Created by eLearnExcel
Last updated 9/2013
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 44 mins on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I 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.
View Curriculum
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 is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 14 Lectures Collapse All 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
About the Instructor
eLearnExcel
4.4 Average rating
151 Reviews
1,769 Students
6 Courses
Leading provider of Online Excel training

Our online eLearning courses build on 20 years experience of classroom training. Training is our business. The courses are delivered by our expert tutors and we know where topics become complex and need better explanations because we see it every day in our classrooms.

Some of the world’s most prominent businesses choose us to teach their employees Excel – including Google, Facebook, Pfizer, Zurich, Aer Lingus, Allianz, HSBC, Intel, Dell, KPMG – even Microsoft use our Excel courses to train their employees on Excel.