![]() ![]() Match Function – This video defines the MATCH function and explains the three values (-1,0 and, +1) that are related to the lookup type.Index With Rows and Columns – This video shows how to use the INDEX function to pick off an entire row or column.Index Function – This video introduces the INDEX function.Vertical Lookup From Multiple Columns – This video shows how to efficiently pull multiple columns of data using a VLOOKUP and the COPY command.Vertical Lookup From Multiple Worksheets – This video shows how to use a VLOOKUP to efficiently pull multiple columns of data from different worksheets.Product Prices Based on Date – This video uses a VLOOKUP to determine a product’s price based on a date when the price changes over time.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). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |