background image

 

www.microsoft.com/office/excel 

24 

Excel Services API 

The benefits of Excel Services extend beyond the end user. With the Excel Services 
application programming interface (API), corporate developers can take advantage of the 
powerful calculation engine in Excel in other applications. By using the Excel Services 
API, developers can control and perform other functions, such as: 

 

Loading an Office Excel 2007 spreadsheet on the server. 

 

Changing the values in one or more cells of a spreadsheet—either by changing a 
cell's value or by refreshing an external data connection—and recalculating the 
spreadsheet based on these new values. 

 

Retrieving all or part of a spreadsheet for viewing or to use within a larger 
business process. 

Support for New File Formats 

Office Excel 2007 offers support for new file formats that improve data integration, boost 
performance, and make it easier to share business information across platforms.  

Office XML Formats  

Office Excel 2007 supports the new Ecma Office XML Formats. The Excel XML Formats 
improve data integration between Microsoft Office system documents and back-end 
systems. The file formats have open, published format specifications that any technology 
provider can use to integrate Microsoft Office system documents into their solutions.  

Because the file formats are compressed, they result in substantially smaller file sizes 
than with previous versions of Excel, Word, and PowerPoint, thereby reducing storage 
and bandwidth requirements. Segmented data storage within the file formats greatly aids 
in recovering corrupt documents because the corruption of any part of a document does 
not prevent you from opening the entire document.  

Support for XPS and PDF  

When you need to create a fixed version of your spreadsheet, you can now save it as an 
XML Paper Specification (XPS) file or Portable Document Format (PDF) file. This “locks” 
your data while providing a polished report for customers.

 

Summary of Contents for 065-04940 - Office Excel 2007

Page 1: ...Microsoft Office Excel 2007 September 2006...

Page 2: ...r Tables 6 Enhanced Table Tools 6 New Formulas and Range Management Tools 8 Professional Charting Tools 9 Quick Formatting Tools for Faster Results 9 Dramatic Visual Effects in Charts 9 Shared Chartin...

Page 3: ...and a Spreadsheet 23 Dashboards Created from Spreadsheets 23 Excel Services API 24 Support for New File Formats 24 Office XML Formats 24 Support for XPS and PDF 24 MANAGE INFORMATION MORE EFFECTIVELY...

Page 4: ...Excel Services a new server based version of Excel that is optimized for managing consuming and sharing spreadsheets Ecma Office Open XML Formats reside at the heart of the new Microsoft Office syste...

Page 5: ...adowing anti aliasing and glow New Shared diagramming and charting with Microsoft Office Word 2007 and Microsoft Office PowerPoint 2007 presentation graphics program help ensure a consistent look acro...

Page 6: ...mers and business partners New Dynamically render a spreadsheet in HTML and then permit others to view only the parts of a spreadsheet you want them to see by using their Web browser New High fidelity...

Page 7: ...most current data New Excel Services application programming interface API enables developers to use the Office Excel 2007 powerful calculation engine in other applications such as a Web based mortgag...

Page 8: ...hich led to multiple frustrating printing attempts that wasted resources Office Excel 2007 addresses these challenges by helping you format business information clearly and easily Professional looking...

Page 9: ...n an array formula was completely eliminated Faster Performance To a large number of customers the calculation speed of Excel is extremely important perhaps the most important feature Calculations in...

Page 10: ...nt tools Column headers stay in view when you scroll through large tables making it easier for your team members auditors or customers to follow your analysis more easily Figure 22 Creating a table Yo...

Page 11: ...selection before she chooses the final look When she needs to write formulae on data from the table Office Excel 2007 provides an intelligent way to reference this information by column heading name...

Page 12: ...ew clicks Format your chart with the Chart Layout and Chart Styles galleries or manually format each component such as axes titles and other chart labels Dramatic Visual Effects in Charts Adding speci...

Page 13: ...s that contain shadowing and other rich effects All of the charting tools are clearly visible from the Office Fluent user interface so the entire process takes far less time Susan does not need to nav...

Page 14: ...w you can see exactly how a spreadsheet will print By changing the spreadsheet s orientation from Portrait to Landscape you might prevent your spreadsheet from being truncated when you print Figure 25...

Page 15: ...www microsoft com office excel 12 predefined styles to any spreadsheet...

Page 16: ...ng with rich visualization schemes You can apply conditional formatting more easily and identify trends by using colored gradients data bars and icons Greater Than and Less Than Enables you to create...

Page 17: ...ed icons are exposed here by default Excel uses percentiles to calculate the break between icon sets You can change the icons or the way Excel determines the values for the icon sets as well as pick f...

Page 18: ...ng rules via the Edit Rule button The Edit Rule UI is the same as the New Rule UI Delete rules via the Delete Rule button Control whether more than one rule can evaluate to true Improved Sorting and F...

Page 19: ...www microsoft com office excel 16 Figure 27 Enhanced filtering and sorting...

Page 20: ...and then share this insight with Sylvie during their next meeting Easy to Use PivotTable and PivotChart Views Office Excel 2007 offers new tools for creating and working with PivotTable views and Piv...

Page 21: ...uestion against your data you can drag fields in different orders to alter the hierarchy of your information Similar to charts you can quickly modify the look of a PivotTable by using the chart galler...

Page 22: ...types of reporting New style options available from the Table Gallery so you can choose a style that is consistent with the look of your table or other aspects of your spreadsheet Quick Access to Cur...

Page 23: ...what you need by using the Field List SQL Server 2005 Analysis Services features that are exposed by the Field List include Separate measures dimensions and KPIs that have different icons The measure...

Page 24: ...www microsoft com office excel 21 Figure 29 Integration with SQL Server 2005 Analysis Services...

Page 25: ...lps you share data more easily and securely External users like customers or business partners can access and interact with your data without the ability to see formulae macros or other confidential b...

Page 26: ...Created from Spreadsheets Excel Services also simplifies the process of creating Web based dashboards from business information You can track KPIs by using dashboards that are created from Office Exc...

Page 27: ...ake it easier to share business information across platforms Office XML Formats Office Excel 2007 supports the new Ecma Office XML Formats The Excel XML Formats improve data integration between Micros...

Page 28: ...ver Based Control Office Excel 2007 offers server based control that helps ensure consistency across your organization while enabling the automatic refreshing and delivery functionality that is so oft...

Page 29: ...of data connections If a connection changes it need only be updated in the library instead of in the individual spreadsheets that are linked to the original data source Report Management Features Off...

Page 30: ...n its entirety cannot be downloaded and opened on a client computer By using the Report Library in Office SharePoint Server 2007 administrators can control who has access to the intellectual property...

Page 31: ...ces or cumbersome tools To get feedback more quickly you can take advantage of the review or approval workflows available from Office Excel 2007 and Office SharePoint Server 2007 To initiate a review...

Page 32: ...on is published Fabrikam Inc gains insight into business performance so that they can respond more quickly to changing conditions Content Management Options Companies are increasingly challenged with...

Page 33: ...t the content has not been changed or tampered with since it was digitally signed Mark as Final Let readers know that the workbook is final and make it read only Information Rights Management You may...

Page 34: ...sheet For instance the policy statement might indicate that a document will expire after a certain period of time or that it is sensitive information that should not be communicated outside the compan...

Page 35: ...and bigger spreadsheets faster Interactive PivotTable views and new conditional formatting options will help you organize analyze and spot trends in your data to make better informed business decisio...

Page 36: ...www microsoft com office excel 33 Resources For more information about Office Excel 2007 please visit Office Excel 2007 http www microsoft com office excel...

Page 37: ...e a commitment on the part of Microsoft and Microsoft cannot guarantee the accuracy of any information presented after the date of publication The information represents the product at the time this d...

Reviews: