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 ways to make Excel work for you, take a live or online training course from AdvantEdge Training & Consulting!