Chandoo you’ve been the OG of excel teaching for years - great to find you on RUclips. And thanks for the humble way you’ve shared your spectacular skills all these years!
0:00 - Introduction 00:18 - Extracting first name with Flash fill feature of Excel 1:47 - Converting numbers to percentages 3:18 - Remove blank cells or rows using Goto special 4:43 - Find common values between two lists 5:32 - Clean-up ugly formats with one click 6:15 - Bonus trick #1 - Remove extra spaces 7:30 - Unstack data easily with simple formulas 9:44 - Removing duplicate combinations in your data 10:37 - Deleting yellow or any colour cells 12:09 - Extract numbers from text values easily 13:35 - Get file names from full path with Find Replace in Excel 15:36 - Bonus trick #2 - Dealing with numbers formatted as text
you are a genius sir, your way of teaching, your example and your English is so simple. I don't have words to say thanks. your example no#6 is most useful for me.
Love you so much Brother...For Your practice sheet and for the tutorial. It Saves lot of time. May Allah bless You all with success, health, happiness, patience and strength.
Great thanks, Chandoo for this video! Especially thanks for special way #2 with data format. Usually i write formula "Ifmistakes", but your way more easy and fast, cool 👌
Very nice ^^ For #8 I think it’s helpful to also mention that the Find, Format button, drop down allows you to select a specific cell to just pull the format from. It helps if you don’t know the exact color you want to duplicate.
@@chandoo_ People like you have been making many of our career. Thank you is not enough for your work. I am addicted with Excel you can say as I have been using it for last few years. Still love to watch videos online and learn new tricks. Keep it up. I am following you videos.
Awesome tricks! Thanks you Chandoo👌I truly want express how much I appreciate all your efforts in helping us learning through your awesome videos and the useful practice files you prepare for us.
I m from non technical background and my confidence was very low..I can say these videos give me boost and make me to try and put efforts.. thank you sir..
You rock as always. Re#8: Once you do the "Find All" you can also use Ctrl+A to select all of the found values without having to scroll down and select all of them (there may be hundreds).
I do most of these practices but I didn't know that there's a flash fill function. I wasn't aware haha that's much faster and easier than doing delimit or formulas!!! Perfect! And very clear explanations. Yesterday was my first time watching your vid, but now I'm subscribing 👏💪🤟
Hi Chandoo, For #6: What I can do is just copy the 3 cell and go to Street cell and do Alt e+s+e(transpose) then enter. Stacked will be done in few seconds.
Hi Chandoo. Great Vidéo/ I'm new to your channel and subscribed. I speak french but i understand your vids. My contribution to the #6 unstacking data: Another way to Unstack Data First, write these formulas like this: E6=C6; F6=C7 and G6=C8 in the first row
Then select the first 3 rows
Then use the fill handle to copy down(fill without formats) Then copy paste as value to get rid of the underlying formula
From here, to get rid of blank cells, select the range (without the header) and sort from Z to A
Great video! Thank you! I just started using the last Bonus trick recently, after I had learned about it. It comes in very handy, because that is a big issue!
Amazing job Chandoo. Loved all your videos. Plz keep doing gr8 job. A quick ques on tip-9, when i try to type numver un 2nd cell, flash does shows all bottom values in dollar but goes away quickly too. How do I get it in all cells?
Excellent video Chandoo and we particular like the section at 9:44 - (Removing duplicate combinations in your data) as this is something we have been working on for many years in our tools, and although Excel has a very quick method of finding and removing duplicates we find that by combining advanced data matching algorithms with configurable lookup libraries can provide the most accurate results.
Here is a dead simple way...Lol. I love this guy's videos. Great job Chandoo.
Chandoo you’ve been the OG of excel teaching for years - great to find you on RUclips. And thanks for the humble way you’ve shared your spectacular skills all these years!
Thank you Seven. 😀
This is a phenomenal video. Very clear and helpful instructions at just the right pace. Well done and thank you, Chandoo!
0:00 - Introduction
00:18 - Extracting first name with Flash fill feature of Excel
1:47 - Converting numbers to percentages
3:18 - Remove blank cells or rows using Goto special
4:43 - Find common values between two lists
5:32 - Clean-up ugly formats with one click
6:15 - Bonus trick #1 - Remove extra spaces
7:30 - Unstack data easily with simple formulas
9:44 - Removing duplicate combinations in your data
10:37 - Deleting yellow or any colour cells
12:09 - Extract numbers from text values easily
13:35 - Get file names from full path with Find Replace in Excel
15:36 - Bonus trick #2 - Dealing with numbers formatted as text
Thank you for these time stamps
Thank u sir
@@Jupiter_176 sambh
OMG - this is the very best Excel video ever. Need to watch like 5 times and takes note. Gold found here.
Wow, thanks!
Thank you, Chandoo. I got the recommendation from one of my colleague in Manila. Very simple and effective presentation.
Glad it was helpful!
Hope you know that you saved a lot of lives with this video. Great content.
Chandoo has become my lecturer in my journey of becoming an analyst, learning as I practice is the best experience. Thanks, Chandoo.
Never skip ads when watching his videos. Dead simple way to thank Chandoo 😉.
Thank You So much, I have always struggled with Numbers in Text Format, but after watching the video I have got the solution.
Fantastic! I have been using Excel for years and these tecnique will improve A LOT my skills for Data Cleaning. Thank you so much!
Chandoo sir, you are my lifeline... I can't imagine using the excel without your videos. Marvelous job !!!
Love from India.
Some are so easy but will save you time. I needed to know number 3, which will save me about 60to 90 minutes of work tomorrow. Thank you so much!!!
Learned so many new things that will increase my productivity and save me more time. Thanks a lot Chandoo. Your fan since a decade.
you are a genius sir, your way of teaching, your example and your English is so simple. I don't have words to say thanks. your example no#6 is most useful for me.
You are most welcome
OH MY GODD... You have no idea how valuable the bonus trick #2 is. I'm literally crying after finding the solution to this probelm 😭
Wow.. Awesome to hear that Swapnil.
Chandoo. Thanks, keep this up. This will make many people’s lives easy.
Now i am ready for my interview Thank you boss Stay blessed
Finding your channel is literally blessing for me thanks lot!❤
I think that unstacking method might be a game changer for me. THANKS!
Happy to find you in youtube. you ease my burden of extracting, cleaning and analyzing data for my report.
Salamat po.
One of the best Excel tutorial!
Wow, thanks!
Chandoo to be true bcoz of you i am trying to learn much about excel day on day basis , Great Guru!!!
Thank you sir for giving such a beautiful gift of knowledge.
Fantastic 🎉
Some of the trick I had know before but I learnt many
🙏
Awesome.. I know you since 8 years ago however following u now.... My bad, I could follow you at the beginning...
You are really amazing....
I really enjoy learning excel from your videos.... very simple and quick to understand..Thanks
These are really powerful tips. Thanks
You're so welcome!
Chandoo Man!!! you're changing people's lives. Great content!
Thanks a lot Chandoo. One of the best Excel gurus on the net.
Dude, do you have SQL cleaning tutorial? You know what you are doing and most importantly you can teach!! You’ve made many people’s life a lot easier.
Dude - your tips are awesome! I tried each one, they work and you explanations are easy to follow. Thank you so much
Love you so much Brother...For Your practice sheet and for the tutorial. It Saves lot of time. May Allah bless You all with success, health, happiness, patience and strength.
Great video. I added it to several playlists just so I know I can find it quickly for reference. Thanks.
Thank you so much, you are distinguished and always presents new information
Simply superb chandhu Anna❤🎉
Midway through the video and this is already the best excel video I've seen
Great thanks, Chandoo for this video!
Especially thanks for special way #2 with data format.
Usually i write formula "Ifmistakes",
but your way more easy and fast, cool 👌
Most of them i know as financial guy but few are unique. Thank you Chandoo. GOD BLESS YOU.
Thanks Nitin...
Bonus 2 is really helpful sir bcoz we received invoice in excel that time we faced this problem thank you so much sir love u lot from maharashtra
Very nice ^^ For #8 I think it’s helpful to also mention that the Find, Format button, drop down allows you to select a specific cell to just pull the format from. It helps if you don’t know the exact color you want to duplicate.
Good tip!
Knew most of these but enjoyed the way you presented. Excellent presentation and voice. Thank you for sharing.
Thank you. I am glad you enjoyed this.
@@chandoo_ People like you have been making many of our career. Thank you is not enough for your work. I am addicted with Excel you can say as I have been using it for last few years. Still love to watch videos online and learn new tricks. Keep it up. I am following you videos.
Thank you. I learnt +go to,clear,flex,format operation devide,multiply,add
Greatest of All time 🐐
/even though I am good at excel, your channel is very refreshing and I still learn a lot
Chandoo, thanks for your video content. 've just come across it and you are an excellent teacher.
Awesome tricks! Thanks you Chandoo👌I truly want express how much I appreciate all your efforts in helping us learning through your awesome videos and the useful practice files you prepare for us.
I just have one word for this video: wow! I guess I could add 'thank you' for all those great tips too!
You are so welcome!
I love those tips. For #10, converting text to number, highlight the range and use ALT+D+E+F. Much faster than a paste special.
Great tip! The old Text Import wizard saves the day !!!
Value() or Multiply by 1 also work. Great video thanks!
I m from non technical background and my confidence was very low..I can say these videos give me boost and make me to try and put efforts.. thank you sir..
Thank you so much man
Very useful and well presented
You rock as always. Re#8: Once you do the "Find All" you can also use Ctrl+A to select all of the found values without having to scroll down and select all of them (there may be hundreds).
Wow... that is a good tip Adam. Donut for you 🍩
@@chandoo_ you are too kind Sir
" Super Thala" by watching video i can feel the Worth of this video keep doing....!!!
Wow. You made it so simple. Thank you
You’re welcome 😊
Found your channel today. Your method of teaching is amazing.
This is excellent. Awesome job
Thank you very much!
You are the Guru in excel.
Great video and the "Monika" with the "k"... Priceless!! 😄
I do most of these practices but I didn't know that there's a flash fill function. I wasn't aware haha that's much faster and easier than doing delimit or formulas!!! Perfect! And very clear explanations. Yesterday was my first time watching your vid, but now I'm subscribing 👏💪🤟
That's awesome! Welcome and more power to you. 😀
Thank you for sharing these tricks. I've always been a big fan of your tips... glad to see that you now have a thriving RUclips channel as well!!
Happy to hear that!
Guru ji tusi grt ho toofa kubul karo😁😁😁.thanku u r such a grt trainer...
Thank you thank you...
Just wow 🙏 super explanation sir ... Just watching 10 m .iam decided to subscribe this channel .. what a explanation 🙏🙏 great sir
Wow... welcome to our little corner of the world :)
liked the way you got file name from full path, this is one thing we need on daily basis,, thanks, loved it
Your videos are really helpfull and understandable.Thanks for your great work Chandoo
Woahh! nr 6: stacked columns, what a great and easy way to fix this! well done Chandoo!
I know, right?
@@chandoo_ how to make it dynamic sir?
Learn to do this in Power Query or a Pivot table. Power Query in particular will blow your mind. In my opinion, #6 won't work in many cases.
Hi Chandoo,
For #6: What I can do is just copy the 3 cell and go to Street cell and do Alt e+s+e(transpose) then enter. Stacked will be done in few seconds.
@@vikashaldar982 agree, but it is going to take longer.
I really enjoyed watching this...I get to know lots of excel tricks in this video ...thanks a lot for this useful video sir
You are most welcome
You are just Awesome Chandoo..All your tricks are mind blowing!
Looking forward to watch more wonderful videos.. Thanks!
Thank you so much 😀
super cool tricks. I wish I knew about them during my heydays! thank you for sharing!
Hi Chandoo. Great Vidéo/ I'm new to your channel and subscribed. I speak french but i understand your vids. My contribution to the #6 unstacking data:
Another way to Unstack Data
First, write these formulas like this: E6=C6; F6=C7 and G6=C8 in the first row
Then select the first 3 rows
Then use the fill handle to copy down(fill without formats)
Then copy paste as value to get rid of the underlying formula
From here, to get rid of blank cells, select the range (without the header) and sort from Z to A
And you are done
Welcome to my channel Thierno...
Thanks for this beautiful tip.
Great techniques Chandoo... Especially unstacking the data & extracting file name from the path.. I am from Hyderabad.
Thanks a ton. My mom lives in Hyd too...
Thank you chandoo sir for making this type of videos, it really help us in our work
Great video Chandoo! Loving your videos and learning excel.. Thanks!
Awesome video!
Bonus trick #2 is just legendary.
Excellent Excel tutorial!
Keep it up 🦾🦾
You are absolutely amazing. Thank you for your videos
Thank you so much for showing us these smart solutions in Excel.
Brilliant Video !!Thanks a lot for sharing such wonderful tricks.
Great video, thanks!
Glad you liked it!
Last one was dedliest trick ...🤙🏻🤙🏻✨✨
Thank you :)
Some elegant built-in alternatives to using mid() and find(). The one to extract numbers is awesome
Glad you found those useful.
You are awesome my friend and your mission to make people awesome in Excel is commendable.
Thanks a lot for sharing your knowledge.
Thanks Rawat. I like learning and sharing.
Video was helpful as always , Thanks Chandoo !
Wow - this dude is amazing - this was so useful. Thanks for the video!
Thanks Anthony 😀
Great video! Thank you! I just started using the last Bonus trick recently, after I had learned about it. It comes in very handy, because that is a big issue!
Thank you. Well explained in your video. Thanks once again.
You are welcome!
Thank you Chandoo, please keep going with your videos!!!!
Hi sir, your knowledge in excel and visualisation tools is vast and very good. Thanks for sharing!
So nice of you
Chandoo huge help indeed! Much thanks for your time and such valuable videos.
My pleasure!
You are always unique , no words great one .
Really cool tricks... Flash fill and finding color formatted cells.
Thanks Nirmal...
Helo Chandoo. Just a thanks for the free lesson. So helpful to me.
sir ap mahan ho ap na hote toh aj mein excel kar nahi pata ......thxxs a lott to u
Thanks KBG...
Good Stuff. Thumbs up for dear Chandoo, I learnt a lot. God bless you.
Amazing. This guy is wizard.
Amazing job Chandoo. Loved all your videos. Plz keep doing gr8 job. A quick ques on tip-9, when i try to type numver un 2nd cell, flash does shows all bottom values in dollar but goes away quickly too. How do I get it in all cells?
hmm. You can trigger it again with Ctrl+E. Let me know if that doesn't work.
Dirty Data is a pain.!! Wow, Million thanks for your video.
Number 6 the BEST one! Once again brilliant stuff from the master.
Thanks Chris... :)
You are amazing and so simple, no loud mouth to advertise our sell the courses,👏God Bless You Chandoo Sir
Thanks Andy for your love and blessings :)
Hi Chandoo!
Watching your videos from Bangladesh... Every content is Simply great....Non stop watching 😀😀👍👍❤️❤️
Thank you so much 😀
Excellent video Chandoo and we particular like the section at 9:44 - (Removing duplicate combinations in your data) as this is something we have been working on for many years in our tools, and although Excel has a very quick method of finding and removing duplicates we find that by combining advanced data matching algorithms with configurable lookup libraries can provide the most accurate results.