Excel Dropdown with NO worksheet data list (with video) Nov 2020

I built an Excel dropdown function — that requires no worksheet reference!

The dropdown built into Excel requires a range of data to populate the dropdown list. This might be an appropriate situation if the spreadsheet is a one-off. In my work, the dropdown list would more appropriately be generated in my PyXLL program.

Excel — Use dynamic arrays and conditional formatting to create a selection dependent menu Oct 2020

I built a short video demonstrating how to use dynamic arrays and conditional formatting to create a selection dependent menu.

Though I built this spreadsheet menu using Excel on a desktop machine, the spreadsheet file also works on an iPad ( ! ) and on an iPhone ( !! ).

Microsoft 365 is required.

NSF, Loyola University, New Orleans 1967 SSTP Sep 2020

Sir Martyn Poliakoff, Element 33, and the periodic chart of videos Sep 2020

CodeSkulptor3 (Probability Plot) Aug 2020

I built a short presentation demonstrating the use of CodeSkulptor3 (Python 3). This time, my goal was to illustrate coding a small probability problem including a plot of results — accessible from any device — desktop, phone, iPad. Feel free to follow the links and to offer a critique. Probability of finding exactly one digit […]