✅Download the demo files and follow along here ➡️ simonsezit.com/power-query-in-excel-crash-course-instructor-files/
In this Power Query tutorial, we introduce you to Power Query, get you familiar with the Power Query Editor, teach you how to import multiple files and data sources into Power Query, how to combine data, merge queries and so much more.
Power Query in Excel can open up a world of data analyzing possibilities. In this Power Query course, we assume that you are an intermediate to advanced Excel user, but that you haven't used Power Query in Excel before.
This Power Query tutorial was put together using videos from our full, Power Query, Power Pivot & DAX course ➡️ bit.ly/2UTBwPl
✅Become a Simon Sez IT Member to get access to the full course ➡️ simonsezit.com/signup/
🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 10,000+ ad-free videos and begin your transformation today! ➡️ simonsezit.lpages.co/ssit-14-day-free/
📝Tutorial Markers:
0:00:00 - Welcome and Overview
0:03:09 - What is Power Query
0:08:34 - What is Power Pivot
0:12:17 - Exploring the Power Query Editor
0:18:47 - Common Power Query Transformations
0:27:46 - Editing an Existing Query
0:37:42 - Import Multiple Files from a Folder
0:48:48 - Connect to Data in Another Excel Workbook
0:58:26 - Checking the Location of your Query's Source
1:02:00 - Unpivoting Columns
1:07:33 - Combine Data from Multiple Tables with Merge Queries
1:13:44 - Use Merge Queries to Compare Two Tables
1:18:48 - Stack Data into One Table with Append Queries
1:24:51 - Duplicating and Referencing Queries
1:34:01 - Grouping and Aggregating Data
1:41:54 - Conditional Columns in Power Query
💻Watch more free popular training tutorials from Simon Sez IT:
✅Check out our FREE 300+ hour training course playlist here 👉
youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
✅Data Visualization playlist here
👉 youtube.com/playlist?list=PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2
✅Excel 2021 Tutorials for Beginners playlist
👉 youtube.com/playlist?list=PLzj7TwUeMQ3jqRlmIaj6jb_X9EGQueMDb
✅Power BI Tutorials for Beginners. Master Power BI! playlist
👉 youtube.com/playlist?list=PLzj7TwUeMQ3i17tx3uoTc6xf9X7Nl2U-s
✅Alteryx for Beginners playlist
👉 youtube.com/playlist?list=PLzj7TwUeMQ3i5rckX7jxILSruhnToGIIO
💬Stay in touch!
✅SimonSezIT.com: 👉 SimonSezIT.com/
✅StreamSkill.com: 👉 StreamSkill.com/
✅YouTube Channel: 👉 youtube.com/user/simonsezittraining
✅LinkedIn: 👉 linkedin.com/company/simon-sez-it/
🔔Subscribe to our channel:
youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a "thumbs up" and subscribe to the channel 👍🏽 ;-)
- Excel Power Query Course: Power Query Tutorial for Beginners ( Download)
- How to use Microsoft Power Query ( Download)
- Learn Excel Power Query to Automate Boring Tasks ( Download)
- Power Query - Beginner to PRO Masterclass in 30 minutes ( Download)
- How to use Power Query - Microsoft Excel Tutorial ( Download)
- Learn Power Query & Automate Boring Data Tasks in 15 Minutes! ( Download)
- Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 MINUTES (project files included!) ( Download)
- How Power Query Will Change the Way You Use Excel ( Download)
- Master Excel 2024: Advanced Data Analysis with Power Query, Unique & Filter Functions ( Download)
- PQB: Power Query Basics From A to Z - Full Course, 5 hours, 17 topics, 25+ Examples ( Download)
- You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query 🤯 ( Download)
- Power Pivot Tutorial & Power Query in Excel - 1-Hour Class ( Download)
- Excel Power Query Tutorial For Beginners | Microsoft Excel Tutorial For Beginners | Simplilearn ( Download)
- Power Query Tutorial - What is it, how to use it & 4 complete examples + Free download ( Download)
- Advanced Excel Power Query | Introduction | Explained in 4 Minutes | Tutorialspoint ( Download)
