STEP 1: Open the workbook in Microsoft Excel. STEP 2: Enter the data in the workbook. In this example, we just gave some random values as x axis and y axis values. STEP 3: In the new cell, give the formula. First always start with ‘ =’ for every functions, INTERCEPT function name, followed by the open parenthesis, the arguments of the.