Tap to unmute

Stop Dragging in Excel, there is a BETTER way!

  Рет қаралды 32,988

Chandoo

Chandoo

Күн бұрын

Пікірлер: 69
@sundertalreja7208
@sundertalreja7208 10 күн бұрын
Let's pledge to stop Dragging 😂
@Ernestowino
@Ernestowino 9 күн бұрын
I have been learning from chandoo since 2024 January and got a job on April as junior data analyst. I appreciate alot
@chandoo_
@chandoo_ 9 күн бұрын
Woohoo 🎉🎉🎉
@sureshj8945
@sureshj8945 12 сағат бұрын
What are all the Topics You Covered? will you please Mention The Playlist you watched
@subratkumarpurohit8686
@subratkumarpurohit8686 8 күн бұрын
You are a genius not only in Excel but also in Content creation 👏
@namy1557
@namy1557 7 күн бұрын
These kind of videos is what makes your Channel Best, learned a lot from you 🎉
@mamadi2camara65
@mamadi2camara65 9 күн бұрын
The king ever seen in data analysis
@GurayVural-nz1lk
@GurayVural-nz1lk 7 күн бұрын
That was great. I also follow one of your online courses. Although I have been using Excel for years, I learned so many new features following your content. They are great for efficiency.
@JJ-ml7wo
@JJ-ml7wo 3 күн бұрын
Best teacher award!! Thank you
@ShuvooRahman-k4o
@ShuvooRahman-k4o 8 күн бұрын
The wait is over. I got my favorite Chandu video. ❤
@mohammedjawad8182
@mohammedjawad8182 9 күн бұрын
Excellent...! Very practical for daily tasks
@chrism9037
@chrism9037 10 күн бұрын
Excellent Chandoo, thanks!
@ArifKhan-qo9jw
@ArifKhan-qo9jw 10 күн бұрын
I had a idea about Sequence function as you teach us earlier. but you give some advance information Thanks Chandoo.
@gregofthelake
@gregofthelake 10 күн бұрын
This is so cool. Thanks. I've been using spill ranges lately to eliminate the need to change multiple formulas. The only drawback is that you can't sort on a spill range, but there are ways around it.
@keziadrevdal5766
@keziadrevdal5766 9 күн бұрын
Thanks for adding some humor in this video!
@swastiktripathy8412
@swastiktripathy8412 8 күн бұрын
Wow! This is new and useful excel trick.
@Rahul-f2p2i
@Rahul-f2p2i 9 күн бұрын
explanation is very good sir i watched all ur videos , i need to learn about business analytics please make a videos in ur way
@YvesAustin
@YvesAustin 8 күн бұрын
I personally prefer the Fill Series feature. It allows to enter data easily with NO formula including a given step; particularly useful in conjunction with the Data Table (sensitivity analysis) where the header rows and columns should not have any formulas but values. Numbers formatted with leading 0s can be done so using the custom format feature. All of those available in legacy Excel versions.
@chandoo_
@chandoo_ 8 күн бұрын
I am a big fan of fill series too.
@xjk101
@xjk101 10 күн бұрын
I love this. I feel inspired.
@MrDhunpagla
@MrDhunpagla 9 күн бұрын
Very nice Mr. C😊
@abhijeetghosh27
@abhijeetghosh27 10 күн бұрын
Very informative. ❤🙏😊
@gamerharry8905
@gamerharry8905 12 сағат бұрын
Bro is best ❤
@manilucky-ee5po
@manilucky-ee5po 6 күн бұрын
Sir super ga explain chestunaru alage quick books,xero,sega telugu lo explain cheyara plz
@mylearningplatform_easytoway
@mylearningplatform_easytoway 4 күн бұрын
Great 👍🏻😃
@adnanabbasi9482
@adnanabbasi9482 8 күн бұрын
good one!👍👍🏼👍🏼👍🏼
@nipunchibber250
@nipunchibber250 9 күн бұрын
Thank you Purna, I hope your family is well. Sometimes, I think you are Starwars "Padawan" of the Great "Johny Lever" . You are getting younger day by day, must be some magical herbs of New Zealand. HaHaHa ! Stay Blessed !
@chandoo_
@chandoo_ 9 күн бұрын
😂 Happy, when you are, Aging, you stop.
@charut2733
@charut2733 10 күн бұрын
Extraordinary 🤩
@syedali-qg3nc
@syedali-qg3nc 2 күн бұрын
Hey, what happen to your hairstyle Chandu, looking great in this one
@nayanreddy9661
@nayanreddy9661 8 күн бұрын
Hi sir I am currently pursuing data analytics course but I always wanted to work with businesses closely and that's the reason I am inclining more towards business analyst profession. Will my experience in data analytics profession help me or give me an edge while switching to business analyst or will it be a void?
@mr5bassman
@mr5bassman 9 күн бұрын
Excellent information as always! How do we get an alphabet sequence that continues into double letters (AA, AB, AC, etc.)?
@chandoo_
@chandoo_ 9 күн бұрын
Thank you. This is an interesting question. I am not sure when in the real life we would need this. But here is a formula that produces the letters. =TEXTBEFORE(ADDRESS(1,SEQUENCE(1000),2),"$") Change 1000 to whatever number you want and you will get all the sequence.
@mr5bassman
@mr5bassman 8 күн бұрын
@chandoo_ That's awesome! Thank you!
@discretetantrum
@discretetantrum 18 сағат бұрын
Thanks Chandoo Is there any efficient way to drag vlookup formulae?
@chandoo_
@chandoo_ 18 сағат бұрын
You can use the below technique. =VLOOKUP(A1:A10, mydata, 2, false) This will spill the vlookup formula for all 10 cells by doing individual lookups against each of the 10 values in A1:A10
@lakshmanvajjakeshavula5380
@lakshmanvajjakeshavula5380 10 күн бұрын
Thanks chandoo
@stoicdarwin
@stoicdarwin 10 күн бұрын
Commenting for the algorithm
@songwejohnpwele9315
@songwejohnpwele9315 Күн бұрын
Just discovered ❤
@agasteen2423
@agasteen2423 9 күн бұрын
Hi sir! You are doing great job! one question , i joined data science institute iam taking a reference your videos, you are teaching great then the institute. Is there any leakage of information on your free videos .
@chandoo_
@chandoo_ 9 күн бұрын
What do you mean by "any leakage of information on your free videos"?
@aiasaiascon3894
@aiasaiascon3894 9 күн бұрын
🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣Super duper mega Fun!!!!🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣
@nazarkamal8831
@nazarkamal8831 10 күн бұрын
😂😂😂😂😂 informative thanks
@Dzeidzorm
@Dzeidzorm Күн бұрын
No more dragging
@SPK_kaushik
@SPK_kaushik 2 күн бұрын
how to fill monday to sunday using sequence function?
@chandoo_
@chandoo_ 2 күн бұрын
If you just want the names (not actual dates), you can use =TEXT(SEQUENCE(7,,2),"DDDD") If you also want the dates, then use the approach I mentioned in the video to first make dates and then use format cell to format the values as day of week.
@SPK_kaushik
@SPK_kaushik 2 күн бұрын
@chandoo_ Okay thanks
@researchr
@researchr 6 күн бұрын
Right
@Sandroider
@Sandroider 10 күн бұрын
dragging or rushing?
@Fardin396
@Fardin396 10 күн бұрын
You will go to Mars in draging!!💀💀
@myneninagasivasai1414
@myneninagasivasai1414 9 күн бұрын
sir give some discount on excel course for telugu students
@naniyadav8624
@naniyadav8624 3 күн бұрын
Sir i have 4 years career gap qualification BSC COMPUTER science 2020 present i am interested in data analyst field course it's suitable for my profile please explain it
@kommulachaitanyabharathi5832
@kommulachaitanyabharathi5832 10 күн бұрын
Sir I want to learn data analyst full course .I am 2024 passed out.i have no job in my hands pls suggest me better one sir.
@Rood67
@Rood67 8 күн бұрын
Makes a video on not dragging, then in the end, dragging - because, dragging in Excel is just part of the process. Joking aside, excellent video. On the dates, I was thinking of how to make this as a calendar view across seven columns. Need to see if I can get this to work.
@scotttheniceguy
@scotttheniceguy 10 күн бұрын
At 3:38 you started to drag columns again (shrugs)
@RituShah
@RituShah 10 күн бұрын
Exactly😂
@chandoo_
@chandoo_ 10 күн бұрын
Haha... good catch. That is not dragging. That is just "selecting".
@madhurikesoju
@madhurikesoju 8 күн бұрын
Hello Chndoo Madhuri here i am looking for Projects for data analyst I would like you to suggest me on that Please
@aiasaiascon3894
@aiasaiascon3894 9 күн бұрын
We don't drag any more... We don't drag any more Like we used to dooooooooooooooo !!!
@VikashGupta-ht3um
@VikashGupta-ht3um 10 күн бұрын
I have almost six packs on my finger 😂😂
@tdkotobo6522
@tdkotobo6522 3 күн бұрын
There is no sequence function in Excel 2019
@greenvally8467
@greenvally8467 10 күн бұрын
@Kalicharan2737r9t
@Kalicharan2737r9t 10 күн бұрын
You missed ctrl d & ctrl r😅
@5pctLowBattery
@5pctLowBattery 10 күн бұрын
😎
@2011Anurag1
@2011Anurag1 7 күн бұрын
😁
@viveklee7
@viveklee7 10 күн бұрын
😂😂😂
@pgkannan
@pgkannan 10 күн бұрын
😂
@josephabuo6027
@josephabuo6027 10 күн бұрын
Lol
@rockeyvalley
@rockeyvalley 9 күн бұрын
Better than XLOOKUP? Try SUPERXLOOKUP!
11:39
Excel Off The Grid
Рет қаралды 47 М.
Как Я Брата ОБМАНУЛ (смешное видео, прикол, юмор, поржать)
00:59
The Excel Tool That Does What PivotTables Can’t (File Included)
13:59
MyOnlineTrainingHub
Рет қаралды 118 М.
5 Excel Tricks They Won't Believe
12:43
Access Analytic
Рет қаралды 4,7 М.
The SECRET to Matching TWO Lists in Microsoft Excel!
4:13
Microsoft Excel Tutorials
Рет қаралды 23 М.
Try This Function Instead of IF Statements
12:51
Kenji Explains
Рет қаралды 43 М.
Change These 10 Settings Before You Use Excel Again
12:44
Kenji Explains
Рет қаралды 56 М.
Learn Power Query & Automate Boring Data Tasks in 15 Minutes!
18:45
Excel's dirty little secrets - 5 things it does you don't expect!
11:25
Excel Off The Grid
Рет қаралды 44 М.
Learn SQL + Database Concepts in 20 Minutes
24:34
Chandoo
Рет қаралды 82 М.