Goal: Create a three dimension data table using the what-if tool in Excel based on three variables.

Welcome, this video will outline one way to create a three-dimension data table in Excel.

In order to properly demonstrate this approach, we will firstly create a simple data table for a company’s gross revenue. This will be based on unit price, units sold and number of sellers.

The following screenshot outlines this in the video.

Download SpreadsheetVault – Creating a Three Dimension Data Table in Excel (solution).xlsb