How To Create ID Cards in Excel Hindi | ID Cards Creation in Excel

Sdílet
Vložit
  • čas přidán 11. 09. 2024
  • How To Create Automatic Employee ID Cards in Excel Hindi | ID Cards Creation in Excel
    Dosto excel me school, colleges ya employees ke liye ID card kaise bnaye ? iska poora process is video me maine step by step btaya hai.
    in this video you will learn, how to create smart automatic ID CARD of School, Colleges, employee etc. You can generate automatic ID cards in excel sheet. this interactive video showing you automatic ID card creation in MS excel, Where you can display/print one or more id card with different ID number, so I described step by step process
    #idcard #deepakeduworld #excelinhindi
    My New Channel : bit.ly/3qFrbl5
    Xlookup Complete Tutorial : • What Xlookup Can Do Fo...
    Vlookup Complete Tutorial : bit.ly/2K0C1Sb
    Complete Microsoft Word Tutorial : • How To Do Office Work ...
    In this video YOU Will Learn important excel formulas used in creating employees id card System through excel.
    1 vlLookup formulas
    2 data validation in excel
    3 picture lookup formula in excel
    4 name manager in excel
    5 Drop Down list in Excel.
    6 special pasting functions in excel
    7 index , match functions
    Download Training File
    drive.google.c...
    Excel Formula Tab in Hindi - How To Use Name Manager And Define Name in EXCEL | In Hindi • Excel Formula Tab in H...
    Index Formula in Excel - Vlookup से भी Powerful कैसे है ये index function - देखिये
    • Index Formula in Excel...
    How To Use Match Formula In Excel in Hindi
    • How To Use Match Formu...
    How To Use VLOOKUP With MATCH Function In Excel || 2D Lookup || Hindi
    • How To Use VLOOKUP Wit...
    Index + Match Function in Excel - Father of Vlookup || Best Ever Explanation in Hindi
    • Index + Match Function...
    Hlookup With Match Function in Excel in Hindi
    • Advanced MS Excel - Hl...
    VLOOKUP VIDEO SERIES:
    1. vlookup in excel with example in Hindi
    • Vlookup in Excel With ...
    2. How to use vlookup for multiple values || Trick to use vlookup for large data
    • सारा Data एक बार में V...
    3. Vlookup in multiple sheets in excel || In Hindi
    • Vlookup in multiple sh...
    4. How To Use Double VLookup in Excel-Nested vlookup
    • How To Use Double VLoo...
    5. Dynamically Updated Vlookup Formula in Excel
    • How To Make a Dynamica...
    6. How To Use Vlookup With Multiple Excel Workbooks
    • How To Use Vlookup in ...
    7. HLOOKUP in excel with example in Hindi
    • HLOOKUP in excel with ...
    Subscribe and Become Family Mamber 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

Komentáře • 438

  • @DeepakEduWorld
    @DeepakEduWorld  Před 5 lety +16

    In excel 2007 you can select data from another sheet while creating dropdown list... But you can do it in excel 2010 or all above versions... So If you are using excel 2007... You have to watch a video to create dropdown from another sheet.. And Link is czcams.com/video/-IDqfwby5MM/video.html

    • @aqibali9759
      @aqibali9759 Před 5 lety

      Is ka liya thanks sir lakin i am using 2013 excel

    • @bidyadharrabha4033
      @bidyadharrabha4033 Před 5 lety +1

      Me bhi 2007 hi use karta hu our mujhe bhi ye problem hua lekin mene socha computer me kuch kharabi he islye mene manage kar diya sheet 2 ka source ko copy karke sheet1 edit karke, lekin ab apka video bhi dhekunga ye video ka baat ki ap kese manage kiya☺

    • @tausifnedarya5851
      @tausifnedarya5851 Před 4 lety

      Sir, superb video he. Sir please isme ek option chiye muje ID pe picture shows and Hide ka option, jese kisi ka photo list me fit he lakin uska photo list me se delete kiye bina, without photo uska id print karna he agar aisa koi option ho to please video banao.

    • @pawanbastta43
      @pawanbastta43 Před 4 lety

      Sir ji apna contact number send kr o ji mobile p kese banye

    • @arvindmaurya0308
      @arvindmaurya0308 Před 4 lety

      Deepak EduWorld thanks sir for reply...I am using excel 10, I got the point of drop down. I am asking ..there is many unique no. And every unique no. Has one image..I want to fetch images in second sheet without using drop down list ..just like we fetch value in vlookup .

  • @gururajmalihalli8247
    @gururajmalihalli8247 Před rokem +2

    Bahut badhiya
    Aur aasaan hai
    Thanks ji

  • @sagar97537
    @sagar97537 Před 4 lety +2

    दीपक सर मैंने अभी अभी आईडी कार्ड बनाने वाली वीडियो देखी थी कि उसमें ऑटोमेटिक कुछ भी नही हो रहा था जैसा कि आप की वीडियो कई आईडी कार्ड्स ऑटोमेटिक शो हो रहे है। बहुत ही यूजफुल वीडियो है, आपकी सर। शुक्रिया आपका।

    • @DeepakEduWorld
      @DeepakEduWorld  Před 4 lety

      Kahan pe or kya problem aa rahi h aapko... I think.. mailing me data jo liya hai excel se usme problem hai.. f1 f2 is tarhe se to nhi aa raha mearge feilds me

  • @USMANKHAN-us8rn
    @USMANKHAN-us8rn Před rokem +1

    Thanks A lot Sir ❤❤

  • @rabiaakterahasan
    @rabiaakterahasan Před rokem +1

    Excellent job

  • @BM4AllinOne
    @BM4AllinOne Před 11 měsíci +1

    You are great

  • @mohitmehta4286
    @mohitmehta4286 Před 4 lety +2

    Sir u re the best, u very nicely told step by step how to make a I'd card

  • @sibasankarsahoo822
    @sibasankarsahoo822 Před 3 lety +1

    Many many thanks

  • @SoHaiL_Khan_64
    @SoHaiL_Khan_64 Před 2 lety +2

    Good tutorials sir plz can u tell me how to print double side id card in a single page.

    • @guldastkhan2154
      @guldastkhan2154 Před rokem

      Is main Sirf single side card print Hoga yeh Sirf Student or Worker ki jaise college main Apne Gale main latkate Hain.

  • @letslearnwithbharti778
    @letslearnwithbharti778 Před rokem +1

    Thank you sir 😊

  • @pankajbadhani1338
    @pankajbadhani1338 Před 6 měsíci

    Thanks you so much sir ❤ I really like this video......🎉🎉🎉🎉🎉

  • @k.suneelkumar3805
    @k.suneelkumar3805 Před 4 lety +1

    Sir superb

  • @ranisongwrite9299
    @ranisongwrite9299 Před 3 lety +1

    Thank you sir.

  • @am5642
    @am5642 Před rokem +1

    good and helpfull boss

  • @factsakar
    @factsakar Před rokem

    Bahut bahut dhanyawad

  • @SUNEELKUMAR-yl9po
    @SUNEELKUMAR-yl9po Před 5 lety +1

    very very thanks

  • @rajeevmewada1917
    @rajeevmewada1917 Před 5 lety +1

    भाई अपने दिल खुश कर दिया
    इतनी आसान तरीके से एक एक चीज़ो को बहोत ही सुंदर तरीके से बताया है
    आपको दिल से धन्यवाद

  • @user-rm1hb3jh9c
    @user-rm1hb3jh9c Před 3 lety +2

    Excellent vedio

  • @funwithdivyanshi1234
    @funwithdivyanshi1234 Před rokem

    dear sir how can make print format multiple card with your trick mind blowing sir grate Sir you made so simple thanks sir

  • @eggslutionServices-xh6wy

    Great idea very useful 🙏🙏🙏

  • @MrPZAHOOR
    @MrPZAHOOR Před 4 lety +2

    Admirable sir. I can't remain at ease without watching your videos

    • @MrPZAHOOR
      @MrPZAHOOR Před 4 lety

      Thank you sir upon responding my comment

  • @xfrancisprabahar1179
    @xfrancisprabahar1179 Před 3 lety +1

    Very good explanation sir...Super

  • @krishnapandey3133
    @krishnapandey3133 Před 5 lety

    Bhut achha video tha

  • @narendrarathore3107
    @narendrarathore3107 Před 5 lety +2

    Nice video. sir, aap ka javab nahi..👌👌👌👍👍👍

  • @kaurpreet6961
    @kaurpreet6961 Před 5 lety

    Apke smjane KA method bhut Acha hai...

  • @Lakshya-t8w
    @Lakshya-t8w Před 4 měsíci +1

    Thanks sir

  • @hafizzubair9774
    @hafizzubair9774 Před 5 lety +1

    deebak sir muje is video ka kafi dino se intzaar tha thank u

  • @aashusharma6182
    @aashusharma6182 Před 2 lety +1

    Thank you sir it helped me

  • @kiranjoseph3190
    @kiranjoseph3190 Před 4 lety

    Useful video, thankuuuuuu

  • @Rajesh-di4zq
    @Rajesh-di4zq Před 3 lety

    Bhohot mst bhai ji

  • @bijendrakumar5426
    @bijendrakumar5426 Před 5 lety +1

    Bhut achha hair sr

  • @programmingera7667
    @programmingera7667 Před rokem

    very very nice sir gggg😀😀😀😀

  • @BalvirSingh-qs9kz
    @BalvirSingh-qs9kz Před 5 lety +1

    pl. how mangal font to kurtidev vedio banana. id cord is very good idea. thanks

  • @kaurpreet6961
    @kaurpreet6961 Před 5 lety

    Thanks so much sir apki video's mei kuch new Sikhne Ko milta hai..

  • @AS-gg5uz
    @AS-gg5uz Před rokem +2

    Thank you. It was very informative video. Can we pull the photo from JPG file if the pictures are saved in a folder with Id number as the file name. Example: ID001.jpg

  • @m.barrahussain8661
    @m.barrahussain8661 Před 3 lety

    lots of Love from Pakistan sir,,,bht achi video

  • @PhaniRaj1970
    @PhaniRaj1970 Před 3 lety

    Excellent boss

  • @prediction2302
    @prediction2302 Před 5 lety

    Very nice sir

  • @Kaju2320
    @Kaju2320 Před 3 lety

    Lajwab superb thank you sir

  • @noorbhangar3833
    @noorbhangar3833 Před rokem +1

    Brilliant Yaar ..!

  • @dhairyagoel8907
    @dhairyagoel8907 Před rokem +1

    That is helpful...
    Can we extract multiple id card at once? Like players with age above 30

  • @chandrakantjain1814
    @chandrakantjain1814 Před 5 lety

    Your all videos is very nice.

  • @sateeshchauhan5988
    @sateeshchauhan5988 Před 5 lety

    Thank bro Bahut Achchha Kar rhe ho aap.. 👍

  • @yasirbakshi005
    @yasirbakshi005 Před 4 lety

    Tysm for the lovely video. Got it in the first go. Looking frwd for more videos

  • @mehkhan8589
    @mehkhan8589 Před 3 lety

    Thanks brother

  • @nitty_gritty_
    @nitty_gritty_ Před 3 lety +1

    Appreciable video

  • @ankitmehta192
    @ankitmehta192 Před 5 lety

    Bhut hi accha he sir ji

  • @anand9985
    @anand9985 Před 5 lety

    Nice video sir

  • @maheshbansal1244
    @maheshbansal1244 Před 5 lety +2

    Thank you Deepak Ji, for sharing this valuable information.

  • @factsakar
    @factsakar Před rokem

    Thanks sir jii

  • @swainsatya
    @swainsatya Před 5 lety +1

    Very Helpful video

  • @jansanwadnews
    @jansanwadnews Před 5 lety +1

    Super video sir

  • @pramodpasi6097
    @pramodpasi6097 Před 3 lety +2

    Deepak Sir, agar aise i-card banayenge to kya agar ek bar i-card bana liya formule se fir koi new student ka record add kiya to kya usaka i-card generate hoga ki nahi ..i mean data update hoga ki nahi..aisa to nahi ki fir se new data k sath wapas sab formula use karana hoga...

  • @gaikhuamlungpamei5235
    @gaikhuamlungpamei5235 Před 5 lety +2

    Very nice lesson. Thank you sir for your valuables times share.

  • @user-yj5zn1qp4f
    @user-yj5zn1qp4f Před 4 lety

    Thank u sir for this helpful video

  • @PradeepSingh-st6og
    @PradeepSingh-st6og Před 5 lety

    kamal he Dost

  • @helpinghands3886
    @helpinghands3886 Před 3 lety +1

    Nice

  • @DeepakSingh-jn9ll
    @DeepakSingh-jn9ll Před 4 lety

    Informative. Nicely explained

  • @DeepakEduWorld
    @DeepakEduWorld  Před 5 lety

    🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
    *Show Me ♥ By Like Share & Comment*
    🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
    *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

  • @vinaymaditation8323
    @vinaymaditation8323 Před 3 lety

    Osm sir

  • @appleair3059
    @appleair3059 Před 3 lety

    Very nice

  • @imtiyajali697
    @imtiyajali697 Před 5 lety +1

    Excellent video.

  • @ashwinpandit9455
    @ashwinpandit9455 Před 4 lety

    aap asa he aur video banaya

  • @lokendrachand7859
    @lokendrachand7859 Před 5 lety +1

    Excellent, 👍👍👍👍👍💟💟💟💟💟💟👌👌👌👌👌👌

  • @rajashahbaz9390
    @rajashahbaz9390 Před 5 lety +2

    Best

  • @m.danish445
    @m.danish445 Před 5 lety +2

    Very very nice trick

    • @DeepakEduWorld
      @DeepakEduWorld  Před 5 lety +1

      I ll send u.. Traing files today

    • @m.danish445
      @m.danish445 Před 5 lety +2

      OK sir I'm very very thankful to you sir.
      Mr.danish000786@gmail.com

  • @parmarnikul8952
    @parmarnikul8952 Před 4 lety

    Superb

  • @GamingLord-l2v
    @GamingLord-l2v Před 5 lety +1

    Fabulous

  • @jchauhan4788
    @jchauhan4788 Před 4 lety +1

    Bhai ek video banao full automatic salary sheet with I'd card and attandance dashboard

  • @twinklejaiyswal5172
    @twinklejaiyswal5172 Před 5 lety +1

    Very help full video Thank you so much💞💓💔💗💘💝💝💟🎻👌👍🎶💜💛💖

  • @RaslationEmploymentProvidersLL

    Very impressively

  • @abdulraziquesk3227
    @abdulraziquesk3227 Před 5 lety +2

    very very nice
    awesome...

  • @mansooralam626
    @mansooralam626 Před 5 lety +1

    Nice lecture..!!

  • @chandan7908
    @chandan7908 Před 5 lety

    Nice sir g

  • @hafizzubair9774
    @hafizzubair9774 Před 5 lety +1

    shandaar sir g

  • @khalidalisubhanallah2947

    Thanks Sir Nice Video

  • @sonikachaudhary1686
    @sonikachaudhary1686 Před 5 lety +1

    very nice ...

  • @mdnehazansari7678
    @mdnehazansari7678 Před 3 lety

    VERY USEFULL CLIP

  • @PuneetBaghelBoy
    @PuneetBaghelBoy Před 5 lety +1

    Top सर

  • @aktharansari4465
    @aktharansari4465 Před 5 lety +1

    Super sir

  • @akashrathore7417
    @akashrathore7417 Před 2 lety

    Thank 😇

  • @satish2010flash
    @satish2010flash Před 5 lety +1

    Deepak sir namaste..
    apa ka invoice video deka super ta aur usiko toda modified karake use kar rahahu last 1year se so thankful you idea in exeal super...
    Danywad

  • @LovePreet-do2dh
    @LovePreet-do2dh Před 5 lety

    Nice video thanks sir

  • @saeedahmad9140
    @saeedahmad9140 Před 3 lety

    سر بہت اچھی ویڈیو ہے میرا ایک سوال ہے کہ ایکسل کے اندر کیمرے کے استعمال کا طریقہ کار کیا ہے ہم کیسے تصویر کیپچر کرکے ایک سیل کے اندر آٹو فٹ کر سکتے ہیں

  • @babuhkonameti4294
    @babuhkonameti4294 Před 5 lety +1

    Thak you so much sir

  • @sherazrathoor8552
    @sherazrathoor8552 Před 5 lety +1

    Java script p video shoro kra plz sir

  • @kartickdey9482
    @kartickdey9482 Před 5 lety +1

    Sir, you are so very clean & clear for all the function with explained in Excel word. I request one thing for ms Excel 2016 how to use developer option please .

    • @DeepakEduWorld
      @DeepakEduWorld  Před 5 lety

      Right click anywhere on ribbion.. Chose Customize the ribbon.. And check developer checkbox

  • @omkarkelshikar7484
    @omkarkelshikar7484 Před 5 lety +1

    Nice sir video

  • @TheGr8Raka
    @TheGr8Raka Před 4 lety +1

    वन्देमातरम।।✊🇮🇳
    *ओम हर हर महादेव।। जय माँ।।*
    🙏🔱⚔🚩💐🌳🌿🌱🥦

  • @ssfunfacts2450
    @ssfunfacts2450 Před 5 lety +1

    nice sir

  • @kanupurigosai8791
    @kanupurigosai8791 Před 5 lety

    SUPERB SIR VERY HELP FUL

  • @aayan5112
    @aayan5112 Před 5 lety +1

    you r best .. i m new in ur channel

  • @MALEKIGM
    @MALEKIGM Před 5 lety +2

    Searchable drop down list in excel with dynamic arrays

  • @arthouse5528
    @arthouse5528 Před 5 lety +1

    Thanks deepak fr ART HOUSE DIMAPUR NAGALAND

  • @neerajsinghnegi7294
    @neerajsinghnegi7294 Před 5 lety +1

    Nice bhai

  • @sarabanu1820
    @sarabanu1820 Před 5 lety +1

    Brilliant sir.

  • @noorqamar7580
    @noorqamar7580 Před 5 lety

    great sir I have earned a lot of honor due to your channel in my office thanks sir G I have almost watched all of yours videos.

  • @koriramtulsi808
    @koriramtulsi808 Před 5 lety +1

    Gud video

  • @sherazrathoor8552
    @sherazrathoor8552 Před 5 lety +1

    Niceeeeeeeeeeeee video bhai jan

  • @ranjankumarbarik159
    @ranjankumarbarik159 Před 5 lety

    Nice yr