Page 77 - Excel 2007 Bible

06_044039 ch02.qxp 11/21/06 10:55 AM Page 34
Part I
Getting Started with Excel
New Worksheet Functions
Excel 2007 has five new worksheet functions, described in Table 2.2.
TABLE 2.2
New Worksheet Functions
Use
Function
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the
IFERROR
formula.
Calculates a conditional average (similar to SUMIF and COUNTIF).
AVERAGEIF
Calculates a conditional average using multiple criteria.
AVERAGEIFS
Calculates a conditional sum using multiple criteria.
SUMIFS
Calculates a conditional COUNT using multiple criteria.
COUNTIFS
In addition, 39 worksheet functions that used to require the Analysis Toolpak add-in are now built-in.
Excel 2007 also includes seven new CUBE functions that retrieve data from SQL Server Analysis Services.
CROSS-REF Chapter 11 covers formulas and functions.
CROSS-REF
Other New Features
Other new features in Excel 2007 worth noting are
n Trust Center: Protecting yourself from malicious macros is a bit easier with Excel 2007. For
example, you can disable all macros, except those in workbooks that are stored in trusted loca-
tions on your computer.
n PDF add-in: You can create an industry-standard Adobe PDF file directly from Excel using an
add-in available from Microsoft.
n Improved zooming: Use the zoomer control on the right side of the status bar to quickly zoom in
or zoom out on your worksheet.
n More control over the status bar: You can now control the type of information that appears in
the status bar.
n Color Schemes: Change the appearance of Excel by applying one of three color schemes that
ship with Excel (Blue, Silver, or Black).
n Resizable formula bar: When editing lengthy formulas, you can increase the height of the for-
mula bar so that it doesn’t obscure your worksheet. Just click and drag on the bottom border of
the formula bar.
n Lots of new templates: Why reinvent the wheel? Choose Office ➪ New, and you can choose
from a variety of templates. One of them may be exactly (or at least close to) what you need.
34