Insights into Office 2007
Veera Reddy Yannam DPTS – Ingram Micro India (P) Ltd
[email protected]
To a complete Platform
Increase Productivity
From Personal Productivity
Collaboration
Mobility
Business Process Integration
Microsoft Office System Vision Accelerate the pace and quality of problem solving by Helping users automate business processes and access “line of business” information Enabling effective, natural group collaboration Connecting users with other people and information Helping users manage the ever growing pool of information and transform it into
Information Security
Information Security Situation
Needs
Sensitive information is easily shared accidentally or intentionally Information leaks can be costly – loss of revenue, competitive advantage and customer confidence Perimeter security technology controls access, not usage
Better protection of sensitive information Protection technology that is easy to deploy and use Technology that augments existing perimeter-based security
Today’s Policy Expression…
…lacks enforcement
Set message policies based on company standards
Smart Documents
Range Editing & Formatting Restrictions
Brian can change just this section
To everyone else the document is read only
Kari can change just this section
Office as a Smart Client Key Features: Familiar MS Office user interface with flexibility of on-line or off-line Analysis of ERP/SAP data Flexible, secured and scaleable reporting and analysis on ERP/SAP data Enhanced RoI from ERP/SAP and MS Office licenses Business Intelligence solutions as well as “Standard ERP” reports
Open XML File Formats
Microsoft Office Open XML Formats Default XML file formats for Word, Excel and PowerPoint Open, transparent format improves interoperability
Published file format specification with royalty-free license XML format enables new integration scenarios for documents and LOB systems Added Benefits: compact and robust
ZIP container allows for standard compression on all files without user effort (Dramatic file size improvements) Significantly more robust files to help minimize data loss
Microsoft Office Open XML Formats Backward Compatible with Office 2000, Office XP, Office 2003
Patches for compatibility available by launch Open, edit and save new formats Legacy support: Current Office 97-2003 binary file formats supported
Support for XML formats from Office 2003, Office XP continued Developers: Endless potential for developers
Build solutions to read, write, and modify Office files (without the need to run Office APIs)
Open XML Formats Architecture User view: single Office “file” File Container
Sample.docx
Document Properties
Developer view: modular file
Document Parts Most parts are XML Each XML part is a discreet, compressed component Can add, extract and modify individual parts without using Office programs Corruption or absence of any part would not prohibit the file from being opened
Comments
WordML / SpreadsheetML, etc.
Custom-defined XML
Images, video, sound
Embedded code / macros
Charts
User Interface
Ribbon Extensibility Tab
Ribbon
Chunk
Menus / toolbars are gone New extensibility model Targeted same behavior across applications Declarative markup with new controls U.I. definitions are additive Definitions fixed at load time Document-level or application-level
The New Extensibility Model
Add your own tabs Add your own chunks to our tabs Add to the File menu Add to our contextual tab sets
Data Collection
Office 2007 Forms Investments Server – reach more users… Smart browser-based forms Multiple browser support Server-based forms management
Client - …with better forms. InfoPath forms within Outlook Offline data caching Visual Studio Integration IRM support
Client & Server Best synergy for forms application
Excel 2007
Excel “2007” Spreadsheet Fundamentals Business Intelligence Server-based spreadsheets Most ambitious release of Excel ever
Customer Needs Excel is everywhere. Many Excel spreadsheets are vital to the business. The highly important spreadsheets need to be used by many people.
Broad, secure sharing of spreadsheets “One version of the truth” Protecting IP in spreadsheets Use Excel in BI solutions and dashboards Collaborate on spreadsheets
New Excel Services! Scalable and robust Excel calculation engine on the server High-fidelity, interactive HTML rendering Web-service API to spreadsheet calculations Completely integrated with Office “2007” SharePoint Servers (OSS)
Excel Services Scenarios View and interact with live spreadsheets in the browser (Excel client for authoring) Lockdown spreadsheet viewing and access Create interactive BI dashboards in the portal using Excel spreadsheets Build applications using web-servicebased access to Excel calculations on the server
Excel Services Overview Browser
Spreadsheets
Excel “2007”
Spreadsheets rendered in HTML Set parameters, sort, filter, and drill to explore and view the right data High fidelity to Excel client
Calculated data and charts
Design and author spreadsheets
Spreadsheets/snapshots Spreadsheets/ Calculated data
Office “2007” SharePoint Servers (OSS) & Excel Services Spreadsheets stored in document libraries Spreadsheet calculation and rendering External data retrieval and caching
Excel “2007” Open in Excel for rich exploration and analysis Open snapshots
Custom Applications Set values, perform calculations, get updated values via Web Services Retrieve full workbook file
The World Today Word 2003 was a major step forward: XML-based file format (WordprocessingML) Customer-defined schema support
However, a big toolbox doesn’t mean it’s easy to build a house You need XML schema, XSLT, client-side code, etc.
Word 2007
The World Of Word “2007” Make it easier to push/pull customer data within Word documents How? Structural integrity (Document Controls) Provide content restriction, lockdown capability
Data/view separation (Office XML data store) Place to store custom XML data in the new file format Each item is stored as a separate part within the package
Other Office 2007 Stack Powerpoint 2007 Visio 2007 Onenote 2007 Outlook 2007 Project 2007 Sharepoint Designer 2007