07 Import Data from Another Excel Workbook 📊

In this video, I will show you how to get the data from another Excel workbook into your current workbook.

This can be really useful when you use the data from a file that is often updated and you have to use the updated data. Instead of manually doing it, you can easily use Power Query to connect the external workbook with your current workbook. If the data changes after a few days, you can get the new data instantly with a single click.

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

☕ 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/trumpexcel?sub_confirmation=1

----------------------------------------------------------------------
00:00 Introduction
00:55 Method 1: Importing from a Regular Worksheet
01:56 Cleaning Up Data in Query Editor
03:19 Setting Correct Data Types
04:36 Benefits of Power Query's Connected Data
05:10 Method 2: Importing from an Excel Table
06:28 Advantages of Using Excel Tables as Source
07:52 Demonstrating Live Data Updates
----------------------------------------------------------------------

#Excel #PowerQuery #ExcelTips