When Office 2010 and SharePoint 2010 Get Together: New Features You Will Love

By Mike Ferrara (@mikecferrara) May 13, 2010 Comments

1 comment

At a very high level, SharePoint 2007 can integrate with Office 2003-2010 to some degree. But in 2010, we are finally seeing a larger acknowledgment that users enjoy working from Outlook. Office, and Outlook in general, is still the command center for many firms, and there’s no reason to change that part of your corporate culture.

Here are some of the new features you get when SharePoint 2010 (news, site) and Office 2010 get together.

SharePoint Composites

The SharePoint framework is marketed by Microsoft as having a collection of building blocks that will allow end users to create advanced no-code business solutions without the need for high-end training. If you’re using Office 2010 and SharePoint 2010 together, then you’ll be able to work with composites even more than you could in the past.

With Business Connectivity Services, BCS (the new BDC), you’ll be able to take advantage of a powerful new ability, CRUD. CRUD stands for create, read, update and delete. With this new ability, your users will be able write back to external data sources from SharePoint and certain Office apps.

One useful scenario would be connecting your users to an external SQL table containing business contacts. Rather than bringing this data into a SharePoint list, you can leave it right in SQL. Fire up SharePoint Designer to create an external data source to this table, and you’ll be able to associate this data as a contact once Outlook touches it.

This is all possible by utilizing external content types in SharePoint. A user can then make changes to the contact (that will appear as a regular contact in Outlook), and the changes are immediately reflected in the SQL table.

Outlook

A big push in SharePoint 2010 is the end user’s social experience. Last month, I wrote an article, 5 Ways Social Networking Has Improved in SharePoint 2010, outlining some of the new features that SharePoint is bringing to the social media game.

One of those features is the new activity feed that tracks a user’s interactions with content in SharePoint. In Outlook 2010, you can now view other user’s activity feeds by way of the Outlook Social Connector.

What makes this feature attractive is that it’s completely extensible through the Office SDK. In fact, LinkedIn has already developed integration, so you can see LinkedIn activity right from within Outlook. You can safely assume that Facebook and Twitter will be next in line.

Screenshot taken from http://blogs.msdn.com/outlook/archive/2009/11/18/announcing-the-outlook-social-connector.aspx

PowerPoint

This is one of my favorite new features in Office 2010, and it relies on the SharePoint framework. Everyone at some point in their career will use PowerPoint to deliver a presentation. It is the industry standard, and it allows you to quickly create a professional presentation in minutes.

But accessibility has always been an issue for remote users. Up until now you needed Live Meeting, GoTo, Webex or some other meeting tool to show your presentation on the internet.

Without further ado, I introduce to you the PowerPoint Broadcast service. Free of charge, you can now broadcast your presentation over the internet to up to 50 users simultaneously! You literally are just clicking on the “Broadcast Slide Show” button and picking where you want to broadcast to.

This is where SharePoint comes in. You can either broadcast this for free over the internet courtesy of Microsoft’s servers (Live ID required), or you can broadcast to your own SharePoint PowerPoint service app. All this requires is that you have Office Web Apps 2010 installed, turn on the PowerPoint service application and then create a SharePoint site with the broadcast site template.