16May
How I Built an Automated Google Docs Generator from Excel Spreadsheets
I tried to build a tool that auto-generates Google Docs from Excel data. Here's what went wrong, how I got help, and what the final solution looked like.
Read MoreBlog
16May
How I Built a Tennis Match Prediction Model in Excel Using Historical Performance Data
I tried building a tennis match prediction model in Excel from scratch. Here's what I ran into, how I got help, and what the final model actually looked like.
Read More
16May
How I Built a SQL Database From Multiple Excel Sheets and Ensured Data Integrity
I tried consolidating multiple Excel sheets into a SQL database myself. Here's what happened, where I hit a wall, and how the work got done right.
Read More
16May
How I Created a Quarterly Sales Tracking Spreadsheet With Automated Monthly Summaries
Learn how I built a sales tracking spreadsheet in Excel with automated monthly summaries, average calculations, and clean formatting for quarterly reporting.
Read More
16May
How I Built a Simple Excel Data Conversion Application Using VBA Macros
I needed to convert Excel data into a different format automatically. Here's how I tried using VBA macros and what finally got the job done right.
Read More
16May
How I Built a Sales Dashboard in Excel Using Pipedrive Data to Track Key Metrics
Learn how I turned raw Pipedrive CRM data into a clear Excel sales dashboard tracking lead generation, conversion rates, and deal closures.
Read More
16May
How I Created a Financial Metrics Dashboard in Excel With Dynamic Formulas and Charts
Learn how I built a quarterly financial metrics dashboard in Excel with dynamic formulas and charts — and how expert help made it accurate and deadline-ready.
Read More
16May
How I Created a Dynamic Ranking Formula System for Hedge Fund Analysis in Excel
I built a dynamic ranking formula system for hedge fund data in Excel. Here's how the project unfolded, where I hit walls, and how it finally got done right.
Read More
16May
How I Built an Automated Power Automate Script to Transfer and Format Excel Data Hourly
Learn how I used Power Automate and Excel scripting to automate hourly data transfers between sheets — and how expert help made it error-free.
Read More
16May
How I Built a Pivot Table and Combo Chart to Visualize Key Business Metrics in Excel
Learn how I used a pivot table and combo chart in Excel to visualize key business metrics clearly — and when I brought in expert help to get it right.
Read More