Cleaning Data in Excel: Microsoft Excel Crash Course

Поделиться
HTML-код
  • Опубликовано: 6 ноя 2024

Комментарии • 68

  • @SimonSezIT
    @SimonSezIT  Год назад +7

    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

    • @rodpascual5573
      @rodpascual5573 Год назад +1

      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

    • @nnamanichidera6647
      @nnamanichidera6647 11 месяцев назад

      Please can I get the raw data so as to practice more. Thanks, great lesson.

    • @mahendrashekhawat4798
      @mahendrashekhawat4798 10 месяцев назад

      @@nnamanichidera6647 I also need

  • @pratikkaushik5351
    @pratikkaushik5351 2 месяца назад +1

    I think this video should be awarded by RUclips as the best video for Excel,,,,,,, I really appreciate the time you give on your video. Thanks a lot and keep posting. It really helps.

    • @SimonSezIT
      @SimonSezIT  2 месяца назад

      Thank you so much for your kind words! I'm glad you found the video helpful. Your support means a lot! 😊

  • @rajeevgosavi4514
    @rajeevgosavi4514 Год назад +11

    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.

  • @sumonahmed744
    @sumonahmed744 Год назад +2

    I'm from Bangladesh. I'm falling in love with your way of teaching. I want to learn more from you.

  • @rezvanyegane4300
    @rezvanyegane4300 Год назад +3

    it's worth watching again and again. Thanks

  • @olufemiolawale3848
    @olufemiolawale3848 Год назад +1

    I always like your style of teaching. I must confess this! Thanks so much, I am getting better!

    • @SimonSezIT
      @SimonSezIT  Год назад

      Wonderful! Thanks for the visit :-)

  • @simonoganga9535
    @simonoganga9535 Год назад +2

    Amazing teaching Ashby, I always love your webinars.

  • @naahidul
    @naahidul Год назад +3

    Really appreciate your effort. Really helpful and comprehensive.

    • @SimonSezIT
      @SimonSezIT  Год назад +1

      Thanks for the nice comments, Nahidul Islam 😀

  • @amarankali646
    @amarankali646 11 месяцев назад +1

    Thank you mam,it helps very much to me, Respect from India 😊

    • @SimonSezIT
      @SimonSezIT  11 месяцев назад

      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

  • @jakehuai
    @jakehuai Год назад +1

    Thanks for the demonstration. It's so helpful.

  • @andrepaz3973
    @andrepaz3973 Месяц назад

    Thank you so much! This helped me immensely.

    • @SimonSezIT
      @SimonSezIT  Месяц назад

      Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
      ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

  • @sandipanmajumder9419
    @sandipanmajumder9419 Год назад +1

    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

    • @SimonSezIT
      @SimonSezIT  Год назад

      Thanks for the love and appreciation ;-)

  • @jasonwamp4325
    @jasonwamp4325 9 месяцев назад +1

    Thank you. Appreciate your work.

    • @SimonSezIT
      @SimonSezIT  9 месяцев назад

      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

  • @biglo813
    @biglo813 Год назад +1

    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🎉🎉🎉

    • @SimonSezIT
      @SimonSezIT  Год назад +1

      Wow, thanks! Glad it was helpful. 🙂

  • @midnajo437
    @midnajo437 Год назад +1

    Excellent Video as usual. Thank you very much for posting.

  • @SothearithKONGMrMuyKhmer
    @SothearithKONGMrMuyKhmer Год назад +1

    Thanks Deborah! That’s really helpful! 👏

  • @alokkumar-ve8bt
    @alokkumar-ve8bt Месяц назад

    Thanks for the valuable info

    • @SimonSezIT
      @SimonSezIT  Месяц назад

      Glad you enjoyed it. In case you are interested we have latest cleaning data tutorial here: ruclips.net/video/04zuc2FBxyw/видео.html 😃

  • @NdifelaniMurida
    @NdifelaniMurida 2 месяца назад

    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.

    • @SimonSezIT
      @SimonSezIT  2 месяца назад

      Glad it was helpful. 🤩 We have the latest cleaning data tutorial here: ruclips.net/video/04zuc2FBxyw/видео.html

    • @NdifelaniMurida
      @NdifelaniMurida 2 месяца назад

      @@SimonSezIT Thank you. Let me check it out and follow along.

  • @AmmarIbrahim-ds2yu
    @AmmarIbrahim-ds2yu Месяц назад

    Wow thank you =proper(simon)!!

    • @SimonSezIT
      @SimonSezIT  Месяц назад

      You already applied your learning 🤩 Glad you found it helpful!

  • @christianmarshrosey1977
    @christianmarshrosey1977 6 месяцев назад

    Great tutorial!

    • @SimonSezIT
      @SimonSezIT  6 месяцев назад

      Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
      ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

  • @DIY_Foodie
    @DIY_Foodie Год назад +1

    amazing tutorial hatsoff

  • @mayasam1326
    @mayasam1326 Год назад

    Can you do course on powerquery
    You explain very well n in detail

    • @SimonSezIT
      @SimonSezIT  Год назад

      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!

  • @JackBlossom1789
    @JackBlossom1789 10 месяцев назад

    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....

  • @razzaqfasherazzaq1636
    @razzaqfasherazzaq1636 Год назад +1

    Thank you , very useful..

  • @ВадимЛомакін-н9т
    @ВадимЛомакін-н9т 8 месяцев назад

    Hi! Unfortunately, you can't get the table file from the video for free at the link provided. At least for today

  • @Omar9557-oc6zf
    @Omar9557-oc6zf 2 месяца назад

    Good morning ,Can you provide some guidance on how to complete and rearrange a date format in excel. For example, i have 203 cells with mixed date of birth formats. I.e.: (1)01/02/1995 (2)02/01/1995 (3) 1/2/1995 (4)1/02/1995 and so on. how do i go about correcting this?

  • @olusolaaiki3642
    @olusolaaiki3642 8 месяцев назад

    Hello, I can't download the free demo files to follow up on this tutorial. I'm asked to register and pay.

  • @kingstonmazulu8547
    @kingstonmazulu8547 Год назад +1

    Very very useful

  • @NurSofi-pn2gz
    @NurSofi-pn2gz Год назад +1

    useful ,thanks .

  • @MdKarim-rj3op
    @MdKarim-rj3op Год назад +1

    Thanks mame

    • @SimonSezIT
      @SimonSezIT  Год назад

      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!

  • @SteveL-n7i
    @SteveL-n7i Год назад +1

    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!

    • @keylanoslokj1806
      @keylanoslokj1806 11 месяцев назад +1

      So what do you do in that case to clean them?

  • @samiahussain8316
    @samiahussain8316 6 месяцев назад

    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.

  • @keylanoslokj1806
    @keylanoslokj1806 11 месяцев назад

    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?

  • @salaheddinelahlali4698
    @salaheddinelahlali4698 Год назад

    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

  • @datle4965
    @datle4965 Месяц назад

    at 48:35mins how do I get the sales data folder for 2017 and 2018

  • @FreeFire-ub7rj
    @FreeFire-ub7rj Год назад +1

    Thank you

  • @jeremysimmons9285
    @jeremysimmons9285 Год назад

    Better than Coursera!

  • @Barchafel
    @Barchafel Год назад +1

    Suriname😎

    • @henrybakky7523
      @henrybakky7523 Год назад

      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

  • @SAXENA2904
    @SAXENA2904 Год назад

    Hi

  • @shyanimukherjee2043
    @shyanimukherjee2043 Год назад

    Visibility is not clear

    • @SimonSezIT
      @SimonSezIT  Год назад

      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.

  • @wwpharmacist
    @wwpharmacist Год назад +1

    Very helpful
    Thanks

  • @SAXENA2904
    @SAXENA2904 Год назад

    Hi