How to Use Macro in Excel in Hindi

Поділитися
Вставка
  • Опубліковано 21 лип 2019
  • Learn How Macros Can Speed Up Your Excel Office Work दोस्तों इस विडियो में मैंने Hindi मे एक्सप्लेन किया है की किस तरह आप Excel में Macro का बेस्ट यूज़ करके अपने घंटों के Hard Work को मिनटों में सेकण्ड्स में कर सकते है | Excel में #Macro अच्छे से सीख लो घंटो का Hard Work चुटकियों में होगा | How To Use Macros In Excel in Hindi उम्मीद है आपको ये विडियो जरूर पसंद आएगा | How Macros Really Speed Up Your Excel Work in Hindi #Macroinexcel #excelmacro #exceltutorial excel 2007 2010 2013 2016 2019 2021 tutorial
    Macro videos:
    how to automatically transfer & Save data from one sheet to another using macro • How to Automatically T...
    How To Make ADVANCED FILTER Dynamic || Auto Updating || Filter To Another Sheet using macro • How To Make ADVANCED F...
    How To Automatically Transfer Current date Data To Another Sheet In Excel || Using Advanced Filter with macro • How To Automatically T...
    EXCEL में Boss को करना है Impress 😎 तो Macro का ये Magic सीखो • 😮 EXCEL में Boss को क...
    Excel के ये 2 interesting Macros आपको Excel में Smart बना देंगे - auto_open & auto_close • Macro in Excel || Exce...
    My Channels :
    A to Z Excel : bit.ly/3hQCRiw
    Deepak Techworld : bit.ly/3qFrbl5
    Deepak EduWorld :bit.ly/3zWWtIS
    Deepak Nehra : bit.ly/364SVGV
    MS Word Complete Course : • Microsoft Word A to Z ...
    MS PowerPoint Complete Course : • MS Power Point Tutoria...
    #Macro
    #MacroTutorial
    #VBA
    #DeepakEduWorld
    #2021
    #HowToUse
    #ExcelTutorial
    #LearnExcel
    #Excel_online_course
    #Microsoft_Excel
    #How_To
    Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
    Deepak EduWorld Playlist's:
    POWERPOINT COURSE ►
    • MS Power Point Tutoria...
    ADVANCED EXCEL ►
    goo.gl/A6LdZA
    ADVANCED EXCEL FORMULAS ►
    goo.gl/bbHYu2
    EXCEL TIPS & TRICKS ►
    goo.gl/wAj1jh
    MS WORD ►
    goo.gl/B4TeSA
    HTML5 & CSS3 ►
    goo.gl/2PFgs8
    COMPUTER TECHNICAL videos ►
    goo.gl/paZmpn
    AUTOMATIC INVOICE IN EXCEL ►
    goo.gl/dFhg54
    PHOTOSHOP ►
    • How To Make Passport S...
    Subscribe Deepak EduWorld ► / deepakeduworld
    Instagram ► / deepakeduworld
    Facebook page ► / deepakeduworld
    LinkedIn ► / deepakeduworld
    Facebook Group ► / deepakeduworld
    Tags : macro in excel in hindi,macros in excel in hindi,Excel Macros,macro in excel,macro in excel,excel macros,macro excel,macro in excel for beginners,how to use macros in excel,how to use macro in excel,excel macro,record macro in excel,macro in excel 2007 with example in hindi,macro in excel 2013 with example,deepakeduworld,deepak eduworld in hindi,Office Work,computer user,excel tricks,advance excel full course in hindi,excel

КОМЕНТАРІ • 930

  • @aknumbergyan231
    @aknumbergyan231 5 років тому +5

    Nice Video sir, After watching your daily video I am also trying to teach through youtube.

  • @harman530
    @harman530 Рік тому +61

    Kl practical h mera aj dkh rha hu😂🤣

    • @debnath.ipsita
      @debnath.ipsita Рік тому +3

      ho gya bhai tumhara practical? 😂

    • @arpitsharma5275
      @arpitsharma5275 11 місяців тому +1

      Wow ho gaya hoga ab to practical

    • @harman530
      @harman530 11 місяців тому

      @@debnath.ipsita hn bhai hogya kbka 😂

    • @harman530
      @harman530 11 місяців тому

      @@arpitsharma5275 hn bhai

    • @shravanwadhwaa
      @shravanwadhwaa 11 місяців тому

      ​@@debnath.ipsitaBhai abb tak toh 2 baar hogya hoga

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

    I believe this is the easiest way to learn macros. Thanks dear. U did great job.

  • @GizmoGallant
    @GizmoGallant Рік тому +2

    Great information dude,.....After working on excel for 14 years, Today i learned the macro with simple and powerful style

  • @sachinjain5698
    @sachinjain5698 5 років тому +7

    Hi deepak.. great tutorial on macro specially on dash board part...can you make macro video on formulas?? I have to prepare a report every week which requires same repeated formulas but data count is not fixed.

    • @DeepakEduWorld
      @DeepakEduWorld  5 років тому +1

      Next video is coming on dynamic macros

  • @anitaarya5174
    @anitaarya5174 4 роки тому +4

    Thank you for explaining it in such a simple way

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

    bro ek baat acchi ye hai ki aap bht hi simple se samjhate ho bina koi technical terms ke that is very amazing and mind blowing thank you so much

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

    daily sales tax ki invoices ki formating one by one krni prti thi but apki video dakh k ab wo kam 5mint ka rh gya...gr888 ...keep it up....thnx ♥️

  • @09shirish
    @09shirish 4 роки тому +3

    I've seen every tutorial and i've learn so many from you ! thanks Sir ! Sirji i've created data validation list in excel sheet, the list is appear on my laptop, but i copy the same file on my pc the tag which is not display ! pl told me solution for appearing this list !

  • @VishalSharma-wj6up
    @VishalSharma-wj6up 4 роки тому +3

    You are genius bro. I have been struggling in excel but your tutorials helped me a lot.
    Thank you so much 🙏🏻

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

    बहुत बढ़िया
    धन्यवाद

  • @DrRaghunathSinghRanawat
    @DrRaghunathSinghRanawat Рік тому +1

    बहुत बढ़िया जानकारी दी गई है ।

  • @VickyT2843
    @VickyT2843 5 років тому +7

    Deepak ji,
    Please VBA series start karo. We are Eagerly waiting for this.

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

      जी सर vba सीरीज स्टार्ट करे जल्द से जल्द

  • @vasalji
    @vasalji 4 роки тому +3

    Excellent lesson, well explained in simple language. I have a small business with about 50 accounts. Will try to create Macros for all these accounts and paste these Macros in the new sheet for consecutive months. Let me see if I can derive the benefit of this technique. Thank you so much for your guidance.

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

      please wait .. i ll publish another video shortly on this topic 👍

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

      @@DeepakEduWorld Ok Sir. Actually I am looking for formula for regularly updating data from one Excel file to another. I have clients who avail of our service on day to day basis. I keep their account in one file and I send them consolidated bill at the end of month. For this I use another file named Bills. For this purpose I make separate Excel files every month for each customer and copy data from Daily file and paste in Bills file.

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

      If you can contact us, we can explore more options, even we can automate some of the tasks.

  • @DeepakEduWorld
    @DeepakEduWorld  5 років тому

    VBA ke bina Dynamic Data ke liye macros kaise record kar saktey hain? Next video is coming soon 👍👍👍

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

    दीपक जी यह बहोत अच्छा वीडियो है, बाकी मे उन लोगो से पूछना चाहता हू जिन्होने इसे दिस्लयिक किया है, भैया क्या कमी है इसमे जरा बताये?
    दीपक भाई आप ऐसे ही वीडियोज़ बनाते रहिये।
    This will be very helpful for some peoples. Keep it up.

  • @paruljoshi3770
    @paruljoshi3770 5 років тому +3

    💃💃💃 first 😊😊😊

  • @mohamedadjal8502
    @mohamedadjal8502 3 роки тому +7

    Hi, Professor, you have provided a lot of effort for these videos, thank you, I have a question in excel, if we have for example in cell "a1" the number 10.00 m, how to have this number in the same format in cell "b1 "using a text function or some other function, thank you very much.😃👍

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

    Thank you in million way sir,
    You used very easy word to teach us

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

    Hello, your videos are good and informative. I want to know how to extract data (mainly forms which are in PDF files) and get them organized in Excel using Macros. Could you please help me with that?

  • @ayeshaKhan-dd4dg
    @ayeshaKhan-dd4dg 5 років тому +19

    Very good sir Thanku sir Microsoft Word 2019 Window7 Mai installed krna sikhaiye thanx

    • @DeepakEduWorld
      @DeepakEduWorld  5 років тому +2

      G

    • @ayeshaKhan-dd4dg
      @ayeshaKhan-dd4dg 5 років тому +1

      Hello sir how are
      Sir Mai apki excel tutorial play list check kr rhi thi Ek video Mai Apne Excel PowerPoint MS Word file ko pdf Mai convert krna sikhaya hai as it is apko follow kiya but after pdf I noticed ke after pdf menu bar tab Wha show nhi ho rhi hai like as creat tab, tool tab why? App whatapp Msg read kr liya kre mujhye problem hoti hai kisi bhi tutorial Mai Mai Jb apko Msg krti hoo I hope you will response Thanku

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

      और व्

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

      Thanks

    • @rohitsharma-lt3yc
      @rohitsharma-lt3yc 2 роки тому +1

      Good afternoon

  • @ThePrady19
    @ThePrady19 4 роки тому +3

    I need the bookkeeping excel sheet with double entry system effect

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

      Could u plz help me
      Or. Develop one for me

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

      Sir betting software ka formula kya h

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

    fantastic... learnt a lot about macros... you are very helpful Deepak Ji in teaching these kind of a stuff... thank you so much for your effort....

  • @prakashkumar-tf9nt
    @prakashkumar-tf9nt 5 років тому +1

    Excel mein MIS par bhi video banaye sir please...maine aapka sabhi video dekha hai...mujhe bahut fayeda huya...you are real teacher....Ek interview mein 'MIS" par question puchha gaya par mujhe MIS nahi aata tha... please Excel MIS par full video banaye..🙏🙏🙏🙏

  • @shanukumar87
    @shanukumar87 5 років тому +3

    Deepak sir I need to record a macro in which data range will increase every day but the task remains the same. Please tell

  • @SumerSinghRathoreJi
    @SumerSinghRathoreJi 5 років тому +4

    I want to update daily stock through outward and inward challan automatically as per vendor by entering only challan details, please suggest link or file

  • @a.k.r5787
    @a.k.r5787 2 роки тому +1

    The way you teach it's a completely different from others which is easy to understand

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

    Amezing . Itna achhe se aap bole ek bar mein samajh aageyi
    Really.👍
    Keep it up.

  • @swatigera3221
    @swatigera3221 5 років тому +4

    I request you to please upload a video on advance use of For loop, while loop function in VBA. If you have already uploaded then please share the link.

    • @yatra_darsha.n3786
      @yatra_darsha.n3786 4 роки тому

      Swati agar aap ka ye loop wala video aya ho to please link share kar do

  • @DeepakEduWorld
    @DeepakEduWorld  5 років тому +31

    दोस्तों ये वीडियो आपको कैसा लगा ? आपके मन में जो भी विचार है हमें Comments मै लिख के जरूर बताएं 🥰
    *My New Channel :* bit.ly/3qFrbl5
    *Complete Microsoft Word Tutorial :* ua-cam.com/video/Xkq0-xXAj48/v-deo.html
    *Complete Powerpoint Tutorial :* ua-cam.com/video/OekrBhNybP0/v-deo.html
    *Xlookup Complete Tutorial :* ua-cam.com/video/0LjfRVD7srU/v-deo.html
    *Vlookup Complete Tutorial* : bit.ly/2K0C1Sb
    *Excel All Formulas :* ua-cam.com/video/C9y53fedo04/v-deo.html

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

    Thank you deepak sir🙏it means alot for me

  • @HR-uw8gq
    @HR-uw8gq 4 місяці тому

    Bhut achi video smjhane ka tarika bhut acha 10/10

  • @CA-Jyothi-lifestyle
    @CA-Jyothi-lifestyle 5 років тому +4

    Hi sir. I have interview tmro can u pls cl me to guide about excel pls

    • @DeepakEduWorld
      @DeepakEduWorld  5 років тому +1

      Advanced formulas.. Vlookup index match sumif sumifs countif countifs hlookup if etc and basic formulas

    • @DeepakEduWorld
      @DeepakEduWorld  5 років тому +1

      Page layout, macros, data validation,, sort filter advanced filter conditional formatting etc

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

      ua-cam.com/video/4bT2TtjK1GM/v-deo.html

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

    Video starts from 2.00
    Thanks me later😜

  • @ZiNDaGi_M_12175
    @ZiNDaGi_M_12175 7 місяців тому

    Mein apko Pakistan se dekhta hun
    Thankss Sir Ap bht behtreen tariqe se samjhate hen .
    I Love from 🇵🇰

  • @thinking-Mann
    @thinking-Mann 4 роки тому +1

    Thank you for making and sharing helpful video in simple way.I am going to watch your rest of the videos.👍🏼👍🏼

  • @meetsweet9522
    @meetsweet9522 4 роки тому +4

    just you need speed with key board

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

    thankz yar you are a good teacher for me brother lots of loves and respect from pakistan peshawar

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

    Achchi video banayi hai sir, thanks

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

    Bhai tusi great ho humko smjh ni aa rha tha lakin ab aa gya thnq bhai

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

    Really good video, first time i saw a video with full and only information. Great Sir thanks for sharing your knowledge to everywhere 😊

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

    बहुत बढ़िया जानकारी दी गई है, धन्यवाद ।।

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

    Thankyou sir. Aap bilkul easy way me explanation krte hai.

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

    Very Nice Video Useful Information

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

    Deepak sir Allah Apka bhala karay buht asaan tareeqo se samjhaya bua h ap ne sab kuch. Ghar bethay itna sab kuch sekha dua ap ne. Kush raho bhaiya

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

    Thank you sir apke vedio se mujhe excel ka knowledge prapt hua

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

    Wow ! Bahot achchha👍👍👍

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

    Very nice...
    I understand very well..
    Now I wanna learn VLookup & HLookup function..
    Will u pls ?

  • @harshsharma2585
    @harshsharma2585 5 років тому +1

    Thank you so much deepak sir

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

    Bohot bohot Dhanyavad Deepak ji!

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 5 років тому +1

    Sir super, very good speech sir..

  • @AnuragSingh-vy7nn
    @AnuragSingh-vy7nn 5 років тому +2

    Very Nice Sir
    Thanks for cover this Topic

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

    You made it so easy.❤️

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

    very good

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

    tq sm sir.. 😊 🙏.. i liked this vidos.. 🙏❤️💐

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

    I've been others who were copying skills and doing vlog, but expert can judge an expert. u r good in it

  • @m-y1007
    @m-y1007 4 роки тому +1

    Thanks a lot sir, it was really helpful.

    • @0522abhishek
      @0522abhishek 4 роки тому

      ua-cam.com/video/tpFLVpsTCbw/v-deo.html

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

    good job bro you deserve millions of likes

  • @rajendramehra4651
    @rajendramehra4651 5 років тому +1

    Really healpfull deepak sir.

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

    Bhut bhut bhut bhut khub🙏🙏🙏🙏

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

    Excellent training Even for seniors

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

    बहुत अच्छी तरह समझाया।

  • @user-kq7yw7px5x
    @user-kq7yw7px5x 4 роки тому

    appreciated

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

    Excel par Kam karne ke liye ...best video 👍👍

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

    Excellent resource, how can I take the live changing data to next row and create a line chart? OR
    Is it possible to create live line chart with live data

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

    Bhai...apke videos to bahot hi mazedaar hai...or apki teaching us se bhi mazedaar..thank you bhai

  • @TutanComputerGuide
    @TutanComputerGuide 5 років тому +1

    Excellent!!

  • @bittu25
    @bittu25 10 місяців тому +1

    Thanks for Teaching Macro.

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

    Aap bahut simple tarike se sikhate hai. Or video bhi banaiye. Achaa laga bahut

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

    Learnt new thing in excel. Thanks for this video

  • @MuhammadYousaf-yf2pg
    @MuhammadYousaf-yf2pg 3 роки тому

    Ustad Jee buhot buhot shukria!!!

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

    THIS MAN IS FROM ANOTHER WORLD.....

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

    Nice deepak sir .... Thank u so very much🤗

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

    me shoch raha tha ki ....maths table ko easily yaad rakh ne ke liye.......
    muje ye trick jan ni he......
    or children ko .......bohat easliy math tables ko dekh sake or shikh sake.......
    ab aap he sab........
    please help this trick .....
    india ko aap ki is trick ka intjar rahega ......
    or muje bhi....
    ☝️☝️☝️☝️☝️☝️☝️☝️☝️☝️☝️☝️☝️

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

    Thank you so much for this video..Can i save the file with desired format through Macro?

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

    Thanks for the video sir. Can we call a macro again and again on the same sheet?

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

    Excellent work

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

    Aap Ka Sabhi vidio mast sir,baht achhe se samjhate ho,love u Deepak sir

  • @satishkumar-ve7rv
    @satishkumar-ve7rv Рік тому +1

    Well bahut acha.hai 🙏🙏🙏

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

    Bht ache se sikhaya sit

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

    Amazing sir, thanks a lot.

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

    Wonderful✨😍

  • @sunilkotyan4443
    @sunilkotyan4443 5 років тому +1

    Very useful video sirji.

  • @AnilKumar-go7hj
    @AnilKumar-go7hj 4 роки тому +1

    Very good information video sir

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

    Very useful. Thanks for sharing this valuable information.

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

    great video thanks, i have electronic components about 5000 pcs i have written in excel its discriptions , i use find button to find my parts, can Macro seprate component numbers eg: 2sc or 2sb or 2sd and keep them in group because they are all mix in my excel book.
    please let me know thanks.

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

    Bahut bahut thank you sir aapka vedio bahut easily tareeke se samajh me aaya

  • @ABHISHEKKUMAR-qn8nn
    @ABHISHEKKUMAR-qn8nn 3 роки тому

    Maza aaya dekh aur sikhkr

  • @knowledgebankofeducation2949
    @knowledgebankofeducation2949 Рік тому +1

    Very useful work

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

    Very good & useful information

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

    aap ke video se kafi kuch sikha hai

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

    Hello, this video is very useful. But how to macros run on protected/hidden (like :- Data)sheets by commanding from unprotected/unhidden normal (like -userform, Entry) sheets. Please give the solution. Thank you.

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

    Bohot hi achcha logic hai. Nice video 👍

  • @nikhilkukde6704
    @nikhilkukde6704 5 років тому +2

    Wow
    wonderful.

  • @sandeepthewanderer
    @sandeepthewanderer 6 місяців тому +1

    bro you teaching skills are superb

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

    Hi sir can we use this function for making pivot table

  • @firojansari7696
    @firojansari7696 5 років тому +1

    Lajwab.... 😍

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

    Thank you for explaining with simple way

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

    Ek question h ....
    Ise ek hi sheet pr continue nhi rkh skte kya
    Kyu ki today date change hote hi sb data new ho jayega only data add krna hota h or last date enter krte hi last data usi seat pr a jayega

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

    वाह क्या बात है सर