|
The new results-oriented user interface makes it easy for you to work in Microsoft
Office Excel. Commands and features that were often buried in complex menus and
toolbars are now easier to find on task-oriented tabs that contain logical groups
of commands and features. Many dialog boxes are replaced with drop-down galleries
that display the available options, and descriptive tooltips or sample previews
are provided to help you choose the right option.
|
|
Themes
In Office Excel 2007, you can quickly format the data in your worksheet by applying
a theme and by using a specific style. Themes can be shared across other 2007 Office
release programs, such as Microsoft Office Word and Microsoft Office PowerPoint,
while styles are designed to change the format of Excel-specific items, such as
Excel tables, charts, PivotTables, shapes, or diagrams.
|
|
Rows and Columns
Office Excel 2007 supports up to 1 million rows and 16 thousand columns per worksheet.
Specifically, the Office Excel 2007 grid is 1,048,576 rows by 16,384 columns, which
provides you with 1,500% more rows and 6,300% more columns than you had available
in Microsoft Office Excel 2003.
|
|
Formatting & Filtering
In 2007 Office release, you can use conditional formatting to visually annotate
your data for both analytical and presentation purposes. To easily find exceptions
and to spot important trends in your data, you can implement and manage multiple
conditional formatting rules that apply rich visual formatting in the form of gradient
colors, data bars, and icon sets to data that meets those rules.
In Office Excel 2007, you can quickly arrange your worksheet data to find the answers
that you need by using enhanced filtering and sorting.
|
|
Charting
In Office Excel 2007, you can use new charting tools to easily create professional-looking
charts that communicate information effectively. Based on the theme that is applied
to your workbook, the new, up-to-date look for charts includes special effects,
such as 3-D, transparency, and soft shadows.
The new user interface makes it easy to explore the available chart types so that
you can create the right chart for your data. Numerous predefined chart styles and
layouts are provided so that you can quickly apply a good-looking format and include
the details that you want in your chart.
In 2007 Office release, charting is shared between Excel, Word, and PowerPoint.
Rather than using the charting features that are provided by Microsoft Graph, Word
and PowerPoint now incorporate the powerful charting features of Excel. The Excel
worksheet that contains the data of your chart can be stored in your Word document
or PowerPoint presentation, or in a separate file to reduce the size of your documents.
PivotTables are much easier to use than in earlier versions of Excel. By using the
new PivotTable user interface, the information that you want to view about your
data is just a few clicks.
|
|
Quick launch
In Office Excel 2007, you no longer need to know the server or database names of
corporate data sources. Instead, you can use Quicklaunch to select from a list of
data sources that your administrator or workgroup expert has made available for
you. A connection manager in Excel allows you to view all connections in a workbook
and makes it easier to reuse a connection or to substitute a connection with another
one. In addition to the Normal view and Page Break Preview view, Office Excel 2007
provides a Page Layout View. You can use this view to create a worksheet while keeping
an eye on how it will look in printed format. In this view, you can work with page
headers, footers, and margin settings right in the worksheet, and place objects,
such as charts or shapes, exactly where you want them. You also have easy access
to all page setup options on the Page Layout tab in the new user interface so that
you can quickly specify options, such as page orientation. It's easy to see what
will be printed on every page, which will help you avoid multiple printing attempts
and truncated data in printouts.
|
|
|
|