Cleaning Data in Excel: Microsoft Excel Crash Course

Hi

Suriname😎

Hi

Thank you

Amazing teaching Ashby, I always love your webinars.

Thank you , very useful..

useful ,thanks .

Thanks Deborah! That’s really helpful! 👏

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

Very very useful

Very helpful
Thanks

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.

Visibility is not clear

Better than Coursera!

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

it's worth watching again and again. Thanks

Really appreciate your effort. Really helpful and comprehensive.

Thanks for the demonstration. It's so helpful.

amazing tutorial hatsoff

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

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

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

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!

Thanks mame

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

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?

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

Thank you. Appreciate your work.

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

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.

Great tutorial!

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.

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?

Wow thank you =proper(simon)!!

Thanks for the valuable info

Thank you so much! This helped me immensely.

Extremely helpful, fantastic and thorough explanation,

nice

Thank you is not enough so I basically allowed the adverts run through! This tutorial has been a real gem.

The dataset file is not loading Pleae provide the correct dataset link

unable to download the excel files

I'm think I am weird because I find enjoyable cleaning data, lol.