These are just a few locations, but additional ones can be found by clicking the "Get Data" button. You'll see that this menu section has several buttons that indicate the external files and locations that can be used to retrieve data. Using external data queries, you could track your yearly expenses to see if they are going up or down each year.Ĭlick the "Data" tab and look in the "Get & Transform" section of the main menu. For these examples, a secondary "Expenses" workbook was created that contained values for last year's bills. The file must be saved with data that can be used to query from another workbook. To test these features, you also need a second workbook stored on your computer. This external workbook can be one that is located on your local drive, on a network drive, or any location where you have permissions to access it. This is the tab that also contains the power query feature to connect to another workbook.
The "Data" tab contains every feature that incorporates importing, querying and working with external data. It's also referred to as the "Get and Transform" feature in most of Microsoft's documentation. You can manually type references to another workbook, but newer versions of Excel offer a much more convenient way to query and consolidate data from external resources including other workbooks. These features let you calculate data in different workbooks and worksheets without the need to copy and paste data to the same location. Excel 2019 has functions that let you retrieve and consolidate data across multiple sheets and multiple workbooks.
0 kommentar(er)
