The CData Excel Add-In for Dynamics 365 Finance and Operations models Dynamics 365 Finance and Operations entities in relational Tables, Views, and Stored Procedures. The table definitions are dynamically obtained from the OData service you connect to. Any changes in the metadata, such as added or removed columns or changes in data type, can be loaded by reconnecting.
The add-in models the writable entities described in the service metadata document as bidirectional Tables.
Stored Procedures are function-like interfaces to the data source. They can be used to perform additional operations that fall outside of the standard CRUD model such as retrieving an OAuth access token.