#1 Excel Hack : Macro Recorder Tool | Bhaumik Shah | Skillshare

Playback Speed


  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

7 Lessons (21m)
    • 1. Intro

      0:49
    • 2. Macros overview

      2:35
    • 3. Recording macro

      6:51
    • 4. Running macros

      4:02
    • 5. Macros with button

      3:55
    • 6. Saving macro

      2:25
    • 7. Course end

      0:51
  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

41

Students

--

Projects

About This Class

Enroll in this course and learn to automate your routine task in Microsoft Excel with the help of Excel Macros!

During this course, you'll learn different ways to automate your repetitive and boring task in excel within a few minutes. Eventually, in this course, you'll learn to automate any task within Excel using a macro recorder. In this course you'll learn three different ways to automate your task in Excel which are as follows:

  • Using the Macro Recorder Manually
  • Using Button and
  • Using Short-cut key

By the end of this course, you would be able to use all these three ways i.e. Macro recorder, short -cut key and button to automate your repetitive task in excel.

Meet Your Teacher

Teacher Profile Image

Bhaumik Shah

Data Science Guy and Freelance Designer

Teacher

Hello, I'm Bhaumik, I am a Data Science Guy , freelance designer and analyst. And I have sound knowledge of widely used analysis tools such as excel, R , SAS , SQL etc.  And I have worked with great numbers of clients from around the world professionally as a freelancer. So i think i can share my knowledge and experience here and enrich learners with great skill set here and learn something new from them. 

See full profile

Class Ratings

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.

Transcripts

1. Intro: Hello, everyone, welcome you onto this course. Now this course is basically regarding or donating your task, which is kind off repudiated with nature. So say if you are daily dealing with their ability task at your work, which you would like to automate using extent than this poses for you guys so you can use Excel macros functions, and you can easily order with your desk using it. So in this course, you would be learning how to exactly recorded Micro's. And what are the different ways through which you can record a macros in Excel for automating your task, which is kind off a repudiating, so not wasting any time, Let's get started. 2. Macros overview: Hello, everyone. Now to this class is basically to make you aware Off Excel Macros Micro recorder is basically used for automating any task which is kind of repetitive in nature or any task which you want to get rid off. So for such things, you can use Excel macros for automating any off their task. We just got off repeated Do so, guys, you can see this morning that were here, and yeah, one thing I would like to tell you guys is you can download this excel file from the file section off this glass. But guys, you won't be finding the header along with the former ring. Don't do that as it's for you guys to practice. So yeah, you can see this morning late hour here which shows different countries and their profits in different quarters. Now, this is just for an example, and this is a small later, but say at your work you are receiving large data and on your down daily basis, but kind off its structure is remaining the same. But whenever you Lord that filing to excel, you wouldn't be having this header along with former Ting. Don't do that. So unit to generate it again and again over a period of time and say, If you want to or do it, that does, then you can do it using Excel Micro's. Now you can see this header over here with forming Don't do that. And so, if you want oh, run it, using manually through macros that also you can do it. But if you want to use a shortcut key for generating header along with former Tinto that and like within less than a second, then you can use your shortcut key. So I'm using a shortcut gear here, and you saw that guys like within less than a second this header, along with former thing God generated. So it's that easy, guys, Using Micro's, you can automate your experience, and so if you are not comfortable with shortcut key and you want to get it just by clicking one burden so you can see this button over here by just clicking this button, we'll head there and along with former thing will be there within no time. So now we will click this button and you can see like this whole headed along with vomiting . God generated within no time. So believe me, guys using this micro's, you can save your time and money like anything. So in upcoming classes we will see how exactly they can do it using Micro's. 3. Recording macro: Hello, everyone. I hope you all are doing good. Now in tourist class, we will see how to exactly like art of Micro's using micro function in excel. So before starting, one thing which I would like to tell you guys, is to download this Excel file from the file section off this class so you can start practicing it along with me. And you would be getting a better understanding of how to exactly Recorder Micro's. So after that, you can experiment with it and can have a better hand on it. So now you can see this dude, our here, which shows different countries in the profits in different quarters on this one, is the total off the profits in different four borders. You can see there is no head over here. So we need to add this header and we will start recording about micro there. So, first of all, we need to click on this view option on the top and on the top, right. You can see this micro's option within it. There is this record macros. So we will click on this and you can see this box God created which we need to fill in a few details. So most of all we need to fill the name. You can select any name off your own choice on you can create a name which you would like toa stores of micro name and one thing which you need to keep in mind. Er's don't leave any kind of space in between else it will show up in an area. So for now, I will keep it as head of. And then after you can see there's a shortcut key option. Now it is an optional option in case you want Oh, Children, your macros using a shortcut key. Then you can use it again. You can create any shortcut here of your own choice, and you can also see, like this shift along with any alphabet which you want to use as a shortcut key like this, or else you can do it without the shift. So far Now I won't be using in a shift option, so I'm just using control. Pill S e is always short, good key. And after that you can see this pre options in storm a cruising The 1st 1 is personal micro workbook and other two are new in this workbook. Now you will be thinking What is the difference between this three now? Personal micro, What book is open whenever you open your excel file in your laptop or desktop? So whenever you open your excel, your personal micro MacBook is active. So in case if you want to reuse that micro's in too many places are like if if you want to use this micro for again and again over a period of time, then you can use this person microgram poop option on. After that you can see this new workbook. It will be created at the time of recording of brand new. A book will be created in the last one. Is this workbook option now? In case you want to record of Macron's just for this active file on which we are working on right now, Then you can use this workbook option. So if you give you excel, file the saved one point to anyone else then that micro will be there in that file. But say if you close this Excel file and if you open the new Excel file again then there won't be that old savoring do that. So for now, we would be using this workbook as we won't go music for this file only. And here we need to add a little description in brief. So I will read it as Ordo meeting Cruz Creation Automating head of creation. Yes. So now we are done with feeling off each and everything in this box. So now we can click on this. Okay, But one thing which we need to keep in mind before clicking okays whatever you would be doing after clicking ok will be noted down by the micro's. So get that pointing mind like even if you're clicking on some cell on it would be one or any other self. Macron's would be noting that down. So keep that point in mind and no real click on this. Okay, Borden. So you can see this small white box on the bottom left and that it's showing that you have micro oil has started recording your moment. And you can also see this stop recording option in this micro's, which shows that your micro is in recording more. So now we will start recording about my clothes. So here we will keep it as a country. This one has quarter one. What it do ordered three waterfall. And this one is total. So long we will do a little bit off for mating war here. So we will go to home on will select color and it was bowled over here. So we are done with the formatting and you can do a little bit off more for mating and added if you would like and I would argue guys toe do a little bit off more experimentations with this automating tasks, you can do anything off your own. Joyce, this is just a example which I'm showing over here so you can do a lot more with the automation thing. So for now, we are done with automation thing. So we will now stop the micro recording. Yeah, One thing, after creating or all the task which you would like to automate. One thing which we need to keep in mind is to stop your recording else. Micro's will keep on recording each and everything. So now we will stop this recording either you can stop it from here. Oh, are you can goto this beauty and you can click on this Stop recording. So, no, we will click on Stop Recording or here and Over Micro has been recorded. So in our next class we will see the further straps, which we need to do. So that's it for today, guys. 4. Running macros: So, guys, we are done with the creation off First Micro's and I hope you guys enjoy the process. And you did it along with me in order to have a better idea of how to exactly record of Micro's. Now what we did in our last class is we created the headers and read a little bit off for mating. Now, in case you missed that, plus are you don't recall or if you're watching a video after a long time, then I will show you in Bring forth We exactly did. So first of all levels like this view options. Then we will go to this micro's It was recorded his micro's over that even filled this. Dictators over here create your own or selector on micro name created a shortcut key. Select any off the options from this tree like personal micro. What book? If you want to reuse that micro's again in future New A book will create a brand new workbook while Recording Micro's and this workbook in case you want to record it. Young Micro is just for the active file on which we are walking right now. So for now they will use this workbook option and you need to provide a little bit off description over here and then click on this. Okay, over here. So after you click on OK, keep one thing in mind. Micro would be recording each and every off your step. So if you are selecting a cell Micro would be keeping note off that. So keep that finding mine. So after that, we will create this header and we will do for mating. And after that we will stop that Micro's one white box will be there when you will stop the micro's oh are. You can directly goto this macro options and in the second option will be off. Stop recording. You can go to that also and stop your micro's. That's what we did in our last class. Now, if you are daily receiving or did I'd your walk your data, which has the same structure, little structure that you can easily get rid off, creating that header along with vomiting again and again by using a shortcut key which we used for creating or micro's. So now, with just one click of our header along with for mating, will be in front offers so you can see here guys like within. No time I don't along with for mating is visible towards and in case like if you are not comfortable with using a shortcut key or if, like you forget what good keys after some time. Then you can directly goto this micro's option and you can see like this View Micro's, but you can see or hear you can directly go there, and you would be able to see all your micro's that you have recorded over here. So as you can see, we have recorded this header growth. So we will see, like the micro's over here on very plea condoms run option on, as I have already created this micro, so I won't be doing that same case. If you haven't used a shortcut key, then click on this run and Macron's will be there. And there won't be any difference between these two options. So you saw guys that you can either use a shortcut key or you can manually goto back rows and select the option for running your micro's. So in this two ways, you can easily on your micro's, and there is one more way to recorder macros by using just one button. So as if you are not comfortable with using both the options off. Using a shortcut, he are going to macros and manually do that process. Then you can use the corruption, which is using a button seen over next class. We will see how to record of Micro's or how to create a little along with for mating by using just one button. 5. Macros with button: so guys love we saw how to run over Micro's either using a short Karki are by manually going to Micro's and selecting a particle of micro's and running that bank rose. But if you're not comfortable with his options as you keep on forgetting the shortcut keys like the manual processes big longer, then you have one more option along with you during your Mac rose. Yeah, you got it right. It's by using but an option. So by just clicking one button, you won't be able to run your micro's. And in this case, you would be able tow run your macros and you will be able tow. See your headers around with the formatting done that. So there will be one button over here. You just need to click on that button, and your microbes will be running over here. So now exactly, we will see how to do that, how to create that button and how to run that micro's. So first of all, we need toe klik right on the top in a few option. Also, you can legal right on the top, and after that you will be able to see this customized here even option over here. So you need to click on this option, and this box will be visible entrant off you within it. If this customize ribbon is not elected, then please like this button. After that, you would be able to see this box over here in this unit toe plate. This right, this double production. So you need to take on this developer. If it's on take, then take that month for me. I already activated that. So it's all very ticked over here, and we need to click on this, okay, after that. So after that, you would be able to see this developer option on the top. So we need to select this devil of corruption, and you would be able to see this introduction or here below deliver. You need to select on that option, after which you would be able to see many options would be visible in front of you. What? You need to select this first option off button as having a rock. Shit. First of all, I will go to this ship so you can see this is the same data with the different countries and their profits in different quarters. and all So again I will select this introduction on will like this button option or here and I will create my button over here. So now you can see these macros, which we created earlier. So we will assign this micro Stover but it so we will select this micro's and we will click on OK, over here so you can see this, but God created. And if we can also change its name as of a butter is related to creating a header limiters head up on now just by clicking this button over microbe would be learning and you would be able to see the header on the top. So now we will click this header option and you can see this header God created within no time. So these are the three options which we can use for running Roma crows. I don't using a shortcut key or by manually running the macros. And the corruption is by using one button option. So by clicking that button, you will be able to run your micro's. So I would add you guys to experiment with all these three options and dry out through things in a different way. So you would be having a veteran restraining off this three options. So that's it for today, guys. 6. Saving macro: So, guys, we are done with the recording and running off. First man grows in three different ways, and I hope you guys enjoyed the process and hid it along with me. Now the important thing is regarding saving along micro file. So if you are using aversion between 2007 or the new, avoid Asians, then you need to save your macro into a macro enable file like Microsoft made changes for the 2007 versions and the newer versions that came after that, like 2010 13 and 16. So if you are using any off those visions, then unit to save your micro file as a micro animal file instead off Justin Excel friend, that is excellent sex. And if you click a save button, then it will show you an error, and it will. Elliott and your file contains of macro, so you need to save it as a bank rose on in case if you just try to save it as a normal Excel file, then the next time you open your Excel file, you won't be having those cores, which you say Vinto Micro's and you will be losing all those ports. So now we will see what happens if I click on this. Say about it. So now we will click on this. Say what? No, here. And you saw that Microsoft shoulder and enter. And it's saying the following features cannot be saved in macron three workbooks to save a file with this, which is no and then choose a micro animal final time in the file type list. So here women flick as no over here and you can see this option for the normal except for that is dot XLs X. But we need toe save it as micro enable for file so you can see over here. So that is dot excel sn. So it stands for micro enabled workbook, so we will save it as grow anybody workbook file So this is an important thing which you need to keep in mind while saving of micro and workbook five so now were played on the same button and we will say it has a macro and even fight. So this is an important thing to keep in mind that you need to take care off while saving your micro enable Fine 7. Course end: So, guys, here we are due the end off this shot Excel macros course in which you learned how to record a micro's in different ways and to run it using a shortcut key or using a bottle on by manually going through Micro's and selecting macros and running that micro's. So you can easily use this macro function for automating any of the tasks that this kind of repeatedly with nature and your world, which you would like to automate using this excel, and it will help you save a lot of your time. So all the best to you on and enjoy this amazing feature off Excel, which is macros and save a lot of your time and make your life simpler.