How to Create a Data Table in Excel Using the What if Analysis Tool

This tutorial demonstrates how to create both a one variable data table and a two variable data table using the What if Analysis Tool. A two variable table creates a crosstabulation of two variables. The example uses students grades to predict overall average. The various what if scenarios test various grades in a table format to show all the possible results of overall average.
If you enjoyed this video please visit my channel page for more videos and please subscribe, I really appreciate it!