Using SciPy in an Excel macro for complex optimization problems.
Multi-Dimensional Optimization: A Better Goal Seek
Using SciPy in an Excel macro for complex optimization problems.
A guide to the different solutions available for working with Excel and Python. From reading and writing Excel files, to using Python as a VBA replacement in Excel.
Learn how to step through Python code running in Excel using the most popular Python IDEs.