Next, Excel needs to know what it will use as ... and then select the data in the Average column of Table 2. Click "OK," and ...

An curved arrow pointing right. Don't waste time testing different values individually in Excel. Use a data table to show the results for many different possible scenarios at once. Follow BI Video ...

Here is where Excel pivot tables step in to extract data ... You can right-click on any column to give it a custom name, generate average results (for specific data types), and make other changes.