Office integration is another excellent feature in D365FO that can cut down many customization requests related to user productivity. The Excel Data Connector add-in makes Excel a seamless part of the user experience within the user interface. The application uses data entities and OData services to interact with Office add-ins and to provide the ability to export static data available on the page and perform template-based export. Moreover, you can modify the data in Excel and push it back.
The following screenshot shows various Excel integration options in Finance and Operations:
The preceding screenshot shows three ...
