ULTIMATE Subscription Audit & Dashboard in Excel (FREE Template)
From MyOnlineTrainingHub · · 9 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.
If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.
Description
Easily audit and cut unnecessary subscriptions with this simple Excel tracker. 🔗 Download the free template here and follow along: https://bit.ly/subsaudit26file 👩🏫 Master Excel & Power BI with my courses: https://bit.ly/subsaudit26courses
🎬 MORE FREE EXCEL TEMPLATES, full playlist here: https://bit.ly/templates26playlist
Small recurring monthly costs can add up fast. In this step-by-step tutorial, you'll learn how to build an automated subscription audit tracker in Excel to see exactly where your money goes, identify which services to cancel, and project how much you could save over time.
Whether you're an Excel beginner or looking to sharpen your spreadsheet skills, this project is simple, practical, and easy to follow.
What you’ll learn:
- Table setup & design: how to organize your subscriptions, costs, renewal dates, and payment methods cleanly.
- Interactive checkboxes: add simple check marks to flag which subscriptions you plan to keep or cancel.
- Automated summary cards: use core formulas to calculate total monthly and annual spend dynamically.
- Visual data bars: apply conditional formatting to spot high-cost subscriptions at a glance.
- Category breakdown: group your spending by category using dynamic Excel functions and a simple donut chart.
- Future savings projection: see the real impact of cutting unused services using compound growth formulas.
LEARN MORE ===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up
🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/
💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS ============== 00:00 Why audit your subscriptions 00:48 Setting up the table 01:41 Adding checkboxes and totals 02:17 Summary metrics and formulas 03:36 Adding progress bars 03:58 Grouping costs by category 04:36 Adding a breakdown chart 05:37 Finding what to cancel 06:42 Seeing how much you can save 08:46 Build a complete personal finance tracker
#Excel #ExcelTemplate #ExcelFinance