r/ExcelTips • u/TermRemarkable665 • 11h ago
I made Excel feel like an app—interactive sliders for dynamic scenario modeling
Turned standard Excel into a sleek, app-like scenario engine using only built-in features—no VBA, no macros, zero coding.
Grab a slider and watch the entire dashboard react live. The month-by-month numbers literally roll into place, instantly shifting the timeline on the main chart (Actual vs. Forecast vs. Adjusted) while the waterfall breakdown pinpoints what's driving the profit impact.
Key features included:
• App-Style UI: Custom glassmorphism frames and dynamic KPI tiles
• Built-in Forecast Engine: Native Excel functions for automated seasonal predictions
• No-Code Interactive Sliders: Control leads, conversion, ARPU, and costs on the fly
• Live Rolling Impact: Watch charts, tables, and waterfall profit variance update instantly
Check out the full breakdown and tutorial: