Current lesson | Lesson 4/31

Importing Data from Another Excel File with Power Query

Advanced Excel – Data Analysis, Power Query and Pivot Tables 0%
Let's see how to dynamically link an external Excel file with Power Query: I'll show you how to select which sheets and tables to import and how to refresh the data with one click whenever the source file changes.
Instructor
Up next Importing a Table from a Web Page with Power Query