|
|
|
|
|
Excel Functions and Formulas
To develop formulas in any version of Excel you can use 21 signs (+, -, =, etc...). Excel (1997 to 2006) also offers you 329 functions and 5 new functions have been added to Excel 2007 for a grand total of 334 functions. When you click on the "Insert Function" icon Excel shows all these functions to you grouped in 10 categories. Only 15.6% of the functions are useful for most users. All the other functions are rarely used by business people (accounting, finance, manufacturing, sales, etc..) because they are too specialized (Engineering and Financial) or redundant.
New Excel Functions in 2007The five new functions in Excel 2007 are: AVERAGEIF, AVERAGEIFS, SUMIFS, COUNTIFS and IFERROR IMPORTANT NOTE: If you use any of the 5 new functions created by Microsoft in Excel 2007 you may not send your spreadsheets to colleagues who are using earlier versions of Excel. The good news is that you can do what 4 of these "new" functions do (AVERAGEIF, AVERAGEIFS, SUMIFS, COUNTIFS) and even more with a single function that has been in Excel forever and that still works in Excel 2007. This extraordinary single and powerful function is SUMPRODUCT As for IFERROR you can use the IF/ISERROR formula to do the same as IFERROR and it works in all versions of Excel SUMPRODUCT: The most powerful and useful Function in Excel since 1980When you start using SUMPRODUCT you will not need many other functions like: SUMIF, COUNTIF, and SUM You can also replace some formulas involving: VLOOKUP When you add INDEX/MATCH formulas to your arsenal other functions become obsolete: VLOOKUP, HLOOKUP and LOOKUP altogether. The forgotten Excel function Since 1997 and even in the 2007 version of Excel, Microsoft has failed to add to the "Insert Function" drop down list a very useful function if you have to work with dates: DATEDIF The MIN, MAX, SMALL and LARGE Functions in Excel Excel Functions and Formulas Sitemap Downloadable Tutorials, Examples and Templates
|
|
|
|