16May
How I Built a Shared Budget Tool with Dynamic Excel Formulas for Couples
I tried building a shared Excel budget tool for my partner and me. Here's how dynamic formulas, charts, and expert help made it actually work.
Read MoreBlog
16May
How I Built Quantitatively Rigorous Financial Diligence and FP&A Dashboard Templates in Excel
How I tackled building complex financial diligence and FP&A dashboard templates in Excel — and what happened when the models grew too complex to handle alone.
Read More
16May
How I Organized 12,000 Software Listings Into a Performance-Tracking Excel Database From Pitchbook Data
I had 12,000 software listings from Pitchbook and no clean way to track them. Here's how I built a performance-tracking Excel database that actually worked.
Read More
16May
How I Built a Cyber Security Interview Question Matrix in Excel With Dynamic Candidate Tracking and Performance Analytics
How I built a dynamic Excel worksheet for cyber security interviews with candidate tabs, rating scales, and performance analytics charts.
Read More
16May
How I Built an Automated Excel Workbook to Stream ETF Data From Google Finance
How I built an Excel workbook to automatically pull ETF data from Google Finance — and why I handed it off to experts to get it done right.
Read More
16May
How I Turned PDF Files Into Structured Excel Workbooks Using Python Automation
I needed to convert PDF files into structured Excel workbooks fast. Here's how Python automation helped me solve the problem and what I learned along the way.
Read More
16May
How I Built a Scalable Excel Sales Dashboard That Automated Data Analysis for a Growing Business
I needed a scalable Excel sales dashboard to automate data analysis. Here's how I solved it and what I learned about building the right template from scratch.
Read More
16May
How I Turned Raw Sales Data Into a Structured Excel Table for Quarterly Performance Analysis
I had a pile of unorganized sales data and needed a clean Excel table fast. Here's how I got it done before a critical quarterly review meeting.
Read More
16May
How I Created Dynamic Excel Spreadsheets for Construction Project Scheduling and Budget Management
Learn how dynamic Excel spreadsheets transformed construction project scheduling and budget management — from setup struggles to a fully working system.
Read More
16May
How I Designed a Data Management System Using Excel and Google Sheets for Cross-Team Collaboration
How I built a cross-team data management system using Excel and Google Sheets — and what I learned when the complexity outgrew my skills.
Read More
16May
How I Turned Messy PDF Files Into Organized Excel Spreadsheets for Financial Integration
Struggling to convert messy PDFs into clean Excel spreadsheets? Here's how I got 10 PDFs extracted and organized for financial system integration fast.
Read More
16May
How I Created a Comprehensive School Database Spreadsheet for Austin Metro Parents and Educators
How I built a detailed Excel spreadsheet categorizing Austin metro schools by type, grade level, performance metrics, and location for easy filtering and analysis.
Read More
16May
How I Created a Comprehensive Hospital Database Spreadsheet for Austin and San Antonio Healthcare Networks
Learn how I built a detailed Excel hospital database for Austin and San Antonio metro areas — tracking locations, contacts, and facility details.
Read More