In this video, we look at using formulas within the excel data connector.

As an excel user, you should be familiar with formulas. Perhaps you frequently take D365 data into excel to perform some external lookups or comparisons. Formulas can be written into your D365 excel-connected experience, so that your dependent formulas refresh when you refresh your connection.

Some Concepts:

• Using Excel Data Connector Add-in for D365
• Adding Formulas to Connected Output
• D365 list-page grouping and totaling
• CountIf() and VLookup() formulas in Excel