Stop Dragging in Excel, there is a BETTER way!

  Рет қаралды 45,869

Chandoo

Chandoo

Күн бұрын

Пікірлер
@sundertalreja7208
@sundertalreja7208 19 күн бұрын
Let's pledge to stop Dragging 😂
@DanielOnyedikachiOkwandu
@DanielOnyedikachiOkwandu 2 күн бұрын
I pledge too😅😅
@Ernestowino
@Ernestowino 18 күн бұрын
I have been learning from chandoo since 2024 January and got a job on April as junior data analyst. I appreciate alot
@chandoo_
@chandoo_ 18 күн бұрын
Woohoo 🎉🎉🎉
@sureshj8945
@sureshj8945 10 күн бұрын
What are all the Topics You Covered? will you please Mention The Playlist you watched
@BhuvaneshSekar-u2h
@BhuvaneshSekar-u2h 4 күн бұрын
Am planning for 2025 let me also post once I got the job
@Office_and_Chai
@Office_and_Chai 2 күн бұрын
What did you learn could you please share I also want to start
@MC_Alaba
@MC_Alaba 17 сағат бұрын
Wow This is highly inspiring
@subratkumarpurohit8686
@subratkumarpurohit8686 17 күн бұрын
You are a genius not only in Excel but also in Content creation 👏
@GurayVural-nz1lk
@GurayVural-nz1lk 16 күн бұрын
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.
@namy1557
@namy1557 16 күн бұрын
These kind of videos is what makes your Channel Best, learned a lot from you 🎉
@ShuvooRahman-k4o
@ShuvooRahman-k4o 17 күн бұрын
The wait is over. I got my favorite Chandu video. ❤
@akashmaity_22
@akashmaity_22 7 күн бұрын
That is hell of new learnings, thanks man
@JJ-ml7wo
@JJ-ml7wo 12 күн бұрын
Best teacher award!! Thank you
@mamadi2camara65
@mamadi2camara65 19 күн бұрын
The king ever seen in data analysis
@ArifKhan-qo9jw
@ArifKhan-qo9jw 19 күн бұрын
I had a idea about Sequence function as you teach us earlier. but you give some advance information Thanks Chandoo.
@gregofthelake
@gregofthelake 19 күн бұрын
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.
@Rahul-f2p2i
@Rahul-f2p2i 19 күн бұрын
explanation is very good sir i watched all ur videos , i need to learn about business analytics please make a videos in ur way
@mohammedjawad8182
@mohammedjawad8182 18 күн бұрын
Excellent...! Very practical for daily tasks
@mr5bassman
@mr5bassman 19 күн бұрын
Excellent information as always! How do we get an alphabet sequence that continues into double letters (AA, AB, AC, etc.)?
@chandoo_
@chandoo_ 19 күн бұрын
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 17 күн бұрын
@chandoo_ That's awesome! Thank you!
@chrism9037
@chrism9037 19 күн бұрын
Excellent Chandoo, thanks!
@swastiktripathy8412
@swastiktripathy8412 17 күн бұрын
Wow! This is new and useful excel trick.
@manilucky-ee5po
@manilucky-ee5po 16 күн бұрын
Sir super ga explain chestunaru alage quick books,xero,sega telugu lo explain cheyara plz
@nayanreddy9661
@nayanreddy9661 17 күн бұрын
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?
@nipunchibber250
@nipunchibber250 19 күн бұрын
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_ 19 күн бұрын
😂 Happy, when you are, Aging, you stop.
@keziadrevdal5766
@keziadrevdal5766 18 күн бұрын
Thanks for adding some humor in this video!
@YvesAustin
@YvesAustin 18 күн бұрын
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_ 18 күн бұрын
I am a big fan of fill series too.
@gamerharry8905
@gamerharry8905 10 күн бұрын
Bro is best ❤
@abhijeetghosh27
@abhijeetghosh27 19 күн бұрын
Very informative. ❤🙏😊
@discretetantrum
@discretetantrum 10 күн бұрын
Thanks Chandoo Is there any efficient way to drag vlookup formulae?
@chandoo_
@chandoo_ 10 күн бұрын
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
@MrDhunpagla
@MrDhunpagla 18 күн бұрын
Very nice Mr. C😊
@xjk101
@xjk101 19 күн бұрын
I love this. I feel inspired.
@MC_Alaba
@MC_Alaba 17 сағат бұрын
@chandoo How can one get the data to practice with?
@chandoo_
@chandoo_ 17 сағат бұрын
There is no data. You can write the sequence formulas yourself.
@charut2733
@charut2733 19 күн бұрын
Extraordinary 🤩
@mylearningplatform_easytoway
@mylearningplatform_easytoway 13 күн бұрын
Great 👍🏻😃
@adnanabbasi9482
@adnanabbasi9482 18 күн бұрын
good one!👍👍🏼👍🏼👍🏼
@agasteen2423
@agasteen2423 19 күн бұрын
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_ 19 күн бұрын
What do you mean by "any leakage of information on your free videos"?
@charancherry8637
@charancherry8637 6 күн бұрын
could you please make videos on Numpy python
@SPK_kaushik
@SPK_kaushik 12 күн бұрын
how to fill monday to sunday using sequence function?
@chandoo_
@chandoo_ 12 күн бұрын
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 11 күн бұрын
@chandoo_ Okay thanks
@songwejohnpwele9315
@songwejohnpwele9315 10 күн бұрын
Just discovered ❤
@syedali-qg3nc
@syedali-qg3nc 11 күн бұрын
Hey, what happen to your hairstyle Chandu, looking great in this one
@stoicdarwin
@stoicdarwin 19 күн бұрын
Commenting for the algorithm
@naniyadav8624
@naniyadav8624 12 күн бұрын
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
@vasusoni8866
@vasusoni8866 6 күн бұрын
Please give a solution if i have not installed excel in laptop then how i can use excel free in laptop without sign in process
@chandoo_
@chandoo_ 6 күн бұрын
Excel is a paid product. You can't use it for free. There is a limited feature version of Excel for free on browser. Just go to excel.new and use it. Or use the free alternatives from Google sheets or open office.
@lakshmanvajjakeshavula5380
@lakshmanvajjakeshavula5380 19 күн бұрын
Thanks chandoo
@Sandroider
@Sandroider 19 күн бұрын
dragging or rushing?
@aiasaiascon3894
@aiasaiascon3894 18 күн бұрын
🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣Super duper mega Fun!!!!🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣
@AnandKumar-hl2ug
@AnandKumar-hl2ug 6 күн бұрын
give us practice worksheet..plz
@nazarkamal8831
@nazarkamal8831 19 күн бұрын
😂😂😂😂😂 informative thanks
@researchr
@researchr 16 күн бұрын
Right
@myneninagasivasai1414
@myneninagasivasai1414 19 күн бұрын
sir give some discount on excel course for telugu students
@sharadbassshow
@sharadbassshow 7 күн бұрын
How to run excell free on android tablet (10.5 inch)
@Dzeidzorm
@Dzeidzorm 11 күн бұрын
No more dragging
@kommulachaitanyabharathi5832
@kommulachaitanyabharathi5832 20 күн бұрын
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 17 күн бұрын
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.
@madhurikesoju
@madhurikesoju 18 күн бұрын
Hello Chndoo Madhuri here i am looking for Projects for data analyst I would like you to suggest me on that Please
@tdkotobo6522
@tdkotobo6522 13 күн бұрын
There is no sequence function in Excel 2019
@Fardin396
@Fardin396 19 күн бұрын
You will go to Mars in draging!!💀💀
@scotttheniceguy
@scotttheniceguy 19 күн бұрын
At 3:38 you started to drag columns again (shrugs)
@RituShah
@RituShah 19 күн бұрын
Exactly😂
@chandoo_
@chandoo_ 19 күн бұрын
Haha... good catch. That is not dragging. That is just "selecting".
@zarintasnimarshe874
@zarintasnimarshe874 8 күн бұрын
Hi! I have been watching your videos like 10 days continuously. Your videos are awesome. But recently I am facing problems regarding using microsoft 365 functions in excel. Can you create a video about this ? How to solve this problem ? How can I use 365 functions in excel ?
@VikashGupta-ht3um
@VikashGupta-ht3um 19 күн бұрын
I have almost six packs on my finger 😂😂
@Wallaha11
@Wallaha11 3 күн бұрын
y u dont participate in financial modelling world cup,i m sure u will win
@aiasaiascon3894
@aiasaiascon3894 18 күн бұрын
We don't drag any more... We don't drag any more Like we used to dooooooooooooooo !!!
@greenvally8467
@greenvally8467 20 күн бұрын
@2011Anurag1
@2011Anurag1 16 күн бұрын
😁
@5pctLowBattery
@5pctLowBattery 19 күн бұрын
😎
@Kalicharan2737r9t
@Kalicharan2737r9t 19 күн бұрын
You missed ctrl d & ctrl r😅
@viveklee7
@viveklee7 20 күн бұрын
😂😂😂
@pgkannan
@pgkannan 20 күн бұрын
😂
@josephabuo6027
@josephabuo6027 19 күн бұрын
Lol
@samvelbarseghyan9307
@samvelbarseghyan9307 8 күн бұрын
I would like your email address; I want to send something to you
@rockeyvalley
@rockeyvalley 18 күн бұрын
50 things you didn't know Excel can DO 💡
30:03
Chandoo
Рет қаралды 282 М.
Try This Function Instead of IF Statements
12:51
Kenji Explains
Рет қаралды 62 М.
To Brawl AND BEYOND!
00:51
Brawl Stars
Рет қаралды 17 МЛН
1% vs 100% #beatbox #tiktok
01:10
BeatboxJCOP
Рет қаралды 67 МЛН
Learn Power Query & Automate Boring Data Tasks in 15 Minutes!
18:45
5 Conditional Formatting Hacks That Will Blow Your Mind
11:16
Mike’s F9 Finance
Рет қаралды 9 М.
Excel's dirty little secrets - 5 things it does you don't expect!
11:25
Excel Off The Grid
Рет қаралды 51 М.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 270 М.
The Excel Tool That Does What PivotTables Can’t (File Included)
13:59
MyOnlineTrainingHub
Рет қаралды 169 М.
Change These 10 Settings Before You Use Excel Again
12:44
Kenji Explains
Рет қаралды 75 М.
The Excel Functions Almost Everyone Overlooks (Better Than SUMIFS)
10:29
MyOnlineTrainingHub
Рет қаралды 113 М.
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Teacher's Tech
Рет қаралды 594 М.
To Brawl AND BEYOND!
00:51
Brawl Stars
Рет қаралды 17 МЛН