Among all of the amazing enhancements in Excel, one that really resonates with the core of Excel is dynamic arrays. Spreadsheets became popular primarily because of their tactile ability to visually compute and display changing results in real-time. Dynamic arrays open up numerous new possibilities for this type of visual, interactive analysis, not least of … Continue reading How to create interactive visualizations in Excel using dynamic arrays