Question

You have access to the desktop version of Microsoft Excel and Excel Online. You need to perform a bulk update of data for 225 contacts.

What are two ways to achieve the goal? Each correct answer presents a complete solution.
A. Open the data in Excel Online, make updates, and then save changes to Microsoft Dynamics 365.
B. Export data as a dynamic pivot table, make updates, and then save changes to Microsoft Dynamics 365.
C. Export the data as a static worksheet make updates, and then save changes to Microsoft Dynamics 365.
D. Export the data as a static worksheet, make updates, and then import the data back into Microsoft Dynamics 365.

Answer 1

Two ways to perform a bulk update of data for 225 contacts involve using Excel Online to save changes directly to Microsoft Dynamics 365, or exporting the data as a static worksheet, making updates, and re-importing the data back into Dynamics 365.

Step-by-step explanation:

To perform a bulk update of data for 225 contacts using Microsoft Excel and Excel Online, with the goal of saving changes to Microsoft Dynamics 365, there are a couple of methods you could use.

Option A: Excel Online

The first method is to use Excel Online. You would open the data in Excel Online, make the necessary updates, and then, assuming there is an integration, save the changes directly into Microsoft Dynamics 365. This method is convenient as it relies on cloud-based functionalities and does not require data to be re-imported back into Dynamics 365.

Option D: Static Worksheet

The second method involves exporting the data as a static worksheet, making updates in Microsoft Excel on your desktop, and then importing the data back into Microsoft Dynamics 365. Download the table in Excel by selecting the XLS option and then choosing where to save the file. After making your updates, you would import the updated file back into Dynamics 365 to complete the bulk update process.