Download the free course files to follow along ➡www.simonsezit.com/cleaning-data-in-excel-webinar-demo-files Check out our FREE 300+ hour training course playlist here ➡ 🔥ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
There can not be a better explanation of cleaning data. Very nicely and lucidly explained. Thank you very much and looking forward to more such tutorials also on power query.
thank you ma'am for such a great Excel course. This one video was enough to learn all essential Excel tricks ❤❤ You've designed this crash course in good manner , THANK YOU AND LOTS OF LOVE
OMG this was so good and informative I absolutely love how you give multiple avenues and using the operations and a very organized and clear in actual teaching the functions not just showing them🎉🎉🎉
Glad you enjoyed it. Thanks for watching! 🙂 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
You are very welcome! Thanks for watching 🙂 For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support! 🔥Check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
You're very welcome 😊 We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI We have additional free tutorials for various data analysis tools and services here 👉 ruclips.net/p/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2 For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support!
27:45 CLEAN(TRIM(PROPER(C2))) does not remove line break To work this formula, we need to put proper the top of them like PROPRE(TRIM(CLEAN(C2))) or PROPER(CLEAN(TRIM(C2))) Since I got "GerMany" when I just followed the video....
in addition to numbers formatted as text, numerical values, especially with leading 0's, used as unique identifiers (like IMEI or SIM IDs) formatted as a number - the worse is formatted as an exponential number. These identifiers are values you will never apply arithmetic operations to like +, -, x!
Glad you enjoyed it. Thanks for watching! 🙂 🔥 We have free tutorials for Power Query here 👉ruclips.net/video/80htpBa6OaM/видео.html Check out our FREE 300+ hour training course playlist here ➡️ 🔥ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support!
Thank you for the wonderful excel tutorial. I think you forgot to send us data files you used for power query in the email with the rest of the tutorial materials.
Hi, I am working on logistic regression. My categorical variables contain no of yes=1, no=2. However, there are many data which are 96/97/98. I don’t need them. How can i clean them? I tried by giving these values in one number, but my results are changing. Please give suggestions.
hi in the first thanks for your amazing courses about cleaning data just an little remark in 46:11 minutes the fields in column date aren't in the same format can you madame give us one method to normalize the date format in dd/mm/aaaa have nice day madame
What if you have stacked data on one column, and wanna separate it on three distinct columns? But it's not easy cause manufacturer name has blue fill, brand name has indented and bold name. And specific items have more indented and non bold fonts. So how do you sort this data if its hundreds of lines?
I just joined your webinar,quite educative and easily delivered for somebody just starting to take IT as a profession. I will love to have a download of previous presentations. Thanks for the good job
To ensure the best video experience, set the video playback quality to 1080p HD. Click on the gear icon ⚙️ located in the bottom right corner. If the font size looks too small, you may need to watch the video in full screen mode.
Download the free course files to follow along ➡www.simonsezit.com/cleaning-data-in-excel-webinar-demo-files
Check out our FREE 300+ hour training course playlist here ➡
🔥ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
Hi Simon, I would appreciate if you could send me the 2017 and 2018 CSV file please. I have a presentation on the first of March 2023. Thanks
Please can I get the raw data so as to practice more. Thanks, great lesson.
@@nnamanichidera6647 I also need
There can not be a better explanation of cleaning data. Very nicely and lucidly explained. Thank you very much and looking forward to more such tutorials also on power query.
So nice of you, thanks!
I'm from Bangladesh. I'm falling in love with your way of teaching. I want to learn more from you.
it's worth watching again and again. Thanks
I always like your style of teaching. I must confess this! Thanks so much, I am getting better!
Wonderful! Thanks for the visit :-)
Really appreciate your effort. Really helpful and comprehensive.
Thanks for the nice comments, Nahidul Islam 😀
thank you ma'am for such a great Excel course. This one video was enough to learn all essential Excel tricks ❤❤
You've designed this crash course in good manner , THANK YOU AND LOTS OF LOVE
Thanks for the love and appreciation ;-)
Amazing teaching Ashby, I always love your webinars.
OMG this was so good and informative I absolutely love how you give multiple avenues and using the operations and a very organized and clear in actual teaching the functions not just showing them🎉🎉🎉
Wow, thanks! Glad it was helpful. 🙂
Thanks for the demonstration. It's so helpful.
Thank you. Appreciate your work.
Glad you enjoyed it. Thanks for watching! 🙂
🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
Thank you mam,it helps very much to me, Respect from India 😊
You are very welcome! Thanks for watching 🙂
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
🔥Check out our FREE 300+ hour training course playlist here 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
Excellent Video as usual. Thank you very much for posting.
Thanks Deborah! That’s really helpful! 👏
You are so welcome!
amazing tutorial hatsoff
Glad you liked it
Great tutorial!
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
Thank you , very useful..
Very helpful
Thanks
Happy to help!
Thanks mame
You're very welcome 😊
We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
We have additional free tutorials for various data analysis tools and services here 👉
ruclips.net/p/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
useful ,thanks .
Thank you
Very very useful
Glad you think so!
27:45 CLEAN(TRIM(PROPER(C2))) does not remove line break
To work this formula, we need to put proper the top of them like PROPRE(TRIM(CLEAN(C2))) or PROPER(CLEAN(TRIM(C2)))
Since I got "GerMany" when I just followed the video....
in addition to numbers formatted as text, numerical values, especially with leading 0's, used as unique identifiers (like IMEI or SIM IDs) formatted as a number - the worse is formatted as an exponential number. These identifiers are values you will never apply arithmetic operations to like +, -, x!
So what do you do in that case to clean them?
Can you do course on powerquery
You explain very well n in detail
Glad you enjoyed it. Thanks for watching! 🙂
🔥 We have free tutorials for Power Query here 👉ruclips.net/video/80htpBa6OaM/видео.html
Check out our FREE 300+ hour training course playlist here ➡️
🔥ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
Thank you for the wonderful excel tutorial. I think you forgot to send us data files you used for power query in the email with the rest of the tutorial materials.
Glad it was helpful. 🤩 We have the latest cleaning data tutorial here: ruclips.net/video/04zuc2FBxyw/видео.html
@@SimonSezIT Thank you. Let me check it out and follow along.
Better than Coursera!
Hi! Unfortunately, you can't get the table file from the video for free at the link provided. At least for today
Hi, I am working on logistic regression. My categorical variables contain no of yes=1, no=2. However, there are many data which are 96/97/98. I don’t need them. How can i clean them? I tried by giving these values in one number, but my results are changing. Please give suggestions.
hi in the first thanks for your amazing courses about cleaning data just an little remark in 46:11 minutes the fields in column date aren't in the same format can you madame give us one method to normalize the date format in dd/mm/aaaa have nice day madame
What if you have stacked data on one column, and wanna separate it on three distinct columns? But it's not easy cause manufacturer name has blue fill, brand name has indented and bold name. And specific items have more indented and non bold fonts. So how do you sort this data if its hundreds of lines?
Hello, I can't download the free demo files to follow up on this tutorial. I'm asked to register and pay.
Suriname😎
I just joined your webinar,quite educative and easily delivered for somebody just starting to take IT as a profession.
I will love to have a download of previous presentations.
Thanks for the good job
Hi
Visibility is not clear
To ensure the best video experience, set the video playback quality to 1080p HD. Click on the gear icon ⚙️ located in the bottom right corner.
If the font size looks too small, you may need to watch the video in full screen mode.
Hi