Select the entire data table range and go to the Data tab, select What-If Analysis > Data Table. Specify the row and column input cells corresponding to the horizontal and vertical variables. Example: ...

Q. In your November Tech Q&A article on Excel’s Scenario Manager, you mentioned two other “what-if” tools: Goal Seek and Data Table. Can you show how those work like you did with Scenario Manager? A.

Once activated, the Power Pivot tab will appear in your Excel ribbon, granting you access to a suite of advanced tools for data modeling and analysis. 10X Your Pivot Tables Skills Watch this video ...