Excel work (घंटों का काम चंद समय में)
HTML-код
- Опубликовано: 11 сен 2024
- ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Follow me
Join Telegram - t.me/bdscomputer
Facebook - / bdscomputergarkha
Instagram - / bds_computer1
RUclips - / @bdscomputer
Email Id - bdscomputer1@gmail.com
Info@bdscomputer.in
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
YES SIRRrrrrrrrrr.....wow😮
Yas sharrrr. 😂
Sir aapki basic knowldge bahut strong he ❤
Nice videos team
Good leaning experience of excels in shorts.
Wonderful job 👍
Thanks a lot
U can use flash fill for the same 😊
Sapna 's' yes sir is incredible in every video 😂😂
Yes sir was so cute ❤..
We can also use split function with space as delimitator and fetch first word
Text to column
Yes
How
Flash fill 😎
Itne mai. Ek Banda copy paste kar dega😅😅
If there was 100 Name?
Ishke baad jab new entry karega toh phir se copy paste karega toh isse acha excel me kiyu word me kaam kar le😂😂😂😂
oye brother only for first name likhna h nhi ki first and last dono
@@ashwatthama8487 100 name k liye command bhi to badh jayegi 😂
@@basicengineeringconceptfor5922 Kounsa command badh jayega nahi samjhe brother
Quick & easy 'Flash fill' no formula required..
flash fill not work if 1st and 2nd first name same..
Mujhe to ye sabhi short video me sapna ka hi video thik laga hai
Sapna is a good Lerner
aise hi video daliye sir sapna ka
Your style to say yes sir is so cute 🥰
Ha ha wahi to dhyan rakhte 😂
sapna full confidence se keh ti hai " YES SIR "......👍
Sabka 😂fav line "Yaa Sir "😂😂
Wao
Thank you
Most welcome 😊
sapna has a different fan base😁
Sahi....
dream is looking good
1st Auto Fill (Falsh Fill ) karo
2nd tarika hai
Find aur mid mix karlo
3rd aap ne kiya ho hai
4th Data break kar ke bhi ho jayega
Nice. Thank you
Sapna ki vajah se video trending me
😂😂😂😂
😂😂😂😂
Yes sir😂😂
😂😂
Spana is very cute 🥰🥰
Very nice sister, I think you are learning Excel course or M S office, in advanced excel if you have office 2003 or next version we can use FLASH FILL ... Just write the first name in first column select below cell and press Ctrl + E for FLASH FILL no function no hadack... in some o/s no need to select blank cells you can just place the cursor on blanc cell area
Kiya hi bola he {YES SIR}😂😂😂
Sapna is very good learner 🌟
Yaar kitni cute hai...❤
Ctrl +E use bhi kar shkte ho or usse east way hai
Step one: create a cell of first name
Step two : select all data
Step three: write the first name without surname and press Ctrl + E
Ha
Lekin Flas fill office 07 me kaam nahi karta hai
Sister your typing mast speed hai❤❤
Pehle cell m enter karne k baad , Ctrl + E click kijiye autofill ho jayega
Without title
Sapna ka video achhaa lagta hai sir ❤
use flash fill.
Es se b asan traqa hai ik
Good... 👍
Thanks for the visit
Flash fill is the best
Sapnaaaa: - Yea sirr😂😂😂😂😂😂😂😂
Love you ❤️❤️💞
Alt+E flash fill use kro, isse jyada easy & fast
Purane version me nhi hota
Flass fill will be easy to use.
Sir flash fill use kyu ni kiya itna long formula ki kya zarurat ?
Flash fill is only available in more recent versions of Excel.. and besides, knowing functions is lot more appreciable interview point of view than a feature.. u could be specifically told not to use flashfill and instead do it by using left function. What do u do in that case? So that's why, knowledge needs to be there
2013 ya usse upper k version me hi chalta he
Honhar bachi hain sapna..
Yas sar....😂😂😂😂
Much easier way is just by typing just the first name in the second column. Move your mouse pointer to the bottom right corner of the selected cell. You should see a small black square, which is the fill handle. Double-click the fill handle. This will automatically copy the formula down to the end of your data,
Every single formula is very important... Jisako jarurat nahi usko useful nahi lagega.
Jisko jarurat hai.. wo bariki se har chij search karke impliment karta hai
Sapna....
Yaaa sir .....ohoho.....❤😊
Madam to engineer ban gyi 🤣🤣🤣
Data scientist 🗿💀
Good sir me bhi excel sikhna chahta hu ❤
I can do this without formula, first copy past the required text from first cell to desired cell then select cells then do the ctrl + e
Use ctrl + e
Ladki ki awaz bht acchi lgi fermula ❤❤❤😂😂😂😂😂😂😂😂so sweet
text to column ka use kr skte h sir
Sapna is beautiful 😍 with smart
Bhai yeah sab power query mae Hojaye, kahe formula use karte ho?
😅😅
Copy paste is best method but you give something new knowledge
Flash fill se bhi fill kar sakte hai sister 😊
Lekin vo daynamic nahi rahata he bhai
Jab Jake badloge to automatic nahi hoga 😂
Thank you bro for giving information to me
nahi bro flash fill se capital hota hai
Amazing video 👏
but please made long video to see all knowledge about computer skills..
Sure 👍
Copy kr k paste bhi kr skte the jaldi se😅
very good sapna
Phla name likh k simple cntrl + E kar dete isse simple tha
Bro vo Feature latest excel Me hai old Me Nahi vo only windows 10 pe Work krta hai
@@ajaykapoor601mera windows 10 hai kam karega na
Bro vo static hai dynamic nhii it's called flash fill
First copy paste all the select all data Type Ctrl+H then type in first box space comma star then replace all done
Write first name then Cntrl + E
Kitni cute hai Yaar 😊😊😊
yes sir😂
To open formula just click tab no need to use brackets...
✨Sapna mujhe tally ke bare Janna hai ✍️
Tally तो बहाना है तुझे सपना के बारे मै जानना है ना 😂😂😂
@@swapindian8233 🤣🤣🤣😂
Tally ke bare me Kya jaanana haii
Kahi main sapna to nahi dekh raha😮
Really amazing
Formula bhi acha hai... Aur swapna bhi.. 😜
Itna time kyo jb flash fill hai to 😂😂 i am also a excel expert 😎
👍👍👍
But office 07 me flash fill work nahi karta hai
@@bdscomputer But sir technology ka jabana hai ab aap bhi next version pe shift ho jaiye ab to excel 365 pe office work hone lga kyonki sir jitne jyada functions and formulas honge utna kaam fast aur best hoga 🙏🙏
@@gyaniaman101 ha sahi kaha apne, but we are run a computer institute, and we are try to teach a every formula to students. And we are try to teach every version of office include office 07 to till version 😊
Thank you for writing for us 🙏
Aur bhi easy way hai sir ji
Isse accha toh first cell m first name type krke ctrl+E type krdeti .....😅😂😂
कुछ नहीं होगा भाई करके देख लो
Yes. It is easy method to do... It will fill in one second..
Fast fill 2013 Ms Excel ya uske aage mei hota hai 2007 mei nhi hoga
Press control+f. In replace tab type followed by *. Press replace all.
Ctrl+H se yahi kaam seconds me ho jata 😂😂
Ctrl+e
Sapna ka quick reaction 👌🏻
Ade baap de😂 sahi hai❤
Itne time lgega tohh ho gya kaam
Sapna .....yes sir bolte hai to bhi konta cute lagti hai .....wow
Haayeeeeee ❤️ Sapna ki awaz 🙈👌
Sapna
Yes sirrrrrrrrrrrrr😂
Was very loud and fast 😅
1000 comments completed ❤❤
Mujhe to sapna aaega aaj
New new topic dikhaye apke vedio se bohot madat milta h keep it up
Excel topic 1 topic 2 aise
जिओ जिओ शेर सिंह हम सरकार जी
I like this video only because of SAPNA😎
Wa sapna
Sapna is very talented
1 saal baad ye comma space wala famula yaad rhega (copy paste karlo yaad bhi nahi rakhna pdega jaldi bhi ho jayega
She is excel queen
Old school.. use text before and text after to get the desired results.. its way too easy!!
Apka. Padhane ka tarika lajawab hai 🙏🙏
Thanks
First name copy paste another column then press enter and press ctrl+E flash feel .😊
Bhai mai to yes sir ke bad sidha comment dekhne aa gya😄😄😄😀
Hamko bhi padhna hai. Sir sapna ke saath 🎉
are humne bhi computer 🖥️🖥️🖥️🖥️ shik rakha hai
is se better use flashfill...jist type first namr in 1st cell then press ctrl + E in 2nd row...you'll get it
So esy
Sapna... So cute❤❤❤
Ess ke leyen app chat gpt use Kern Sir.
Ya sir
very good information for excel learning students. but I have one doubt in this.
agar last name likhna ho toh kon sa formula lagega.
Thankyou
क्या बात है मैडम क्या बात है
Very nice. I have a good exercise you can show in your videos. Its quite interesting. The names that are here in one column , invert there order
Thank you for your comment!