MM0060 - 25/01/21 - Excel Optimisation Basics
If you are working with a 'model' that consists of input, process and output, optimisation is something you might be interested in, and Excel is great at it! Let's explore the basics in this stream.
Topics
Topics
- | What Is Optimisation?
- | Example Optimisation Question
- | Benefits Of Optimisation In Excel
- | What Is Required For Optimisation
- | When An Excel Model Is Not A Model!
- | How To Identify Input, Process, Output Cells
- | How To Do Optimisation Manually
- | Summary Of Excel Optimisation Options
- | What Is A 'Variable'?
- | How To Set Up An Optimisation Table
- | How To Create A Data Table (1 Way)
- | How To Create A Data Table (2 Way)
- | How To Test Data Table Output
1 Lesson