|
|
|
Special Excel Functions 2003
Special Excel Functions 2007
|
Lesson 3: Excel Spreadsheets Engineering Functions (40)In annex 3 you have found a description of all 40 Excel functions in the "Engineering" category. As these functions are specialised, there are no examples of formulas developed with functions of the "Engineering" category in the downloadable tutorial on Excel functions and formulas. If you are using a version of Excel earlier than 2007 you need to activate the "Excel Analysis Toolpack" to make some of the functions above available. Excel Functions and Formulas Sitemap Go to the next lesson:
|
|
|
|
SUMPRODUCT ¦ INDEX/MATCH ¦ SUBTOTAL ¦ ISERROR ¦ COUNTIF ¦ SUMIF ¦ HLOOKUP ¦ LOOKUP ¦ VLOOKUP
AVERAGEIF ¦ AVERAGEIFS ¦ COUNTIFS ¦ SUMIFS ¦ IFERROR