5 Best Excel Tips & Tricks in 2020 [ Hindi ] - Everyone Should Must Know | Excel Tricks in Hindi

Поділитися
Вставка
  • Опубліковано 13 жов 2024
  • Here are 5 Best Excel Tips & Tricks in 2020 [ Hindi ] - Everyone Should Must Know | Excel Tricks in Hindi - in this video you will learn 5 Best Time Saving MS Excel Tips and Tricks which can make your Office Work faster. these 5 Excel Tips Tricks will be helpful and useful for every Excel User.
    Doston 5 Tips MS Excel ki is video mai main apko btane vala hun jo aap sabke bahut kaam aane vali hain or definitely aap sabko is Excel ke video se kuch nya seekhne ko milega.
    #exceltips
    #exceltricks
    #msexcel
    Excel Tricks, Excel Tips And Tricks, Excel Tips, Excel Tutorial In Hindi, Excel Tips And Tricks 2019, Excel Tips And Tricks You Must Know
    Hope you will like the video. Thanks For Watching Friends.... Have A Nice Day...
    Deepak EduWorld Playlist's:
    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's in excel ► goo.gl/dFhg54
    Subscribe to Deepak EduWorld ► / deepakeduworld
    Follow on Instagram ► / deepak__nehra
    Like my Facebook page ► / deepakeduworld
    Follow on LinkedIn ► / deepakedu. .
    Facebook Group ► / cse92
    We Always Provide Useful & Helpful Content On The Deepak Eduworld UA-cam Channel, Here MS Excel Tips And Tricks, And Tips And Tricks For MS Word, And Internet Tips And Tricks, Along With The Computer Related Useful Information In Simple Hindi Language. I You Can Visit Our Channel Playlist's. It Is Our Effort To Get This Information Useful For All Types Of Excel Users, MS Word Users, Computer Users And Internet Users.
    Tags : microsoft excel,excel tips,Here are 5 Best Excel Tips & Tricks in 2020 Everyone Should Must Know,excel tricks,excel user,excel tips and tricks,computer user,excel tutorial,tips and tricks,excel tips and tricks you must know,excel tips and tricks 2019,excel tutorial in hindi

КОМЕНТАРІ • 99

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

    Very nice last wla nhi janta tha Mai apka video Pura deakhny Ka fyada ho Gaya...,,,

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

    Deepak bhaiji aapka explanation bahut hi top ka hai, but AAP ek baar construction ka store inventory ka short key aur heavy formula wala software banaao na....❤❤❤

  • @sandeepsingh-jf5qb
    @sandeepsingh-jf5qb 3 роки тому +1

    Sir Please ek video financial Function upar bnao 🙏🏼🙏🏼
    kyuki apka padaya huha jayada smaj ata hai 🙏🏼✔️🙏🏼✔️

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

    Agreed... U r Excel Guru....

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

    बहुत ही शानदार आपने ट्रिक दीपक जी बताई ही बहुत-बहुत धन्यवाद

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

    Well done bhai, agar ek cell me multiple entries ho alt+enter ke baad to us data ko individual cell me kese laye, delimited se bhi nhi hua, mera data kafi bada tha, I hope ap smjh gaye hoge, for excel ek cell me name, father name, address, contact no. Etc the aur second entries bhi isi cell me thi. Pls help

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

    Last wala formula sum average bahut kamal ka hai great

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

    Aise video lagatar lekar aaya sir ji

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

    thanks a lot Deepak Sir. I am so inspired by your art of teaching

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

    First View...
    I Learned Many Good Tips From Your Video 📹...
    Love You Sir

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

    Last trick was awesome

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

    Great tricks sir... always feel great to educate our-self while watching you.... Keep it up..... and Stay Blessed always....

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

    Valuable trick sir ji thank you so much

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

    Very helpful. Thanks

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

    Super tricks

  • @Aftabkhan-jz3ji
    @Aftabkhan-jz3ji 2 місяці тому

    Awesome 👍 sir

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

    very nice thank you

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

    Nice video 👌👌👌👌

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

    Wonderful tricks

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

    Sir aap buhat acha explan krte ho but thoda sa english word pr focus otherwise you r superab sorry if u feel bad bez aap template ko templete bol rhe ho just suggestion hai otherwise we r happy jaisa aap sukha rhe ho

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

    Bhai attandance sheet me humare paas complete data hai ab agar koi candidate job quit kar gaya hai to next month sheet me only continue workers ka hi data aaye left candidate ka nahi

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

    Great sir

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

    Thank u sir

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

    best trick sir thanks

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

    deepak ji kya app tally ke video ve banate ho

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

    Every video very very nice but & please making a mobile excel series video
    this is digital new india hai sirji
    please i request start
    Upcomming excel mobile video serise
    ok my dear

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

    Superb...
    Keep posting...

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

    kya baat maja aa gaya

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

    Nice video ji..

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

    Gazab sir, great knowledge

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

    Very good

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

    great Tips th'x

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

    speechless

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

    Alt +248 Se bhi degree symbol ata h

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

    Sir mai apka video dekhne se pahle hi like krti hu
    Because i know
    Aap deserve krte ho
    Thanku sir
    Love you
    G'NIGHT
    Tack care

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

    Very useful and time saving sir.. nice.
    Sir my one question..???
    Ek Excel sheets me 5 to 10 sheet hai...or unmey se ..one sheet me 20 to 30 party ki entry hai.. different name or detail ke Saath.kya yesa ho Sakta hai ki alag 2 name ,date or detail alag 2 sheet pe transfer ho Jaye...
    Matlub..sheet on me entery ho or data transfer ho Jaye..
    Fir example
    Date .xxxx
    Name ..ram
    Good of purchase...
    Amount.
    One sheet me ram ki entry Kare to ram ke ledger me transfer ho Jaye details.or shaym ki entery Kare to shayam ke Ledger me transfer ho Jaye.
    Sir ,pls reply

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

    Wow 🥰

  • @AdityaSharma-rg1zn
    @AdityaSharma-rg1zn 4 роки тому

    Degree ka symbol available hota h..... Insert me jaake

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

    Nice

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

    Thanks 😊 sir,
    Excel me agar decimal wale numbers ko sum karte hai to decimal ke bad ke number count ho jate hai. Agar hame ise nahi count karna hai to kya kare(ex-1.2+1.4+1.4=3 ho na ki 4)

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

      First of all use round function for 1.2 1.4 and 1.4 then use Sum...

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

    Deepak ji any way of converting multiple timezones in one timezone in excel . Like I want to convert USA, England, Brazil , Cuba, Austrialia, China , Russia, Iran into Indian standard time with
    Date. Actually I have online customer chat meetings from multiple countries at specific time and want to convert them in Indian time. Please make a video about it.

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

    V nice sir ji

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

    Respected sir
    Agar hamare pass kuch candidates ka result hai or ham ko yeh pata karna hai candidate ke kitne subjey pass hain
    But us result main science or prectical ko kaise cover karna hai

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

    Sir, muze koi aisa search function bataiye, for example, list me country india select kare to next list me india ke state short ho jaye, state select kare to next list me district short ho jaye aur district select kare to tehsil short ho jaye.

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

    Every video teaches new and valuable thing. Thanks a lot for sharing.

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

      I am extremely grateful Deepak Sir for this handy trick.

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

    I love you sir

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

    Sap ke bare me जानकारी दे

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

    Sir mujhey products ki list bnani hai kaise bnaye

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

    Sir excel me mera ek billty wise stock maintain hota hai nd usi bilty ka hisab company me jata haii esa koi trick hai ki mujhe pata chal jay ki ye bilty wala hisab gaya hai ya nahi

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

    Sir मैने आपकी daybook का वीडियो देखकर daybook बनाई।पर मेरी table automatic आगे नही बढ़ रही है।मुझे टिप दे आगे कैसे बड़े।

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

    Sir, I am working in outstanding report in that outstanding file I have to adjust payment received column to outstanding payment of 0-30 days, 31-60 days,61-90 days, currently I am using sum and plus and minus formula in excel for adjust payment received. For example if payment received 10000 and outstanding is 0-30 days is Rs. 4000,0-60 is blank and 61-90 days is Rs. 5000 it means outstanding is 9000 and it has cleared against payment received do have any trick or formula, please help

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

    Sir, In new year 2020,These are really new and useful tips and tricks.
    Thank You So Much Sir for uploading a valuable content!
    May God 😇🙏👼 Bless You!
    Sir, One request to you is that please explain mail merge in Ms Word.

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

      🥰

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

      Sir namaskar, I great feel for your teach and I want to know that camera option windows 2007 mein keise milega

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

    insert tabe me suru se option by option bataiye sar please sir

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

    🙏🙏🙏🙏

  • @dharmendrayadav-bw2gp
    @dharmendrayadav-bw2gp 4 роки тому +1

    👍 👍 👍 👍

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

    Deepak sb. Koi aisa function btaye jis se today function ki date fix ho Jaye.

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

    Dehli

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

    Dear Sir, Please solve my problem in excel when I enter any number it reduces by 2 digits when I enter the same number with decimal & two zero then full number without decimal & zero shown. also when I use ' before the number then the correct number is shown, please suggest the remedy.
    .

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

    Hi sir why we put star sign what is function of star

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

    SIR PLEASE TELL HOW TO ADD PUNJABI FONT IN GOOGLE SHEET & HOW TO CONVERT NUMBER TO WORD IN GOOGLE SHEET

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

    sum and averege formula me space kaise dena hai.....space nahi araha hai

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

    Bhai Number type karney kay baad ALT + 0176 sey degree ka symbol nahi aa raha

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

    Namaste sir ji
    Data tab me
    Mujhe get external samjhne me bahut pareshani ho rhi h please sir ji help kijiye

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

    Try to your diagnose for Rupees but get Rs. not get original symbol of Rupees as you show pls intimate Thankyou

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

    Sir,
    A1 cell me 125+70
    B1 cell me 90
    Dono ko sum kaise kare? Apka video dekha abhi mil nhi raha wo vdo,

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

    I am not able to make this degree symboll by that method.

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

    office 2016 main

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

    Where can i read more about excel.can you tell me more soures.

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

    Extra sheet how to add when file not showing any more book

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

    Currency Symbol wala bhi nahi huwa help karein aisa kyun nahi ho raha

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

    how to download this video sir

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

    Alt +248

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

    Sir bahut bde data me har 4 row k bad ek blank row add kese kre

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

      Atul ji@iske liye aap yeh trick use krna..suppose mere pass 10 row Tak data hai to me 1-10 number Tak m serial number enter kar lunga uske baad isi serial number ko ushi colum ke neeche dobara copy paste kruga ish tarah se aapko jitni row ke baad blank row chahiye aap in serial number ko copy paste krna or bad me serial number ko sort kr Dena..ish tarah se blank row aa jayegi

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

      @@omjoriya2554 bhai yah to mujhe bhi ata hai but aap apna mail id de me apko sheet share krta hu agar aap bta de ki kese krna hai

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

    Kisi event ko5 din pahale show karana ho to ????

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

    mere laptop pe alt+0176 se ni aa raha hai

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

    Sir,Namaste 🙏,
    Mey bagali hey so likh ne mey problem hota hey,😁Apko ak bat kehena chahate hey 👉ap jo attendance sheet banaya usme gread/designation hota hey, matlab ( skill,unskill,semi skilled,high skill).so greadtion ke liye alag alag announce milta hey(Attendance announce (15/day),food announce (Rs-20/day), other's announce(Rs-30/Day).
    🍂so ap pakriye ,attendance announce (Rs-15/day)10din ka upar kam karega to milega.koi koi admi 24/25/26day Kam kiya, too logic keya hoga.
    Please botaiye.mera mail I'd,👉 bhuniachandan884@gmail.com
    Mob:-9933343896

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

    Sir apna mobile no. Dijiye

  • @HarwinderSingh-wh5bu
    @HarwinderSingh-wh5bu 4 роки тому

    alt + 0176

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

    Nice video 👌

  • @RahulKumar-ly6ly
    @RahulKumar-ly6ly 4 роки тому

    Nice video sir