A function that returns the sum of the products of elements in a set of arrays

This function allows the user to pull a subset of data from a larger table of data based on some criterion 

This button creates arrows pointing to the selected cell from cells that are part of the formula in that cell 

Shows arrows pointing from the selected cell to cells that depend on the selected cell 

To see the formulas in a worksheet

 Provides an excellent means of identifying the exact location of an error in a formula

Provides an automatic means of checking for mathematical errors within formulas of a worksheet 

Useful for large models when not all of the model is observable on the screen or when multiple worksheets are used

An Excel function to count cells in a range that meet a single condition.