15May
How I Built an Excel Web Add-in Using Visual Studio 2022 and JavaScript
A real account of building an Excel web add-in using Visual Studio 2022 and JavaScript — what worked, where it got complicated, and how it got done.
Read MoreArticles by Marcus Johnson(3191)
15May
How I Built an Excel Tool from Complex Mathematical Models to Optimize Sales Strategy
How I turned a complex system of equations into a user-friendly Excel tool to automate sales strategy analysis — and what I learned along the way.
Read More
15May
How I Built an Automated Overtime Calculator in Excel to Streamline Payroll Processing
Learn how I automated overtime calculations in Excel using timesheet data and predefined parameters — and how expert help made it accurate and scalable.
Read More
15May
How I Built a Scalable Capitalization Table in Google Sheets for an Early-Stage Startup
Learn how I built a scalable capitalization table in Google Sheets for an early-stage startup — tracking equity, ownership percentages, and funding rounds.
Read More
15May
How I Built Dynamic Scatterplot Templates in Excel Using VBA for Financial Analytics
Learn how I built dynamic scatterplot templates in Excel using VBA for financial analytics — and how expert help made the difference when complexity peaked.
Read More
15May
How I Built a Scalable Excel Database to Streamline Data Management for a Growing Company
Learn how I tackled messy data chaos by building a scalable Excel database with structured entry, reporting tools, and security — and how expert help made it happen.
Read More
15May
How I Built an Automated Excel Reporting System That Updates in Real-Time Across Multiple Workbooks
How I automated a complex Excel reporting system that updates in real-time across multiple workbooks — and what I learned when the project got too complex to handle alone.
Read More
15May
How I Solved Complex Excel Formula Challenges Across a Team
Struggled with VLOOKUPs, INDEX-MATCH, and SUMIFS across your team? Here's how I tackled complex Excel formula problems with expert help.
Read More
14May
How I Built a Responsive Client Dashboard in Google Sheets With Interactive Charts and KPI Analytics
How I built a responsive client dashboard in Google Sheets with interactive charts and KPI analytics — and what I learned along the way.
Read More
14May
How I Built a Minimalistic PDF-to-Excel Converter with Login and Google Docs Integration
How I tackled building a minimalistic PDF-to-Excel converter website with login functionality and Google Docs integration — and where I got help to finish it right.
Read More
14May
How I Built Dynamic Excel Budget Models That Aligned With Strategic Financial Goals
Learn how I built dynamic Excel-based budget models aligned with strategic financial goals — and when I brought in expert help to get it right.
Read More
14May
How I Fixed Legacy Excel Automation and Streamlined Macro Workflows
I inherited broken Excel macros and outdated automation scripts. Here's how I diagnosed the issues and got everything running smoothly again with expert help.
Read More