Hi guys, Welcome to the Advanced Video Search Engine, and you are watching How To Automate Data Tasks In Excel Using Power Query. That video is uploaded by Excel Campus - Jon at 2020-05-14T04:00:36-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [vq9AgAtSvQg]
| Name | How To Automate Data Tasks In Excel Using Power Query |
| Video Uploader | Video From Excel Campus - Jon |
| Upload Date | This Video Uploaded At 14-05-2020 11:00:36 |
| Video Discription | Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/ Learn how to use Power Query, which is a data automation tool that allows us to import, transform, and cleanse data in Excel or Power BI. In the video I share an overview of the Power Query workflow and then go into a hands on demo. You will learn how to combine multiple CSV files, clean up the data, and automate the entire process for when you get new/updated data. This video is an introduction for beginners. If you have tried to use Power Query, but are confused by the process or user interface, then this training is for you. Power Query is a tool that can save you a ton of time with your work by automating common data processes like: ✔ Remove columns, rows, blanks ✔ Convert data types - text, numbers, dates ✔ Split or merge columns ✔ Sort & filter columns ✔ Add calculated columns ✔ Aggregate or summarize data ✔ Find & replace text ✔ Unpivot data to use for pivot tables ✔ Merge (join) data tables together ✔ Combine (append) data tables, sheets, and workbooks Free Webinar on The Modern Exvel Blueprint: https://www.excelcampus.com/blueprint-webinar Additional Resources: Read the companion article on an Overview of Power Query: https://www.excelcampus.com/power-tools/power-query-overview/ Complete Guide to Installing Power Query: https://www.excelcampus.com/install-power-query/ How to Unpivot Data with Power Query: https://youtu.be/Kbu5RkUo6-k How to Fix Date Errors in Power Query: https://youtu.be/NZ5q5mYoFR8 00:00 Introduction 02:43 Demo 11:01 Updating and Refreshing vq9AgAtSvQg |
| Category | Education |
| Tags | excel | excel campus | Power Query Overview | power query | excel power query training | excel tips and tricks | power query functions | power query tutorial | power query function power bi | microsoft power query | power query explained | how to use power query | introduction to power query | power query for beginners | data automation in excel | get and transform | get and transform data in excel | power query combine multiple excel files | combine csv files in excel |
