Это видео недоступно.
Сожалеем об этом.

How To Create Fully Automatic Multi Rate GST invoice in excel Hindi || Auto Save Invoice Entries

Поделиться
HTML-код
  • Опубликовано: 18 авг 2024
  • How To Create Fully Automatic Multi Rate GST invoice in excel Hindi - Auto Save INVOICE entries in excel sheet for future reference. we can set a backup database easily for invoices. which save invoice invoice entries by using macro feature of excel. VBA. watch this video... Published by DEEPAK NEHRA [Eduworld ] #billingsoftware #excel 2021
    How To Create #GSTInvoice /bill In Excel Hindi- Fully Automatic - Very Simple - GST Invoice format [ GST Bill Format ] Autofill By Codes - Create an automated GST invoice in excel auto fill by just using codes in Hindi. very simple invoice template format in excel 2007 2010 2013 2016. you can easily make this invoice format in excel even you can also download this template. in this video i am showing you how to make a simple GST invoice template format in excel . this GST invoice is fully automatic. using vlookup and iferror formulas.
    Download This Invoice/Bill Template
    drive.google.c...
    INVOICE PART 1: How To Create Fully Automatic Multi Rate GST invoice in excel Hindi || Auto Save Invoice Entries • How To Create Fully Au...
    In Part 1 of this invoice you will learn how to create/make this fully automatic multirate GST invoice auto fill by codes.. by using vlookup if & iferror formulas. very simple invoice template format in excel 2007 2010 2013 2016
    INVOICE PART 2: How To Automatically Save Invoice Entries in another worksheet For Future Reference in Excel | HINDI • INVOICE PART 2 - How T...
    In Part 2 of this invoice you will learn How to setup a database for invoice to Auto Save INVOICE entries in another excel sheet for future reference. we can set a backup database easily for invoices. which save invoice entries by using macro feature of excel. VBA.
    INVOICE PART 3: How To Auto Save Excel Invoice Back Up in PDF With Invoice Number automatically -HINDI • INVOICE PART 3 - How T...
    In Part 3 of this invoice you will learn fully Automatic invoice/bill Saving excel invoice data as PDF format To Your Pc Folder for future reference and pdf invoice file will be save with invoice number automatically. so that you can easily find any invoice at any time easily.
    LEARN how to automatically transfer & Save data from one sheet to another in excel || HINDI • How to Automatically T...
    OTHER INVOICE VIDEO LINKS:
    Invoice video link - How To Create GST Invoice In Excel || Fully Automatic Invoice Template || In Hindi • How To Create GST Invo...
    Invoice video link - how to create automated invoice in excel || in hindi
    • How to Create Automate...
    How to make dropdown in excel 2007 2010 2016 2013 hindi
    • How to Create Drop Dow...
    convert number in Words or Indian rupees.. spellnumber
    • convert number to word...
    How to use vlookup formula in hindi
    • Vlookup in Excel With ...
    How to use hlookup formula in hindi
    • HLOOKUP in excel with ...
    How to use IFERROR formula in excel || HINDI
    • How to use IFERROR for...
    How To Fix Excel Formula Errors #NAME? | #VALUE! | #REF! | #DIV/0! | ###### In Hindi
    • How To Fix Excel Formu...
    My Channels :
    A to Z Excel : bit.ly/3hQCRiw
    Deepak Techworld : bit.ly/3qFrbl5
    Deepak EduWorld :bit.ly/3zWWtIS
    Deepak Nehra : bit.ly/364SVGV
    #Invoiceinexcel
    #AdvancedExcel
    #BillingSoftware
    #Billinginexcel
    #ExcelTutorial
    #Excel_Formulas_and_Functions
    #Excel_online_course
    #deepakeduworld​​
    #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 TIPS ►
    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 ► / deepakedu​​world
    Thanks for watching
    DEEPAK NEHRA

Комментарии • 1,7 тыс.

  • @DeepakEduWorld
    @DeepakEduWorld  5 лет назад +29

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

    • @shreecreative4420
      @shreecreative4420 5 лет назад +2

      sir aap isme print ka button bhi add karo or usme automatic 2 print aaye 1 original 2 duplicate kya ye possible he

    • @prangyashreemishra3572
      @prangyashreemishra3572 5 лет назад

      Ap P/l and balance sheet vi kijiye ....
      Plz

    • @HAFIZ3921
      @HAFIZ3921 5 лет назад

      sir words main shift nahi hota

    • @sajjadhusain7482
      @sajjadhusain7482 5 лет назад

      Hii gd evg sir apne jo if formula k sath interstate sale ye mere me work nii krta to isk liy ky kre koi solution dijiye aap isk wjh s complete nii ho rha so pls i request u pls tell me now

    • @wasimhumdard1285
      @wasimhumdard1285 4 года назад +1

      i face the problem run time error 1004 : we cant do the that to a merged cell please help me to solve these type of error

  • @Dasanuj755
    @Dasanuj755 5 лет назад +7

    Thank Sir u teach me great lesson today thanks a lot

  • @ITTEHADchannel
    @ITTEHADchannel 4 года назад +4

    Microsoft Visual basic
    Run- error '1004':
    Ko kaise fix karein!
    And,
    Thank you! for your all uploadings.

    • @DeepakEduWorld
      @DeepakEduWorld  4 года назад +1

      Use at least office 2010

    • @vvksrn
      @vvksrn 3 года назад

      SIR AUTO HSN SUMMARY FEATURE??

  • @loveislife4769
    @loveislife4769 9 месяцев назад +1

    अभी तक मैंने ७ या ८ वीडियो देख लिया लैकिन कुच्छ नहीं समझा लेकिन आपका एक ही विडियो में ८०% समज़ गया ।

  • @BillingSoftwareGuru
    @BillingSoftwareGuru 5 лет назад +2

    ये वीडियो मुझे बहुत अच्छा लगा,अच्छा जानकारीपूर्ण वीडियो है,धन्यवाद।

  • @shaktimishra3896
    @shaktimishra3896 5 лет назад +7

    Hi, this is very good & helpful invoice. Plz do me a favour how can i add discount column in it.

  • @rakeshranjan8477
    @rakeshranjan8477 6 лет назад +3

    Thanks Sir, but one question in this format if product wise sales data how can save. please help on this

    • @amiralicharania5324
      @amiralicharania5324 3 года назад

      Sir even I have many product name will it save all of one invoice pls need ur advice

  • @aartimusale6158
    @aartimusale6158 4 года назад

    Best video sir 👍
    खूप नविन गोष्टी शिकायला मिळाल्या. भारी पद्धतीने सर्व गोष्टी सांगितल्या.

  • @shawarjun719
    @shawarjun719 4 года назад +1

    Sir,, maine to advance excel sikhe the.. lekin formulae ko kaise use kare, mujhe ku6 samajh me nhi ata tha.. lekin aapke video dekhne ke baad,, mujhe samajh me aane laga.. aur aapke ke video se maine bahut ku6 sikha h.. thanx..

  • @manikverma1641
    @manikverma1641 4 года назад +4

    Sir if Merge cells then the new invoice button is not working on it.

  • @areebazaid2344
    @areebazaid2344 5 лет назад +5

    Sir please helped me whenever I clear my invoice my formulas also cleared from cell..what should I do?

  • @AbhishekGupta-ye2oe
    @AbhishekGupta-ye2oe 5 лет назад +1

    Sir aap kitna badiya bta rhe h video mein mujhe toh ek hi baar mein samjh aa gya thank you mujhe iski bahut jarurat thi

  • @bsjZIZIzzbzva
    @bsjZIZIzzbzva 2 года назад +2

    One of the most usefull video in excel😇

  • @MrJsinwrld
    @MrJsinwrld 3 года назад +2

    Data validation aur vlookup se relation kuch hi cell me set ho rahaa hai......Drop down banta hai lekin beech beech cell me value nhin aa raha.....It is excell 2007

  • @manasvimultiservices8769
    @manasvimultiservices8769 5 лет назад +4

    hiii i fae the problem run time error 1004 : we cant do the that to a merged cell please help me to solve these type of error

  • @pritam_deb
    @pritam_deb 6 лет назад +1

    Bro u r awesome. U saved me from paying lots of money to the agencies who maintain such things for customers. Thanks a lot brother.

  • @mdthoslimhossintareq6487
    @mdthoslimhossintareq6487 2 года назад +1

    Boss very very help full video bro ,...... i love you

  • @worldwinelectricals7422
    @worldwinelectricals7422 4 года назад +3

    save invoice no ke sath name add kyse kre

  • @crazythemadboy
    @crazythemadboy 6 лет назад +6

    hi, ur video is very helpful for me.. but i m stuck here now.. i need to put over 100 items in the same bill... so just let me know that how can i add automatically new rows in the invoice with formulas into it too.
    like i keep on adding items n new rows r adding automatically with the formulas...

  • @moj1938
    @moj1938 5 лет назад

    Deepak Jee
    Thanks very detail explanations. Also very Clear step by step different entries explained.
    Appreciate very much.

  • @shuaibmalik6578
    @shuaibmalik6578 3 года назад +1

    deepak bhai excellent explanation method you have.. owesome....!

  • @vimleshpottam3379
    @vimleshpottam3379 6 лет назад +5

    Ms office 2007 me sheet select nhi Ho rha hai drop down list ke liye

    • @sadaqatalibhatti185
      @sadaqatalibhatti185 4 года назад

      Mere laptop men b office 7 han to drowpdown list aik sheet se dosri sheets tak kese bane gi mujhe b samajh men nahi aa raha

  • @vinaykumar-gf3gd
    @vinaykumar-gf3gd 5 лет назад

    SIR APKA BAHUT BAHOOOOT DHANYABAD
    BAHUT ACHE SE SIKHAYA APNE SIR PLZ YE KNOWLEDGE KI VIDEO BANATE RAHIYE

  • @appsid3858
    @appsid3858 6 лет назад +1

    gajab ki vdo
    ek hi vdo me bahut kuchh sikha diya aapne

  • @sanjayrawat5114
    @sanjayrawat5114 6 лет назад +4

    sir one question jb ham new invoice pr click karte hai to new invoice no ata hai but ager hamko pura invoice ka print nekalna ho to kya karna hai new invoice pr click karke new no ata hai to purana kese dubara dekhana hai sir soryy but apne uske bare me nhe btaya

    • @DeepakEduWorld
      @DeepakEduWorld  6 лет назад

      +Sanjay Rawat okay ji... inxt invoice videos i'll teach u

    • @jamshedgulbutt7431
      @jamshedgulbutt7431 6 лет назад +1

      kindly mera msg deepak bro ko pohncha dain meray c comment post nahi ho raha .thanks. hello bro mn n ye form bana lia ha.laikin kuch entries k bad data veledation k entry to ho jati ha laikin cells mn baki entries nahi karta jaysa k ap k banay howay form mn karta ha.product name to laita ha laikin rate or gst etc automatic nahi lata.5 rows tk to automatic karta ha lakin os k bad nahi karta.kindly help me

    • @bhawnanigam7329
      @bhawnanigam7329 6 лет назад +1

      Ye to mujhe bhi puchna tha please iske liye bhi kuch bataiye sir...Or apke video sach me bahut acha hai

    • @DeepakEduWorld
      @DeepakEduWorld  6 лет назад

      +Bhawna nigam i have also published PART 2 & PART 3 of this invoice... Links is given in description of this video...
      Please watch part 3.. I hope this will be very helpful for you

    • @brjakher1986
      @brjakher1986 6 лет назад

      Sir micro me new invoice ad karte hai to sub new invoice red colour ho jata hai add Nahi hota to micro se new invoice kaise delete hoga plz batane ka kast Karen

  • @avinashchelak1819
    @avinashchelak1819 5 лет назад +1

    Video dekhkr mja aa gya sir bahut bahut acchha

  • @puneetsharma9962
    @puneetsharma9962 9 месяцев назад +1

    Thanku so much for making such informative videos❤

  • @nikhileshmakireddy3795
    @nikhileshmakireddy3795 5 лет назад +2

    Superb Sir. Thank U so Much. Such a nice Explanation

  • @maheshchandra7617
    @maheshchandra7617 5 лет назад +1

    Thnks a lot Deepak ji very useful video
    Apke sare video bht ache hote hain ap bht simple tarike se btate hain thnks again

  • @mdadil2831
    @mdadil2831 Год назад

    Thank you bahut achhe se samajh aaya

  • @rahibhussainshabrani7348
    @rahibhussainshabrani7348 4 года назад

    زبردست جناب from Pakistan 🇵🇰

  • @richatripathi7848
    @richatripathi7848 5 лет назад +2

    Thank you so much sir it's video is very fantastic🤘🤘......,,

  • @saiecorp5646
    @saiecorp5646 5 лет назад +1

    Amazing work. Layman like me could understand. You are a great teacher.

  • @alidhillon7677
    @alidhillon7677 5 лет назад +2

    Thank You So Much
    You are doing a brilliant job.
    Million Thumps Up...
    Keep It up

  • @salamindia5148
    @salamindia5148 4 года назад +1

    Sir Excel users ke liye bahut hi use full video hai.
    New Invoice,
    Save ke sath
    Print button kaise add kare please bataye....

    • @DeepakEduWorld
      @DeepakEduWorld  4 года назад

      Just draw a shape and assign macro to it

  • @uniquecollection.shop.
    @uniquecollection.shop. 6 лет назад +1

    My Name Abdullah, Shot name AJ,
    I m From PAKISTAN,
    ser mai ap ki sari videos ko bohat pasnd krta hon,
    I like all videos,

  • @ArunChauhan-xr5dn
    @ArunChauhan-xr5dn 6 лет назад +1

    SIR JI THANKS AAPNE BAHUT ACCHE TARIKE SE BATAYA

  • @suhelshah12
    @suhelshah12 3 года назад +1

    Bahut adbhut guruji

  • @b.p.choudhary631
    @b.p.choudhary631 5 лет назад

    Very Nice and briefly explain.

  • @minakhisarangi6794
    @minakhisarangi6794 5 лет назад +2

    Thank you so much sir for your online classes.

  • @shaileshvaghela1830
    @shaileshvaghela1830 5 лет назад

    SIR VERY VERY GOODS ALL VIDEOS HELPFUL IN HINDI AND VERY USE FULL THANKS

  • @reyentertainment6918
    @reyentertainment6918 4 года назад +1

    Bohot hi pyara

  • @aryasharma17
    @aryasharma17 5 лет назад

    Hii sir Apka Video Mere liye Bahut labh Dayak rha thank you

  • @pcltmawia3093
    @pcltmawia3093 6 лет назад

    Ok Sir ji... bahuut borya video...

  • @hp8811
    @hp8811 6 лет назад +1

    Thank You Sir. I have completed my 1st part. Nice explanation good work. 5star for your work. Thanks a lot.

  • @TVSCDN
    @TVSCDN 4 года назад

    Thanks for your help and video 👌❤️ of quality 👌😁

  • @kumaresamanikaruppasamy7002
    @kumaresamanikaruppasamy7002 6 лет назад +2

    Dear Brother, am really appreciate you to explain this video, Thank you so much for your hard work and effort. I will download all your 3 videos and try to work out it. Once again thank you very much. God bless you.

  • @VijaySingh-yb4dv
    @VijaySingh-yb4dv Год назад +1

    Thank you so much
    You are doing brilliant job👍
    Keep it up 👍🙏🏻
    Sir can you make one video on plastic Scrap granules stock management, sell & inventory and invoice

  • @anujmodi2702
    @anujmodi2702 4 года назад +1

    Thank you sir , great content

  • @shekarraj7865
    @shekarraj7865 6 лет назад +2

    Sir I was so happy by seeing this billing invoice.

  • @priyankathakur3582
    @priyankathakur3582 5 лет назад +1

    VERY NICE SIR THANK U SO MUCH

  • @manishkumar-xn5oq
    @manishkumar-xn5oq 6 лет назад

    Sir aap ka Video Bhot Acha hh

  • @johnsahayaraj5803
    @johnsahayaraj5803 4 года назад +2

    long term try now at my lap thank u sir for making me a new invoice.

  • @starblack9419
    @starblack9419 3 года назад +2

    Thank you so much for this video

  • @ytv7046
    @ytv7046 5 лет назад

    অনেক অনেক উপকারি ভিডিও

  • @pankajandiyawala1660
    @pankajandiyawala1660 4 года назад +1

    very helpful topic share sir thank you.

  • @megasikm
    @megasikm 2 года назад

    Super presentation, very helpful

  • @vickeyraj4055
    @vickeyraj4055 5 лет назад +1

    Bhai bohot bohot bohot badhiya 👍👍👍👍

  • @mmaleem5586
    @mmaleem5586 4 года назад

    very knowledge full thanks

  • @riteshkeshri8705
    @riteshkeshri8705 4 года назад +1

    nice video sir
    This trick is work

  • @shakeelahmedshaikh7418
    @shakeelahmedshaikh7418 2 года назад +2

    Jiyo Bhai Zabardast Video hai

  • @chandnijaiswal9029
    @chandnijaiswal9029 4 года назад +1

    Thankyou sir
    Mai class me kbhi tnsn nhi leti
    Q ki aap ho hm sab ke sath thanku u so much sir luv you🤗🤗🤗🤗🤗

  • @shivamtambe2268
    @shivamtambe2268 2 года назад +1

    1 No 👌👌👌👌👍👍👍

  • @ashish1584
    @ashish1584 9 месяцев назад

    absolutely amazing video. too good

  • @babatikamsinghcollegependh7713
    @babatikamsinghcollegependh7713 6 лет назад +1

    nice video sir i am create a Create Fully Automatic Multi Rate GST invoice in excel

  • @Asingh_29
    @Asingh_29 5 лет назад +1

    Mind blowing video. No words. Thanks a lot Deepak ji

  • @MQasim-un1ne
    @MQasim-un1ne 6 лет назад +2

    Most awaited tutorial for me thanks support & love from pakistan deepak bhai

  • @arunkumarkm5295
    @arunkumarkm5295 6 лет назад +2

    wow, such a wonderful video...Thank you Mr.Deepak

  • @Gaurav-hc4tj
    @Gaurav-hc4tj 5 лет назад +2

    Awesome Deepak Ji. you are doing very good job. Keep going.

  • @ajit8690
    @ajit8690 2 года назад

    Thank you very much sir.. 🙏🙏🙏🙏

  • @hamayounsherzad9085
    @hamayounsherzad9085 4 года назад

    Thank you so much It really work

  • @mominulislam3476
    @mominulislam3476 4 года назад +1

    I am always fan of you

  • @gpnewsmyd9604
    @gpnewsmyd9604 5 лет назад

    Maashallah..
    super video sir...it is very usefull for me.
    THANK U..

  • @vijaykavi7184
    @vijaykavi7184 6 лет назад +1

    Bro you are simply great Thank you so much

  • @Siddhu-v3e
    @Siddhu-v3e 2 года назад

    Dear sir your video is too good
    please make one video in which we learn to prepare invoice book to day book automatically

  • @RahulSingh-un3ft
    @RahulSingh-un3ft 6 лет назад +1

    This video is very use full thnx

  • @santdnyaneshwar9920
    @santdnyaneshwar9920 Год назад +2

    Sir, isme kuchh problem face karne pad sakte hai.. jaise
    1) 'New Invoice' par galati se 2-3 ya jyada baar click karenge to auto Invoice number change hota rahega aur blank invoice ko invoice number assign hota rahega, yeh galti se bhi nahi hona chahiye...
    2) Save Data / Save Invoice par bill complete karne se pahle click karte hai aur fir bill me kuchh updation karte hai aur Save Invoice karenge to ek hi invoice multiple times backup me save nahi hona chahiye..
    3) =today() yeh formula bill date ke liye lagate hai to sabhi old invoice ka date bhi current date hi aata rahega.. yeh bhi wrong ho jayega..
    baki sabhi automated functions 👌👌👌👌👌👌👌👌👌👌👌
    In short hum agar janbujhkar bhi koi galti karna chahe to vah nahi honi chahiye... then it will be a perfect auto invoice...

  • @rsruhulamin4232
    @rsruhulamin4232 2 года назад

    Very helpful video ♥️♥️

  • @rinaamin9744
    @rinaamin9744 2 месяца назад

    Fantastic work, keep it up

  • @jamshedkhan4674
    @jamshedkhan4674 6 лет назад

    very well described and easy to follow instructions. Great work. God bless you.

  • @jimmyrajeshkantharia7092
    @jimmyrajeshkantharia7092 5 лет назад +1

    useful video who have the small business

  • @waseemsalmani8406
    @waseemsalmani8406 Месяц назад +1

    Thanks bro 🙏

  • @MBTECH-jl7vi
    @MBTECH-jl7vi 4 года назад

    BOHOT KHUB SIR

  • @ashutoshkarmakar6802
    @ashutoshkarmakar6802 5 лет назад

    Keep making videos like this
    Excellent video
    Very helpful

  • @pallabpramanick
    @pallabpramanick 6 лет назад

    You are a excel guru

  • @rohitdass1864
    @rohitdass1864 5 лет назад +1

    Superb Video

  • @prakshshukla9584
    @prakshshukla9584 3 года назад +1

    A very good video you had maid sir .

  • @RaviRaj-zf1ew
    @RaviRaj-zf1ew 2 года назад +1

    THANK YOU SIR

  • @arvindkumarsoni9990
    @arvindkumarsoni9990 Год назад

    This video 📷 excellent 👌

  • @skpjobsinfo6320
    @skpjobsinfo6320 5 лет назад +1

    Bahut accha sir

  • @gpnewsmyd9604
    @gpnewsmyd9604 5 лет назад

    Maashallah ....superb video sir.....
    THANK U....

    • @DeepakEduWorld
      @DeepakEduWorld  5 лет назад

      Belated same to u dear... Tell me how may i hlp u?

  • @moodkn
    @moodkn Год назад

    Thanks..... Super Excellent...

  • @harshac2008
    @harshac2008 6 лет назад

    Thanks for information Sir

  • @durgaprasad5627
    @durgaprasad5627 4 года назад

    Excellent bro, you rock....

  • @surendrapenumarti8447
    @surendrapenumarti8447 5 лет назад

    hello sir u did very good job its 100% helpfull to all small business , iwant small faver from you make a vedio of monthly stok maintain purchase & sale and small information from saved invoice of indivedual bill details insert search option to find how maney times customer purchased from us

    • @DeepakEduWorld
      @DeepakEduWorld  5 лет назад

      G blkul.. Please wait i will publish video as soon as possible

  • @Dilshathmohamed
    @Dilshathmohamed 6 лет назад

    Excellent job 👍🏻 very nice explanation

  • @VijayMarfatia
    @VijayMarfatia 6 лет назад +1

    It's very helpful video

  • @abhinab564
    @abhinab564 6 лет назад +1

    Nice video it helps me in my work.keep it up .keep uploading videos.

  • @deivavinodhandeivan8594
    @deivavinodhandeivan8594 6 лет назад +1

    Thank you Ji. Great work.. sincere thanks...

  • @majharulislamsumon3463
    @majharulislamsumon3463 4 года назад +1

    Lot of thanks