08 - Getting Data from Current Excel Workbook to Power Query

In this video, I will show you how to get the data into your current workbook into Power Query.

When working with Power Query, your data needs to be in an Excel table, or at least be a named range.

✅ Power Query Course Download files: https://trumpexcel.com/course-downloa...

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB

Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

------------------------------------------------------------------
00:00 Introduction
00:21 Plain Tabular Data Method
01:47 Using Existing Excel Tables with Power Query
03:22 Using Named Ranges with Power Query
04:55 Comparing Methods: Excel Tables vs Named Ranges
------------------------------------------------------------------

#Excel #PowerQuery #ExcelTips