Image 1 of 13
Microsoft is designing the next generation of Excel to help you better visualize data and analyze trends faster. Excel 2007 beta 2 clusters its tools within tabs that make up a graphical Ribbon along the top of the screen.rnrn
The Ribbon along the top of Excel’s interface presents a host of features for changing the appearance of a document.
As with the other applications in the Office 2007 system, you can customize 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.
Excel 2007 beta 2 dedicates a Ribbon tab to Formulas that you can apply to data, without having to memorize Microsoft’s function abbreviations.
Table Styles choices let you preview and polish table designs, and you can add your own to the gallery for later use.
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.
Excel’s Conditional Formatting tool allows you to pick styles that help you visualize data trends.
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.
When ready to present data as a chart, the Ribbon’s Insert tab displays choices for column, line, pie and other types of charts.
While adding and stylizing a pie chart might be snap, adding percentages and other data labels to it might not be as obvious a process.
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.
The Data options within Excel 2007’s Ribbon bring tools to the surface for analyzing and validating your data.
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.
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. rnrn