|
|
|
Special Excel Functions 2003
Special Excel Functions 2007
|
Lesson 29: Excel Analysis ToolpakThe Analysis Toolpak is an add-in created by Microsoft that adds 86 functions to the ones already available. When you activate the Analysis Toolpak (in versions of Excel earlier than 2007) you get the Engineering functions, many more Financial functions and a few Mathematical and Date and Time functions. To activate the Excel Analysis toolpak go to "Tools/Add-ins" and check the box for Analysis Toolpak then "OK. From then on you really have 333 functions that are offered to you when you click on "Insert/Function" or when you click on the icon Learn more on Excel Excel Functions and Formulas Sitemap
|
|
|
|
SUMPRODUCT ¦ INDEX/MATCH ¦ SUBTOTAL ¦ ISERROR ¦ COUNTIF ¦ SUMIF ¦ HLOOKUP ¦ LOOKUP ¦ VLOOKUP
AVERAGEIF ¦ AVERAGEIFS ¦ COUNTIFS ¦ SUMIFS ¦ IFERROR