Immersive Excel, the future looks very exciting

So what is the immersive Excel experience you say? Well imagine you are working with a list of records and you want to do a quick sum or ad hoc calculation on the values, you can now open in Excel Online inside of Dynamics CRM and perform the action that you want to do. You can even update the values and reimport in if you have the right security roles.

So what do you need?

  • Dynamics CRM Online Spring Release Update 1
  • An Office 365 plan that includes Office products

What does it look like?

So basically select any view in CRM and then select export to Excel and select Excel Online.

Exporttoexcelonline

The view will then open in Excel online as below:

Immersiveexcel

Now you have it in Excel you can manipulate the data. In the example below I have summed up the estimated value and have added a Pie Chart for effect!

Excelonlinechart

Finally If update the Probability of my opportunities, I can simply select Save Changes to CRM button above the Excel logo and import the changes into CRM, easy.

Update Behaviour, the basics

One thing to note if someone else has subsequently updated one of the opportunities that I have updated in Excel, that specific row will fail on the import, the online update will always win.

What’s next?

At Convergence 2015 in the roadmap session, in the Fall release we may see some pre-built templates that can be opened in the context of the view selected and have the ability to create and then easily share. Slide from the CRM Roadmap session:

fall excel release

Advertisements

One Response

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s