New in 2016 – Queries are coming!

To add a query in a 2016 Excel spreadsheet, click the Data tab, then click the drop down for New Query command.

article03_01

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.

article03_02

article03_03

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.

article03_04

For more office techniques see our MS Office Tips.