MM0061 - VBA-Based Optimisation In Excel
We've looked at some of the 'built-in' options that Excel offers for optimisation in the past few weeks. Nothing beats the power and flexibility of VBA, however. Let's feel that power just a bit in this session …
Topics
Topics
- | What Is Optimisation Using Excel VBA?
- | How To Trace Dependencies In Excel
- | 2-Variable Vs. 3-Variable Optimisation
- | How To Plan A VBA-Based Optimisation
- | Use & To Concatenate Text
- | Set Up Loops For VBA-Based Optimisation
- | Use A Message Box To Test A VBA Loop
- | Classic Combo: Loop - Variable - Offset Method
- | Loop Within Loop Example
- | 3 Embedded Loops Example
- | How To Record Iteration Numbers
- | Create An Output Table For Optimisation
- | Summary Of Steps In VBA Optimisation
- | Bart Talks About Setting Up An Excel Business
1 Lesson