How to Clean Data in Power Query

Рет қаралды 2,428

15 күн бұрын

✅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:
kzfaq.info...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

Пікірлер: 19

@sanimunir 14 күн бұрын

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 12 күн бұрын

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

@xlwatcher8885 8 күн бұрын

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

@SimonSezIT 7 күн бұрын

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

@alphaandromeo 14 күн бұрын

Thank you 👍

@SimonSezIT 12 күн бұрын

You are very welcome! Thanks for watching 😃

@naominaomi5312 11 күн бұрын

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 11 күн бұрын

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 7 күн бұрын

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