Mike selects a category and can easily see the sales figures. To share the sales analysis with other team members, Mike publishes the sales analysis charts in SharePoint 2010 by using Excel Services from the Office Backstage view in Excel 2010. Security in SharePoint 2010 ensures that only his sales team and marketing can view or edit the analysis. Because the Backstage view is extensible, Mike uses a button he has customized to publish the view to his team site so he doesn’t corporate system, Mike sifts through the large data tables using PivotTable views and finishes the analysis. To share his analysis with the team, Mike manually navigates to the SharePoint 2010 site to publish the sales report. He publishes the Excel 2007 sales report in SharePoint 2010 and specifies which components of the workbook will be visible when they’re published to
SharePoint 2010, which synchronizes data with the SAP database. The submission of an Excel report triggers an alert for Sara to validate the budget transfer. Sara is about to disconnect from the company’s intranet and leave the office, so she takes the budget data offline in SharePoint Workspace 2010. While she is on the bus, Sara opens SharePoint Workspace 2010 to review the budget transfer and make some updates. She then saves the changes. After she reconnects to the network at home that evening, Sara’s updates are reflected back to SharePoint and the SAP database. Sara is about to disconnect from the company’s intranet and leave the office. Before she does so, she requests that Chris send her a copy of the Excel 2007 report generated with Office Business Applications. on the bus, Sara reviews the budget transfer, makes some updates in her copy, and saves the changes. After she reconnects to the network at home that evening, Sara again clicks the Update Budget Transfer button in the Excel report. Sara’s changes are reflected back to SharePoint 2010. She puts the new figures in the ERP system and they are accessible by Chris and the rest of the finance team. Office 2010 with SharePoint 2010 Streamline content creation and publishing, and automate business processes to empower users to quickly respond to competitive market pressure. With Microsoft Office 2010 and SharePoint 2010 capabilities, people can bring innovative, new products and services to market with the speed and agility that sets them apart from their competitors. They can quickly create and manage portals and external-facing sites to more effectively engage, retain, and provide self-service features for employees, partners, and customers. Scenario Provide people with automated processes for quickly creating, publishing, and delivering content over the Internet, intranet, and extranet. Let’s consider an example in the Marketing Manager, Ryan Gregg, needs to work on new product launch documentation and introduce an external-facing site to respond to competition. FEATURES Branding Document Sets Automatic Metadata Microsoft Office 2010 with SharePoint 2010 Microsoft Office 2007 with SharePoint 2010
Save Documents and Presentations Directly to SharePoint from Office Automatically discover the SharePoint document library to make saving the content easy and intuitive. People can save Office 2010 documents directly to the SharePoint 2010 document library from Office Backstage view. Bring Ideas to Life Microsoft Office 2010 Microsoft Office 2007 Microsoft Office 2003 Project “Gemini" "Gemini" for Excel 2010 provides streamlined integration and Web-based analysis in SharePoint 2010. Use data from multiple sources and manipulate large data sets that have up to hundreds of millions of rows. Publish and share analysis with less effort and enable others to enjoy the same Data Slicers and fast-query capabilities, even when they work in Excel Services reports. Publish and Share Through Excel Services Share analysis and results across the organization by publishing Excel spreadsheets to the Web or other SharePoint site (intranet or extranet). Use Office Backstage view in Excel 2010 to selectively publish parts of a worksheet, hide formulas, and stage data to SharePoint 2010. Manually navigate to SharePoint sites and specify which components of the workbook will be visible when published to the Excel Services site. Microsoft Office Access Design for the Web Microsoft Office Access applications developed in Design for Web mode can be designed and edited for publishing to SharePoint 2010, so people can share, collect, and report on data. Use Access 2010 to publish data, logic/macros, and reports with nearly the same look and feel in the browser as Access 2010 on a PC. Automate Metadata Capture Make information more findable, perceptible, discoverable, navigable, manageable, and Use Word 2010 to provide better and more automated metadata capture from Backstage view, including document information either added Use the document information panel to manually capture metadata from within Microsoft Office 2007.
automatically or typed quickly in AutoComplete fields. Use Office Backstage View Seamlessly connect Microsoft Office applications with SharePoint 2010 to provide workflow integration, the ability to enter metadata, and social context. By the Backstage view in Office 2010 applications, people can enter metadata, interact with workflows, access authors’ profiles, and more. Because Backstage view is extensible, people can add custom actions to suit custom needs. Access SharePoint Templates Access document templates stored on SharePoint 2010 more quickly and easily. People can access document templates stored in SharePoint 2010 via the New Document wizard in Microsoft Office applications. Apply PowerPoint Themes to SharePoint Sites Make customization of SharePoint 2010 sites more flexible by using themes as used in presentation decks. People can theme SharePoint 2010 sites by using the same themes as in PowerPoint 2010. Use Reusable Workflows Support workflows that can be used multiple and provide workflow templates for later use in SharePoint 2010. SharePoint Designer 2010 supports reusable workflows and workflows attached to content types. Visualize Workflow Allow a workflow designer to see the steps in a SharePoint 2010 workflow in a visual format. Workflows developed as drawings and exported from Microsoft Office Visio® 2010 can be imported into SharePoint Designer 2010 for modification and deployment. Use Forms-Based Applications
Forms-based applications connect with back-end data and include workflow, reporting, custom Web pages, and other components. Integrate InfoPath 2010 forms with back-end data by using external lists in SharePoint 2010, and include custom sandboxed solution code. Anywhere Access Microsoft Office 2010 Microsoft Office 2007 Microsoft Office 2003 View and Edit Documents, Spreadsheets, Presentations, and Notebooks in the Browser Allow editing, even if applications are not loaded on a PC. View and make light edits to documents through Office Web applications in a browser. Document formatting and content are maintained when changes are made in the browser, because Web applications can be hosted on the premises, running in SharePoint. Mobile Access Enhancements View and edit documents from a mobile device, even when on the go. View Office 2010 documents from virtually anywhere with Web applications without losing fidelity, and make changes with limited editing capabilities. Work Offline with an Improved Experience in Microsoft Office Access Edit Office Access forms, reports, queries, and macros offline and synchronize changes in SharePoint when reconnected to the network. Data in Microsoft SharePoint 2010 lists is cached in Access 2010 by default. Before working offline with data from SharePoint sites, people must manually create links between Access 2007 tables and SharePoint 2010 lists. Collaborate Offline and Online Work offline with SharePoint 2010 contents and when reconnected to Work offline with SharePoint 2010 document libraries and through SharePoint Workspace 2010. Work offline in SharePoint 2010 document libraries only through Microsoft Office Groove®.
the network, changes are synchronized. Fill In Forms Offline SharePoint list forms are synchronized with the workspace so people can work offline. SharePoint 2010 list items open in an InfoPath 2010 form that is hosted in SharePoint for edit in display mode. Extend the Reach of Forms Fill in InfoPath forms from a Web browser, while online or offline, and from a mobile device. The InfoPath 2010 forms solution offers embedded solutions using InfoPath controls that can be hosted. Limited InfoPath 2007 controls work on and mobile forms. Publish Access Databases to the Web Securely publish database applications to the Web so IT managers can meet requirements for data compliance, backup, and audits. While publishing data, Access 2010 checks for incompatible objects and builds a report of any runtime differences between the client and server. While publishing data from Access 2007, people must manually check whether objects created in Access can be supported in the server or not. The Practical IT Platform Microsoft Office 2010 Microsoft Office 2007 Microsoft Office 2003 Integrate LOB Data Offline and Online Take LOB data offline, and then synchronize changes automatically when back online. Synchronize LOB data in both directions between SharePoint Workspace 2010 and enterprise systems by bringing LOB data into SharePoint 2010 Sites, and then taking that data offline via SharePoint Workspace 2010. Use Business Data Applications Design forms for SharePoint 2010 that create, read, update, and Business data applications start with an external list in SharePoint 2010 and use InfoPath Designer 2010 to
and SharePoint site template (.stp) file formats. Appendix B: Microsoft Office 2010 with Different Versions of Microsoft SharePoint Collaboration without Compromise SharePoint 2010 SharePoint 2007 SharePoint 2003 Coauthor Documents and Presentations Share ideas with other people simultaneously and see what areas of a document have changed. With coauthoring, work together in Microsoft Office Word 2010 and Microsoft Office PowerPoint 2010, and see others’ changes tracked in documents hosted in SharePoint 2010. Simultaneously Edit Spreadsheets and Notebooks Work together on content a Web browser. Work together in Microsoft Office Excel 2010 and Microsoft Office OneNote 2010 Web applications simultaneously and see others’ changes in real time. Highlight Changes in Shared Notebooks Enable multiple people to add to and change the same shared notebook. Author names appear in near real time as changes are made. Shared OneNote 2010 notebooks provide a clear trail of what other authors have changed since the last user opened the notebook. Broadcast Slide Shows in PowerPoint a PowerPoint presentation over the Web for remote or networked viewers. Audiences do not need to have PowerPoint 2010 installed; they can see the presentation in high fidelity in a Web browser.
Save Documents and Presentations Directly to SharePoint Automatically discover SharePoint document libraries to make saving content easier and more intuitive. People can save Office 2010 documents directly to the SharePoint 2010 document library from Office Backstage view. Bring Ideas to Life SharePoint 2010 SharePoint 2007 SharePoint 2003 Project code-named “Gemini" "Gemini" for Excel 2010 provides streamlined integration and Web-based analysis in SharePoint. Use data from multiple sources and manipulate large data sets that have up to hundreds of millions of rows. Publish and share analysis with less effort and enable others to enjoy the same Data Slicers and fast-query capabilities, even when working in Excel Services reports. Publish and Share Information Through Excel Services Share analysis and results across the organization by publishing Excel 2010 spreadsheets to the Web or other SharePoint sites (intranet, extranet). Use Backstage view in 2010 to selectively publish selective parts of a worksheet, hide formulas, and stage data to SharePoint 2010. Use Backstage view in Excel 2010 to selectively publish parts of a worksheet to SharePoint 2007. Microsoft Office Access Design for the Web Microsoft Office Access 2010 applications developed in Design for Web mode can be designed and edited for publishing to SharePoint, so people can share, collect, and report on data. Use Access 2010 to publish data, logic/macros, and reports with nearly the same look and feel in the browser as in Access 2010 on a PC. Automate Metadata Capture Provide better, automated metadata capture in SharePoint to make information more findable, perceptible, discoverable, navigable, manageable, and re-usable. Use Word 2010 to provide better and more automated metadata capture from Backstage view, including document information either added Word 2010 provides automated metadata capture from Backstage view, including document information added automatically.
automatically or typed quickly in AutoComplete fields. Use Office Backstage View Seamlessly connect Office 2010 applications with SharePoint to provide workflow integration, the ability to enter metadata, and social context. By using Office Backstage view in Office 2010 applications, people can enter metadata, interact with workflows, access authors’ profiles, view recent content the author has created in SharePoint 2010, and more. By using Office Backstage view in Office 2010 applications, people can enter metadata and interact with workflows. Access SharePoint Templates Access Office 2010 document templates stored in SharePoint more quickly and easily. People can access document templates stored in SharePoint 2010 via the New Document wizard in Office 2010 applications. Apply PowerPoint Themes to SharePoint Make customization of SharePoint sites more flexible by using themes used in PowerPoint 2010 presentations. People can apply themes to SharePoint 2010 sites by using the same themes as in PowerPoint 2010. Use Reusable Workflows Support workflows to be used multiple times and provide workflow templates for later use in SharePoint. SharePoint Designer 2010 supports reusable workflows and workflows attached to content types. Visualize Workflow a workflow designer to see the steps in a SharePoint workflow in a visual format. Workflows developed as drawings and exported from Office Visio 2010 can be imported into SharePoint Designer 2010 for modification and deployment. Use Forms-Based Applications Forms-based applications connect with back-end data and include workflow, reporting, custom Web pages, and other components. Integrate InfoPath 2010 with back-end data by using external lists in SharePoint 2010, and