Excel में ऐसे प्रॉब्लम में अगर आप फंस गए तो | Excel Date Tips in Hindi

  Рет қаралды 35,037

Excel Tutorial

Excel Tutorial

Күн бұрын

Excel में ऐसे प्रॉब्लम में अगर आप फंस गए तो to Excel Date Tips in Hindi का ये वीडियो आपको बहार निकलेगा | दोस्तों, इस विडिओ मे मैंने Date format की Excel Real Job Query का सोल्यूशंस बताया है जो अक्सर लोगो को Excel के डाटा मे Date से रिलेटेड होती है। मैं इस प्रॉब्लेम को दो तरीकों फार्मूला और बिना फार्मूला से बताया है। तो आप भी इस विडिओ को देखें और हमे बताए क्या आपने भी कभी ऐसी प्रॉब्लेम फेस की है।
Timestamps
00:00 Introduction
04:35 Trick 1 - Text to Column
7:05 Trick 2- Using Flash Fill
8:28 Trick 3- Solution With Formula
---------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Courses Website :bit.ly/skill_course
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇️ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : skillcourse.in/
Learn on Mobile (Download APP Skill Course) : bit.ly/3BWfQVa
---------------------------------------------------------------------------------------------------------------------------
To download the practice file visit our telegram channel: telegram.me/learnmoreindia
Check our latest blogs: learnmoreindia.in/
---------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
---------------------------------------------------------------------------------------------------------------------------
My Other Channels:
Real Tutorial: ✅
/ @realtutorial550
Complete Technology:✅
/ @completetechnology
Learn more shorts:✅
/ @learnmoreshorts
Satish Tech (Marathi):✅
/ @satish_tech
Tally Tutorial:✅
/ @tallytutorial
Excel Tutorial:✅
/ @excel_tutorial
Learn More:✅
/ @learn_more
Curiosity: ✅
/ @curiosity9432
---------------------------------------------------------------------------------------------------------------------------
My KZbin Gears :
Best Mic for Recording (Condenser Mic): amzn.to/2UUMDnH
Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
My DSLR Camera Canon 200D: amzn.to/39ciw3E
My Laptop (Video Editing): amzn.to/2UXQj8h
Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
Antivirus: amzn.to/3l3TIgi
Screen Recording Software: bit.ly/2J39n2j
Video Editing Software: bit.ly/3nOPlri
Green screen with Stand: amzn.to/2KAl1Cu

Пікірлер: 69
@Excel_Tutorial
@Excel_Tutorial Жыл бұрын
Learn Satish Sir courses with Certificate Download Course App : bit.ly/3BWfQVa Courses Website :bit.ly/skill_course ✅ Watch on Desktop : skillcourse.in/
@TechnicalHelpandsupport
@TechnicalHelpandsupport 2 жыл бұрын
Sir aap itne achhe sey batate ho ki dusri video dekhne ki jarurat nahi hoti thank you Sir 🙏🙏🙏
@judaysinghsidar8216
@judaysinghsidar8216 2 жыл бұрын
Bahut sundar👌
@jass285
@jass285 Жыл бұрын
Thank you so much bhot badi problem solve ho gye butt wo date se related nhi thi 5.27% ko normal 5 mai change krna tha good ho gya
@RahulKumar-ly6ly
@RahulKumar-ly6ly 2 жыл бұрын
Thanks sir very helpful video
@pratapyadav9007
@pratapyadav9007 2 жыл бұрын
Awesome videos hai sir
@kanubhaisuthar4574
@kanubhaisuthar4574 2 жыл бұрын
Excellent teaching sirji thanks a lot
@bhuvneshwarkumar2056
@bhuvneshwarkumar2056 2 жыл бұрын
Amazing sir 🙏
@canirmalchoudhary8173
@canirmalchoudhary8173 2 жыл бұрын
It is great to take users' problems and discuss with all viewers. Please keep it up.
@tahirshaikh3989
@tahirshaikh3989 2 жыл бұрын
Awesome vedio sir
@itsvinitsingh
@itsvinitsingh Жыл бұрын
Thank you sir 🙏
@watchandlearn7300
@watchandlearn7300 2 жыл бұрын
Thank u sir ❤️❤️❤️❤️❤️
@ashishshiriskar123
@ashishshiriskar123 2 жыл бұрын
Sir as usual you are superb 👍👍👍👍
@vimaldewangan9309
@vimaldewangan9309 2 жыл бұрын
Great
@SandeepKumar-og7rp
@SandeepKumar-og7rp 2 жыл бұрын
Jai ho
@LakhanKumar-lo8ii
@LakhanKumar-lo8ii 2 жыл бұрын
Sir indesign ka tutorial bna digiye
@SURAJ-shorts6
@SURAJ-shorts6 2 жыл бұрын
Sir TAX format par video banaiye plz 🙏🙏🙏
@BabulalKumar
@BabulalKumar 2 жыл бұрын
🙏🙏🙏🙏🙏🙏🙏🙏
@pawan_sharma95
@pawan_sharma95 2 жыл бұрын
Good afternoon sir 🙏 आप से निवेदन है कि Daynamic Calendar For any month & any year एक video बनाइए sir 🙏 Please please please 🙏🙏🙏🙏🙏🙏🙏
@balajigovindachari6858
@balajigovindachari6858 2 жыл бұрын
Your technic was excellent but your going very fast
@wiseedutech4191
@wiseedutech4191 2 жыл бұрын
Hlo balaji you can watch my video atleast once. I have explain with logic about excel @ wise edutech
@atulbharti7880
@atulbharti7880 2 жыл бұрын
excellent video sir.but i share with you that problem which i sometimes face in excel.when i used vlook or some other formula to get values & add that values excel always show error.bt if i paste result as values then sum formula is worked.plz provide some solution on this.
@pksirknowledge
@pksirknowledge 2 жыл бұрын
Sir wildcard se bhi Time ko hata sakte hai naaa
@AshutoshMishra-kf1sb
@AshutoshMishra-kf1sb 2 жыл бұрын
make a complete video of Microsoft excess
@Getinfo92
@Getinfo92 2 жыл бұрын
Dear Sir Sateesh love you from Pakistan. Cntl+E also works in row or just in Colum as you shown practicaly in video? Waiting for reply
@rustamali9294
@rustamali9294 2 жыл бұрын
Sir excel se hm kam krte koi sheet bnate hain salary sheet mark sheet to is tra ki lambi sheet ka hm print kese nilale ge.? Is pr koi video ap ki chanel pr hai to link send kr de
@vishalbhati912
@vishalbhati912 2 жыл бұрын
Ek page me kya ??
@AshutoshMishra-kf1sb
@AshutoshMishra-kf1sb 2 жыл бұрын
make a video of Microsoft access
@YogenderVlogs5514
@YogenderVlogs5514 2 жыл бұрын
Hello sir Sir ek sath 500 hundred I'd card kese banay few minutes please make video
@vishalbhati912
@vishalbhati912 2 жыл бұрын
Mail merge se ho jayega 500 kya 10000 bhi ban jayegi within seconds
@Gulluthevlogger
@Gulluthevlogger 2 жыл бұрын
Sir agr hm b row k coloum k data ko b sheet or Lena ho to ....??? Ye btayye sir pls
@priyankabhardwaj4275
@priyankabhardwaj4275 2 жыл бұрын
Find replace se bhi to kar sakte ... . Ke jagah -
@gurjitstudypoint
@gurjitstudypoint Жыл бұрын
Televome mei vlookup ka full video banaao
@BabulalKumar
@BabulalKumar 2 жыл бұрын
👆👆👆👆👆
@mukundsabale2422
@mukundsabale2422 2 жыл бұрын
सर एक्सेल सिट पे एक ही नामपर कमसेकम 40 ईटरी कैसे करे ऊदारी की क्रुपया करके बताई
@vijayupadhyay2505
@vijayupadhyay2505 2 жыл бұрын
Ca relate problem excel sheets batao
@realityworld3223
@realityworld3223 2 жыл бұрын
💔❤🩹محبت چاہے کتنی سچی اورگہری کیوں نہ ہو اگربزدل شخص سے ہوتوادھوری ہی 🩹❤💔❤🩹❤🩹💘💘💔💔
@yogeshmaheshwari5992
@yogeshmaheshwari5992 2 жыл бұрын
Can we learn Financial function in excel
@amarjamdar4308
@amarjamdar4308 2 жыл бұрын
Dear sir I've problem found in tally Debtors list showing in cell amount Dr or amount cr how to sort this Dr or cr for advance and outstanding. Please solve this problem
@golubaba5281
@golubaba5281 2 жыл бұрын
Koi setting batai jisse Excel me fast letter capital letter ho jai
@gulshansharma2279
@gulshansharma2279 2 жыл бұрын
Dear sir I have a doubt in excel Suppose We have a data between 1-Aug-2020 to 30-oct-2020 , how we can calculate the sum between 22.Aug to 10.Sept ? Please help....
@ravindrakumar-di1in
@ravindrakumar-di1in 2 жыл бұрын
sir mujhe gstr filling karna sikhna chahta hu.. tally sikh chuka hu. simple way me sikhna hai taki mujhe samjh aye ache se pls help me🙏
@ravindrakumar-di1in
@ravindrakumar-di1in 2 жыл бұрын
me apki sari video dekta hu
@aloksah2747
@aloksah2747 2 жыл бұрын
when i type date with dot separator it changes into a long decimal number so first how can i write date with dot separator
@wwherbs2176
@wwherbs2176 2 жыл бұрын
Screen recorder tutorial
@hs_gaming9061
@hs_gaming9061 2 жыл бұрын
Kya hal ha
@Ultapulta01
@Ultapulta01 2 жыл бұрын
🙏🙏Sir 🙏🙏 Main 18 sheets hai sabko 1 sheets me lana hai kaise hoga sir please help me 🙏🙏
@sonupathak4906
@sonupathak4906 2 жыл бұрын
HOW TO USE FOCUS MODE
@noobgamers4563
@noobgamers4563 2 жыл бұрын
Sir mein excel me apna naam likh raha tha to "PANKAJ Sharma" aisa aa raha tha surname capital letters me nahi ho raha tha bohot koshish ki but nahi hua
@ChandanSharma-cz5ke
@ChandanSharma-cz5ke 2 жыл бұрын
Sir, jab date ke sath right, left and mid formula use krte hai tab aapne F9 press karne ko kaha tha. Aisa karne ke bad back jane k liye kya krna hoga...? Esc press karne par sara formula gayab ho jata hai...
@Excel_Tutorial
@Excel_Tutorial 2 жыл бұрын
Ctrl + z prees karna hoga jab aap f9 karte ho to ctrl + z hi kijiyega nahi to pura formula forse type karna padega
@khushishah8637
@khushishah8637 2 жыл бұрын
Sir... Aapke videos bahut acche hote hai.. bhaut helpful hote hai.. Muje ek shikhna hai.. ki agar mere pass ek data hai.. aur usme sare name multiple hai.. aur muje ye pata karna hai... Ke is data me kitne logo ka name hai.. muje sirf count pata karna hai.. to kese kare... Agar koi solution hai.. to pls... Uske uper koi ek video bana dijiye...
@vishalbhati912
@vishalbhati912 2 жыл бұрын
Ek naam kitni baar he ye dekhna he ya kuch or
@khushishah8637
@khushishah8637 2 жыл бұрын
@@vishalbhati912 ek nam 2 se jyada barr hai... But muje count m ek hi chaie
@vishalbhati912
@vishalbhati912 2 жыл бұрын
@@khushishah8637 duplicate remove kar lo. Ya fir countif ka formula laga lo.
@khushishah8637
@khushishah8637 2 жыл бұрын
@@vishalbhati912 duplicate to remove nai kar sakti... isiliye dikkat aa rai hai.. kyuki muje har din usme data add karna hai.. aur ye pivot table me ho sakta hai kya????
@khushishah8637
@khushishah8637 2 жыл бұрын
Extlly mere pass jo data hai.. usme me amount ka sum karne ke bad wo jo total amount hai.. usme kitne person ne mikle ye kam kiya hai.. wo jan na hai.. but agar name multiple times hai.. to me countif yaa pivot tabal me bhi Count nai kar sakti..
@sumitpooranpurausrahar337
@sumitpooranpurausrahar337 2 жыл бұрын
Hlookup batao sir please
@rohitbarnwal4243
@rohitbarnwal4243 2 жыл бұрын
500 ka word me kese hoga formula me kese hoga
@vishalbhati912
@vishalbhati912 2 жыл бұрын
Vba code se hi hoga.
@RahulSharma-zn2vb
@RahulSharma-zn2vb 2 жыл бұрын
Itna Slow bataoge toh mujhe 10year lg jayega apse sikhte sikhte
@PAWANSINGH-ok9fp
@PAWANSINGH-ok9fp 2 жыл бұрын
Kya gnta dimag lgaye sir apne excal ki 50 video bna di... 8 hours ki vo alg se
Most people don't know How to use the fill series properly in Excel
25:16
Llegó al techo 😱
00:37
Juan De Dios Pantoja
Рет қаралды 57 МЛН
Ouch.. 🤕
00:30
Celine & Michiel
Рет қаралды 13 МЛН
No empty
00:35
Mamasoboliha
Рет қаралды 9 МЛН
Викторина от МАМЫ 🆘 | WICSUR #shorts
00:58
Бискас
Рет қаралды 3,4 МЛН
Boost Your Productivity by using these hidden options in excel😲
24:27
Learn POWER QUERY step by step in Hindi - Advance Excel
50:02
Data Cleaning in Excel - 10 Tricks (Beginner to PRO)
15:20
Chandoo
Рет қаралды 378 М.
99% People don't know about this Excel Formula!
12:58
Excel Tutorial
Рет қаралды 19 М.
50 useful keyboard shortcuts to become computer master in Hindi
40:06
Complete Technology
Рет қаралды 3,6 МЛН
Llegó al techo 😱
00:37
Juan De Dios Pantoja
Рет қаралды 57 МЛН