background image

 

www.microsoft.com/office/excel 

30 

Finishing Documents 

The Finish menu (to activate, click the Office button) offers different options to gain more 
control over the document and reduce information risk. 

 

Document Inspector: The document inspector inspects the document for hidden 
metadata or personal information (such as comments and annotations, document 
properties, custom XML data, hidden rows or columns, headers, or footers) When 
inspection is done, you will have the option to remove the information before 
distribution. 

 

Add a Digital Signature: You can digitally sign a document for many of the same 
reasons you might sign a paper document. A digital signature is used to 
authenticate the spreadsheet—by using computer cryptography. Digital signatures 
help to establish that the signer is who he or she claims to be and that 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 need to protect and control who can access company information, especially if 
you are creating spreadsheets with highly confidential information. Using Windows Rights 
Management Services in Microsoft Windows Server

 2003 with the Microsoft Office 

system, you can assign permissions that prevent others from copying, printing, or editing 
your spreadsheet. Permissions-based data access can also be applied to only parts of a 
spreadsheet. 

Records Management  

Office SharePoint Server 2007 provides a managed document repository built on 
Microsoft Windows SharePoint Services to store the document record or the master 
document in a Records Repository. Using Office Excel 2007, you can upload documents to 
this repository directly from the application. As a result, you have greater control and 
management over your spreadsheets. 

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: