To pick a random name from an Excel table using a method that works across every version of Excel, this classic combination ...

I use custom views, the selection pane, clean UI toggles, and other tools to present my workbook professionally.