background image

 

www.microsoft.com/office/excel 

 

Improved!

 

Sorting and filtering

 helps you find the information you need, 

quickly and easily. Office Excel 2007 supports up to 64 levels to sort data, 
including the ability to sort by color. 

 

Improved!

 

Create a PivotTable or PivotChart

®

 more easily

 by using data 

fields to reorient data quickly and find the answers you need. 

 

New!

 

Full support for Microsoft SQL Server

 2005 Analysis Services

 

enables you to query your most current business data by using the flexibility of 
Office Excel 2007. 

Share Information with Customers and Partners  

With Excel Services, you can share sensitive business information more broadly and 
securely with coworkers, customers, 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 between the Office Excel 2007 client and spreadsheets

 

that are rendered using Excel Services helps you navigate, sort, filter, and interact 
with tables or PivotTable views from a Web browser. 

 

New! 

Business dashboards can be easily created from spreadsheets

 to 

track key performance indicators (KPIs), and then you can share these broadly 
through a Web browser.  

 

New!

 Support for PDF and XML Paper Specification (XPS)

 file formats helps 

you convert your spreadsheets into a fixed file format for easier sharing.

*

  

                                                        

*

 

You can save as a PDF or XPS file from a 2007 Microsoft Office system program only after you install an add-

in. For more information, see 

Install and use a PDF or XPS add-in

.

 

Содержание 065-04940 - Office Excel 2007

Страница 1: ...Microsoft Office Excel 2007 September 2006...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 15: ...www microsoft com office excel 12 predefined styles to any spreadsheet...

Страница 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...

Страница 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...

Страница 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...

Страница 19: ...www microsoft com office excel 16 Figure 27 Enhanced filtering and sorting...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 24: ...www microsoft com office excel 21 Figure 29 Integration with SQL Server 2005 Analysis Services...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Отзывы: