New in 2016 – Queries are coming!

To add a query in a Excel spreadsheet, click the Data tab, then click the drop down for New Query command.
Queries Excel
This will open a display box that allows you to choose the workbook you want to run the query against, and will then open another dialog box that allows you to choose the worksheet from that workbook.
Queries Excel
Queries Excel
Once selected, click the Load button. This will load the information into a new worksheet. A navigation pane will open and allow you to refresh the information when necessary.
Queries Excel

Find more ways to make Excel work for you with a training course from AETC.