Published: Thu, 04/10/25
Updated: Wed, 04/16/25
Having trouble viewing this email? Read this email in your browser.
Hi ,
Your dashboard shouldn’t fall apart every time someone changes the timeframe.
Most project dashboards:
❌ Can’t toggle between days, weeks, or months.
❌ Break when the data shifts.
❌ Force you to build 3 different versions.
This one does it better:
✅ One dashboard.
✅ One dataset.
✅ Three dynamic views (daily, weekly, monthly).
All controlled with a simple button click.
No VBA. No complex tools.
Just Excel doing smart things with CHOOSE, SWITCH, and a few form controls.
Perfect for project tracking and managing schedules.
🎥 Watch the tutorial and download the template here: Every Project Manager Needs This Dashboard Trick
Watch on YouTube
Mynda Treacy Co-Founder of MyOnlineTrainingHub
Want to sponsor our newsletters? Just reply to this email to get in touch with us.
Excel Dashboards
Power BI
Power Query
Power Pivot & DAX
Advanced Excel
Advanced Formulas
PivotTable Quick Start
Xtreme PivotTables
Excel Tables
Financial Modelling in Excel
Excel for Customer Service
Excel, Word & PowerPoint
This email may contain affiliate links. This means I may earn a commission should you choose to make a purchase using my link. But we only promote courses we believe will benefit you.