How to Clean Data in Excel Power Query
Вставка
- Опубліковано 1 лис 2024
- ✅Download the free demo file and follow along here
➡️www.simonsezit...
Uncover the magic of cleaning data in Power Query with our latest tutorial! 🧹🔍 Learn the essentials of Power Query as we navigate through a messy dataset example. Say goodbye to tedious copy and pasting, and instead, dive into importing a text file seamlessly using Get & Transform.
Explore the powerful features of the Power Query Editor, where we tackle data cleaning head-on. From removing top rows and blank spaces to merging, filtering, and splitting columns, witness the transformation of your dataset. Discover how to promote headings, rename columns, trim data, and change data types effortlessly. We'll even show you how to add a custom column for more personalized insights. Once your data is pristine, close and load it to Excel for further analysis.
Elevate your reporting game by creating a PivotTable and Pivot Chart for a visual representation of your cleaned data. Learn how to update and refresh your data effortlessly. Streamline your data cleaning process and become a Power Query pro!
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ www.simonsezit...
🚀 Level up your skills with a free 30-day trial to our complete training library of 10,000+ videos ⏩ www.simonsezit...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for Excel beginners 👉 • Microsoft Excel Beginn...
✅ Excel 2021 Tutorials for Intermediate Users here 👉 • Excel 2021 Tutorials f...
✅ Microsoft Excel Tips and Tricks 👉 • Microsoft Excel Tips a...
✅ Microsoft Office 2021 and Office 365 Training here 👉 • Microsoft Office 2021 ...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT...
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
www.youtube.co...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
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!😅
Thank you for your kind words! Happy to hear that you found the content simplified and helpful. 🤩
I am giving 5 stars! you have covered a lot in just one video, thank you so much!
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
Your explanations are excellent. But why is it not crossing a million views? I wish you could top the chart
Thanks for the kind comments 😊 Learn more Microsoft Excel Tips and Tricks here ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
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!
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
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!
Thanks for watching and leaving such a sweet comment. 😊 Happy to hear you enjoyed the video!
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!
Thank you for your kind words! It's great that you noticed those discrepancies; attention to detail is so important 😊
This was a most amazing vid on this complex topic. Supremely well-explained. Thank you so much.
Thanks a ton for the positive feedback! Glad it was helpful. 🤩
Thanks for the wonderful Teaching
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
Another banger👌🏻
Glad you enjoyed it. Thanks for watching! 😃
Excel Goddess 😊
Thank you! Excel can truly feel like a superpower when you know how to wield it!
Thank you 👍
You are very welcome! Thanks for watching 😃
hoW CAN I GET THE DATASET
✅Download the free demo file and follow along here
➡️www.simonsezit.com/cleaning-data-in-power-query-webinar-demo-file/
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.
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
@@SimonSezIT its a zip file and unzipped its a txt file
..sad to say.the practice file is in text format
Cant download demo file from your link
Sorry about that. Please try another web browser, or try clearing your browser cache.
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
@@SimonSezIT it works, thank you!
The link to the files does not work?
Hi! The link works. Please try another web browser, or try clearing your browser cache.
Ive tried both and the link still doesn’t work.
I’ve tried 3. Rowsers. No luck.
Where did you download the dataset from please?
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