Figure 1 – from technewstoday.com
Sandy Stachowiak posted a great article on 10 New Microsoft Office 2016 Features to Increase Productivity at http://www.makeuseof.com/tag/10-new-microsoft-office-2016-features-increase-productivity/.
You can read her blog in detail as she does a great job of highlighting new features. The big features for Dynamics ERP users is the feature for NEW AND IMPROVED CONNECTION options. Here is what she says.
Connectivity for Excel
You can import data from SAP HANA databases, SharePoint folders, and online services such as Salesforce Objects or Reports. Select Data > New Query and then make the appropriate selection from the drop-down box.
The connectors for IBM DB2 and SQL Server Database have been improved as well. For IBM DB2 you can now choose the Microsoft driver and for SQL Server Database you can include schema information as part of the navigation hierarchy.
Connect Excel To Power BI with Publish
Power BI is a service that can transform your data into interactive reports. Using the business dashboard, you can monitor, analyze, and build models easily. Select File > Publish to upload workbooks or export workbook data directly to and from Power BI.
Note that the service requires that you have a OneDrive for Business subscription.