Excel 2007 has five new worksheet functions, described in Table 12-2.

TABLE 12-2
New Worksheet Functions

IFERROR Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
AVERAGEIF Calculates a conditional average (similar to SUMIF and COUNTIF)
AVERAGEIFS Calculates a conditional average using multiple criteria
SUMIFS Calculates a conditional sum using multiple criteria
COUNTIFS Calculates a conditional COUNT using multiple criteria

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.

Other new features
Other new features in Excel 2007 worth noting are:

• 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 locations on your computer.
• PDF add-in: You can create an industry-standard Adobe PDF file directly from Excel using an add-in available from Microsoft. Search Excel’s Help system for “PDF” to learn more.
• Improved zooming: Use the Zoom control or Zoom slider on the right side of the status bar to quickly zoom in or zoom out on your worksheet.
• More control over the status bar: You can now control the type of information that appears in the status bar.
• Color Schemes: Change the appearance of Excel by applying one of three color schemes that ship with Excel (Blue, Silver, or Black).
• Resizable formula bar: When editing lengthy formulas, you can increase the height of the formula bar so that it doesn’t obscure your worksheet. Just click and drag on the bottom border of the formula bar.
• Lots of new templates: Why reinvent the wheel? Choose Office Button?New, and you can choose from a variety of templates. One of them may be exactly (or at least close) to what you need.

• Investing in Dollarama, Canada's First Publicly-Traded Dollar Store Begins Trading This Week When it comes to retail and consumer stocks, Canadians have a few staples to choose from: Canadian Tire (TSX: CTC),...
• Walking San Francisco: 30 savvy tours exploring the CityAEs distinctive enclaves, colorful history, and back alley intrigues User Reviews Send this to a friend Walking San Francisco: 30 savvy tours exploring the CityAEs distinctive enclaves, colorful history,...
• Clear Lake Fishing Map (California Fishing Map Series, A134) User Reviews Send this to a friend Clear Lake Fishing Map (California Fishing Map Series, A134) Manufacturer: Fishing Hot Spots...
• Roth IRA Conversion Calculators Most of you know that 2010 presents a tremendous opportunity for baby boomers with higher incomes to open a Roth...
• Daily Late 0 DQ Vintage Curves You may have seen my Prosper vintage curves... While they were hard to make since the data had to be...