Easy tutorial. How to create and manage Queries and File Connections with your Excel Workbook. Includes
1. How to make queries and connections in an Excel workbook using Get and Transform (Power Query).
2. Using your queries and connected files in data models in Power Pivot.
2.How the option to save your queries and file connections as separate data source definition files in your file directory is used.
3.How to access and use these saved queries and connection definition files from any Excel file.
An easy introduction to saving queries externally and connecting to saved queries - A Practical Tutorial:https://youtu.be/6-bxX1mSaK8