Stop Dragging in Excel, there is a BETTER way!

[@sundertalreja7208]

Let's pledge to stop Dragging 😂

[@DanielOnyedikachiOkwandu]

I pledge too😅😅

[@Ernestowino]

I have been learning from chandoo since 2024 January and got a job on April as junior data analyst. I appreciate alot

[@chandoo_]

Woohoo 🎉🎉🎉

[@sureshj8945]

What are all the Topics You Covered? will you please Mention The Playlist you watched

[@BhuvaneshSekar-u2h]

Am planning for 2025 let me also post once I got the job

[@Office_and_Chai]

What did you learn could you please share I also want to start

[@MC_Alaba]

Wow This is highly inspiring

[@subratkumarpurohit8686]

You are a genius not only in Excel but also in Content creation 👏

[@GurayVural-nz1lk]

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]

These kind of videos is what makes your Channel Best, learned a lot from you 🎉

[@ShuvooRahman-k4o]

The wait is over. I got my favorite Chandu video. ❤

[@akashmaity_22]

That is hell of new learnings, thanks man

[@JJ-ml7wo]

Best teacher award!! Thank you

[@mamadi2camara65]

The king ever seen in data analysis

[@ArifKhan-qo9jw]

I had a idea about Sequence function as you teach us earlier. but you give some advance information Thanks Chandoo.

[@gregofthelake]

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]

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]

Excellent...! Very practical for daily tasks

[@mr5bassman]

Excellent information as always! How do we get an alphabet sequence that continues into double letters (AA, AB, AC, etc.)?

[@chandoo_]

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]

@chandoo_ That's awesome! Thank you!

[@chrism9037]

Excellent Chandoo, thanks!

[@swastiktripathy8412]

Wow! This is new and useful excel trick.

[@manilucky-ee5po]

Sir super ga explain chestunaru alage quick books,xero,sega telugu lo explain cheyara plz

[@nayanreddy9661]

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]

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_]

😂 Happy, when you are, Aging, you stop.

[@keziadrevdal5766]

Thanks for adding some humor in this video!

[@YvesAustin]

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_]

I am a big fan of fill series too.

[@gamerharry8905]

Bro is best ❤

[@abhijeetghosh27]

Very informative. ❤🙏😊

[@discretetantrum]

Thanks Chandoo Is there any efficient way to drag vlookup formulae?

[@chandoo_]

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]

Very nice Mr. C😊

[@xjk101]

I love this. I feel inspired.

[@MC_Alaba]

@chandoo How can one get the data to practice with?

[@chandoo_]

There is no data. You can write the sequence formulas yourself.

[@charut2733]

Extraordinary 🤩

[@mylearningplatform_easytoway]

Great 👍🏻😃

[@adnanabbasi9482]

good one!👍👍🏼👍🏼👍🏼

[@agasteen2423]

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_]

What do you mean by "any leakage of information on your free videos"?

[@charancherry8637]

could you please make videos on Numpy python

[@SPK_kaushik]

how to fill monday to sunday using sequence function?

[@chandoo_]

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]

@chandoo_ Okay thanks

[@songwejohnpwele9315]

Just discovered ❤

[@syedali-qg3nc]

Hey, what happen to your hairstyle Chandu, looking great in this one

[@stoicdarwin]

Commenting for the algorithm

[@naniyadav8624]

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]

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_]

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]

Thanks chandoo

[@Sandroider]

dragging or rushing?

[@aiasaiascon3894]

🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣Super duper mega Fun!!!!🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣

[@AnandKumar-hl2ug]

give us practice worksheet..plz

[@nazarkamal8831]

😂😂😂😂😂 informative thanks

[@researchr]

Right

[@myneninagasivasai1414]

sir give some discount on excel course for telugu students

[@sharadbassshow]

How to run excell free on android tablet (10.5 inch)

[@Dzeidzorm]

No more dragging

[@kommulachaitanyabharathi5832]

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]

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]

Hello Chndoo Madhuri here i am looking for Projects for data analyst I would like you to suggest me on that Please

[@tdkotobo6522]

There is no sequence function in Excel 2019

[@Fardin396]

You will go to Mars in draging!!💀💀

[@scotttheniceguy]

At 3:38 you started to drag columns again (shrugs)

[@RituShah]

Exactly😂

[@chandoo_]

Haha... good catch. That is not dragging. That is just "selecting".

[@zarintasnimarshe874]

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]

I have almost six packs on my finger 😂😂

[@Wallaha11]

y u dont participate in financial modelling world cup,i m sure u will win

[@aiasaiascon3894]

We don't drag any more... We don't drag any more Like we used to dooooooooooooooo !!!

[@greenvally8467]

❤

[@2011Anurag1]

😁

[@5pctLowBattery]

😎

[@Kalicharan2737r9t]

You missed ctrl d & ctrl r😅

[@viveklee7]

😂😂😂

[@pgkannan]

😂

[@josephabuo6027]

Lol

[@samvelbarseghyan9307]

I would like your email address; I want to send something to you

[@rockeyvalley]

❤