A video showing a simple business problem that you can solve using Excel's Solver add-in. This particular example is focused on optimizing the production mix of Mice, Keyboards, and USB Hubs. However, there are many analogous problems in business, such as choosing Lean Six Sigma projects or Choosing IT enhancements that maximize return on investment (ROI).

This video shows the basics of using the Excel Solver add-in and also demonstrates some of the best practices in organizing your spreadsheet.

Here is a link to the spreadsheet used in the example: [ Ссылка ]

свернуть