✅ Top 30 Excel Tips and Tricks in Just 30 Minutes

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 มิ.ย. 2024
  • Top 30 Excel Tips and Tricks in Just 30 Minutes
    dosto vaise to apko channel par excel tips and tricks 2021 ke bahut sare video mil jayenge but ye aisa video hai jisme maine top and most ever useful Microsoft excel tips ke bare me btaya hai wo bhi bas 30 minute me. agar aap sach me aek smart excel user banna chahate ho to ye video apke liye hai ye 1 video hi apko excel me bahut kuch sikha dega. is video me jo top 30 excel tricks maine btayi hai wo commenly bahut jyada kaam aati hain isliye is video ko end tak jarur dekhen.
    In this video of Microsoft excel you will learn Top 30 Excel Tips and Tricks in Just 30 Minutes in Hindi 2021 tutorial
    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...
    00:00 Intro
    00:34 Convert Text Into Uppercase Without Formula
    01:25 Cell Message
    02:27 Move Text in Center of Selected Cells Without Merge cells
    03:51 Display Picture on Cell Hover
    05:52 Smart Use of Clipboard
    07:04 Freeze Top Rows
    08:04 Freeze Top Row Without Freeze Pane
    09:04 Freeze Bottom Row
    10:17 Print Headers on Every Page
    11:29 Print Only Selected Data
    12:04 Hide Data
    12:59 Move Data Without Copy Cut Paste
    13:25 Transpose Data
    14:04 Fill Series of Dates up to Nth
    15:09 Insert Blank Row After Every Row
    16:14 Highlight Blank Cells
    16:48 Delete Blank Records
    17:26 Fill Blank Cells
    18:12 Remove Duplicates
    18:26 Highlight Duplicates
    19:29 Move Sheet into New Workbook
    20:42 Insert Bulk Sheets in Workbook
    22:06 Protect Workbook
    22:46 Hide Zero
    23:31 Swap Row and Columns
    24:16 Data Entry Using Form
    26:14 Find Workbook Saved Location in Computer
    27:01 Copy Visible Cells Only
    28:14 Fast Filter Trick
    28:55 Flash Fill
    #Exceltips
    #Exceltricks
    #DeepakEduWorld
    #exceltipsandtricks
    #2021
    #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

ความคิดเห็น • 695

  • @DeepakEduWorld
    @DeepakEduWorld  ปีที่แล้ว +9

    ✅ Top 30 Microsoft Word Tips and Tricks 2023 in Just 30 Minutes
    👉 th-cam.com/video/ERtR7bp06IM/w-d-xo.html
    Ye video jarur dekh lo 🔥

    • @MrGuest591
      @MrGuest591 11 หลายเดือนก่อน +1

      Ms excel pr problem ara h

  • @DeepakEduWorld
    @DeepakEduWorld  ปีที่แล้ว +6

    📢 Dosto apko DATA ENTRY course karna hai to ye raha video डाटा एंट्री करना सीखे | Data entry Course th-cam.com/video/HbUc-w60a68/w-d-xo.html

  • @zeeshanalam3557
    @zeeshanalam3557 2 ปีที่แล้ว +12

    I am using excel from like 14 years but still found few new and very useful tricks in this video. Good work, appreciated!!

  • @surajjagtap3632
    @surajjagtap3632 2 ปีที่แล้ว +222

    I am watching this video at the time of doing my office excel work, and indeed this 30min. video saves my several hours .. Thanks DeepakJi

  • @ahmedshakebzubairi25
    @ahmedshakebzubairi25 2 ปีที่แล้ว +4

    An absolutely fantastic video. Thank you for collecting wonderful useful tips.

  • @maoozkhan251
    @maoozkhan251 2 ปีที่แล้ว +6

    Your teaching style is really understandable.

  • @riddhishah9574
    @riddhishah9574 ปีที่แล้ว +1

    Still havent seen whole video, bich me se hi gratitude karne ka man ho gaya.
    Trick no 4 was very much needed and i never knew this could be done also. Thank u thank u so much for amazing tricks

  • @Mr.SBV_92
    @Mr.SBV_92 2 ปีที่แล้ว +5

    Thanks for sharing... Your tricks really helped me 😊

  • @AmitKumar-kh7lz
    @AmitKumar-kh7lz 2 ปีที่แล้ว +2

    ONE of the best video i have ever seen for excel tips. Thanks a lot sir ji 👌👌🙌🙌🙏🙏

  • @vikashmourya8964
    @vikashmourya8964 2 ปีที่แล้ว +3

    Genius sir......love you......appreciate your work

  • @khanshariqaijaz3561
    @khanshariqaijaz3561 2 ปีที่แล้ว +2

    Wonderful demonstration, and very helpful tricks

  • @Sadhubhai007
    @Sadhubhai007 ปีที่แล้ว +1

    Helpful tips for freshers,thanks❤️

  • @priyankakande2348
    @priyankakande2348 2 ปีที่แล้ว +2

    Useful Information.... Thank you🙏🙏🙏

  • @pramodbhavsar4488
    @pramodbhavsar4488 2 ปีที่แล้ว +5

    Thank you very nice tricks and useful and important function explain with good example Thank you sir

  • @avinashthakur3765
    @avinashthakur3765 2 ปีที่แล้ว +6

    Hii
    Very good suggestion sir. I watched your vdo start to last so I am very thankful to you share like that motivation topic .hope to you more tricks like that. Your explaining methods is good so everyone can be understand very quickly and easily. Because now these days computer learning is necessary for everyone and today every work has been done by system. Today 10 minte work done only 1only minte so life became very easy but because of this invention a lot of people has been came on way because he has not meet work for care his family or themselves so I am very appreciated to u make like that motivation bdo.

  • @ilyasshaikh6541
    @ilyasshaikh6541 2 ปีที่แล้ว +2

    Very important information provided to make work more efficiently

  • @pkmangla
    @pkmangla 2 ปีที่แล้ว +9

    Hi deepak.. its very helpful video. this is the first time i found a good video on excel. normally people keep telling normal tricks like copy, paste, total sum, multiply, etc. really thanks a lot

  • @nikiis10
    @nikiis10 ปีที่แล้ว +1

    Thanks a lot. This video was very useful. I learnt many new things inspite of having used Excel since very long time. May God bless you 🙏

  • @fayazhussainmangi4022
    @fayazhussainmangi4022 ปีที่แล้ว +2

    Your efforts are highly appreciated.

  • @ganeshbehera3350
    @ganeshbehera3350 2 ปีที่แล้ว +2

    I proud feel ur teaching thanks to u..

  • @tehsinullahjan
    @tehsinullahjan 2 ปีที่แล้ว +17

    I am Excel user since the time when it replaced Lotus 123. I have never learnt so much about Excel in one go before. Thanks a million Deepak. Lots of love and respect from Pakistan.

  • @MohitSingh-bn9qv
    @MohitSingh-bn9qv ปีที่แล้ว +2

    Some real magic goes on here. Wonderful video!

  • @sureshv7724
    @sureshv7724 2 ปีที่แล้ว +2

    Thanks Deepak ji.
    Very informative.

  • @sujataingale1673
    @sujataingale1673 ปีที่แล้ว +3

    Excellent tips, Thanks for sharing

  • @syedadnanhossain7980
    @syedadnanhossain7980 ปีที่แล้ว +1

    Great 😃 Very Smartly save the time in work Field. Thanks alot for this Video. This is very helpful for us

  • @saifkhan9590
    @saifkhan9590 2 ปีที่แล้ว +2

    This is very useful for Us... Thank you so much Sir...

  • @ITCE2018
    @ITCE2018 2 ปีที่แล้ว +2

    Deepak Sir Amazing Tips Must Be Beneficial for all no doubt

  • @muhammadfayaz2016
    @muhammadfayaz2016 2 ปีที่แล้ว +3

    Thank you so much brother
    Really I appreciate you for making this video
    Very helpful 👌

  • @vivekdoshi9836
    @vivekdoshi9836 2 ปีที่แล้ว +2

    VERY NICE AND USEFUL TRICK THANKS DEEPAK SIR

  • @user-rs4ky6yu3u
    @user-rs4ky6yu3u 9 หลายเดือนก่อน

    👌👌AKSHRIKA channel is also providing good information.

  • @wahafkhan7580
    @wahafkhan7580 7 หลายเดือนก่อน +1

    Mere Bhai Aap Ku Nahi Pata Muje Kithna Help Hua Ye Video Se, Sab Daily Kaam Ane Wali Hy, Thank You Bro

  • @kaleemghumman8553
    @kaleemghumman8553 2 ปีที่แล้ว +2

    Good lecture. Thank you

  • @aandrajj
    @aandrajj 2 ปีที่แล้ว +2

    Thx for giving us this useful information,,,

  • @jbrkingp2597
    @jbrkingp2597 ปีที่แล้ว +2

    Zabardast techniques, Thank you very much sir for making this amazing video 👌👌👌🙏🙏

  • @TRMNPS
    @TRMNPS 2 ปีที่แล้ว +8

    Just awesome Sir. I will definitely share with my students.

  • @SunilKumar-qc9ph
    @SunilKumar-qc9ph 2 ปีที่แล้ว +2

    Thank you so much sir 😊 💐 you are brilliant

  • @shivapandey6414
    @shivapandey6414 4 หลายเดือนก่อน

    Excellent tricks taught in an easy way.Thank you!!

  • @roshansiddiqui4011
    @roshansiddiqui4011 2 ปีที่แล้ว +2

    Thanku so much Deepak
    Your video is so much helpful but plz for your coming videos, make sure that excel menu should be more visible.

  • @mohammedaveshpathan5341
    @mohammedaveshpathan5341 2 ปีที่แล้ว +2

    Very very nice sir
    Excellent
    Superb
    Marvellous
    You are great Deepak sir
    Thank you

  • @faisalmohammad611
    @faisalmohammad611 2 ปีที่แล้ว +1

    Bahut badhiyan sir, Bahut kuchh sikhne ko mila.... Shukriya

  • @amanrawat3072
    @amanrawat3072 2 ปีที่แล้ว +2

    Yr bhuat kuch naya shik lia ❤️❤️ I love this video ❤️❤️👍 wo bhi raat ke 1:16 pe 🥰

  • @bibihajira7397
    @bibihajira7397 ปีที่แล้ว +1

    Thank u so much sir for this wonderful tricks

  • @MrBhujbalgv
    @MrBhujbalgv 2 ปีที่แล้ว +2

    Thank you very much sir. 🙏

  • @nareshkumarpenumetcha5953
    @nareshkumarpenumetcha5953 2 ปีที่แล้ว +1

    Wonderful. These are very useful to us. Thanks alot

  • @sanvimagicworld3931
    @sanvimagicworld3931 ปีที่แล้ว +2

    Very Informative video thanks for sharing.

  • @mohammedsadiq-7630
    @mohammedsadiq-7630 ปีที่แล้ว +1

    Thankyou sir, very useful video

  • @kartarsingh2643
    @kartarsingh2643 2 ปีที่แล้ว +1

    Tnx sir ji apki vjh se bhut bachho ka future bn skta h really thnanks 🙏🙏🙏

  • @advocatevasundhara5100
    @advocatevasundhara5100 ปีที่แล้ว +3

    One of the best video on TH-cam. Thanks bhaai

  • @imraniqbal5067
    @imraniqbal5067 ปีที่แล้ว +2

    thanks Sir for such wonderful and professional excel formulas

  • @heeralal-sn8zd
    @heeralal-sn8zd 2 ปีที่แล้ว +1

    Thanku sir ji aapne meri problem hi solve kr di bhagwan apko lmbi umar de aur hame aise hi sikhaate rhe 🙏🙏

  • @sadamhussain-rm2lw
    @sadamhussain-rm2lw ปีที่แล้ว +1

    It's fantastic knowledge ☺️ Thanks

  • @ronprathima
    @ronprathima 2 ปีที่แล้ว +2

    Amazing. Thank you

  • @caitanbraganca1943
    @caitanbraganca1943 2 ปีที่แล้ว +1

    Very Useful Video.
    Thank you

  • @babykhan7572
    @babykhan7572 ปีที่แล้ว +2

    Thanks alot sir very useful tricks u are a great teacher..👍👍👍🙏❤️❤️

  • @rinkusinghparihar1216
    @rinkusinghparihar1216 ปีที่แล้ว +6

    shift+f3 is the fastest way to change letters from lower to upper case.

  • @princemarandi679
    @princemarandi679 11 หลายเดือนก่อน +1

    Great sir thankyou 👋👋👋

  • @jhumpadutta871
    @jhumpadutta871 ปีที่แล้ว

    was very important to me. I known a lot. I learned a lot . It was very useful. Thank you for your information

  • @nandeshanil432
    @nandeshanil432 ปีที่แล้ว

    Very useful excel formulas. Thanks sir!!

  • @anam7952
    @anam7952 ปีที่แล้ว +2

    Ur Tips solve my problem Thank you 🙏

  • @klakhani41
    @klakhani41 ปีที่แล้ว +1

    thank you very much Guruji, you teach to us like class room ❤🧡💙🙏🙏

  • @007123abhishek
    @007123abhishek ปีที่แล้ว +2

    Really informative video.
    Please share the link for beginners I mean from scratch 😊

  • @kumarp33701
    @kumarp33701 ปีที่แล้ว

    #So nice very useful tricks. thank a lot..,♥️💞🥀💯🥳🙏

  • @tulsikumari3919
    @tulsikumari3919 2 ปีที่แล้ว +1

    It's very useful..thank you sir..

  • @venkateshseshan6912
    @venkateshseshan6912 ปีที่แล้ว +1

    Thank you so much, it helped me a lot to practice my homework given to me by my tutor .

  • @basu.31
    @basu.31 2 ปีที่แล้ว +1

    Thank You Sir, Very Nice Video... Thanks a lot..

  • @mumtajali8074
    @mumtajali8074 2 ปีที่แล้ว

    Thanks for valveable tips and tricks

  • @believeinyourself1165
    @believeinyourself1165 ปีที่แล้ว +1

    Very informative...thanks it's really help me out 😊

  • @faisalkhawar3147
    @faisalkhawar3147 ปีที่แล้ว +1

    Boht khoob Sir. Thanks for this very very informative vedio.

  • @superNareshg
    @superNareshg 2 ปีที่แล้ว

    Thank you sir.
    Very useful video.

  • @MrMeraj-fv7qb
    @MrMeraj-fv7qb ปีที่แล้ว

    Best tricks and way to making understand without any doubts.... Thanks!!

  • @Ak_computer_Gyan
    @Ak_computer_Gyan 9 หลายเดือนก่อน +2

    Faboulas video sir I am very happy after watched this ❤❤❤❤

  • @TheMozzarilla
    @TheMozzarilla 2 ปีที่แล้ว +1

    Sir, very useful information for the users. Lot of thanks and Love from Pakistan.❤

  • @vasantparmar2884
    @vasantparmar2884 8 หลายเดือนก่อน +1

    Good information.. Thanks

  • @supriyachoubey2985
    @supriyachoubey2985 2 ปีที่แล้ว +1

    sir aap itni mehnat krk ham log k liye itni aacchi acchi aur usefull tricks laate hain thank you so much sir .

  • @jayanarayanniat5848
    @jayanarayanniat5848 2 ปีที่แล้ว +1

    Thanks for this nice vdo sir it's really support us in our daily work

  • @hemantxaxa9422
    @hemantxaxa9422 ปีที่แล้ว +1

    Good one keep it up sir👍

  • @mohamedrafiq2343
    @mohamedrafiq2343 2 ปีที่แล้ว +1

    Deepak bro bahot sahi video hai bhai, bahut kuch sikha thank you bhai..

  • @Toolooa
    @Toolooa 2 ปีที่แล้ว +3

    You are too good. May God give you all the good opportunities in life.

  • @rohanbhandari5132
    @rohanbhandari5132 2 ปีที่แล้ว +2

    Thanks, Really Helpful

  • @mariainam3087
    @mariainam3087 2 ปีที่แล้ว +1

    Best video I really appreciate

  • @gopalrsonadagar6167
    @gopalrsonadagar6167 27 วันที่ผ่านมา +1

    Very nice teaching

  • @vijay_yejare
    @vijay_yejare 6 หลายเดือนก่อน

    It's very useful and tysm. Pls make more such videos

  • @Sumitmishra6001
    @Sumitmishra6001 2 ปีที่แล้ว +1

    Sir ji itni jankari khan se prapt karte hai aap . Adbhut guru ji

  • @RakeshSingh-oc7gh
    @RakeshSingh-oc7gh 2 ปีที่แล้ว +1

    Love the way u say main hoon Deeeeeepak

  • @nurulhaque89
    @nurulhaque89 2 ปีที่แล้ว +3

    Very useful for Daily life

  • @reshmakerketta5678
    @reshmakerketta5678 9 หลายเดือนก่อน +1

    Ye video mere bhaut kaam aai thanks sir , superb 👍👍👍

  • @ketanpatel963
    @ketanpatel963 ปีที่แล้ว +1

    The best one lecture🎉

  • @JawadKhan-jr1ku
    @JawadKhan-jr1ku ปีที่แล้ว

    very useful tricks in this video. Good work

  • @bindasgirl8579
    @bindasgirl8579 8 หลายเดือนก่อน +1

    Thank you Deepak ji

  • @farahnaz6598
    @farahnaz6598 ปีที่แล้ว +1

    Please make vedio about ......... odoo software online ... For construction company .... Any function
    Vendor bill
    Contractor bill
    Wages Bank balance
    Etc
    Please make vedio

  • @ketanprajapati1471
    @ketanprajapati1471 ปีที่แล้ว +1

    Salute bro. worked hard.. Nice explanation.

  • @molajutop3270
    @molajutop3270 2 ปีที่แล้ว +1

    i think its a best tips video of excel ever ;i love it:)

  • @sajidalijalal3340
    @sajidalijalal3340 2 ปีที่แล้ว +1

    Loved it bro thanks alot❤️❤️❤️❤️❤️

  • @GauravSingh-qj1xm
    @GauravSingh-qj1xm 2 ปีที่แล้ว +1

    I realy love this to your new trick in excel!

  • @tonythapa786
    @tonythapa786 4 หลายเดือนก่อน +1

    so helpful tutorial great job and have a nice day

  • @poonamyadav9586
    @poonamyadav9586 ปีที่แล้ว +1

    Very nice video sir🙏🏻🙏🏻🙏🏻

  • @learntobesmarter6763
    @learntobesmarter6763 ปีที่แล้ว +7

    Sir i watched this amazing lecture to build my kowledge however in 17 tick i found an error which i would like to mentioned when you used filter to delet blanck cell so cell 7 having pincode was also delet due to not highlight just visible cell by using paste special functioned. kindly watch you again and let me confirmed whether i raise point is valid or not

  • @subratamondal3074
    @subratamondal3074 ปีที่แล้ว

    Just Awesome 👌 Very Helpful

  • @Karthik-Chakra
    @Karthik-Chakra 2 ปีที่แล้ว +1

    Excellent excel tips all 30. Joshhhh to u sir.....

  • @jagdeeshphoolmali886
    @jagdeeshphoolmali886 ปีที่แล้ว

    बहुत शानदार गुरु जी बहुत कुछ सीखा