I have been learning from chandoo since 2024 January and got a job on April as junior data analyst. I appreciate alot
@chandoo_9 күн бұрын
Woohoo 🎉🎉🎉
@sureshj894512 сағат бұрын
What are all the Topics You Covered? will you please Mention The Playlist you watched
@subratkumarpurohit86868 күн бұрын
You are a genius not only in Excel but also in Content creation 👏
@namy15577 күн бұрын
These kind of videos is what makes your Channel Best, learned a lot from you 🎉
@mamadi2camara659 күн бұрын
The king ever seen in data analysis
@GurayVural-nz1lk7 күн бұрын
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-ml7wo3 күн бұрын
Best teacher award!! Thank you
@ShuvooRahman-k4o8 күн бұрын
The wait is over. I got my favorite Chandu video. ❤
@mohammedjawad81829 күн бұрын
Excellent...! Very practical for daily tasks
@chrism903710 күн бұрын
Excellent Chandoo, thanks!
@ArifKhan-qo9jw10 күн бұрын
I had a idea about Sequence function as you teach us earlier. but you give some advance information Thanks Chandoo.
@gregofthelake10 күн бұрын
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.
@keziadrevdal57669 күн бұрын
Thanks for adding some humor in this video!
@swastiktripathy84128 күн бұрын
Wow! This is new and useful excel trick.
@Rahul-f2p2i9 күн бұрын
explanation is very good sir i watched all ur videos , i need to learn about business analytics please make a videos in ur way
@YvesAustin8 күн бұрын
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_8 күн бұрын
I am a big fan of fill series too.
@xjk10110 күн бұрын
I love this. I feel inspired.
@MrDhunpagla9 күн бұрын
Very nice Mr. C😊
@abhijeetghosh2710 күн бұрын
Very informative. ❤🙏😊
@gamerharry890512 сағат бұрын
Bro is best ❤
@manilucky-ee5po6 күн бұрын
Sir super ga explain chestunaru alage quick books,xero,sega telugu lo explain cheyara plz
@mylearningplatform_easytoway4 күн бұрын
Great 👍🏻😃
@adnanabbasi94828 күн бұрын
good one!👍👍🏼👍🏼👍🏼
@nipunchibber2509 күн бұрын
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_9 күн бұрын
😂 Happy, when you are, Aging, you stop.
@charut273310 күн бұрын
Extraordinary 🤩
@syedali-qg3nc2 күн бұрын
Hey, what happen to your hairstyle Chandu, looking great in this one
@nayanreddy96618 күн бұрын
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?
@mr5bassman9 күн бұрын
Excellent information as always! How do we get an alphabet sequence that continues into double letters (AA, AB, AC, etc.)?
@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.
@mr5bassman8 күн бұрын
@chandoo_ That's awesome! Thank you!
@discretetantrum18 сағат бұрын
Thanks Chandoo Is there any efficient way to drag vlookup formulae?
@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
@lakshmanvajjakeshavula538010 күн бұрын
Thanks chandoo
@stoicdarwin10 күн бұрын
Commenting for the algorithm
@songwejohnpwele9315Күн бұрын
Just discovered ❤
@agasteen24239 күн бұрын
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_9 күн бұрын
What do you mean by "any leakage of information on your free videos"?
@aiasaiascon38949 күн бұрын
🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣Super duper mega Fun!!!!🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣
@nazarkamal883110 күн бұрын
😂😂😂😂😂 informative thanks
@DzeidzormКүн бұрын
No more dragging
@SPK_kaushik2 күн бұрын
how to fill monday to sunday using sequence function?
@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_kaushik2 күн бұрын
@chandoo_ Okay thanks
@researchr6 күн бұрын
Right
@Sandroider10 күн бұрын
dragging or rushing?
@Fardin39610 күн бұрын
You will go to Mars in draging!!💀💀
@myneninagasivasai14149 күн бұрын
sir give some discount on excel course for telugu students
@naniyadav86243 күн бұрын
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
@kommulachaitanyabharathi583210 күн бұрын
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.
@Rood678 күн бұрын
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.
@scotttheniceguy10 күн бұрын
At 3:38 you started to drag columns again (shrugs)
@RituShah10 күн бұрын
Exactly😂
@chandoo_10 күн бұрын
Haha... good catch. That is not dragging. That is just "selecting".
@madhurikesoju8 күн бұрын
Hello Chndoo Madhuri here i am looking for Projects for data analyst I would like you to suggest me on that Please
@aiasaiascon38949 күн бұрын
We don't drag any more... We don't drag any more Like we used to dooooooooooooooo !!!