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.
