Flash Fill In Excel | Excel Lecture 3 | Excel for Beginners (हिंदी)
Vložit
- čas přidán 12. 09. 2024
- #flashfill #ExcelforBeginners
Hi everyone in this video we are going to talk about a very interesting function of ms excel and that ms excel flash fill function. This entire video is dedicated to ms excel flash fill tutorial. We are going to talk about ms excel flash fill shortcut, excel flash fill and autofill, how to use ms excel flash fill. Flash fill in excel is very useful if you have thousands of entries to deal. You can use almost same method to use flash fill google sheets.
Enjoy the video and watch the full video to get maximum benefit. Thank You.
============
🔥 Learn & Master Excel With 3500+ Students Across India on Excel Club 🔥
Link: www.skill91.co...
😍 Why Choose Excel Club By Neeraj Arora ? 😍
✅ 50+ Detailed pre-recorded videos highlighting every feature & function of Excel.
✅ Access anytime & anywhere On Android, iOS, and Web. Breathe easy and download videos on the fly to enjoy remote access
✅ 350+ Multiple Choice Based Tests to track your progress & evaluate your current level of proficiency with excel
✅ Interviews with Corporate Professionals from World’s Leading Organizations - uncover their experience with Excel & how they use Excel in their daily work to make real-time business decisions.
✅ Real-life use cases of excel that you can use in your job, business, or internship
✅ Certificate from Skill91 that you can highlight in your resume
✅ And above all a 24x7 Discussion Forum where you can ask all your doubts for an unlimited number of times and get personalized responses in a community of more than 3500 students who are learning excel with you RIGHT NOW!
Wondering about validity?
Don't worry. Each enrollment is valid for a SOLID 365 days!
No matter if you're a student, professional, or just looking to get started on MS-Excel
Excel Club will prove to be an EXCELLENT choice for mastering MS-Excel in a unique, fun, engaging, and informative way.
All Prices Running On Discounted Prices. Limited Time Offer Expires Soon.
=======
Excel for Beginners Playlist: • Excel for Beginners | ...
🔥 Learn & Master Excel With 3500+ Students Across India on Excel Club 🔥
Link: www.skill91.com/s/store/courses/description/Excel-Club
sir mujhe jo chahiye excel me vo nahi mil paa raha. mujhe excel sheet banani hot hai purchase ki jisme gst no., vendor name, tax rate, state, ye sab colums hote hai majhe chahiye ki vendor name daalte hi uske baaki details jaise gst no. state aur tax rate automatic fill ho jaaye
Flesh fill option not available sir
@ExcelforBeginners is there any excel course by you ?
Flash Fill is very new to me, I checked in my excel 2010, did not foud, now i am going to Install Excel 2013. Tussi great ho, Tohfa qabool karo
You can do it with text to column option easy to seperate detail🖖
I also don't find
@@himpeak6122 bro, kese krna h, text to column mai jaake?
Kaise karna hai
@@AshishSingh-tm3hd data m jaake u have to choose text to column thn choose space and thn enter u will get seperate entry of selected data
agar india m,e aise teachers honge to india ka educati0n systm hi badal jaayega thank u neeraj sir
You actually taught everything about that single topic...! Fantastic ❤️
It's been 5 years , I have left your classes. Working with Citibank now, saw this video has a great help .
Always love ❤️ u 😘
Hope you remember me.
Just been 2 dayz watching ur excel videoz n really became fan of u...
Sir,As I work in excel first time in my life,so I really say that your Teaching Skills & Style is fabulous & I really like your teaching very much.
From where did you get job ?
First time I met you sir at New Delhi center, GMCS training...
Aaj firr aapka ye video mil gaya
Kabhi kabhi lagta hai aap farishta ho sir...
*Sir, I Started My Articleship Just In December And This Function Is Literally Very Useful And Specially Sir As You Already Know While Articleship There Lots Of Kinds Of Work That We Need to Perform* Hence, Thank You So Much...... 👌🏻👌🏻👌🏻
Hardik Nandha but mere excel sheet m ye option hi nhi h wht i do plz help me
@@jyotijainjain616 You can Find This Function In DATA Tab And In Case it doesn't show up there
Click File > Options.
Click the Advanced in the left pane, and ensure that the Automatically Flash Fill box is checked.
Click OK
.Close and restart Excel.
Ye sheet sir ne sirf video ke liye banayi hai agar aap ise use karna chaate hote to nahi ho payega kyoki ye formula wali excel sheet me inhone kuch function use kiye hai ye formula nahi sikhate ye sirf jadu sikhate hai 😂
Is company secretary course good?
Thank you so much sir..... I forgot many things .... Now I have remembered all thanks to you sir🙏🙏.. keep teaching us🤗
بلا شک زبردست ٹول ہے, اور اس سے بھی زبردست آپ کا سٹائل ہے ... اس سے پہلے واقعی نہیں پتہ تھا. تھینکس
I have been using excel from a long time but never heard or used flash fill. Thank you sir for teaching this new excel function
This is my third class learing excel. Flash Fill was fun. Thank you Neeraj Sir. I am really enjoying this. Please share more video.
Waiting for lecture-4.. Amazing vedio sir... Thank you so much😊..
Maja aa gya sir..aapke btane ka tarika.... awesome hai.... love you
Your way of teaching is very impressive and attractive for students ❤️
Your teaching style really awesome
there is limitation in everything sir but this is really great I love flash fill.....
thank you sir, please upload more videos
same here
I didn't use excel before watching your videos for learning excel.
Thank you very much
Sir ji
Thank You Sir for making the lock down effective.
it is a great experience for me. I was knew little about excel but i just see your three videos and found great knowledge. I never used the flash fill even i had never listened about it. thanks for all knowledge what i gain.
Great video sir..
But you didn't discuss how to separate Name,address, phone number,pin code, if it is written in one cell.
seriously your videos is very helpful for me because i really don't know about excel, after watching your videos i can use excel easily thanks a lot...😊
I don't understand how could someone dislike these kind of educational videos.
Bhai relatives her kisi ke hote hen 😄
Sir Aapke samjhane Ka tarika bahut best h ki Sare dout clear kr dete ho or aapki voice bahut pyari h.
video starts at 2:20
Thik h shaab ase kr lete ki gal hogyiiiii excel izz very smart jiiiii❤
We can also use "Text to Column" of data Menu and then delimit it with space....
I also use text to column option under data tab
Kitni vdos dekhi or sach btau to merko ghnta kch nhi ata tha isme but bhai sach m dil se btara hu yaha se me seekh rha hu sach me confidence aa rha h ab 💫💞💞💞 bht bht Shukriya
Ammmmmmazzzzing trick
I'm going to use this trick first time.
Really helpful thqnks sir 👍👍
Flash fill trick is amazing .
Thanks for sharing this content and best wishes for your upcoming video.
👍👍👍👍👍👍👍👍
Thanks sir
Thank you so much sir,maine bahut sari excel ki video youtube par dekha hai,but pure youtube par aapke jaisa koi nhi sikhata sir really ❤
😱😱Never knew about flash fill .. thank u sooooo much sir this will help me a lot in office 😇😇
Apna toh chl ni ra flash fill guru
Your teaching style really amazing sir...🎓 I'm too much confident after watching your video...👨💻 thank you sir for inspiring us.😊❤
2:30 minute ka intro😆 btw useful video
Sir thanks
Please aise hi video send karte rehna
Many thanks to you sir
You are best😊😊😊😊
Never used before. Thank you so much sir ❤️
sir it was pleasure to have teacher like you thank you very much
One of the feature that I never knew and never found nowhere.
not useful anymore. what abt 3 digits name or 4 digits name with random format? it's only temporary thing .
Sir l have not computer but l watch your video then I know various types of knowledge from excel
Brother waiting for lecture 4
Hello sir this is hamza from Pakistan your videos are so informative I'm leaning alot .thnx
How dare you!! Teach so perfectly.
Please keep the work going sir. I started with the first video and now i cannot stop.
Thank you sir.
I got the notification, i clicked on the video within a flash. “Watttaaa video title reference, damn”
. V n m n u
O w
,
Vn
A
V
N vm . , v v vv .2
N
Vmb m
Mvvmv v
mv
Vn m
m vn mv m vn vv nvm
. ;
. Vn
Babu Bhiya Ei Jadu to Bade kam ki cheez he...😮✨ 😄👍🏻
Thank you 🙏🏻❤😊
Sir... I don't have that flash fill option in my lap ....how to apply it?
Same problm 😞
Ctrl+ E
@@AbhikAbhi its not working
@@irsabutt9137 use online version of Excel
Sir u r amazing..... Aapke smjane ka trika bhut hi pyara bdi jldi smj aa gya.... Thanks a ton Sir for this useful video 🙏🙏
Wonderful explanations. But I feel you forget to tell that it only functions in adjacent column to real data. Like if my data is from A1 to K10, it won't work from L22 to X32. Is it true? Because it is not working if editing areas are not in adjacent columns. You also did it in adjacent areas only both time. Please guide.
O. P. Flash Fill.... I just learn about it.... Good one sir
When you upload the fourth part of excel
Sir ur way of teaching is awesome...loved way u r machaing tabahi..😜
What if very first name is neeraj narang and I want first character of last name
Ur way of teaching in superb
Video starts at 2:25
Thank me later.
Me also skip video till 2.25 😀😀😀😀😀
you are amazing sir 😆 the way you teach is fab 😉
You can skip first 2:25 min ... Which is full of marketing...
what broblem for you ...........he has right to marketing.....very negative aniket
@@netraguleria17 i dont want people to waste their time 😋😋😋
@@Vocal_Vibes_byaniket nothing is free here . he is not stupid for waisting time for people likes you . how much minutes you waisted while you were typing these cheap coments ??????
czcams.com/video/p6qVJ1KhHek/video.html this is for you ! RIP English #waist 🤣🤣🤣🤣
@@Vocal_Vibes_byaniket spelling galat hone se tu sahi nhi ho sakta । Gandi nali ka keeda ochha aadmi। नीच। तुझे तो सब बोलते है कि तू शक्ल से ही घटिया दिखता है।😆😆😆😝😝🤣🤣👈🏻
Wow sir manna padega apki tricks ko.
, use excel text to column instead of flash fill. 10 lines ke data main error dekhna assan hain..
Bhai Kuch acha upload kiya karoo
Neeraj ji, I really liked your video with your special comments. I have not used flash fill before. So Thank You. Jai Hind
MS EXCEL 2010 MAY FLASH KA OPTION NAHI HY AGAR HY TO KIS NAME SAY HY
Yeh 2016 mai or uske baad aaya h
No Sir Maine Kabhi Use Nahi Kiya Ye Trick Mujhe Bahut Accha Laga And Mere Pass Aisa Work Bahut Sara Hai..Show Thank You Very Much
Sir flash fill ms excel 2010 me nahi hai?
No.
2013 or 16 me hai sirf
Superb Sir...Aajka lesson bahut shandar tha or usse shandar tha aapka btane ka mode..👌👌👌
introduction jyada karte ho..
Way of teaching is excellent sir. Kush raho g.
5:27 Kya ye me bhardu😂😂😂
Really funny tha vo😂😂😂😂😂😂😂
😂😂😂
Love You Sir ❤️ Love Your Voice 😍 And Love Your Teaching 🙏
Mere exel me FLASH FILL nahi hi
then use short cut key ctrl+e
It works only in latest ms Excel ctrl e se kuch ni hota
Superb sir ! pehle nhi pta tha aapse hi sikha
Dosen't he looks like Ayushman khurana?😂😂
Thank you sir You are best excel teacher
sir aapki trick to hamein bahut pasand aaye dhanayad
sikhne me maza aa raha hai
Tabaahi Machaa di Sir Ji
Sir your way of teaching is intresting 👍
Bhai thanks bahut bahut jayad bro ...... Bhai jo kam appp karte ho institute Wale bahut charge karte hai bro ..... but app free me information de rahe ho ... app ko salute hai bro
Good Evening Sir,
Superb ! thank you very much .
Wooooww Teaching Method Is Awesome amazing love u sir
Nice vdo infact... i used flash fill for the first time its really nice
Thank you sir for giving us so useful tips it's a grt job sir that your are helping those students through you tube
I am an engineer and also a excel trainer. My new topics given by you... Thank v much
Yes sir its very magic to use data tab
I like and subscribed
मान गए बॉस।
आपका मेथोर्ड और उसे बताने का बिंदास और मस्त एकदम मस्त तरीका
Glad to know about flash fill 🔥🔥🔥😎😎😎😎😍😍😍😍
I like this function
Best way of Teaching
i took paid classes from Udemy but that class is not helpful for me . i came to on your youtube channel ,its very help full to me
thanks for giving us good knowledge
very nice to learn flash fill
I really want to learn more about excel please provide more tutorial videos
Thank you bro for your efforts and free service
Neeraj Arora sahb you are great 👍
i never use it before. thankyou sir for that kind info.
Bhai love ur video ...Mai apke vajay se bahot kuch Sikha hun....🙏🙏
sir your teaching level is amazing and friendly, love from Pakistan ❤❤❤
excellent. I'm the first learner and user of Flash fill
Thank u for always teaching us in very excellence way🤌🏻❤️
Or kuch nhi paid courses ki waat lagadi ......tabahiiii macha di 🔥❤
This is New for not only me even everyone
Thnku sir for new tool it's very helping for me...
Sir I love that way you teacher ❤❤