background image

 

www.microsoft.com/office/excel 

Create Better Spreadsheets 

Organizing and working with large amounts of data can be a challenging task. In 
previous versions of Excel, row and column capacity limits made it difficult to analyze 
large amounts of data. Some of the most advanced tools and capabilities were contained 
in menus and sub-menus, forcing users to find these commands on their own. Creating 
and working with tables is one of the most fundamental reasons people use Excel, yet 
using tables could be challenging. Beyond simply creating or formatting a table, there 
was no way to refer to the table data intelligently. Building and formatting charts was 
“click-intensive,” and even the most common tasks, like changing a chart’s title, could be 
difficult. When you were ready to print your spreadsheet, it was difficult to know what 
the output would look like before doing so. Furthermore, it was hard to know where a 
page break might occur, which 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 reports and charts are now simple to create, so 
you do not have to depend on an external design firm to get the look you want. When 
you are ready to print, the Office Excel 2007 Page Layout View helps to ensure better 
printed results. 

Enhanced Interface with More Room to Work  

Office Excel 2007 takes advantage of the Office Fluent user interface to make powerful 
productivity tools easily accessible. It also offers more room to work and delivers faster 
performance.   

Microsoft Office Fluent User Interface 

With the Office Fluent user interface of the Microsoft Office system, Office Excel 2007 
presents the appropriate tools at the right time so that you can produce your best work 
more quickly. Important features are organized and presented in context. For example, 
when you are writing a formula to calculate a value, Office Excel 2007 displays the 
Formulae tab and toolset to help you in your selection. Or, when you are working with a 

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: