No video

✅ Top 30 Excel Tips and Tricks in Just 30 Minutes

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

Пікірлер: 702

  • @DeepakEduWorld
    @DeepakEduWorld Жыл бұрын

    ✅ Top 30 Microsoft Word Tips and Tricks 2023 in Just 30 Minutes 👉 kzread.info/dash/bejne/d4aotJmboJOcebA.html Ye video jarur dekh lo 🔥

  • @MrGuest591

    @MrGuest591

    Жыл бұрын

    Ms excel pr problem ara h

  • @DeepakEduWorld
    @DeepakEduWorld Жыл бұрын

    📢 Dosto apko DATA ENTRY course karna hai to ye raha video डाटा एंट्री करना सीखे | Data entry Course kzread.info/dash/bejne/epaJxY-wZpPHZps.html

  • @surajjagtap3632
    @surajjagtap36322 жыл бұрын

    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

  • @parassuri3676

    @parassuri3676

    2 жыл бұрын

    Kaha work karte hai app

  • @mahek2003

    @mahek2003

    2 жыл бұрын

    Acha to hame q bata ra re

  • @ksanjeva1505

    @ksanjeva1505

    2 жыл бұрын

    @@parassuri3676 qaaQ&Aq

  • @its_dvlifestyle6666

    @its_dvlifestyle6666

    2 жыл бұрын

    Hii where are u from

  • @RelaxingMusic-yp2mu

    @RelaxingMusic-yp2mu

    Жыл бұрын

    Thanks for your video

  • @zeeshanalam3557
    @zeeshanalam35572 жыл бұрын

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

  • @ahmedshakebzubairi25
    @ahmedshakebzubairi252 жыл бұрын

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

  • @tehsinullahjan
    @tehsinullahjan2 жыл бұрын

    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.

  • @maoozkhan251
    @maoozkhan2512 жыл бұрын

    Your teaching style is really understandable.

  • @avinashthakur3765
    @avinashthakur37652 жыл бұрын

    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.

  • @pkmangla
    @pkmangla2 жыл бұрын

    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

  • @darshanpatel-hp6kh

    @darshanpatel-hp6kh

    7 ай бұрын

    good reply

  • @heeralal-sn8zd
    @heeralal-sn8zd2 жыл бұрын

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

  • @riddhishah9574
    @riddhishah9574 Жыл бұрын

    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

  • @pramodbhavsar4488
    @pramodbhavsar44882 жыл бұрын

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

  • @nikiis10
    @nikiis10 Жыл бұрын

    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 🙏

  • @AmitKumar-kh7lz
    @AmitKumar-kh7lz2 жыл бұрын

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

  • @Mr.SBV_92
    @Mr.SBV_922 жыл бұрын

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

  • @syedadnanhossain7980
    @syedadnanhossain7980 Жыл бұрын

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

  • @sujataingale1673
    @sujataingale1673 Жыл бұрын

    Excellent tips, Thanks for sharing

  • @ilyasshaikh6541
    @ilyasshaikh65412 жыл бұрын

    Very important information provided to make work more efficiently

  • @wahafkhan7580
    @wahafkhan75809 ай бұрын

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

  • @learntobesmarter6763
    @learntobesmarter67632 жыл бұрын

    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

  • @vikashmourya8964
    @vikashmourya89642 жыл бұрын

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

  • @priyankakande2348
    @priyankakande23482 жыл бұрын

    Useful Information.... Thank you🙏🙏🙏

  • @khanshariqaijaz3561
    @khanshariqaijaz35612 жыл бұрын

    Wonderful demonstration, and very helpful tricks

  • @faisalmohammad611
    @faisalmohammad6112 жыл бұрын

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

  • @muhammadfayaz2016
    @muhammadfayaz20162 жыл бұрын

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

  • @Sadhubhai007
    @Sadhubhai007 Жыл бұрын

    Helpful tips for freshers,thanks❤️

  • @roshansiddiqui4011
    @roshansiddiqui40112 жыл бұрын

    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.

  • @TRMNPS
    @TRMNPS2 жыл бұрын

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

  • @MegaMindTech

    @MegaMindTech

    2 жыл бұрын

    Yes good one

  • @jbrkingp2597
    @jbrkingp25972 жыл бұрын

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

  • @amanrawat3072
    @amanrawat30722 жыл бұрын

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

  • @sudhakarverma4705
    @sudhakarverma47052 жыл бұрын

    Pahli baar esi trick achhi lagi nahi to sare KZread me bas basic shortcut dete h

  • @kartarsingh2643
    @kartarsingh26432 жыл бұрын

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

  • @saifkhan9590
    @saifkhan95902 жыл бұрын

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

  • @imraniqbal5067
    @imraniqbal5067 Жыл бұрын

    thanks Sir for such wonderful and professional excel formulas

  • @sureshv7724
    @sureshv77242 жыл бұрын

    Thanks Deepak ji. Very informative.

  • @ITCE2018
    @ITCE20182 жыл бұрын

    Deepak Sir Amazing Tips Must Be Beneficial for all no doubt

  • @MohitSingh-bn9qv
    @MohitSingh-bn9qv Жыл бұрын

    Some real magic goes on here. Wonderful video!

  • @ganeshbehera3350
    @ganeshbehera33502 жыл бұрын

    I proud feel ur teaching thanks to u..

  • @fayazhussainmangi4022
    @fayazhussainmangi40222 жыл бұрын

    Your efforts are highly appreciated.

  • @shivapandey6414
    @shivapandey64145 ай бұрын

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

  • @mohammedaveshpathan5341
    @mohammedaveshpathan53412 жыл бұрын

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

  • @nareshkumarpenumetcha5953
    @nareshkumarpenumetcha59532 жыл бұрын

    Wonderful. These are very useful to us. Thanks alot

  • @venkateshseshan6912
    @venkateshseshan6912 Жыл бұрын

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

  • @vivekdoshi9836
    @vivekdoshi98362 жыл бұрын

    VERY NICE AND USEFUL TRICK THANKS DEEPAK SIR

  • @aandrajj
    @aandrajj2 жыл бұрын

    Thx for giving us this useful information,,,

  • @supriyachoubey2985
    @supriyachoubey29852 жыл бұрын

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

  • @SunilKumar-qc9ph
    @SunilKumar-qc9ph2 жыл бұрын

    Thank you so much sir 😊 💐 you are brilliant

  • @kaleemghumman8553
    @kaleemghumman85532 жыл бұрын

    Good lecture. Thank you

  • @advocatevasundhara5100
    @advocatevasundhara5100 Жыл бұрын

    One of the best video on KZread. Thanks bhaai

  • @babykhan7572
    @babykhan7572 Жыл бұрын

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

  • @007123abhishek
    @007123abhishek2 жыл бұрын

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

  • @anam7952
    @anam79522 жыл бұрын

    Ur Tips solve my problem Thank you 🙏

  • @mkraj6312
    @mkraj63122 жыл бұрын

    प्लीज सर एक्सेल में इंसर्ट टैब का कंप्लीट वीडियो बना दो और अपने नंबर शेयर कर दो सर आप बहुत अच्छे पढ़ाते हो हर पॉइंट समझ में आता है वेरी-वेरी थैंक्स

  • @ushagarkoti12

    @ushagarkoti12

    2 жыл бұрын

    kzread.info/dron/Y5MuTgVvcdCtqv57JKT3wg.html

  • @GagandeepSingh-zh7cn
    @GagandeepSingh-zh7cn2 жыл бұрын

    Super sir thanks

  • @jhumpadutta871
    @jhumpadutta871 Жыл бұрын

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

  • @mohamedrafiq2343
    @mohamedrafiq23432 жыл бұрын

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

  • @Ak_computer_Gyan
    @Ak_computer_Gyan11 ай бұрын

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

  • @MrBhujbalgv
    @MrBhujbalgv2 жыл бұрын

    Thank you very much sir. 🙏

  • @sanvimagicworld3931
    @sanvimagicworld3931 Жыл бұрын

    Very Informative video thanks for sharing.

  • @rinkusinghparihar1216
    @rinkusinghparihar1216 Жыл бұрын

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

  • @caitanbraganca1943
    @caitanbraganca19432 жыл бұрын

    Very Useful Video. Thank you

  • @ronprathima
    @ronprathima2 жыл бұрын

    Amazing. Thank you

  • @user-gb9xw8jk1u
    @user-gb9xw8jk1u4 ай бұрын

    Bahut achchi video hai sir tank's

  • @TheMozzarilla
    @TheMozzarilla2 жыл бұрын

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

  • @rama8am535
    @rama8am5352 жыл бұрын

    You are great sir thanks

  • @MrMeraj-fv7qb
    @MrMeraj-fv7qb Жыл бұрын

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

  • @Toolooa
    @Toolooa2 жыл бұрын

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

  • @molajutop3270
    @molajutop32702 жыл бұрын

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

  • @reshmakerketta5678
    @reshmakerketta567810 ай бұрын

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

  • @klakhani41
    @klakhani41 Жыл бұрын

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

  • @mumtajali8074
    @mumtajali80742 жыл бұрын

    Thanks for valveable tips and tricks

  • @sadamhussain-rm2lw
    @sadamhussain-rm2lw Жыл бұрын

    It's fantastic knowledge ☺️ Thanks

  • @believeinyourself1165
    @believeinyourself1165 Жыл бұрын

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

  • @jayanarayanniat5848
    @jayanarayanniat58482 жыл бұрын

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

  • @sadamhussain-rm2lw
    @sadamhussain-rm2lwАй бұрын

    Thank you so much, Really appreciated content

  • @superNareshg
    @superNareshg2 жыл бұрын

    Thank you sir. Very useful video.

  • @basu.31
    @basu.312 жыл бұрын

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

  • @faisalkhawar3147
    @faisalkhawar3147 Жыл бұрын

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

  • @GE-Excel
    @GE-Excel2 жыл бұрын

    Your video is a nice one. I do have plenty in my channel. Yet, its something i have ever liked to watch the method of teaching.

  • @tulsikumari3919
    @tulsikumari39192 жыл бұрын

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

  • @nandeshanil432
    @nandeshanil432 Жыл бұрын

    Very useful excel formulas. Thanks sir!!

  • @Sumitmishra6001
    @Sumitmishra60012 жыл бұрын

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

  • @VikashGupta-it3fx
    @VikashGupta-it3fx2 жыл бұрын

    Magical tricks. Loved it. Thank you Sir G 🙏🙏 Can you please help me 1. how to drag automatically alphabetical value. & 2. How to insert serial no in uneven cells location with reference of adjacent cell. i.e. 1. Ram (Space) 2. Mohan (Space) (Space) 3. Etc

  • @Ashutosh.Parasar

    @Ashutosh.Parasar

    2 жыл бұрын

    If uneven name or value are in B column and starting from B2 then Use formula, =IF(B2””,COUNTA($B$2:B2),””) and drag up to your data it will give sl number of the cell which is not blank

  • @Ashutosh.Parasar

    @Ashutosh.Parasar

    2 жыл бұрын

    for alphabetical value yo can use as below =CHAR(64+ROW($A$1:A1)) and drag

  • @ushagarkoti12

    @ushagarkoti12

    2 жыл бұрын

    kzread.info/dron/Y5MuTgVvcdCtqv57JKT3wg.html

  • @GauravSingh-qj1xm
    @GauravSingh-qj1xm2 жыл бұрын

    I realy love this to your new trick in excel!

  • @thiyack
    @thiyack2 жыл бұрын

    Hi boss, While using Excel sin, cos and tan values I'm not get exactly. It's a software program or any setting problem. Mean time I'll get right values in normal calculator .

  • @chetanwagh6651
    @chetanwagh66512 жыл бұрын

    I love this video. Thank you so much sir

  • @36sachin
    @36sachin2 жыл бұрын

    Thanks bhai for your help today I learn more ट्रिक which I don't know befor that

  • @Karthik-Chakra
    @Karthik-Chakra2 жыл бұрын

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

  • @jagdeeshphoolmali886
    @jagdeeshphoolmali886 Жыл бұрын

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

  • @rohanbhandari5132
    @rohanbhandari51322 жыл бұрын

    Thanks, Really Helpful

  • @cleatusantony5978
    @cleatusantony597810 ай бұрын

    What a wonderful video

  • @indian-rl5ge
    @indian-rl5ge Жыл бұрын

    Very useful tricks. Thanks

  • @SHREE75OM
    @SHREE75OM2 жыл бұрын

    Thanking so much Very helpful video Good job Love you

  • @tubaijana6480
    @tubaijana64802 жыл бұрын

    Bohat Sundar Hain sir, Upka video Tutorials Mujhe Acha Lagte Hain.👌 Sir Iss full Excel Course Ka pdf Theory Milagga Sir?

  • @rakeshct
    @rakeshct2 жыл бұрын

    Sir, thank you for showing such a wonderful tips and tricks in excel. 🙏🙏

  • @kadarsayyad6760
    @kadarsayyad67602 жыл бұрын

    Thanks man. May god bless you.

  • @nurulhaque89
    @nurulhaque892 жыл бұрын

    Very useful for Daily life

  • @85aj084231
    @85aj0842312 жыл бұрын

    Excellent it helps a lot.

  • @pushpayadav4013
    @pushpayadav4013 Жыл бұрын

    Thanks deepak ji, its very useful

  • @afsarali7726
    @afsarali77262 жыл бұрын

    You Are Awesome, and Your tutorial is Too Awesome. So useful. Thanks a Lot. God Bless You my dear.👌

Келесі