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




About this tutorial:

Video duration: 8:47
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.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads