Horizontal Lookup – This video uses the HLOOKUP function to lookup sales and employees during each month.
Vertical Lookup – This video shows how to use the VLOOKUP function to compute a tax rate based on income and a products price based on its code.
Variance Analysis – In this video we show how to decompose a sales variance into a volume, product mix, and price variance.
Product Line Pricing – This video shows how changing the price of two products, (specialty and regular coffee) changes the demand for each product.
Butterfly Effect – This video illustrates the Butterfly effect: If a butterfly flaps its wings in Tahiti it may cause a snowstorm in Kansas.
Gravity Model – This video explains how to implement a complex formula, the Gravity Model which computes market shares for stores based on their locations and quality.
Depreciation – This video shows how to model 3 different methods of depreciation used to depreciate a machine to its final salvage value.
Amortization Schedule – This video explains how a loan payment reduces the balance of a loan by the end of the loan term.
Modeling Fish in a Pond – This video explains how to create a dynamic model that shows the evolution of the number of fish in a pond.
Retirement – This video explains how to model the evolution of a retirement fund.
Cost Curves – This video explains how to use PEMDAS to compute basic economic cost curves (Average Cost, Marginal Cost, etc.).
Modeling Supply and Demand – This video explains how to create a simple chart to model supply and demand for a product.
Big Mac Index – In this video we use the Economist’s Big Mac Index and basic spreadsheet formulas to show that the Chinese currency is vastly undervalued.
Body Mass Index – This video shows how to use PEMDAS to compute Body Mass Index (BMI).
It also discusses Order of Operations (PEMDAS).
Gini Index – This video shows how to use Excel to compute a complex important formula (Gini index measuring income inequality).
Diving Score – This video explains using the LARGE function to help compute Olympic Diving Scores.
Computing a Production Function – In this video we show how to compute a production function which shows how labor and cloth can be transformed into dresses.
Basic Formulas Part Three – This video explains how to create a worksheet that computes students final grades based on homework and exams.
Basic Formulas Part Two – This video explains how to copy formulas across rows and down columns, the meaning of $ signs, and setting up a dynamic model of customer evolution.
Basic Formulas Part One – This video explains how to copy a formula not involving “$” signs.
0 kommentar(er)
