Tony RobertsinPython in Plain EnglishInstall Python on a Locked-Down PC Without Local AdminEven if you don’t have local admin or if you are not able to run installers to install software on your PC, you can still use Python.9 min read·Jun 27, 2022----
Tony RobertsinTowards Data ScienceBuilding a Univariate GARCH Model In ExcelVolatility forecasting using GARCH in Excel with Python and PyXLL9 min read·Nov 11, 2021--2--2
Tony RobertsinTowards Data SciencePython Jupyter Notebooks in ExcelEmbed Jupyter into Microsoft Excel and write Python instead of VBA9 min read·Dec 22, 2020--15--15
Tony RobertsinTowards Data ScienceLive Streaming Crypto Prices in ExcelLearn how to get real time ticking crypto prices in Microsoft Excel5 min read·Oct 27, 2020----
Tony RobertsinTowards Data ScienceA Non-Volatile INDIRECT Alternative in Excel using the Pub/Sub PatternThe INDIRECT function in Excel is a tricky beast. One the one hand it can be incredibly useful, but on the other hand it is responsible…9 min read·Jul 15, 2020--1--1
Tony RobertsinTowards Data ScienceMitigating End User Computing Risk with ExcelThe risk associated with End User Computing, or EUC, is something that companies more and more are taking seriously. End User Computing is…9 min read·Mar 24, 2020----
Tony RobertsinTowards Data ScienceInteractive Neural Network Fun in ExcelExploring neural networks to understand how they work, in Microsoft Excel.8 min read·Dec 2, 2019--3--3
Tony RobertsinTowards Data ScienceA Better Excel Goal Seek using PythonGo further than Excel’s Goal Seek or Solver solutions using Python’s scipy.optimize package, in Excel.4 min read·Nov 22, 2019--3--3
Tony RobertsIntegrating Excel and ClojureUse Excel as a front-end user interface powered by Clojure7 min read·Oct 24, 2019--3--3
Tony RobertsinTowards Data ScienceReplacing VBA with Java in ExcelFall in love with Excel again with the help of some Java8 min read·Jun 12, 2019----