How to Use Macros in Excel | Step by Step Tutorial to Learn Macros in Excel in Hindi |

Поділитися
Вставка
  • Опубліковано 6 жов 2024

КОМЕНТАРІ • 548

  • @shivamkumar-od3ot
    @shivamkumar-od3ot 4 роки тому +49

    Kya samjhya hai sir ..🙏🙏🙏 mne bht vdo dekha h pahle is topic par lekin aapka jabab nhi..tnqqq..or advance leble pay batayega...plzz

    • @EasyExplain
      @EasyExplain  4 роки тому +6

      Arey vaah. Jarur.❤️👍🏻😊

    • @Amitsharma-lg1me
      @Amitsharma-lg1me 2 роки тому

      Mai jo payment bolenge vo payment krwa denge.

    • @simransurve1644
      @simransurve1644 2 роки тому

      @@EasyExplain When you shift the name column to the left, the job title column automatically got disappeared. I have a doubt here. Did you delete that column? Because when you applied same thing with Gender, the result was different from the previous one.

    • @tarunkhanna9571
      @tarunkhanna9571 2 роки тому

      9

    • @salonisethi6367
      @salonisethi6367 Рік тому

      @@simransurve1644 because i think he pasted the name column and gendee column was cut and insert plus

  • @MrKaushal001
    @MrKaushal001 4 роки тому +14

    Guys i dont know why this guy is not getting likes and subscription , You Nailed it my bro ... My request please keep continue with excels expertise in easy way .. I learned a lot ... Thanks a lot

    • @EasyExplain
      @EasyExplain  4 роки тому +2

      You're Welcome Brother. Thanks For Your Support. Keep Loving Keep Sharing 👍🏻❤️.

  • @mukeshk.tiwari5539
    @mukeshk.tiwari5539 3 роки тому +19

    Excellent way to explain... I had seen many videos, but none was at par with yours... Kudos!!! & Thanks

  • @anusharma5502
    @anusharma5502 2 роки тому +2

    Arey kyaa baat hai.. I didn't realize how well I would understand these macros in the Hindi version ❤

  • @prateeksharma277
    @prateeksharma277 Рік тому

    Thanku so much macro k video to bahut se logo n bna rkhe h bt save krne ka jo tarika aap n btya bahut hi excellent he. Really good video again thanks sir.

  • @UKJ28
    @UKJ28 3 роки тому +2

    Wow.. explained so sleekly...you are a great teacher..thanks for the helpful video..

  • @bijaykumarmishra7689
    @bijaykumarmishra7689 10 місяців тому

    Bahut dino ke baad ap ka video dekhne ka mauka mila

  • @dineshkumarachari8757
    @dineshkumarachari8757 Рік тому

    Ek number sir! short, simple and directly explain! super sir. pls continue more topics.

  • @ahadkmk
    @ahadkmk 2 роки тому +1

    Excellent way of explaining every step, i'am from Pakistan, it looks you're telling in urdu, very little use of typical and difficult words from hindi. I loved it. Full marks bro

  • @sohinichanda3766
    @sohinichanda3766 3 роки тому +2

    Amazing video, example of recorder was osm👍 I was searching for a video where I can hide/unhide rows through toggle,have you made any such video? Please share.thanks alot

  • @nalinijain3699
    @nalinijain3699 3 роки тому +5

    Best video I have ever watched. Thank you so much.

  • @meerhadi2127
    @meerhadi2127 2 роки тому

    You are doing such a great job you make every complex lecture easy for us

  • @avinashpushpan
    @avinashpushpan 2 роки тому

    this is excellent, the way you taught is very exceptional. thanks brother

  • @sunilnh3299
    @sunilnh3299 3 роки тому +10

    I will recommend this to everyone In my team, thanks

    • @EasyExplain
      @EasyExplain  3 роки тому

      You're welcome. Keep Loving♥️ Keep Sharing🔃

    • @thefunland2481
      @thefunland2481 3 роки тому +1

      Where you work bro??

    • @EasyExplain
      @EasyExplain  3 роки тому

      @@thefunland2481 it seems like you are from U.P. and were preparing for SSC exams and Railway exams. How did it go?🙂

    • @thefunland2481
      @thefunland2481 3 роки тому

      @@EasyExplain Cleared CHSL 19 waiting for descriptive result and waiting for NTPC result....But I don't want to wait bro.... Bro give me tips to start a career as data analyst

  • @gknizamani
    @gknizamani 3 роки тому

    Briefly and perfectly explained. You have gained a new subscriber from Pakistan. Thank you.

  • @9618015865
    @9618015865 3 роки тому +2

    Thank you sir, simple and clear explanation 🙏

    • @EasyExplain
      @EasyExplain  3 роки тому

      You're Welcome. Keep Sharing 🔃

  • @sandipsutar8751
    @sandipsutar8751 2 роки тому

    Thank you for this video. It is very useful in working of MS excell.

  • @shubhamshirsekar3519
    @shubhamshirsekar3519 2 роки тому

    I never thought to create macro is so much easy. Thank-you

  • @anthu22
    @anthu22 3 роки тому +1

    wav,,, superb informative video.. if we get explained like this during our studying time kaha rehte ham.. thank you so much..became your fan

    • @EasyExplain
      @EasyExplain  3 роки тому +1

      Glad To Hear that. Definitely you can be wherever you want to even today if start focusing. Keep Loving Keep Sharing 🔃♥️👍🏻

  • @shashankbhat227
    @shashankbhat227 3 роки тому +1

    Very thank you
    There was a big confusion in this topic. Thank you for solving

  • @shivnathgonea9410
    @shivnathgonea9410 2 роки тому

    Just loved the content.... Let me go back n start building the Macros 🙂😀

  • @AshishRawat_1
    @AshishRawat_1 Рік тому

    Thanks bhai month end pe Mera kaafi kaam easy hogayaa

  • @vaishnavityagi3788
    @vaishnavityagi3788 2 роки тому +1

    This video is so helpful for me thank you sir 🥰

  • @sheebaabrar4318
    @sheebaabrar4318 3 роки тому +1

    Sir you are superb... You explain with so clarity that anyone can learn it very easily... Please make more such videos thank you

  • @PankajSingh-ej9ii
    @PankajSingh-ej9ii 3 роки тому

    Ur way of. Medium is so easy and fantastic sir.. love u

    • @EasyExplain
      @EasyExplain  3 роки тому

      Keep Sharing 🔃♥️👍🏻

  • @prasadjoil5667
    @prasadjoil5667 2 роки тому

    Simply great explanation.. you have done this very easily understandable..👏

  • @impiyushgupta
    @impiyushgupta 3 роки тому

    Bahut badhiya pehli baar maine ek macro record kiya bhale hi tuccha tha but tha macro thnx dost

  • @amitgondale1364
    @amitgondale1364 2 роки тому

    Nice way to explain..Easily understanding

  • @deepakkumar-vy1xf
    @deepakkumar-vy1xf 3 роки тому +2

    Sir where is job title coloumn after shifting...

  • @VINAYSHARMA-ck7jt
    @VINAYSHARMA-ck7jt 2 роки тому

    Thank you for clear understanding

  • @jstips3558
    @jstips3558 2 роки тому

    Thank you sir I love your teaching way

  • @rahulsinghbhandari1370
    @rahulsinghbhandari1370 3 роки тому

    Thanks Buddy. It was very useful for novice to understand.

  • @vimalkmr951
    @vimalkmr951 3 роки тому

    Super Sir, Muggko daily ek report send karni hoti hai, mai last one year se macro se hi kaam kar rha hu

  • @monporoshneog4725
    @monporoshneog4725 3 роки тому +1

    Pls make a detail video on how to plot Live data in graphical form.. for example- time vs change in OI. THANK YOU

  • @hetalpandya8929
    @hetalpandya8929 3 роки тому +3

    Short, simple and crips! Great information, thank you so much!

  • @shrimpyyt1268
    @shrimpyyt1268 3 роки тому +1

    Have exams tommorow you saved me thank you

  • @payalsahu1786
    @payalsahu1786 3 роки тому

    I came here after watching 4 videos before...very well and easy explained...Keep making such videos...

    • @EasyExplain
      @EasyExplain  3 роки тому

      You're welcome. Keep Sharing 🔃♥️👍🏻

  • @AkankshaSingh
    @AkankshaSingh 2 роки тому

    awesome easy very easy thank you so much....

  • @saif-urrehman7815
    @saif-urrehman7815 4 роки тому +2

    Hi Sir,
    At first, I appreciate ur struggle and secondly i have one question, once i record the macro suppose for 10 lines formatting in excel sheet and it saved. But in next time, if I have the data spreading more than 10 lines i-e 50 lines in excel sheet, how macro will work for formatting of 50 lines if I run it as previously saved?

    • @excelonlineadvisor
      @excelonlineadvisor 3 роки тому

      No it won't work. You need to add some formulas too if you are not sure about the line (10/20 or may be 50) for the next time . Reach me on exceladvisoor@gmail.com for help.

  • @VM-it8pm
    @VM-it8pm 3 роки тому

    Very simple and easy to understand video.

  • @amittgupta4232
    @amittgupta4232 3 роки тому

    Thank u Brother u taught it in a very correct and decent way i like it very much

    • @EasyExplain
      @EasyExplain  3 роки тому

      You're welcome. Keep Sharing 🔃♥️👍🏻

  • @pintusharma8484
    @pintusharma8484 3 роки тому +5

    Thank you for this video. Can you also do video for Loop by using same data.
    In this we have only 10 line of items, if there is more data and we need to apply same formatting, how we need to do this. But we have recorded macro only for 10 line of items.

    • @reshmababugulbahadur6556
      @reshmababugulbahadur6556 3 роки тому

      You need to select all the data. as per my knowledge volume will not be a constraint

  • @rhisaria
    @rhisaria 3 роки тому

    Maja aa gaya yaar. Seekh gaya main. Kaam asaan ho gaya

  • @surajkuramvanshi6383
    @surajkuramvanshi6383 2 роки тому

    Thanks sir to excel in a simple way

  • @syedacreationmenhdidesign6819
    @syedacreationmenhdidesign6819 2 роки тому

    Aapka samjhane ka tariqa lajawab sab se hat kar

  • @manojshinde2539
    @manojshinde2539 3 роки тому +3

    Can we record PIVOT TABLES AND VLOOKUPS in macros?

  • @himanipandey3313
    @himanipandey3313 2 роки тому

    Nice video...great way of explaining..

  • @nakashali6928
    @nakashali6928 3 роки тому

    Wah G wah Akkash Gujjar
    I'm from Pakistan also Gurjar or Gujjar. Great teaching❣

  • @vaibhavsrivastava5165
    @vaibhavsrivastava5165 3 роки тому +1

    Very well explained...I have subscribed this channel in just 4 minutes of watching this video.
    Keep it up and please upload more such videos.
    You delivery is very nice and easy to understand👍🏽
    Thanks

  • @humabaqui3180
    @humabaqui3180 3 роки тому

    Thank you love to you
    Please insert more vedio about macro and devlapor

  • @deepsamanta13
    @deepsamanta13 3 роки тому

    Shandar jabardast jindabad kya samjhaya hai sir aapne Thanks a lot

    • @EasyExplain
      @EasyExplain  3 роки тому

      You're welcome. Keep Sharing 🔃♥️👍🏻

  • @syedshahbazhussain134
    @syedshahbazhussain134 2 роки тому

    Good explanation of the topic!

  • @JitenderKumar-vn8lh
    @JitenderKumar-vn8lh 3 роки тому

    Best Video.
    👍👍👍👍👍
    Can you pls prepare video on S Curve..????

  • @shankarbhagat9284
    @shankarbhagat9284 2 роки тому

    So well explained in detail

  • @SaurabhKumar-js5lh
    @SaurabhKumar-js5lh 7 місяців тому

    Macro ke liye bahut achcha banaya hai aapane aur Maine use bhi Kiya hai Lekin hamen ek Aisa micro chahie

  • @mohammedkhan4932
    @mohammedkhan4932 3 роки тому

    Nicely explained very cool and calm way.Thank you Sir.

  • @munafansari1957
    @munafansari1957 3 роки тому +2

    Amazing ! Thank you for this tutorial.

    • @EasyExplain
      @EasyExplain  3 роки тому

      You're Welcome. Keep Sharing 🔃

  • @Amitkumar-un1rk
    @Amitkumar-un1rk 4 роки тому +2

    Thanks sir
    Very easy explanation
    Keep it up .....

    • @EasyExplain
      @EasyExplain  4 роки тому +1

      Will sure do. Keep Loving. Keep Sharing.👍🏻❤️

    • @VBAExcelUrdu
      @VBAExcelUrdu 3 роки тому

      Also learn excel vba course

  • @rakshittiwary9901
    @rakshittiwary9901 3 роки тому +1

    Loved it... Learnt a lot of new stuffs

  • @swapniltoraskar8843
    @swapniltoraskar8843 3 роки тому +2

    Can we record countif, concatenate, vlookup, pivot functions in macros.

  • @yogendrabaghel2827
    @yogendrabaghel2827 3 роки тому

    Nice video.. easy to use for daily work

  • @chawdemramprasad9236
    @chawdemramprasad9236 2 роки тому

    super sir. nice teaching 👋

  • @niranjankumarjha1729
    @niranjankumarjha1729 4 роки тому +1

    Google sheet me macros kaise use karna hai ispe bhi ek series banao na aap please

  • @ranjanapant9084
    @ranjanapant9084 2 роки тому +1

    Subscribed you..very nice explanation.. i really want you to grow...If you will use English subtitles and green screen and other better quality of video..you will achieve heights.. because your content and explanation is very very good and precise...Also try to include situational points after the discussion. Amazing content again..kudos

    • @aadi9292
      @aadi9292 2 роки тому

      Agree very well said I feel the same

  • @atulatri2185
    @atulatri2185 3 роки тому +1

    Perfect explanation, thanks

  • @shreyanvi786
    @shreyanvi786 3 роки тому

    superb video..cleared in one shot.

    • @VBAExcelUrdu
      @VBAExcelUrdu 3 роки тому

      Also learn excel vba course in urdu

  • @souravchavan7730
    @souravchavan7730 2 роки тому

    Really good video. It would be helpful if you could please provide the data you used in the video.

  • @AshishRawat_1
    @AshishRawat_1 Рік тому

    Love i bro time bahut save ho gaya

  • @MrZubairSheikh
    @MrZubairSheikh Рік тому

    Bohat Awlaa Bhai Shukria..

  • @pranjmhatre1982
    @pranjmhatre1982 2 роки тому

    Thank you for this video. Can we add pivot table. Mcros not performing my pivot step

  • @aakashdreamer2605
    @aakashdreamer2605 3 роки тому

    Thank you frnd superb explanation ❤️

    • @EasyExplain
      @EasyExplain  3 роки тому

      You're welcome. Keep Sharing 🔃♥️👍🏻

  • @pragatibroadcastingonline34
    @pragatibroadcastingonline34 3 роки тому

    Your are very much clear & precise!Great.
    Now can you guide me????
    I have data of positive values & negative values in one same column & this is same in many sheets ( in one single work book)
    Now the problem is I need the sum of pluse & minus value separately in the main sheet,so that I can see what is the pluse total & minuse total of each customer in my main sheet

    • @kokab860
      @kokab860 2 роки тому

      Pay me 5000 I will do

  • @jyotichawla6262
    @jyotichawla6262 3 роки тому +5

    Can we use recorded macro in new excel sheet ?

  • @rizwan18147
    @rizwan18147 3 роки тому

    It was really easy to understand thanks

  • @TheBlackGem13
    @TheBlackGem13 Рік тому

    thanks for beautiful video

  • @yashkhilavdiya5693
    @yashkhilavdiya5693 2 роки тому

    Thank You So Much 🙏🙏

  • @sheikhasif422
    @sheikhasif422 Рік тому

    thank you brother explanation alhamdulilah

  • @therichbudget
    @therichbudget 3 роки тому +1

    Very well explained, Great going!

  • @SaiKumar-bv7nb
    @SaiKumar-bv7nb 2 роки тому

    Thank you so much sir.
    Muje poochna ta ki is me vlookup ya hlookup laga sakte he

  • @mdimran-iu9jw
    @mdimran-iu9jw 3 роки тому

    Now understood, agar mouse ki jagah saare shortcuts key use kre to records hogi?

  • @husnakhan4917
    @husnakhan4917 3 роки тому

    Very very useful thank u soo much sir. 😊(Video 9:34) Ctr+x k baad ctr+ paste k liye work nahi karta ..ctrl+V hoga ya toh ctrl +shift+ add karege column .

  • @RajendraSingh-bt1fc
    @RajendraSingh-bt1fc 2 роки тому

    Very clear.

  • @rupalmukhi1254
    @rupalmukhi1254 3 роки тому

    Hello! Can you please post a video on how to create KPI Dashboard using Excel?

  • @rajeshkharva633
    @rajeshkharva633 2 роки тому

    Great information

  • @mbilal429
    @mbilal429 2 роки тому

    keep doing good work, Love from Pakistan

    • @EasyExplain
      @EasyExplain  2 роки тому

      You're Welcome. Keep Sharing 🔃♥️👍🏻

  • @nazirmanek5785
    @nazirmanek5785 2 роки тому

    Thank you so much 🥰

  • @Rise_Shine0
    @Rise_Shine0 2 роки тому

    Thank u so much Sir 🙏

  • @cosmos7685
    @cosmos7685 2 роки тому +1

    Hello @easyexplain
    Can you please tell me how can I get default view of vba in excel when creating macros because by mistake I have clicked some options and now it is showing only blank screen.

  • @heershaikh7980
    @heershaikh7980 2 роки тому

    Vlookup with different sheet kaisa macros mai banane ka plz batai sir ek video banao sir

  • @saurabhsaxena8736
    @saurabhsaxena8736 3 роки тому

    bhai , ur videos are excellent and ur teaching methods even better . you deserve millions of followers .in my opinion only thing stopping you from reaching a bigger audience is the use of language. you video is in hindi and not everyone understands it. you should put subtitle in English. that way anyone in the world apart from india can watch n understand ur videos.

    • @EasyExplain
      @EasyExplain  3 роки тому

      You're welcome. Keep Loving♥️ Keep Sharing🔃

    • @skedu3756
      @skedu3756 Рік тому

      For English you can prefer other channels 👍
      Don't overrate other languages....

    • @skedu3756
      @skedu3756 Рік тому

      Even Sandeep Maheshwari/carry minati & Bhuvan Bam all are making videos in Hindi only and just because of Hindi they become popular...
      So plz don't try provoke people to dump their own languages

  • @VandanaSingh-k9l3o
    @VandanaSingh-k9l3o 7 місяців тому

    Oh my God ❤❤❤❤ thankyou so much

  • @vinayaksaraswat2.3m49
    @vinayaksaraswat2.3m49 3 роки тому

    Very good explanation

  • @Damarodam89
    @Damarodam89 4 роки тому

    Sir
    Koi naya table banana ho to ye process repeat karna hoga
    Ya fir ek baar macro record hone k baad hum aage b apply kar sakte hain kya...?
    Alag alag sheet ya new sheet pe kaise apply kre ye

    • @excelonlineadvisor
      @excelonlineadvisor 3 роки тому

      1 baar record kr k "Personal Macro" m save krna then duabra record ni krna padega. Reach me on exceladvisoor@gmail.com for help.

  • @gauravandroid7
    @gauravandroid7 3 роки тому

    Bro u r a superhero in excel

  • @vinitmaurya147
    @vinitmaurya147 3 роки тому

    Sir macro sirf 1 sheet pe hi hoga ya 2nd sheet pe koi data copy past kare to uspe bhi apply hoga .

  • @sameerkmr20
    @sameerkmr20 3 роки тому

    Best video on macro

  • @meeraservicenow2905
    @meeraservicenow2905 3 роки тому

    very well explained
    thank you

    • @EasyExplain
      @EasyExplain  3 роки тому

      You're welcome. Keep Sharing 🔃♥️👍🏻

  • @kiranvichke5375
    @kiranvichke5375 3 роки тому

    Easily explained. Thnx

  • @rajschannel9365
    @rajschannel9365 3 роки тому +1

    Well explained

  • @chandrimaghosh3638
    @chandrimaghosh3638 3 роки тому +2

    Just tell me one thing.suppose this data is for the month of January.What if I want to use Macro for the data of Feb n March?
    Do I have to record Macro again?
    Or simply a Run macro will do?
    Plz help me with a solution.
    Thanks🙂

    • @alankarsolanke5519
      @alankarsolanke5519 3 роки тому

      Same question i have , can i use recorded macro for next day Pendency report

    • @debasishbhowmick3018
      @debasishbhowmick3018 2 роки тому

      If rows or columns both are increases or decreased do same micro will work