The relationship between Microsoft Office 2010 and Microsoft SharePoint is an integral component of the Microsoft Business Productivity Infrastructure or BPI. BPI lays the groundwork to achieve the capabilities that information workers need and want by having two or more programs work together. In this case, Office and SharePoint work together to achieve rich features and services that would not be possible if relying on either Office or SharePoint alone.
Viewing and Editing of Information
A key component of the relationship between SharePoint and Microsoft Office 2010 is the ability to access data across a wide range of devices, including smartphones, tablets and browsers in addition to the traditional PC workstation. Through SharePoint, you can take an Office document offline, and then resynchronize it when you reconnect. Workers can access line-of-business data from within familiar interfaces, and multiple people can access and even edit the same document concurrently.
Collaboration on Office Documents
Sophistication of collaborative tools is a core focus of BPI and perhaps the greatest advantage achieved through Microsoft Office 2010 and SharePoint working together. This goes beyond letting people work on a document at the same time to achieving true collaboration. Workers can actually share data in real-time and respond to that information accordingly. To understand this more fully, consider a real-world scenario in which multiple people across multiple departments are working together to create a press release. Representatives from the information department, PR department, legal department and relevant technical department can all be working together in real-time without being in the same physical room.
Bringing Ideas to Life
Microsoft used the phrase “bring ideas to life” to describe the aspect of BPI that helps information workers avoid information overload. Work environments are more complex than ever. Workers have access to more information and access to that data in a faster manner than ever before. The relationship between SharePoint and Office also helps people to make sense of all that information. Data can be automatically streamlined, and workers can further refine it through search, capture, reuse and a host of other tools. People are also able to benefit from work performed previously by others.
Always On and Always Connected
Mobile work is no longer limited to just the sales force. Most professionals need to be available even when away from the office, and that means having access to pertinent data at all times in order to be productive. Taking Office with you wherever you go often isn’t practical, but having access to SharePoint from any Internet connection is. Using just a smartphone app as the frontend, an information worker can not only access an Office document but edit it and even perform complex operations, such as using a data slicer in Excel to pare down a data set.