Back to Browse

Excel — Build a Subscription Tracker (Beginner Capstone)

35 views
Feb 19, 2026
8:06

In this capstone of the Excel Basics series, we build a real subscription tracker from a blank sheet. You can download the finished subscription tracker from the link below. In this video, we: ✅ Start from scratch ✅ Plan the structure intentionally ✅ Build a subscription tracker step by step ✅ Use tables where they make sense ✅ Create something that’s clean and hard to break This is a beginner-friendly Excel project that combines ranges, tables, sorting, filtering, and basic formulas. If you’ve followed the basics so far, this pulls everything together. 📂 Finished Subscrption Tracker file download: https://chillpirate.gumroad.com/l/subscriptiontracker 📖 Chapters 0:00 Building a subscription tracker 0:14 Planning the structure 0:35 Entering initial data 1:34 Creating the table 2:24 Sorting & filtering 2:58 Totals and annual cost 3:58 Summary area 5:28 Demo of summary area 5:49 Adding and updating a subscription 6:38 Final formatting polish 7:13 Final checks & wrap-up Music by Wahyu Music on Pixabay

Download

0 formats

No download links available.

Excel — Build a Subscription Tracker (Beginner Capstone) | NatokHD