Learn and Record your First Excel Macro in 3 simple steps

Breaking Macro's Myth......
3.8 (43 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.
6,681 students enrolled
$25
Take This Course
  • Lectures 9
  • Contents Video: 39 mins
  • Skill Level All Levels
  • 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 12/2013 English

Course Description

In this Learn & Record Macro video course, Nurture Tech Academy introduces you to the most simplest way to understand Macros and other Macros settings.

In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on, as he explains step by step how to record a Macro. The training starts with understanding what is a Macro. Then it will show you how to use show developer tab, ways to record a Macro, record a Macro, use Relative Reference, Create a Monthly Report Macro, assign a Macro to a shape, how to edit or delete a Macro and finally what are the security settings of a Macro.

By the completion of this online training course, you will be fully versed, and capable of Recording Macros in Microsoft Excel 2007/2010/2013 in a commercial Environment.

What are the requirements?

  • Microsoft Excel 2007/2010/2013

What am I going to get from this course?

  • How to record a Macro
  • Learn the technicalities behind recording a Macro
  • Suitable for beginners to advanced users. ideal for users who learn faster when shown.
  • This tutorial explained by Microsoft Certified Trainer
  • Macros explained in most logical and simplest manner
  • Downloadable exercise files for practical learning

What is the target audience?

  • Working Professionals & Students

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: Breaking Macro's myth....
04:26

The literal meaning of Macro is - on large scale, but do not confuse this with that meaning, in Excel, Macro means recording your actions and to play those recorded action in future by hitting the specified keystroke on your keyboard or toolbar button or an icon in a spreadsheet. It means that whenever you have some repetitive work to perform in Excel e.g. a daily, weekly, bi-weekly, monthly, quarterly report etc. then while preparing that report for the first time you can just start the recoding of the macro and start doing your work to prepare the report and after finishing the same you can just stop the recording and you are done….. So whenever in future, if you want to create that report again just hit the keystroke you assigned to that macro and Excel will take from few seconds to few minutes to prepare that report which you have created in hours.

One of the most beautiful features of Macro recording is that while recording is turned ON and if you leave your computer for another hour or two or whatever time, Excel will not record anything, because as I already mentioned earlier that Macro will record only your actions.

Section 2: Prepare your Excel to handle Macros.
01:40

    Excel 2007 users –

    -Click the Microsoft Office Button, and then click Excel Options.

    -In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

    Excel 2010/2013 users –

    -Click the File tab

    -Click Options, and then click Customize Ribbon

    -In the Customize Ribbon category, in the Main Tabs list, select the Developer check box, and then click OK

Section 3: Let's Record your first Macro.....
01:44

Way # 1: Status Bar


Way # 2: View Tab

Way # 3: Show Developer Tab



10:10

By going through from any of the above ways you will see a “Record Macro” dialog box on your screen. You can see in the dialog box the first thing required to fill in is “Macro Name”. Let me tell you guys that before giving any name to your Macro just keep in mind few things that name can not contain any spaces or any special character. You even can’t give a name which starts with a number but yes after starting a name with an alphabet you can use numbers. Just try to write a name which is crisp and meaningful. So let’s say we want to record a Macro that will write our name in an active cell. So, let’s give this Macro a name as “Name1”.

Now we need to provide a shortcut to this Macro. Now again few things to take care of before you choose any shortcut, you can see that in the dialog box it is written as “Ctrl + “i.e. if you write any alphabet in the box, that alphabet with control key will be the shortcut for this Macro. But keep in mind one thing that almost every alphabet is already assigned as a shortcut with control key e.g. if I use “C” than “Ctrl + C” will be the shortcut to run this Macro in future and this in turn means that this will replace your default shortcut i.e. in future if this workbook is opened in which you will store the macro and if you will press “Ctrl + C” to copy any content (which is a usual thing) but instead of copying, Excel will run this Macro. So, now the question comes that how we can assign a shortcut key?..... the answer to this question is, instead of just pressing an alphabet on your keyboard , press “Shift + alphabet “ e.g. in this case we will use “Shift + N”.

Where to store the Macro? (As I told you earlier, that whenever we record a Macro, only your actions will be recorded and in the backstage of Excel, these actions will be saved as different statements. So what happens is, whenever we run the Macro, Excel execute these statements one by one so quickly that it perform all the task in few minutes or few seconds) so if excel is asking you that where to store the Macro, it means that where you want excel to store the coding.

In this drop down you will see three options - This Workbook, New Workbook & Personal Macro Workbook.

For our example, let’s choose “Personal Macro Workbook”.

The last part of this dialog box is Description. As we can’t explain everything about the Macro by its “Macro Name” so we can use “Description”. This will help us to know which Macro will do what.

Now just press ok and the recording will start. You can also see the color of the Macro recorder (in the left corner of the status Bar is changed to Blue).Now just type your name in the active cell and then press enter. After doing so just stop the recording.

06:04

Macros by default works on absolute references i.e. whenever we record a Macro, excel will automatically save the address of the cells in the coding so if we want excel to work on relative references we need to select "Use Relative Referance "

04:20

Let's prepare a Monthly report Macro. After going through with the video just follow the steps in your system and prepare an identical macro. If you encounter a run-time error while playing the Macro then don't panic. You may have done something wrong, so just record the Macro again with another name and run the same again.

02:24

Now let's see how to assign a Macro to a shape. In this lecture we will learn how to assign a Macro to a shape and make a clickable shape.

Section 4: How to edit or delete a Macro
04:01

As we have recorded a Macro in Personal Macro Workbook, we need to first unhide the workbook first and then we can easily edit or delete the same.

Section 5: Security Settings of Macro
04:17

It is really important to understand the security settings of a Macro because on the basis of which security settings you choose on your computer, you will be able to run the Macro enabled files.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Nurture Tech Academy, Microsoft Office Specialist

Nurture Tech Academy (http://nurturetechacademy.in/) is Microsoft Authorised Testing Centre, providing blend of instructor-led and online training programs in Basic Excel, Advanced Excel, VBAs, Macros, and other MS Office applications. It has a team of Microsoft Certified Trainers who are specialist in their respective fields.

Ready to start learning?
Take This Course