New in 2016 – Queries are coming to Excel!

To add a query in a 2016 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 excelFor more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!