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.
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.
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.
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 !
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?
hello chandoo! what if you have number 2 on A1 and number 4 on A2? if you select both and drag, it will give you 2, 4, 6, 8... how would you put just even or odd numbers using the sequence function? sequence + 2?
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.
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 .
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.
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
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.
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.
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
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 ?
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
Let's pledge to stop Dragging 😂
I pledge too😅😅
I have been learning from chandoo since 2024 January and got a job on April as junior data analyst. I appreciate alot
Woohoo 🎉🎉🎉
What are all the Topics You Covered? will you please Mention The Playlist you watched
Am planning for 2025 let me also post once I got the job
What did you learn could you please share I also want to start
Wow
This is highly inspiring
You are a genius not only in Excel but also in Content creation 👏
These kind of videos is what makes your Channel Best, learned a lot from you 🎉
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.
The wait is over. I got my favorite Chandu video. ❤
The king ever seen in data analysis
Best teacher award!! Thank you
Nice and interesting video.Thank you for sharing this and your knowledges with us. 👍😃
That is hell of new learnings, thanks man
Those are pretty good tips!
I had a idea about Sequence function as you teach us earlier. but you give some advance information Thanks Chandoo.
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.
Excellent...! Very practical for daily tasks
Excellent Chandoo, thanks!
Thanks for adding some humor in this video!
Wow! This is new and useful excel trick.
explanation is very good sir i watched all ur videos , i need to learn about business analytics please make a videos in ur way
Very nice Mr. C😊
Extraordinary 🤩
Sir super ga explain chestunaru alage quick books,xero,sega telugu lo explain cheyara plz
Bro is best ❤
Very informative. ❤🙏😊
Great 👍🏻😃
I love this. I feel inspired.
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.
I am a big fan of fill series too.
good one!👍👍🏼👍🏼👍🏼
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 !
😂 Happy, when you are, Aging, you stop.
Just discovered ❤
Thanks chandoo
Hey, what happen to your hairstyle Chandu, looking great in this one
🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣Super duper mega Fun!!!!🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣
😂😂😂😂😂 informative thanks
Commenting for the algorithm
No more dragging
You will go to Mars in draging!!💀💀
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?
hello chandoo!
what if you have number 2 on A1 and number 4 on A2? if you select both and drag, it will give you 2, 4, 6, 8...
how would you put just even or odd numbers using the sequence function? sequence + 2?
You can use step option of Sequence to do that.
For example
=SEQUENCE(10,,2,2) will generate 10 even numbers starting from 2.
Excellent information as always!
How do we get an alphabet sequence that continues into double letters (AA, AB, AC, etc.)?
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.
@chandoo_ That's awesome! Thank you!
could you please make videos on Numpy python
How can I use this with a formal cell and cloumn having 10lk rows 😅
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 .
What do you mean by "any leakage of information on your free videos"?
Right
give us practice worksheet..plz
@chandoo
How can one get the data to practice with?
There is no data. You can write the sequence formulas yourself.
Hi sir, in Ms Excel Sequence option not showing...
how to fill monday to sunday using sequence function?
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.
@chandoo_ Okay thanks
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
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.
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
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.
I have almost six packs on my finger 😂😂
Thanks Chandoo
Is there any efficient way to drag vlookup formulae?
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
dragging or rushing?
How to run excell free on android tablet (10.5 inch)
y u dont participate in financial modelling world cup,i m sure u will win
We don't drag any more...
We don't drag any more
Like we used to dooooooooooooooo !!!
sir give some discount on excel course for telugu students
❤
Hello Chndoo Madhuri here i am looking for Projects for data analyst I would like you to suggest me on that Please
There is no sequence function in Excel 2019
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.
😎
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 ?
At 3:38 you started to drag columns again (shrugs)
Exactly😂
Haha... good catch. That is not dragging. That is just "selecting".
😁
You missed ctrl d & ctrl r😅
😂😂😂
😂
Lol
Please Change your Hairstyle.
The iconic earlier one is better than the current one.
😍😂 Thanks for that...
I like to experiment.
I would like your email address; I want to send something to you
❤