How to use Power Query - Intermediate Microsoft Excel Tutorial
This intermediate Microsoft Excel tutorial focuses on learning Power Query. In this step-by-step Excel Power Query tutorial, we'll show you how to use Microsoft Excel's powerful data transformation tool. Power Query can help you quickly clean, consolidate, and analyze data from multiple sources.
If you're new to Power Query, this tutorial is perfect for you. We'll start with an introduction to the Power Query interface and walk you through connecting to various data sources such as Excel files, text files, and databases. We'll then demonstrate how to use Power Query's features, such as merging, filtering, and pivoting, to transform and refine your data.
This tutorial provides easy-to-follow instructions, so you can practice using Power Query along with us. By the end of this video, you'll have a solid understanding of Power Query and how to use it to streamline your data analysis.
Watch this Excel Power Query tutorial for beginners and start taking your data analysis to the next level. Don't forget to hit the like button and subscribe to our channel for more Excel tutorials!
Power Query Practice File: https://bit.ly/Power_Query_Practice_Data
0:00 Introduction to Power Query in Excel
0:45 What is Power Query?
2:34 Where do you find Power Query?
3:05 How to import data from the web with Power Query
8:40 How to import data from a range or table in Power Query
9:50 Power Query Editor layout
14:25 Make changes to your headers
16:42 Examining the applied steps
17:06 How to convert data types in the Power Query Editor
18:36 Remove unwanted rows (filtering)
20:39 How to split columns in Power Query
22:45 Create a new column
24:33 Create a new column to find a value
28:33 Rounding and moving column
29:39 How to merge queries and join tables in Power Query
34:21 Add new data, then refresh your query
Intermediate Excel Lesson 1: https://youtu.be/PqczHnsNFdM
Learn how to use Power Query in Power BI: https://youtu.be/hehYMb9kobw
Видео How to use Power Query - Intermediate Microsoft Excel Tutorial канала Teacher's Tech
If you're new to Power Query, this tutorial is perfect for you. We'll start with an introduction to the Power Query interface and walk you through connecting to various data sources such as Excel files, text files, and databases. We'll then demonstrate how to use Power Query's features, such as merging, filtering, and pivoting, to transform and refine your data.
This tutorial provides easy-to-follow instructions, so you can practice using Power Query along with us. By the end of this video, you'll have a solid understanding of Power Query and how to use it to streamline your data analysis.
Watch this Excel Power Query tutorial for beginners and start taking your data analysis to the next level. Don't forget to hit the like button and subscribe to our channel for more Excel tutorials!
Power Query Practice File: https://bit.ly/Power_Query_Practice_Data
0:00 Introduction to Power Query in Excel
0:45 What is Power Query?
2:34 Where do you find Power Query?
3:05 How to import data from the web with Power Query
8:40 How to import data from a range or table in Power Query
9:50 Power Query Editor layout
14:25 Make changes to your headers
16:42 Examining the applied steps
17:06 How to convert data types in the Power Query Editor
18:36 Remove unwanted rows (filtering)
20:39 How to split columns in Power Query
22:45 Create a new column
24:33 Create a new column to find a value
28:33 Rounding and moving column
29:39 How to merge queries and join tables in Power Query
34:21 Add new data, then refresh your query
Intermediate Excel Lesson 1: https://youtu.be/PqczHnsNFdM
Learn how to use Power Query in Power BI: https://youtu.be/hehYMb9kobw
Видео How to use Power Query - Intermediate Microsoft Excel Tutorial канала Teacher's Tech
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Take Control of Your Inbox Chaos: Simplify with Gmail Aliases](https://i.ytimg.com/vi/5GdEVSSaBj0/default.jpg)
![Discover the Game-Changing Power of the Insta360 Link Webcam](https://i.ytimg.com/vi/Y6NPiSIHLeQ/default.jpg)
![How to Add Background Music to your PowerPoint Slides](https://i.ytimg.com/vi/h_7fYaUGyas/default.jpg)
![5 Powerful yet Underused Charts in Microsoft Excel for Data Visualization](https://i.ytimg.com/vi/GEw6_nNngKk/default.jpg)
![How to Reduce Video File Size with Without Compromising Video Quality: Handbrake Tutorial](https://i.ytimg.com/vi/lvn0ibw2E5w/default.jpg)
![📝Best Free PDF Editors: Edit Text and More Without Breaking the Bank 🏦](https://i.ytimg.com/vi/rsvukScRG5M/default.jpg)
![How to Create AI Generated Images from Text with MidJourney - Beginners Tutorial](https://i.ytimg.com/vi/6ezYNvSnQLM/default.jpg)
![ChatGPT 101 for Teachers: A Beginner's Tutorial](https://i.ytimg.com/vi/Y6cp89S6W8M/default.jpg)
![Make Teaching Easier in 2023: Find out the Top Productivity Apps!](https://i.ytimg.com/vi/Qxwqgvbl7og/default.jpg)
![5 Amazing Google Docs Hacks!](https://i.ytimg.com/vi/74IbZ0XRm8g/default.jpg)
![How to Record your Computer Screen for FREE](https://i.ytimg.com/vi/n0BcU6oYKZQ/default.jpg)
![How to Record Your Computer Screen and Make AMAZING Videos with Microsoft's Clipchamp](https://i.ytimg.com/vi/22ZUGZ5tbmA/default.jpg)
![How to use Microsoft's FREE Video Editor - Clipchamp Beginners Tutorial](https://i.ytimg.com/vi/Kf_14bvASxY/default.jpg)
![How to use Microsoft Edge as a PDF editor](https://i.ytimg.com/vi/X_GBol7q9j4/default.jpg)
![How to use Adobe Acrobat Pro - Beginners Tutorial](https://i.ytimg.com/vi/wdENhL-FxOs/default.jpg)
![How to use Power Pivot in Excel - Intermediate Microsoft Excel Tutorial](https://i.ytimg.com/vi/kyGhgreDNUQ/default.jpg)
![Automatically Remove all Hyperlinks in Microsoft Word with VBA](https://i.ytimg.com/vi/hJKEkx35_Gw/default.jpg)
![Look Up Values with INDEX and MATCH functions in Microsoft Excel](https://i.ytimg.com/vi/nXQz3G0NPgI/default.jpg)
![How to Create a Bell Curve In Microsoft Excel](https://i.ytimg.com/vi/K1xQK6pkGGg/default.jpg)
![How to use Adobe Express - Beginners Tutorial](https://i.ytimg.com/vi/VA3o3rFNIP0/default.jpg)