New in 2016 – Queries are coming to Excel! - AdvantEdge Training & Consulting

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!

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top