Home » sharepoint_1 » Using Excel Services with SharePoint Online

Using Excel Services with SharePoint Online

Organizations that utilize SharePoint Online (meaning SharePoint® as included in a Microsoft® Office 365 account) can successfully avail of Excel Services. We offer a training class on our SharePoint-Videos dot com online repository of video training content for SharePoint, “Use the Chart Web Part to visualize data from Excel spreadsheet” which works perfectly with SharePoint Online. This training class is available to any individual or organization with an unlimited subscription to all of the training content on our website. We offer either a monthly or yearly subscription to individuals along with annual subscriptions to groups of users that need access to all of our site content. Individual subscription options for SharePoint-Videos training content may be the perfect solution to the needs of specific individuals. Group subscriptions to all of the content on SharePoint-Videos make sense for teams of users who are working together to support an enterprise. We regret that this course in Excel Services is not available on any of our DVDs.

Excel Services conform nicely with the needs of enterprise businesses to publish activity data in a manner conducive to executive decision-making, in other words in chart format. Any subscription to SharePoint Online from an E3 plan and up will include Excel Services. For Small to Medium Businesses (SMBs) an E3 plan should be, therefore, that much more compelling as the combination of Business Intelligence reports, together with a powerful Intranet platform capable of many other powerful features like shared document libraries, shared calendars and more would likely cost much more to build than is the case with the monthly cost for subscriptions to SharePoint Online Plan E3.

We have also used the Excel Services web part, which is available with SharePoint Online, to publish spreadsheet data with a familiar, Excel look and feel. It should be noted that we verified perfect presentation of the Excel data on a Linux system (OpenSuSE 12.1) with a Firefox browser. Users should keep in mind that Excel functionality (for example, addition or subtraction, etc) is not accessible with the web part. Rather, any data manipulation does require the use of the Excel web app which is included with any Office 365 E3 subscription plan (which, of course, does not work on computers with OSs other than MS Windows. In order for the Excel web app to work, a computer must also include a version of Excel). The purpose of the Excel Services web part is to enable enterprise wide presentation of native Excel data for Business Intelligence (BI) purposes.

If your business is seriously considering an Office 365 computing platform, you should likely consider an E3 plan. The combination of access to Excel and Access Services, together with BCS and, finally, the automatic update of a Microsoft Office Professional subscription for your desktop computers is likely very attractive. If you would like a better sense of the training for users that will make sense should you opt for an Office 365 E3 plan, then please contact us at (630) 786-7026, or Contact Us to further a discussion about this offer. Of course we are happy to speak about your SharePoint development plans, as well.

As ever, use this link to place an order for an annual subscription to SharePoint-Videos instructional content

© Rehmani Consulting Inc, all rights reserved