|
|
To print: Select File and then Print from your browser's menu
-------------------------------------------------------------- This story was printed from ZDNet Australia. --------------------------------------------------------------
|
Images: Excel 2007 beta 2 By Compiled by ZDNet Australia, CNET News.com May 25, 2006 URL: http://www.zdnet.com.au/reviews/software/productivity/soa/Images-Excel-2007-beta-2/0,139023447,139257346,00.htm
Microsoft is designing Excel's next generation to better visualise data, analyse trends. We take a look.
The Ribbon along the top of Excel's interface presents a host of features for changing the appearance of a document. Credit: CNET
As with the other applications in the Office 2007 system, you can customise the Quick Access menu and display its functions below the Ribbon. This can provide shortcuts to features you use a lot but that aren't at the top level of Excel's default menu system. Credit: CNET
Excel 2007 beta 2 dedicates a Ribbon tab to Formulas that you can apply to data, without having to memorise Microsoft's function abbreviations. Credit: CNET
Table Styles choices let you preview and polish table designs, and you can add your own to the gallery for later use. Credit: CNET
To view options for sorting data within the columns of a chart, you can select an arrow in a header row and right-click the mouse. Credit: CNET
Excel's Conditional Formatting tool allows you to pick styles that help you visualise data trends. Credit: CNET
In addition to shading in cells based on their values, Conditional Formatting also allows you to apply icons such as arrows, flags and other symbols to data for instant visual analysis. Credit: CNET
When ready to present data as a chart, the Ribbon's Insert tab displays choices for column, line, pie and other types of charts. Credit: CNET
While adding and stylising a pie chart might be snap, adding percentages and other data labels to it might not be as obvious a process. Credit: CNET
Say you want to send a spreadsheet to clients but don't want them to fudge the data. Excel 2007 beta 2 provides multiple options within the Review tab that allow to you lock specific elements. Credit: CNET
The Data options within Excel 2007's Ribbon bring tools to the surface for analysing and validating your data. Credit: CNET
The Ribbon's Data tab enables you to import data from Access and other sources without having to fish through buried toolbars for the options. Credit: CNET
The Office 2007 system introduces XML-based files that are smaller than the previous XLS spreadsheets. You can publish any Office 2007 file as a PDF or XPS and save it to be compatible with software versions 97 to 2003. Credit: CNET
Copyright © 2009 CBS Interactive, a CBS Company. All Rights Reserved. |
