Learn and Record your First Excel Macro in 3 simple steps
3.8 (54 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,682 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn and Record your First Excel Macro in 3 simple steps to your Wishlist.

Add to Wishlist

Learn and Record your First Excel Macro in 3 simple steps

Breaking Macro's Myth......
3.8 (54 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,682 students enrolled
Last updated 12/2013
English
Current price: $10 Original price: $25 Discount: 60% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 39 mins on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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
View Curriculum
Requirements
  • Microsoft Excel 2007/2010/2013
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.

Who is the target audience?
  • Working Professionals & Students
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 9 Lectures Collapse All 9 Lectures 39:06
+
Breaking Macro's myth....
1 Lecture 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.

Preview 04:26
+
Prepare your Excel to handle Macros.
1 Lecture 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

Preview 01:40
+
Let's Record your first Macro.....
5 Lectures 24:42

Way # 1: Status Bar


Way # 2: View Tab

Way # 3: Show Developer Tab



Preview 01:44

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.

Preview 10:10

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 "

Use Relative Reference
06:04

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.

Prepare a Monthly Report Macro
04:20

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.

Assign a Macro to a Shape
02:24
+
How to edit or delete a Macro
1 Lecture 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.

How to edit or delete a Macro
04:01
+
Security Settings of Macro
1 Lecture 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.

Security Settings of Macro
04:17
About the Instructor
Nurture Tech Academy
4.0 Average rating
350 Reviews
11,729 Students
5 Courses
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.