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.Jun 27, 2022Jun 27, 2022
Tony RobertsinTowards Data ScienceBuilding a Univariate GARCH Model In ExcelVolatility forecasting using GARCH in Excel with Python and PyXLLNov 11, 20212Nov 11, 20212
Tony RobertsinTowards Data SciencePython Jupyter Notebooks in ExcelEmbed Jupyter into Microsoft Excel and write Python instead of VBADec 22, 202015Dec 22, 202015
Tony RobertsinTowards Data ScienceLive Streaming Crypto Prices in ExcelLearn how to get real time ticking crypto prices in Microsoft ExcelOct 27, 2020Oct 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…Jul 15, 20201Jul 15, 20201
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…Mar 24, 2020Mar 24, 2020
Tony RobertsinTowards Data ScienceInteractive Neural Network Fun in ExcelExploring neural networks to understand how they work, in Microsoft Excel.Dec 2, 20193Dec 2, 20193
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.Nov 22, 20193Nov 22, 20193
Tony RobertsIntegrating Excel and ClojureUse Excel as a front-end user interface powered by ClojureOct 24, 20193Oct 24, 20193
Tony RobertsinTowards Data ScienceReplacing VBA with Java in ExcelFall in love with Excel again with the help of some JavaJun 12, 2019Jun 12, 2019