David Johnk
Useful educational videos ... how to solve various problems on Excel.
What age to retire? Maximize your total inflation-adjusted retirement income using Excel
Change a UNIX date to a normal date using both and Excel formula and and Excel Lambda function
Download from Yahoo Finance adjusted close price history to Excel for free; no copy-paste.
Calculate the Discounted Payback Period in 90 seconds!
Random sampling from a table of random numbers on Excel and alternate method using randarray.
Random sampling times in Excel. I recently recorded a better one here:
Workstation Balancing on Excel
How to do the StockTrak Assignments
Microeconomics: how to graph quantity supplied and quantity demanded versus price on Excel.
Calculate the weights of the minimum variance portfolio with two stocks on Excel
Graph the efficient frontier and capital allocation line for a three stock portfolio using Excel.
Two ways to download stock prices from Yahoo Finance to Excel now that it's behind a paywall.
Downloading stock prices and calculating periodic and average returns using various methods.
An intuitive method for solving a simple linear programming problem on Excel using Solver
Calculate the Payback Period in 30 seconds!
Calculate the Payback Period on Excel
Turn Your Master's Into Gold: Excel's Future Value Magic
Unlocking TIPS: Calculate Total Return Like a Pro!
Avoid Costly Mistakes: Master Discounted Cash Flows using PB and DBP on Excel
How to do multiple regression on Excel for forecasting.
Income statement calculations in Excel. Demonstrates Excel goal seek as an algebra alterative.
How to Show your Work on the Mini-cases
How to show your work on Excel
Linear Programming Sensitivity Analysis on Excel
Calculate a binomial interest rate tree from par values using Excel.
Calculate the value of a capped, floating coupon rate bond. CFA fixed income study material.
Maximize Profit with tiered profits depending on quantity
Calculate Initial Assessment with CAMELS rating
Calculate spot rates from par rates using Excel
Easily calculate Beta using historical stock data on Excel