If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Here are some other Excel tips videos you may find useful: ✅ How to Delete Blank Rows in Excel - th-cam.com/video/2t6gEKjTqvI/w-d-xo.html ✅ How to Remove Leading and Trailing Spaces in Excel - th-cam.com/video/EGien2dwG9M/w-d-xo.html Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course
0:08 Trim extra space 1:19 select blank cells. treat then all the same. 2:39 Convert numbers stored as text into numbers 4:59 Remove duplicates 7:21 Highlight errors 9:24 Change text to lower/UPPER/Proper case 10:54 break up concatenated text (e.g. street address) into separate columns 13:15 Spell check 14:33 Find and Replace 16:59 remove line breaks in text 17:47 Clean (out unwanted characters from) text data
There are many excel teachers in the TH-cam, but i must say the way you guys teach and summarise the functions are awesome. Well done and keep inspiring guys.
Thanks for sharing,buddy.Learn a lot from your channels in easy and simple ways.Hindi:Kee sai ho?T-Koo.Can/t lai lee kai ho can/t lai nei he?Can/t lai nei he kai ah mei tao mei key lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Tao lee tao lee,Hindi,Hindu art dee hei.Mei,Hindi,Hindo art dee hei?Mei India kam kee hei ,kar kee hei.Au bag dai bar kar kar hei,easy art dee hei.Bo ho ma sai he hei.Bar hei bo ho got me hei?Kam beer jar dar ban lee "B lai"Bar hei bo ho bar lish hei?Chut dar sure lure kee mut.Mei jar lai ha hung,Bo ho tek kee hung.Bar mei link it.Mei ban lee.So kar lee ah.Ug lai hip see dai mei link it.So kar lee ah.Doom ah char in shan who?Ji b must sai gar mut dee ho,doom Ma lee ma du jar kee ho.
You are simply Amazing I am a Corporate Graphic designer and time time I receive Excel Documents where I require to do some tweaks and I always face problems, but now I know a place to go to where I get all the solutions with absolutely no nonsense. :)
Simple everyday functions but never cease to learn something new to exploit different ways of using them. Really appreciate the versatility of Find/Replace feature that goes beyond finding and replacing text. Woah! 😲👏👏
1. Not Appear - Better replace with zeros and use formatting to show Text "Not appear. THanks to that pivot and formulas will work better. 2. Instead of looking for Errors it's better to create formula that handles the errrors, such as IFERROR. 3. Ctrl+J - brilliant! 4. (*) - also clever.
Thanks for sharing,buddy.Learn a lot from your channels in easy and simple ways.Hindi:Kee sai ho?T-Koo.Can/t lai lee kai ho can/t lai nei he?Can/t lai nei he kai ah mei tao mei key lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Tao lee tao lee,Hindi,Hindu art dee hei.Mei,Hindi,Hindo art dee hei?Mei India kam kee hei ,kar kee hei.Au bag dai bar kar kar hei,easy art dee hei.Bo ho ma sai he hei.Bar hei bo ho got me hei?Kam beer jar dar ban lee "B lai"Bar hei bo ho bar lish hei?Chut dar sure lure kee mut.Mei jar lai ha hung,Bo ho tek kee hung.Bar mei link it.Mei ban lee.So kar lee ah.Ug lai hip see dai mei link it.So kar lee ah.Doom ah char in shan who?Ji b must sai gar mut dee ho,doom Ma lee ma du jar kee ho.
i am glad to find your channel.the way you teach all these things its really easy to understand.keep posting all these videos..and one more thing your voice is amazing...
Very nice video. Many people are unaware of this Alt+G option which has got numerous useful things for the user. The another wonderful thing which I like; is Ctrl+Enter which fills data for the cells scattered in the data base. technically we call it RELATIVE CELL REFERENCE feature of excel; once again a very useful tool. Thanks for knowledge sharing :)
Thanks for the informative lecture. There is also a formula to apply when dates are resistant to routine formatting; the formula is =DATEVALUE(TEXT(A1,"dd-mm-yyyy")) . NB A1 is the cell number you want to change its Date format
Thanks for this quick and easy demo to clean up data! I want to download file with large amount of data for cleanup practice. Do you know the reliable source from where I can download it?
Waah Sumit! I use Auto Correct a bit too, but it never struck me that entire Formulae could be generated by a few keystrokes! This is excellent learning! Thanks once again for one more EXCELLENT video on Excel! Yes, you did swap the columns in the Formulae Auto Correct part of the video, but thats ok - wish Excel had an Auto Correct option to correct that as well, don't you! 😁😎
I have taken to learning excel on a full time after my retirement in May 2017. First it started as a hobby and now it has become an obsession since it gives me a lot of happiness. I almost spend 4 to 5 hours going through all the excel videos that come in TH-cam and practice each one of them. I can definitely say that the way you teach excel is simply fantastic. All the explanations are extremely crisp. Hats off to your work
Thank you. Excellent. Yes, I learned 2 more tips here. I'm happy to find gems like these. For as long as I've used excel, I can never take for granted I've learned enough. Plus, there are always three ways from which to choose to do one task. As always, with excel, knowing it leads to sharing it. Good users just keep that cycle flowing.
Hi - I have a workbook with 13 sheets. Each sheet has a table which tracks weekly data. Each week I manually add a new row to the top of the table for the newest weeks data and update the formatting and formula in the new row, for each sheet. I then manually update formulas about the table which tracks MIN, MAX, SUM and AVG. Is it possible to automate these steps for all 13 sheets?
If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.
Here are some other Excel tips videos you may find useful:
✅ How to Delete Blank Rows in Excel - th-cam.com/video/2t6gEKjTqvI/w-d-xo.html
✅ How to Remove Leading and Trailing Spaces in Excel - th-cam.com/video/EGien2dwG9M/w-d-xo.html
Also, I have made all of my Excel courses available for free. You can check these out using the below links:
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
💞
0:08 Trim extra space
1:19 select blank cells. treat then all the same.
2:39 Convert numbers stored as text into numbers
4:59 Remove duplicates
7:21 Highlight errors
9:24 Change text to lower/UPPER/Proper case
10:54 break up concatenated text (e.g. street address) into separate columns
13:15 Spell check
14:33 Find and Replace
16:59 remove line breaks in text
17:47 Clean (out unwanted characters from) text data
13:55 Deleting all formatting
For spell check when i pressed F7 , i am getting airplane mode on
@@sophialawrence6880 hit Fn + F7, Fn is your function key, located next to the 'alt' key.
@@sophialawrence6880 press Fn+f7
Do you use some API function to get time stamps or painstakingly do it manually.
i was 8 years old when i watched this video. now im 15 and i wanna say that im the best at excel in the whole neighborhood, thank you sumit bansal
There are many excel teachers in the TH-cam, but i must say the way you guys teach and summarise the functions are awesome. Well done and keep inspiring guys.
Thanks for sharing,buddy.Learn a lot from your channels in easy and simple ways.Hindi:Kee sai ho?T-Koo.Can/t lai lee kai ho can/t lai nei he?Can/t lai nei he kai ah mei tao mei key lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Tao lee tao lee,Hindi,Hindu art dee hei.Mei,Hindi,Hindo art dee hei?Mei India kam kee hei ,kar kee hei.Au bag dai bar kar kar hei,easy art dee hei.Bo ho ma sai he hei.Bar hei bo ho got me hei?Kam beer jar dar ban lee "B lai"Bar hei bo ho bar lish hei?Chut dar sure lure kee mut.Mei jar lai ha hung,Bo ho tek kee hung.Bar mei link it.Mei ban lee.So kar lee ah.Ug lai hip see dai mei link it.So kar lee ah.Doom ah char in shan who?Ji b must sai gar mut dee ho,doom Ma lee ma du jar kee ho.
@@keithau8159 th-cam.com/video/-su8Z4j1p1A/w-d-xo.html
I am agreed!!👏
I've looked at about 15 excel videos and this one was the best and most clearly explained without excessive chit chat..This Professor rocks! thanks.
You are simply Amazing I am a Corporate Graphic designer and time time I receive Excel Documents where I require to do some tweaks and I always face problems, but now I know a place to go to where I get all the solutions with absolutely no nonsense. :)
Simple everyday functions but never cease to learn something new to exploit different ways of using them. Really appreciate the versatility of Find/Replace feature that goes beyond finding and replacing text. Woah! 😲👏👏
1. Not Appear - Better replace with zeros and use formatting to show Text "Not appear. THanks to that pivot and formulas will work better.
2. Instead of looking for Errors it's better to create formula that handles the errrors, such as IFERROR.
3. Ctrl+J - brilliant!
4. (*) - also clever.
No nonsense! Some really great content in a relatively short amount of time.
Thanks for sharing,buddy.Learn a lot from your channels in easy and simple ways.Hindi:Kee sai ho?T-Koo.Can/t lai lee kai ho can/t lai nei he?Can/t lai nei he kai ah mei tao mei key lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Tao lee tao lee,Hindi,Hindu art dee hei.Mei,Hindi,Hindo art dee hei?Mei India kam kee hei ,kar kee hei.Au bag dai bar kar kar hei,easy art dee hei.Bo ho ma sai he hei.Bar hei bo ho got me hei?Kam beer jar dar ban lee "B lai"Bar hei bo ho bar lish hei?Chut dar sure lure kee mut.Mei jar lai ha hung,Bo ho tek kee hung.Bar mei link it.Mei ban lee.So kar lee ah.Ug lai hip see dai mei link it.So kar lee ah.Doom ah char in shan who?Ji b must sai gar mut dee ho,doom Ma lee ma du jar kee ho.
If I could give this video another Like I would. I've saved it as a favourite and keep coming back to it. Awesome job; well done.
Glad you're finding the videos useful
I just got your video and saw it only for one minute and I am exited about the first presented function!
Excellent !!!
This video is a jem on internet. God bless you brother.
Straight to the point, covers each point thoroughly.
Thank you so much!
Those non printing characters were proving a real headache.
I am so mad I didn't find this video sooner. Very helpful tips, thanks.
Excellent short presentation of very helpful tips. Thanks you.
You are a great and honest teacher - salute you -thanks once again.
Thank you for the excellent presentation. Everything is clear and concise.
Excellent......In very short time covered many important excel tools....Thank you
This really is one of the Best tips post for Excel functions!
Excellent. hugely helpful. Many thanks...
simple and time saving tricks ! Thanks for sharing
Feels like found Treasure in TH-cam after many years , Great work
Very useful in day to day operations!
Really very much useful. Your teaching method of teaching is so easy to understand and your speech is nice. Very useful tips. Thank you
i am glad to find your channel.the way you teach all these things its really easy to understand.keep posting all these videos..and one more thing your voice is amazing...
Big thanks to this video. As an Analyst, I found it very time-consuming to clean the data. This is very helpful.
Hey, follow this guy. He has pivoted into data analyst and has really helpful videos th-cam.com/video/axTt_5Zr46M/w-d-xo.html
This guy is sharp and knows his stuff
Excellent video, very clear and precise
Good video ..thank you, as a data analyst , these tips are helpful and i have included in my data cleansing checklist before any analysis
one of the best TH-cam channel to learn Excel. Nice Explanation...
Excellent video !
Thank you for this video. I came across a spreadsheet and it was garbage. Now it's nice and clean!
Very nice video. Many people are unaware of this Alt+G option which has got numerous useful things for the user. The another wonderful thing which I like; is Ctrl+Enter which fills data for the cells scattered in the data base. technically we call it RELATIVE CELL REFERENCE feature of excel; once again a very useful tool. Thanks for knowledge sharing :)
Great video. I had a tough time converting text format to number format. I will what you have taught here. Thanks
Thank you.This really help me.More videos please.
No words for the explanation. Thx
Thanks for the informative lecture. There is also a formula to apply when dates are resistant to routine formatting; the formula is =DATEVALUE(TEXT(A1,"dd-mm-yyyy")) . NB A1 is the cell number you want to change its Date format
Thanks for sharing,buddy.So generous at all.
Your videos really help. Thanks.
Thank you so much! Very helpful.
I love your video and thank you very much for doing this!
VERY GOOD TIPS! I'm so happy to learn these new tricks. Thanks a lot and please keep it up!
Thank you very much. Very helpful.
Excellent Sumit ji, You have explained everything with good examples in this video. God Bless. Thank you for efforts you have put in.
You are a star sir. So useful.
Thank you very much, these are very useful
Just discovered this now, love it ! THANK YOU :D
Very good thank you but i want to ask you something would you plz make tutorial about stock in excel inventory
nicely done, easy to swallow and to the point, thank you for your hard work. thumbs up
You are a very good teacher
Stay blessed
Great work
Excellent teacher you are amazing thank you for sharing..
Great tutorial..
Excellent coaching
Superb Video, exactly what I was searching for on the internet
Hey, follow this guy. He has pivoted into data analyst and has really helpful videos th-cam.com/video/axTt_5Zr46M/w-d-xo.html
Great tips and tricks video! Thank you
Very useful video boss.
Thank you for an informative tutorial.
Excellent. Useful tips. Thank you.
Very good and thorough tutorial!
Great tips! Thanks a lot!
Great and clear explanation. Thanks!
Thanks for this quick and easy demo to clean up data! I want to download file with large amount of data for cleanup practice. Do you know the reliable source from where I can download it?
Waah Sumit! I use Auto Correct a bit too, but it never struck me that entire Formulae could be generated by a few keystrokes! This is excellent learning! Thanks once again for one more EXCELLENT video on Excel!
Yes, you did swap the columns in the Formulae Auto Correct part of the video, but thats ok - wish Excel had an Auto Correct option to correct that as well, don't you! 😁😎
I have taken to learning excel on a full time after my retirement in May 2017. First it started as a hobby and now it has become an obsession since it gives me a lot of happiness. I almost spend 4 to 5 hours going through all the excel videos that come in TH-cam and practice each one of them. I can definitely say that the way you teach excel is simply fantastic. All the explanations are extremely crisp.
Hats off to your work
I wish I'd found this video sooner! Great information.
Thank you! It gives me big helps..
amazing bro thanks a lot
This is very helpful.those data cleaning techniques are extremely useful for our daily excel work. great
Thank you! Great tips. Very useful.
Excellent explanation!
Nice and simple thank you
Awesome bro ..thank you for teaching
Thanks for sharing, very interesting and helpful.
Really great tutorial
The Video was very helpful!!! Thank you so much for sharing!!! :)
By far the best. Clean, straight to the point. Paid on udemy only to get my time wasted
Nice tricks. Very useful.
thanks 4 sharing :) it help my day :)
Many thanks Sir.
absolutely brilliantly useful. thanks
Amazing video!! Thank you very much!!
Nice work!
Thank you. Excellent. Yes, I learned 2 more tips here. I'm happy to find gems like these. For as long as I've used excel, I can never take for granted I've learned enough. Plus, there are always three ways from which to choose to do one task. As always, with excel, knowing it leads to sharing it. Good users just keep that cycle flowing.
Hi - I have a workbook with 13 sheets. Each sheet has a table which tracks weekly data. Each week I manually add a new row to the top of the table for the newest weeks data and update the formatting and formula in the new row, for each sheet. I then manually update formulas about the table which tracks MIN, MAX, SUM and AVG. Is it possible to automate these steps for all 13 sheets?
Fantastic video, thank you! It will save me a lot of time
Thank you!!
It's a very useful sharing ! 😃😃😃
Super helpful!
very informative and easy to understand......
Thank you so much!!
how can you highlight a specific portion in your excel tutorial? great video indeed
Excellent excel tricks.
Short and useful tutorial 👍👍
Great video!!
Summit, great video and contents. Thank you for such useful video. Please help me to execute the result without showing formula
Very well explained,quick and easy. Thanks for sharing.
Brilliantly presented, thanks
Excellent excellent 👍🏻
Thanks!
Glad you found the video useful!