Microsoft Excel - Recording Macros

Learn to build Macros to carry out repetitive tasks and learn to work with macros within different workbooks.
4.8 (4 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.
38 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 14
  • Length 44 mins
  • Skill Level Expert Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2013 English

Course 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.

What are the requirements?

  • Advanced knowledge of Excel

What am I going to get from this course?

  • 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.

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Recording Macros in Excel
00:46

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

Opening the Developer Tab
Preview
02:02
Running an existing macro
Preview
01:51
Record a macro to this workbook
Preview
04:14
Saving a workbook that holds a macro
Preview
02:17
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

eLearnExcel, 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.

Ready to start learning?
Take This Course