4.2 Insert Function Tool – Intro to Excel 2016 Data Analysis

4.2 Insert Function Tool

The Insert Function tool is great to use if you are new to Excel formulas and functions and are experiencing some difficulty formulating your function with the correct arguments (parameters). This discussion/tutorial on usage of the Insert Function Tool should help you through this process.

The Insert Function tool can be used with any Excel function.

​You can access the Insert Function tool from any Excel tab since the Insert Function icon  is located on the Ribbon next to the Formula Bar, shown below. It is also located on the Formula tab, shown in the bottom graphic.

When we select the Insert Function icon, we will view this dialog box:
​We will demonstrate usage with the AND, OR, IF functions.