How to Clean Data in Excel Power Query

[@sharifashikurrahman3314]

I am giving 5 stars! you have covered a lot in just one video, thank you so much!

[@SimonSezIT]

Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@carlospinho3194]

Well done. Its a great video.

[@SimonSezIT]

Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@coachsudhakar]

Your explanations are excellent. But why is it not crossing a million views? I wish you could top the chart

[@SimonSezIT]

Thanks for the kind comments 😊 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@specialsnowflake8950]

I just clicked in the video for a glance and got hooked till the end of it. Very very helpful and so simplified! Would love a version of data input and cleaning for law enforcement data analysts!😅

[@SimonSezIT]

Thank you for your kind words! Happy to hear that you found the content simplified and helpful. 🤩

[@NdifelaniMurida]

Thank you so much for this tutorial. I followed along and you made it easy because you explain every step thoroughly and slowly for beginners. This is highly appreciated. Thanks again!

[@SimonSezIT]

Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@sanimunir]

Hello, Deb. Thank you so much for this detailed video on cleaning data for pivot table! Your explanations are always clear and concise, and I appreciate the time you took to cover each step thoroughly. The 41 minutes flew by! I am excited to apply these skills to my own projects in future. Thank you for your hard work and dedication to teaching excel skills!

[@SimonSezIT]

Thanks for watching and leaving such a sweet comment. 😊 Happy to hear you enjoyed the video!

[@paaauuull]

Hi Deb, Your teaching style is undeniably incredible! I’ve learned so much from you, even more than from my paid courses. However, I noticed some odd values in the "Total" column, particularly in the 10th row (before you applied the custom column for the total). It seems like the total in that row should have been 280.00 instead of 200.00, considering the price per unit was 70.00 and the quantity was 4. I found four such discrepancies in the column, but it might have been intentional - not sure, haha. Good thing you fixed those values using the custom column. Thanks again, Deb!

[@SimonSezIT]

Thank you for your kind words! It's great that you noticed those discrepancies; attention to detail is so important 😊

[@xlwatcher8885]

This was a most amazing vid on this complex topic. Supremely well-explained. Thank you so much.

[@SimonSezIT]

Thanks a ton for the positive feedback! Glad it was helpful. 🤩

[@UjuMkpuluma]

Thanks for the wonderful Teaching

[@SimonSezIT]

Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@AmmarIbrahim-ds2yu]

Another banger👌🏻

[@SimonSezIT]

Glad you enjoyed it. Thanks for watching! 😃

[@alphaandromeo]

Thank you 👍

[@SimonSezIT]

You are very welcome! Thanks for watching 😃

[@soyoyeoluwafunso4586]

hoW CAN I GET THE DATASET

[@SimonSezIT]

✅Download the free demo file and follow along here ➡️www.simonsezit.com/cleaning-data-in-power-query-webinar-demo-file/

[@naominaomi5312]

The demo file refuses to download. When email address is entered on the webpage linked above, an automatic email is forwarded with an additional link. Clicking the link in the email leads user to the same page where you're prompted to input email address again. However, this time, no download or second email is sent to user to actually retrieve the demo file.

[@SimonSezIT]

Sorry about that. Here's the link to the files ssi-member-webinars.s3.amazonaws.com/Cleaning+Data+in+Power+Query+-+October+2023/Cleaning+Data+in+Power+Query+demo+file.zip

[@rashedalsadat1012]

@@SimonSezIT its a zip file and unzipped its a txt file

[@geramilmingoc8252]

..sad to say.the practice file is in text format

[@limukanimoyo8792]

Excel Goddess 😊

[@SimonSezIT]

Thank you! Excel can truly feel like a superpower when you know how to wield it!

[@dangthanhnhan3189]

Cant download demo file from your link

[@SimonSezIT]

Sorry about that. Please try another web browser, or try clearing your browser cache.

[@SimonSezIT]

Please try think link: ssi-member-webinars.s3.amazonaws.com/Cleaning+Data+in+Power+Query+-+October+2023/Cleaning+Data+in+Power+Query+demo+file.zip

[@dangthanhnhan3189]

@@SimonSezIT it works, thank you!

[@alexrosen8762]

The link to the files does not work?

[@SimonSezIT]

Hi! The link works. Please try another web browser, or try clearing your browser cache.

[@juliepeppitt9253]

Ive tried both and the link still doesn’t work.

[@juliepeppitt9253]

I’ve tried 3. Rowsers. No luck.

[@juliepeppitt9253]

Where did you download the dataset from please?

[@SimonSezIT]

Please use this link ssi-member-webinars.s3.amazonaws.com/Cleaning+Data+in+Power+Query+-+October+2023/Cleaning+Data+in+Power+Query+demo+file.zip