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 - kzfaq.info/get/bejne/aNpmmqh8z7rVpn0.html ✅ How to Remove Leading and Trailing Spaces in Excel - kzfaq.info/get/bejne/e62ZmNFjyd2raYE.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
@pa2happiness133 жыл бұрын
💞
@ashaydwivedi4202 жыл бұрын
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
@Beluga7474 жыл бұрын
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
@dimonovych4 жыл бұрын
13:55 Deleting all formatting
@sophialawrence68804 жыл бұрын
For spell check when i pressed F7 , i am getting airplane mode on
@JohnDoe00Zero4 жыл бұрын
@@sophialawrence6880 hit Fn + F7, Fn is your function key, located next to the 'alt' key.
@prakashsathyapriya4 жыл бұрын
@@sophialawrence6880 press Fn+f7
@granand3 жыл бұрын
Do you use some API function to get time stamps or painstakingly do it manually.
@mahamohan16 жыл бұрын
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 KZfaq 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
@simonafullinfaw97305 жыл бұрын
To the point and very precise. Didn't waste a single second. Thank you for providing this.
@keithau81593 жыл бұрын
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.
@CH50926 жыл бұрын
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.
@muhammadhaider85614 жыл бұрын
There are many excel teachers in the KZfaq, but i must say the way you guys teach and summarise the functions are awesome. Well done and keep inspiring guys.
@keithau81593 жыл бұрын
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 didn't know about using Ctrl + J in Find & Replace box.. thank you, that would be very very useful someday.
@ashokanselliah95714 жыл бұрын
Excellent. hugely helpful. Many thanks...
@sumayaasif622 жыл бұрын
This video is a jem on internet. God bless you brother.
@eniitanoyesowo7159 Жыл бұрын
Thank you so much for this video. I have been struggling with data cleaning and most of the videos I have been seeing are not useful but this video solve it. thank you once again!
@umeshyeole1232 жыл бұрын
Excellent......In very short time covered many important excel tools....Thank you
@zhangxinyi89974 жыл бұрын
I would say this is the most helpful video Ive watched recently although its already 2020! Thank you so much!
@mohamadehtheshams25273 жыл бұрын
Bro you have EXCELLENT Knowledge on Excel , great
@karimlike14 жыл бұрын
Excellent video !
@ashwinantony71403 жыл бұрын
You have used "=TRIM" in your videos too. No nonsense no time waste. Thank you.
@Faithful_Tribe2 жыл бұрын
Enjoyed that 'Parse data using text to column' method.
@joestauffer4 жыл бұрын
You have an excellent teaching style. Very complete instruction without the unnecessary blab you find on many KZfaq videos. Very knowledgeable, yet easy to follow and understand. Keep up the good work.
@aaokuchhseekhe74583 жыл бұрын
Excellent video, very clear and precise
@srenyvas14 жыл бұрын
Simple and useful tips , Thank you very much
@haiderabbasi53203 жыл бұрын
Excellent Presentation
@lenac35875 жыл бұрын
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! 😲👏👏
@jsoloughlin4 жыл бұрын
Excellent short presentation of very helpful tips. Thanks you.
@billpoon90174 жыл бұрын
Great tutorial..
@Nabhishek4 жыл бұрын
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. :)
@isldgrl20082 жыл бұрын
Straight to the point, covers each point thoroughly.
@PankajKumar-bd1hx4 жыл бұрын
Very useful in day to day operations!
@thepeddler92265 жыл бұрын
Wow. I'm speechless. There are a few I knew Excel could do (ex. caps/no caps) but couldn't find it anywhere since I couldn't explain it properly. Learned a lot. Keep up the good work. I like the Ctl-H thing too. Extra step with Ctrl-F... No fluff, no hesitation, right to the point. My kind of tutorial. Thanks for showing, Nicole from Canada
@MAVlogs5054 жыл бұрын
Very helpful video thanks
@janechannel55883 жыл бұрын
Thank you.This really help me.More videos please.
@tinkerbrownie4 жыл бұрын
I've been using excel for heavy analysis work for the past year. Even then, I have learned at LEAST 8 new things from your video. Wow. Thank you so much!
@serdip5 жыл бұрын
Excellent video! Thank you so much. When the cursor is inside a block of data, press Ctrl + A to select the block of data instead of dragging the cursor. When copying down a formula in a column adjacent to existing data, select first cell to be copied, hover mouse over that cell's lower right corner until it becomes a cross and then double click to automatically copy down the formula or content of the first cell into the cells beneath it down to the last row of data in the adjacent column. This technique is faster than dragging down the cursor over the target cells. Thank you kindly.
@ravisankar2954 жыл бұрын
💐💐💐
@nengtech69144 жыл бұрын
Very nice tip
@parminderghai4 жыл бұрын
Thank you. 🌻
@nurjayantianis67583 жыл бұрын
@@parminderghai c
@vipinamar83234 жыл бұрын
No nonsense! Some really great content in a relatively short amount of time.
@keithau81593 жыл бұрын
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.
@larifari74733 жыл бұрын
I just got your video and saw it only for one minute and I am exited about the first presented function! Excellent !!!
@cambellevans99453 жыл бұрын
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.
@trumpexcel3 жыл бұрын
Glad you're finding the videos useful
@sloggingdanish79454 жыл бұрын
You are a great and honest teacher - salute you -thanks once again.
@executiveengineerchitradur75423 жыл бұрын
Superb!!! Thanks Sumith. The way of teaching is excellent and with in a very short span of time.
@swathic36322 жыл бұрын
Excellent coaching
@zyadalharbi1803 жыл бұрын
Thank you very much. Very helpful.
@narenderyadav17274 жыл бұрын
Very useful video boss.
@santamills86384 жыл бұрын
Thank you so much. I think your lessons are very helpful
@cambellevans99454 жыл бұрын
You are a star sir. So useful.
@Adi-jk2ef4 жыл бұрын
simple and time saving tricks ! Thanks for sharing
@nitinbhosale015 жыл бұрын
Hello, I've not even reachedd half way but found your video to be crisp and to the point. Just enjoying this crash course. Pls keep making it.... Thank u
@meignanamurthy97954 жыл бұрын
One of the best videos on excel that I have ever watched
@gunesbirinci17049 жыл бұрын
The people who work with excel generallay, these hints and videos are very useful. Thanks.
@angelina_ruchi2 жыл бұрын
Your videos really help. Thanks.
@DavidSNY4 жыл бұрын
Very helpful. Thank you!
@quynhc8293 жыл бұрын
Thank you so much! Very helpful.
@prakashsathyapriya4 жыл бұрын
Really very much useful. Your teaching method of teaching is so easy to understand and your speech is nice. Very useful tips. Thank you
@mcbaintaylor4 жыл бұрын
Excellent teacher you are amazing thank you for sharing..
@TG11814 жыл бұрын
Thank you for the excellent presentation. Everything is clear and concise.
@annaamato52714 жыл бұрын
Great tips and tricks video! Thank you
@krishnarajl42513 жыл бұрын
Excellent tips.... thank you
@deo7005 жыл бұрын
Wow! I don't know where you made this video but you helped me out here in Chicago just watching this.
@daowara853 жыл бұрын
I love your video and thank you very much for doing this!
@bella88ification4 жыл бұрын
Great tips! Thanks a lot!
@aishwaryakk43693 жыл бұрын
Feels like found Treasure in KZfaq after many years , Great work
@grishmasingh36912 жыл бұрын
Great explanation
@awfullawton44702 жыл бұрын
This guy is sharp and knows his stuff
@sabakhalid50553 жыл бұрын
Nice and simple thank you
@st.charlesstreet98764 жыл бұрын
This really is one of the Best tips post for Excel functions!
@SolidSnake595 жыл бұрын
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.
@jasfradique4 жыл бұрын
I don't usually comment on videos, but this time I have to say: great tips and amazing explanations! Thank you man, you rock!
@preetichoudhary36513 жыл бұрын
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...
@axatsharma8814 жыл бұрын
Really great tutorial
@narinderkumar9375 Жыл бұрын
This is the best video on data cleaning I have seen. Thanks. Please upload more on vlookup index and other useful techniques.
@shdwctchr3 жыл бұрын
Thank you for taking the time to create this video!
@noshortcuttoglory64434 жыл бұрын
Many thanks Sir.
@cdroze315 жыл бұрын
I am so mad I didn't find this video sooner. Very helpful tips, thanks.
@berkayberkayuk11 күн бұрын
amazing bro thanks a lot
@elizabethworiamarrah3 жыл бұрын
Thanks so much it helps greatly ☺
@CARLPERU5 жыл бұрын
Wow, this is excellent. Thank you for uploading this video, you have no idea how helpful this video is.
@dr.dineshvellatt14515 жыл бұрын
Nice tricks. Very useful.
@granand3 жыл бұрын
Awesome bro ..thank you for teaching
@bawaljudgemental71733 жыл бұрын
Thank you! It gives me big helps..
@onlychild66374 жыл бұрын
Super helpful!
@marisa4942 Жыл бұрын
Thank you so much!!
@sunilkumarkalathil71004 жыл бұрын
0:08 Trim extra space [TRIM command] 1:19 select blank cells. treat then all the same. [Go to special - (highlight range and F5)] 2:39 Convert numbers stored as text into numbers [paste special, multiply by 1] 4:59 Remove duplicates [DATA tab, remove duplicates] 7:21 Highlight errors [Go to special] 9:24 Change text to lower/UPPER/Proper case [command, LOWER, UPPER, PROPER] 10:54 break up concatenated text (e.g. street address) into separate columns [DATA, text to column] 13:15 Spell check [select range, press F7] 14:33 Find and Replace [ctrlH] 16:59 remove line breaks in text [ctrlH, find what tab = ctrlJ; replace with tab = space bar} 17:47 Clean (out unwanted characters from) text data (use asterix in find what and replace with white space]
@twinklemoon74905 жыл бұрын
Excellent!
@gellijayalakshmiharika29373 жыл бұрын
Love the way you converted text to number
@soe500606 жыл бұрын
Thank you so much! Those non printing characters were proving a real headache.
@apriltwenty49454 жыл бұрын
Excellent excellent 👍🏻
@keithau81593 жыл бұрын
Thanks for sharing,buddy.So generous at all.
@ravingagunawardana1783 жыл бұрын
Thanks!
@trumpexcel3 жыл бұрын
Glad you found the video useful!
@kalangiprasad40734 жыл бұрын
one of the best KZfaq channel to learn Excel. Nice Explanation...
@titifash743 жыл бұрын
Good video ..thank you, as a data analyst , these tips are helpful and i have included in my data cleansing checklist before any analysis
@mohammedalmashibi17274 жыл бұрын
Thank you very much, these are very useful
@akprice82423 жыл бұрын
Thank you for this video. I came across a spreadsheet and it was garbage. Now it's nice and clean!
@basis_tech45554 жыл бұрын
SuperTricks bro...very useful in work..
@amitgoyal94234 жыл бұрын
Thanks Sumit for this wonderful video, you have covered a lot real time scenarios in which I struggled and don't have answer how to easily fixed it
@ashokkhatri85774 жыл бұрын
wonderfull tricks.
@rmmccarthy12402 жыл бұрын
Thank you.
@BikashKumar-pz8hc4 жыл бұрын
Nice work!
@prashanth8496 Жыл бұрын
Thank you👍
@spreadingknowledge33114 жыл бұрын
You are a very good teacher Stay blessed Great work
@thangaveluraj53664 жыл бұрын
Super AMAZING is that you are talking in English........ Incredible, unbelievable, overwhelming, awesome, etc.,
@greenshadowooo Жыл бұрын
It's a very useful sharing ! 😃😃😃
@vbatipsandtricks52374 жыл бұрын
Good Effort.
@MsAnupamsingh6 жыл бұрын
No words for the explanation. Thx
@RA-rh5lb5 жыл бұрын
Great video. I had a tough time converting text format to number format. I will what you have taught here. Thanks