Category Archives: Excel

FeedSpot

Posted on 24/05/2026 by dougaj4

Feedspot is a blog database with a huge list of different categories, each with listings of the best blogs, including: 60 Best Excel Blogs to Follow in 2026 with a wide range of blogs, including: For a complete list of … Continue reading →

Posted in Computing - general, Excel | Tagged , , | Leave a comment

Scipy-statistics with all distributions

Posted on 17/05/2026 by dougaj4

Following the previous post the Scipy statistics functions have been updated to include all the distributions, including the discrete distributions. The input to the distribution functions has also been updated to allow arrays to be transferred either as Excel ranges … Continue reading →

Posted in Arrays, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , , , , | Leave a comment

Transferring different data types to/from Python with pyxll

Posted on 12/05/2026 by dougaj4

When a user defined function (UDF) is created in Excel with Python and pyxll the data type of each argument can be specified, either in the @xl_func decorator, or with a separate @xl_arg decorator for each argument. I prefer the … Continue reading →

Posted in Arrays, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , , | 1 Comment

Scipy-statistics with distributions

Posted on 01/05/2026 by dougaj4

The Scipy statistics functions last presented here have now been updated with the addition of links to the numerous distribution functions. The py_Stats spreadsheet, with associated Python code in PythonStatsFuncs3.py and pyScipy3.py, and also minor updates to the pyNumpy.py code, … Continue reading →

Posted in Arrays, Excel, Link to Python, Maths, Newton, NumPy and SciPy, Python Pandas, PyXLL, UDFs | Tagged , , , , , , , , , | Leave a comment

Dealing with annoying Excel defaults

Posted on 27/04/2026 by dougaj4

Mynda Tracey’s MyonlineTrainingHub has a recent post on how to change 15 Excel default settings at: Excel Settings You Need to Change Raise your hand if Excel’s default settings have ever driven you just a little bit crazy. Maybe your … Continue reading →

Posted in Excel | Tagged , , | Leave a comment