29 November 2011

Integrate Excel in SharePoint With Excel Web Services

Another demo by the CEO of Business Solutions has been published on the Tips section of the website. This time Peter shows how to embed an Excel model on a SharePoint site. It is done with the help of Excel Web Services, which is included in the SharePoint 2010 Enterprise license and also in the more advanced Office 365 licenses.

Excel model
As example Peter has chosen a model that shows how much revenues in dollars change when sales increase ‒ or decrease ‒ with certain percentages, and he starts by creating that model in Excel 2010. When the table is finished he also makes a graph of the data, to show the changes in a clearer way.

Save to SharePoint
In the second step Peter saves his model table and graph to the company’s SharePoint site, so that people who don’t use Excel also can see it. Maybe you even want to display it to all employees on the intranet homepage? Peter shows how to do that also. 

SharePoint and Excel expert knowledge
Peter Kalmstrom is a Microsoft Certified specialist on both Excel and SharePoint, and he has promised to take his time to make more demos of this kind in the future. So if you want to learn some more tips and tricks on Excel or SharePoint, keep an eye on this blog and on the Tips pages!