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.