Guides
Learn how to automate your spreadsheets, build financial models, clean data, and integrate with databases using ModelMonkeyโs AI-powered assistant.
How to Analyze Sales Data in Google Sheets
Master sales data analysis with pivot tables, advanced formulas, and automated reports. Perfect for business analysts and data-driven teams.
How to Create Financial Reports with AI
Save hours every month by using an AI assistant to generate financial reports, budget tracking, and variance analysis in Google Sheets.
How to Build a Three-Statement Financial Model with AI
Master the art of building integrated financial models that link the income statement, balance sheet, and cash flow statement โ with AI to help you build faster and avoid common errors.
How to Build a DCF Valuation Model
Master the art of company valuation using discounted cash flow analysis. Learn to forecast cash flows, calculate WACC, determine terminal value, and arrive at an intrinsic value estimate.
How to Build a Cap Table with Dilution Modeling
Take control of your startup's equity with a comprehensive cap table model. Learn to track ownership, model funding rounds, manage option pools, and forecast dilution through multiple scenarios.
How to Build a Runway Calculator for Startups
Master your startup's cash management with a comprehensive runway calculator. Learn to track burn rate, forecast when you'll run out of money, and optimize your fundraising timeline before it's too late.
How to Build a Freelance Income & Expense Tracker
Track your freelance income, expenses, and profit margins with an automated Google Sheets system that helps you stay organized and tax-ready.
How to Clean Spreadsheet Data with AI
Turn messy, inconsistent data into clean, analysis-ready datasets in minutes instead of hours.
How to Connect Google Sheets to PostgreSQL
Query PostgreSQL databases directly from Google Sheets with AI-powered assistance.
How to Clean Messy Data in Google Sheets
Master data cleaning techniques with formulas, functions, and AI automation. Turn messy spreadsheets into analysis-ready datasets in minutes.
Master Google Sheets QUERY Function
Unlock SQL-like data manipulation in Google Sheets. Learn QUERY syntax to filter, sort, pivot, and aggregate data with powerful formulas.
Build a Startup Metrics Dashboard in Google Sheets
Track the metrics that matter: MRR, CAC, LTV, burn rate, and runway. Build an investor-ready dashboard that updates automatically.
Track Sales Pipeline in Google Sheets
Build a lightweight CRM to manage deals, forecast revenue, and track sales team performanceโwithout expensive software.
Build Financial Projections in Google Sheets
Create investor-ready 3-5 year financial forecasts. Model revenue growth, expenses, and cash flow for fundraising and planning.
Create an OKR Tracker in Google Sheets
Align your team around clear objectives and measurable key results. Track progress and hold everyone accountableโall in one simple spreadsheet.
Analyze Customer Feedback in Google Sheets
Turn customer surveys, support tickets, and reviews into actionable product insights. Identify patterns, prioritize features, and improve satisfaction.
Automate Monthly Reports in Google Sheets
Stop manually creating reports every month. Build automated dashboards that update themselvesโsave hours and eliminate errors.
Build Executive Dashboards in Google Sheets
Create clean, visual dashboards that give leaders instant visibility into business performance. Track KPIs, spot trends, make data-driven decisions.
How to Connect DuckDB to Google Sheets
Query Google Sheets data with DuckDB SQL using Python and the Sheets API. Run joins, aggregations, and GROUP BY on live spreadsheet data in under 50 lines of code.
How to Track Freelance Income from Multiple Payment Sources
Build a Google Sheets ledger that consolidates Stripe, PayPal, Wise, and bank transfers into one tax-ready income tracker. Step-by-step setup.
How to Create an Income Tracking Rule in Google Sheets
Learn what an income tracking rule is and how to build one in Google Sheets using formulas, data validation, and SUMIF to categorize and summarize income automatically.
How to Calculate Runway for a Startup in Google Sheets
Build a startup runway calculator in Google Sheets. Track gross burn, net burn, and months of cash with formulas that update automatically.
Automate Expense Tracking for Freelancers in Sheets
Build a self-updating expense categorizer in Google Sheets with dynamic column mapping, a vendor rules table, and outputs that feed a real P&L or burn model.
How to Build an OKR Google Sheets Template (2026)
Build a live-linked OKR Google Sheets template with auto-updating scores, weighted objectives, and a board-ready dashboard. Step-by-step for finance teams.
Sales Pipeline Bijhouden in Google Sheets (2026)
Bouw een sales-pipeline tracker in Google Sheets voor 10kโ40k rijen CRM-data. Met funnelweergave, wekelijkse trend en een directie-dashboard.
DCF Valuation Model Step-by-Step in Google Sheets
Build a 7-tab DCF valuation model in Google Sheets from scratch โ WACC, UFCF projections, terminal value, and a sensitivity table. Real SaaS example with formulas.