Excel Power Query Course: Power Query Tutorial for Beginners
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.
This Power Query tutorial was put together using videos from our full, Power Query, Power Pivot & DAX course ► https://www.simonsezit.com/courses/microsoft/power-pivot-power-query-and-dax-in-excel/
Become a Simon Sez IT Member to get access to the full course ► https://www.simonsezit.com/signup/
Try Simon Sez IT for free, and get your hands on 4, introductory courses here ► https://www.simonsezit.com/four-free-power/
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
Check out more popular MS Office tutorials from Simon Sez IT:
- 6-Hour Microsoft Excel Crash Course: https://youtu.be/sM0Lldwt7iA
- How to Add video to Microsoft PowerPoint: https://youtu.be/yvWv1bk6mu8
- Learn PivotTables in One Hour: https://youtu.be/2RKw-HGCLB0
- Microsoft Project 2016 Tutorial for Beginners: https://youtu.be/lWmP0kReXkQ
Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a "thumbs up" and subscribe
to the channel ;-) #simonsezit
Видео Excel Power Query Course: Power Query Tutorial for Beginners канала Simon Sez IT
This Power Query tutorial was put together using videos from our full, Power Query, Power Pivot & DAX course ► https://www.simonsezit.com/courses/microsoft/power-pivot-power-query-and-dax-in-excel/
Become a Simon Sez IT Member to get access to the full course ► https://www.simonsezit.com/signup/
Try Simon Sez IT for free, and get your hands on 4, introductory courses here ► https://www.simonsezit.com/four-free-power/
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
Check out more popular MS Office tutorials from Simon Sez IT:
- 6-Hour Microsoft Excel Crash Course: https://youtu.be/sM0Lldwt7iA
- How to Add video to Microsoft PowerPoint: https://youtu.be/yvWv1bk6mu8
- Learn PivotTables in One Hour: https://youtu.be/2RKw-HGCLB0
- Microsoft Project 2016 Tutorial for Beginners: https://youtu.be/lWmP0kReXkQ
Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a "thumbs up" and subscribe
to the channel ;-) #simonsezit
Видео Excel Power Query Course: Power Query Tutorial for Beginners канала Simon Sez IT
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Getting Started with Power Pivot & Power Query in Excel - 1-Hour ClassPower Query Overview - Automate Data Tasks in Excel & Power BIWord Advanced TutorialAdvanced Excel Power Query - IntroductionHow to use Microsoft Power BIEasily Import Data from Web to Excel (2 Practical Examples)Get Multiple Files Containing Multiple Sheets with Power QueryHow Power Query Will Change the Way You Use ExcelWhat is Power Query and What Does It Do? - Excel Power Query (lesson 1) - GoSkills.comExcel Crash Course - Learn PivotTables in 1 Hour - Microsoft Excel TutorialIntroduction to Power Query & Power Pivot Data Model in Excel 2016 (Excel Magic Trick 1468)Power BI Tutorial From Beginner to Pro ⚡ Desktop to Dashboard in 60 Minutes ⏰Advanced Excel Power Query - Merge Queries - NO VLOOKUPConsolidate & Clean Multiple Excel Sheets in One Pivot TableLearn Excel - Power Query - Podcast 1956☑️ Top 30 Advanced Excel Tips and TricksMSPTDA 03: Power Query Introduction: Importing & Transformation Data in Excel & Power BI DesktopPower BI Full Course - Learn Power BI in 4 Hours | Power BI Tutorial for Beginners | EdurekaHow to Merge Tables with Power Query: VLOOKUP Alternative☑️ Top 25 Advanced Pivot Table Tips & Tricks For Microsoft Excel