15May
How I Designed an Automated Sales Tracking Spreadsheet With Dynamic Reporting
Learn how I built an automated Excel sales tracking spreadsheet with dynamic reporting, clean formulas, and a monthly summary sheet that actually works.
Read MoreBlog
15May
How I Built a Comprehensive Excel Retirement Cash Flow Model With Scenario Planning and Tax Analysis
Learn how a comprehensive Excel retirement cash flow model with scenario planning, tax analysis, and projection tools was built for financial planning clients.
Read More
15May
How I Built an Automated Excel Dashboard to Track Dog Hotel KPIs Across Two Locations
Learn how I built an automated Excel dashboard to track booking, revenue, and customer KPIs across two dog hotel locations using Gingr data exports.
Read More
15May
How I Created a Cessna 172 Takeoff and Landing Distance Calculator in Excel
How I built a Cessna 172 takeoff and landing distance calculator in Excel using pivot tables, aerodynamics data, and professional formatting.
Read More
15May
How I Built a Financial Dashboard in Excel That Scaled With a Growing Consultancy
How I went from basic Excel templates to a fully functional financial dashboard with KPIs, projections, and clean data visualization — built to scale.
Read More
15May
How I Turned Raw Financial Statements Into an Interactive Excel Analysis Tool
Learn how raw financial statements were transformed into a clean, interactive Excel analysis tool with key metrics, ratios, and actionable financial insights.
Read More
15May
How I Built a Multi-Source Excel Dashboard to Unify Sales, Customer, and Marketing Metrics
How I tackled building a complex Excel dashboard to track sales, customer, and marketing metrics — and what finally made it work end to end.
Read More
15May
How I Built an Excel Add-in That Pulls Live Financial Data From an API
How I set up an Excel add-in that pulls live financial data from an API — covering authentication, JSON parsing, and integration with expert help.
Read More
15May
How I Built a Budget-Friendly CRM System in Excel for a Growing Small Business
I needed a budget-friendly CRM for my small business. Here's how I tried building one in Excel and what happened when the complexity got real.
Read More
15May
How I Built a Customizable Airbnb Budget and Expense Tracking Spreadsheet in Excel
Learn how I built a customizable Airbnb budget and expense tracking spreadsheet in Excel — and when I brought in expert help to get it right.
Read More