This video shows how to use Solver in Excel to generate optimal portfolios (mean - variance optimization). It also shows how to utilize matrix notation to make your life easier.