How to Clean Data in Power Query
Vložit
- čas přidán 18. 06. 2024
- ✅Download the free demo file and follow along here
➡️www.simonsezit.com/cleaning-d...
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.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 10,000+ videos ⏩ www.simonsezit.com/ssit-first...
💻 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.com/
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
czcams.com/users/simonsezittra...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-) - Věda a technologie
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!
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. 🤩
Thank you 👍
You are very welcome! Thanks for watching 😃
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
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