Excel Analysis Toolpak

Excel functions, formulas and examples

 

Excel tips on functions and formulas

Excel Functions and Formulas

excel-functions tutorial

Excel macros (VBA)

Excel and VBA Expert

Excel fonctions et formules

Special

Excel Functions

2003

 

sumproduct

index-match

subtotal

iserror

countif

sumif

hlookup

lookup

vlookup

 

 

Special

Excel Functions

2007

 

averageif

averageifs

countifs

sumifs

iferror

 

 

 

 

 

 

 

Lesson 29: Excel Analysis Toolpak

The 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 Excel insert function


Learn more on Excel
Discover our Products


Excel Functions and Formulas Sitemap


See the complete version of this lesson in
The Tutorial on Excel
Functions

 

 

 

Excel tips on functions and formulas

excel-functions tutorial

Excel macros (VBA)

Excel and VBA Expert

Excel fonctions et formules

SUMPRODUCT  ¦  INDEX/MATCH  ¦  SUBTOTAL  ¦  ISERROR  ¦  COUNTIF  ¦  SUMIF  ¦  HLOOKUP  ¦  LOOKUP  ¦  VLOOKUP
AVERAGEIF  ¦  AVERAGEIFS  ¦  COUNTIFS  ¦  SUMIFS  ¦  IFERROR