New Formulas in Excel 2007

Every new version of Excel seems to introduce a few new tools you can use in your formulas. Excel 2007 is no different; this tip explains what was added and where you can find further information. (This tip works with MS Excel 2007.)

Upgrading to Excel 2007 brings several new worksheet functions in the version of the program. What's needed is a good summary of what those functions are and how they can be used.

There are more than 50 new worksheet functions in Excel 2007. The majority of those were functions that had, in previous versions of the program, been in the Analysis ToolPak. A good, general intro to the new functions can be found in this blog post:
http://blogs.msdn.com/excel/archive/2005/10/20/483205.aspx

You might also, in Excel 2007, just use the Help system to find the new functions. Press the F1 key and then click the "What's New?" link. You should see a good overview of what has been added to this version of the program.

If you want to see all the added functions in one list, then the following site provides a good list. (Just scroll down to the "Functions" section of the page.)
http://visio.mvps.org/Excel_2007.htm

Posted courtesy of Tips.Net