Python can be much faster than VBA for numerical calculations. Python functions can be called from Excel in the same way as VBA functions using PyXLL, and often with significant performance benefits. This video demonstrates how a simple function can be sped up by writing it in Python and also further improved using the Python package Numba.

Links:

Newton Excel Bach
https://newtonexcelbach.com/2021/05/3…

PyXLL
https://www.pyxll.com/

PyXLL Jupyter
https://www.pyxll.com/jupyter

Numba
https://numba.pydata.org/

Subscribe: https://www.youtube.com/channel/UCfMaA6FC0aKYXEWubmOW5Vw/featured

#python #excel #numba