Data Tables, Goal Seek, And Scenario Manager Syllabus

Data Tables, Goal Seek, and Scenario Manager

This course covers Data Tables, Goal Seek, and Scenario Manager and consists of 16 topics.

One Way Data Table – This video shows how to use a One Way Data Table to determine how changing a single spreadsheet input affects multiple outputs.
Two Way Data Table – This video shows how to use a Two way data table to determine how changes in two spreadsheet inputs affect a single output.
Mortgage Data Table – This video shows how to use a Two way data table to determine how the monthly payment on a loan depends on the loan size and annual rate.
Customer Value – This video uses a Two way data table to determine how a customer’s value depends on the time value of money and customer retention rate.
Goal Seek – This video shows how Goal Seek can be used to determine the number of unit sales needed for a juice bar to break even.
Goal Seek Finance – This video shows how to use Goal Seek to determine the annual rate on a loan that makes the monthly payment hit a desired value.
Scenario Manager – This video shows how the Scenario Manager can be used to describe how scenarios involving multiple spreadsheet inputs influence multiple spreadsheet outputs.
Down Payment – This video shows how to use a Two way data table to determine how the return on equity for a home investment depends on the size of the down payment and the change in home value.
Project Management – This video shows how to use a One-Way data table to determine the critical activities in a project.
Hedging – This video shows how to use a One way data table to show how hedging with puts can reduce equity risk.
Bill Belichick’s Bold Move –This video explains how to use a Two way data table to show that Belichick was right when he went for it on 4th down against the Colts.
IF Statements and Data Tables – In this video we combine IF statements and a one-way data table to calculate how many antitrust cases were active during the years 1960-2016.
Data Table Chart – In this video we show how to create a chart to summarize the numbers in a two-way data table.
Hedge Funds – In this video we use a one-way data table to show how a simple hedge fund strategy neutralizes market risk.
The Syracuse Problem – In this video we use IF, MATCH, the ISEVEN function, and data tables to describe the famous Syracuse Problem conjecture
Relating Bond Price and Yield – In this video we use data tables to show the relationship between bond prices and yields.
Learn More