المدة الزمنية 8:24

Advanced Excel PRO Trick You NEED To Know | Excel Tips and Tricks

بواسطة Deepak EduWorld

41 842 مشاهدة

1.5 K

تم نشره في 2021/08/16

Advanced Excel PRO Trick You NEED To Know Excel Tips and Tricks Dosto Microsoft excel ki bahut kaam aane vali bahut sari tips and tricks maine apke sath share ki jo aap sabke bahut kaam bhi aayi. is video me bhi maine bahut kaam ki excel trick apke sath share ki hai jo apke excel work me office work me definitely bahut kaam aa sakti hai. ye advanced excel trick seekhne ke baad apki excel skills jarur improve hongi aur apko excel me kuch nya seekhne ko bhi milega. Aur excel tips and tricks ke liye is https://goo.gl/wAj1jh link par click karen. in this video of Microsoft excel you will learn advanced excel most useful pro trick in Hindi. creating data validation dropdown list which hide already selected list items. Chapters 00:00 Intro 01:29 Formula Required 01:48 Filter Formula 03:55 Countif Formula 05:21 Preparing List Items 06:46 Making Dropdown list My Channels : A to Z Excel : https://bit.ly/3hQCRiw Deepak Techworld : https://bit.ly/3qFrbl5 Deepak EduWorld :https://bit.ly/3zWWtIS Deepak Nehra : https://bit.ly/364SVGV Filter Formula : /watch/84PLIP4aSdNaL Countif Formula : /watch/84PLIP4aSdNaL #ExcelTipsAndTricks #ExcelTrick #ExcelTips #2021 #HowToUse #AdvancedExcel #ExcelTutorial #LearnExcel #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 ► /watch/0PbyNhBrkeOry ADVANCED EXCEL ► https://goo.gl/A6LdZA ADVANCED EXCEL FORMULAS ► https://goo.gl/bbHYu2 EXCEL TIPS & TRICKS ► https://goo.gl/wAj1jh MS WORD ► https://goo.gl/B4TeSA HTML5 & CSS3 ► https://goo.gl/2PFgs8 COMPUTER TECHNICAL videos ► https://goo.gl/paZmpn AUTOMATIC INVOICE IN EXCEL ► https://goo.gl/dFhg54 PHOTOSHOP ► /watch/84VcwHkNK4mNc Subscribe Deepak EduWorld ► /deepakeduworld Instagram ► https://www.instagram.com/deepakeduworld Facebook page ► https://www.facebook.com/deepakeduworld LinkedIn ► https://www.linkedin.com/in/deepakeduworld Facebook Group ► https://www.facebook.com/deepakeduworld Thanks for watching DEEPAK NEHRA

الفئة

عرض المزيد

تعليقات - 72

@

@puspendupal2616منذ 3 سنوات Deepak Ji I learned so many things from your video regarding xlsx. your example and technic of learning are so easy. that is very easy to learn.
@

@tarak0274منذ 3 سنوات दीपक जी, बहुत धन्यवाद अच्छी जानकारी देने के लिए। वैसे तो फॉर्मूला का उदाहरण तो होता है एक्सेल में पर उसे लागू करना मुश्किल होता है पर आपका वीडियो बहुत आसान कर देता है।
@

@salil8880منذ 3 سنوات गजब सर आप तो कमाल हो कहां से लाते हो इतना दिमाग और नई नई टेक्निक 1
@

@leejae146منذ 3 سنوات Sir, I have downloaded a gform response spreadsheet excel for my research work. The responses are in words i.e ranging from Strongly Agree to Strongly id="hidden2" class="buttons"> Disagree or similar rating. Each of these responses are supposed to assign a number and accordingly we have to calculate but since my sample is 250 and number of questions is 90, I am facing difficulty assigning the numbers to my responses (250×90) manually. Please help me!! ....وسعت 1
@

@learncomputer9121منذ 3 سنوات FIRST COMMENT. SIR THANKS A LOT SIR AAPKI VEDIO DEKHKAR EXCEL ME KAFI ACHA KNOWLEDGE GAIN KIYA HAI. 5
@

@kaleem77منذ 3 سنوات Really supper tricks I like it thank you 1
@

@hbp7633قبل 10 أشهر Can you make a video of Amazon Orders how to manage in Google sheet and Excel. You will get views over millions because your explanation is outstanding 1
@

@hasanmeeran5790منذ 3 سنوات Mr Deepak new excel published video thanks
@

@rajsahu1029منذ 3 سنوات Really, it is awaited since long time. I am using Office 365. Thanks
@

@Dhirendarkumarمنذ 3 سنوات Sir. 1 video Excel ki all basic to advance all functions & formula.
kya hota h or kaise use kare is pe banaye. 1
@

@MrTkraju1957منذ 3 سنوات I am looking for this trick since last year,tried to get this output questioned in many Excel forums 1
@

@jatinderkadara7787منذ 3 سنوات Hello sir How are you ???
Sir aapki video is very nice.
Sir mera tiffin services ka kaam hai to mujhe uske according koi mein video bana sakte ho to pls.
@

@D1fact743منذ 3 سنوات Sir agar aap excel ka video banaate hai to step by step video daaliye ya 1,2,3 karke playlist banaaiye
@

@sachin345kumar6منذ 3 سنوات Sar ji main aapki sabhi video dekhta hu
@

@Entertainment-ix9vyمنذ 3 سنوات Dear Sir Please teach us Invoice from Basic.
Love you and your family.
Stay Safe Stay home.
@

@user-bi9vn9qu3lمنذ 3 سنوات sir love you sir If you don't mind so plz prepare video on Financail Accounting
@

@skmorsalim4268منذ 3 سنوات This project ko office 2019 ke liye dijiye please
@

@exceling3820منذ 3 سنوات How I can use filter formula Office16. 1
@

@puspendupal2616منذ 3 سنوات if you publish or upload any video regarding "speed and distance" in xlsx. please if you have
@

@afrinsir7479قبل 7 أشهر ihow could i use this formula in office 10 1
@

@Ravindra31sdمنذ 3 سنوات sir app computer me kaun se cource kiye hai
@

@sanjaypal5139منذ 3 سنوات Hi sir jo apne attendance sheet bnana btaya Tha usme every month ka data kaise save rakhe usi sheet me jab Mai jo month karu usi ka attendance a jaye 1
@

@fshabandariمنذ 3 سنوات World country code aur + ke sath mobile number ka validation kaise lagayen 1
@

@ak.education9900منذ 3 سنوات Tally ka full course video bana dijiye sir please
@

@learncomputer9121منذ 3 سنوات Sir excel me kai sare formule hai jo mil hi ni rahe but qapne sikhaya hai jaise. Formukatext, textjoin,switch,xlookup yaha tak ki excel 365 me bhi nahi hai.
@

@pramodnikam8611منذ 3 سنوات Sir aap party order wise Excel sheets Bana sakte ho, jisme Order received and order date wise despatch kar sake, me aapko woh sheets details send kar sakta hu 1
@

@vishalkushwah4154منذ 3 سنوات Sir i have question for you,,, jab bhi me 0724 esa kuch enter karta hu na toh starting ka 0 remove ho jata he automatically isska kuch solutions batao sir
@

@shrutimishra9649منذ 3 سنوات Sir .mere laptop me filter formula nhi use ho rha hai ?.
@

@deepanshugautam1566منذ 3 سنوات Sir mene data entry sikh li hai par mujhe samaj nahi aa rah ki job kese dudu to ap kuchh kar sakte hai 1
@

@indrasenverma4676منذ 3 سنوات Sir agar ham koi invest karte hai 5 year ke liye..To 10 year bad kitna total value milega.Kis formula se calculate kar sakte hai??
@

@shivkumar-mh5gxمنذ 3 سنوات sie agar excel aur word ki file open hi nahi horahi hai to is lock ko kaise remove karenge??? please bataye
@

@rakeshvachhani5871منذ 3 سنوات Sir Countifs between two dates VBA kaise Banaye? please Help 1
@

@Abdullahfunny104منذ 3 سنوات Sir hotel room booking
bill wise reporting
date wise reporting
Taxable and non taxable reporting
Please make this video ....وسعت
@

@shwelaمنذ 3 سنوات Sir ek swal puchna hai ek word document m undo command kitni baar estmal kar sakte hai 1
@

@beautyofpakistan1195منذ 3 سنوات SIR MA PAKISTAN SY HOO MUJY AAP KI VIDEO BOHOT ACHI LAGI HAN KYA AAP KA WHATSAPP NUMBER MIL SAKTA KU K MUJY EXCEL EK SY 2 PROGRAME MA PROBLEM AA RAI HAN
@

@panjabuniversityupdates7535منذ 3 سنوات Deepak ji muje aap ka number chahiye maine aap se baat karni hai
Main charanpal Singh clerk department of Laws Panjab University Chandigarh
@

@sulemanhasan6850منذ 3 سنوات Ye jo ap formulas batate ho konse excel me hote h milte hi ni
Xlookup and filter ye ecxel me kese ate h
@

@HemantPatel-xn9rnمنذ 3 سنوات जनवरी से दिसम्बर तक के हर मास का मान अलग अलग कोलमे लिखे है मेरे को दूसरी सीट पर जनवरी का डेटा चाहिए तो में मेकरो रिकॉर्ड से करता हूँ तो पास वाले सभी महीने का नाम आ जाता है।ऐसा हो सकता है कि फक्त जनवरी का नाम लिखु तो जनवरी के डेटा आये बाकी के 11 मास के नाम नही आना चाहिए।मेरे पास ऐसा डेटा है।
क्रम,jan,feb,mar,apr,may,jun,jul,Aug,sep,Oct,nov,dec,name,dob, address,
इसमे कई पार्टी के नाम हरेक महीनेमें होगा,कई के नाम में क्वाटर्ली होगा ,कोई हाफ यरली और यरली भी होगा तो जिस मास का नाम लिखे उसे मास की पूरी डिटेल चाहिए ऐसा कोई excel sheet का वीडियो जरूर बनाई ....وسعت