How-To Guides
Practical how-to articles for Google Sheets and Excel. Every guide points to a free template or in-browser tool you can use immediately.
Browse by topic
Free browser tools
Clean CSVs, rewrite lookups, and decode formulas — nothing uploads.
Guide
How to Clean a CSV Before Importing It Into Sheets or Excel
Clean a messy CSV before it breaks your import — duplicates, blank rows, stray spaces, and bad headers fixed in seconds with a free browser tool.
Guide
How to Convert VLOOKUP to XLOOKUP in Google Sheets or Excel
Replace brittle VLOOKUP with XLOOKUP — paste the old formula, get the modern version, and skip counting column numbers in Sheets or Excel.
Guide
How to Understand a Spreadsheet Formula (Without Guessing)
Paste any Google Sheets or Excel formula and learn what it does, function by function — a free browser tool that explains without uploading your data.
Budgets & money
Monthly budgets, debt payoff, savings, and household spend.
Guide
How to Build a Monthly Budget in Google Sheets (or Excel)
Build a working monthly budget from scratch in Sheets or Excel in under 15 minutes — the exact formulas, layout, and a free copy-ready template.
Guide
How to Pay Off Debt With a Spreadsheet (Snowball vs. Avalanche)
Compare snowball vs. avalanche debt payoff in one spreadsheet — see payoff dates, total interest, and which method saves more money.
Guide
How to Track Savings Goals in a Spreadsheet (Sinking Funds)
Track multiple savings goals with progress bars, monthly contributions, and auto target dates — sinking funds without a budgeting app.
Freelancing & creative work
Rates, invoices, and client billing for independent work.
Guide
How to Calculate Your Freelance Hourly Rate in a Spreadsheet
Work out the freelance hourly rate you actually need — target income, costs, taxes, and real billable hours, not a number you guessed from a forum post.
Guide
How to Track Freelance Invoices and Outstanding Payments in a Spreadsheet
Track billed, paid, and overdue freelance invoices in one spreadsheet — flag who hasn't paid and set aside tax money before you spend it.
Guide
How to Price Graphic Design Projects in a Spreadsheet
Build graphic design quotes from hours, rate, deliverables, and usage rights — with rush and revision add-ons in Google Sheets or Excel.
Home services & invoicing
Service calls, maintenance agreements, and field invoices for trades operators.
Guide
How to Bill HVAC Maintenance Agreements in a Spreadsheet
Track HVAC service plans, visits due, renewals, and recurring revenue — bill maintenance agreements before visits slip through the schedule.
Guide
How to Bill Pest Control Service Agreements in a Spreadsheet
Track pest control plans, visit frequency, renewals, and recurring revenue — keep agreement billing aligned with every scheduled stop.
Guide
How to Track Plumbing Service Calls and Invoices in a Spreadsheet
Log plumbing calls, parts, labor, and invoice status from scheduled to paid — a field-friendly service log without dispatch software.
Education & tutoring
Gradebooks, session scheduling, and parent billing for tutors and teachers.
Guide
How to Build a Gradebook in Google Sheets (Weighted Categories)
Build a weighted gradebook in Google Sheets with auto-averages, letter grades, and at-risk flags — set up your grading rules in 15 minutes.
Guide
How to Bill and Track Tutoring Invoices in a Spreadsheet
Bill tutoring from sessions and hourly rate, track paid and overdue invoices, and total monthly income — without tutoring platform fees.
Guide
How to Track Tutoring Students and Progress in a Spreadsheet
Track tutoring students, subjects, session counts, progress notes, and payment balance in one spreadsheet — without a learning management system.
Design & architecture
Interior design budgets, architecture fees, and studio project tracking.
Guide
How to Track Interior Design Projects Room by Room in a Spreadsheet
Track interior design projects by room, phase, deadline, and status — see every active job without heavyweight project software.
Guide
How to Track an Interior Design Budget in a Spreadsheet (Estimate vs. Actual)
Track interior design FF&E budgets with estimate vs. actual, markup, and vendor status per item and room — before client selections blow the number.
Guide
How to Track Architecture Design Fees by Phase in a Spreadsheet
Split contract fees by design phase and track billed vs. remaining — architecture and design firms without heavyweight billing software.
Legal & professional billing
Billable hours, paralegal time, and unbilled WIP for firms and freelancers.
Guide
How to Log Attorney Billable Hours in a Spreadsheet
Log attorney billable time by matter with auto fee totals and billed vs. unbilled views — prep invoices without trust-account software.
Guide
How to Track Paralegal Billable Hours in a Spreadsheet
Log paralegal time by matter with rate and billable totals — invoice-ready hours without legal billing software.
Guide
How to Track Unbilled WIP and Client Billing in a Spreadsheet
Track unbilled work-in-progress, hours to value, and realization per client — invoice professional services before WIP becomes write-offs.
Real estate
Commissions, rental deals, cash flow, and STR income for agents and investors.
Guide
How to Track Real Estate Commissions in a Spreadsheet
Track agent deals, commission splits, and projected vs. earned income — pipeline and closed commissions in one view.
Guide
How to Analyze a Rental Property Deal in a Spreadsheet
Model rental cash flow, cap rate, and cash-on-cash return before you offer — vet deals on the same math every time.
Guide
How to Track Rental Property Cash Flow in a Spreadsheet
Track rent, expenses, and cash flow per rental unit in one spreadsheet — tax-ready totals without property management software.
Property services
Pool routes, build estimates, rent rolls, and maintenance for field property operators.
Guide
How to Bill Pool Service Clients in a Spreadsheet
Track pool service monthly fees, paid status, and outstanding balances — recurring route billing without pool service software.
Guide
How to Maintain a Rent Roll and Collect Rent in a Spreadsheet
Track rent due, payments, balances, and lease ends per unit — monthly billing ops for landlords without PM software.
Guide
How to Estimate In-Ground Pool Build Costs in a Spreadsheet
Price pool size, decking, equipment, and labor with margin — build consistent estimates before you quote a dig date.
HOA & leasing
Apartment leads, unit availability, HOA violations, and common-area maintenance.
Guide
How to Track Leasing Leads in a Spreadsheet
Track apartment leasing prospects by source and stage from tour to application — measure conversion without a leasing CRM.
Guide
How to Run a Unit Availability Board in a Spreadsheet
Track apartment unit occupancy, notice status, and available dates — know what you can tour and lease today.
Guide
How to Log HOA Violations in a Spreadsheet
Track covenant violations by unit with notice dates and cured status — document HOA enforcement without management software.
All guides
How to Analyze a Rental Property Deal in a Spreadsheet
Model rental cash flow, cap rate, and cash-on-cash return before you offer — vet deals on the same math every time.
By
SheetFor Editorial Desk
Spreadsheet Templates & Tools Editorial Team
How to Bill and Track Music Lesson Invoices in a Spreadsheet
Turn music lessons into monthly invoices by rate, track invoiced vs. paid, and flag overdue balances — without studio management software.
By
SheetFor Editorial Desk
Spreadsheet Templates & Tools Editorial Team
How to Bill and Track Tutoring Invoices in a Spreadsheet
Bill tutoring from sessions and hourly rate, track paid and overdue invoices, and total monthly income — without tutoring platform fees.
By
SheetFor Editorial Desk
Spreadsheet Templates & Tools Editorial Team
How to Bill Home Care Clients in a Spreadsheet
Bill home care hours by client and payer with invoiced vs. paid tracking — private-pay and program splits without claims software.
By
SheetFor Editorial Desk
Spreadsheet Templates & Tools Editorial Team
How to Bill HVAC Maintenance Agreements in a Spreadsheet
Track HVAC service plans, visits due, renewals, and recurring revenue — bill maintenance agreements before visits slip through the schedule.
By
SheetFor Editorial Desk
Spreadsheet Templates & Tools Editorial Team
How to Bill Landlords for Tenant Screening Reports in a Spreadsheet
Invoice landlords per screening report with paid vs. outstanding totals — billing ops for tenant screening services without CRM bloat.
By
SheetFor Editorial Desk
Spreadsheet Templates & Tools Editorial Team
How to Bill Patent Search Clients in a Spreadsheet
Invoice patent search clients by project with hours, flat fees, and expenses — track outstanding balances before the next search request lands.
By
SheetFor Editorial Desk
Spreadsheet Templates & Tools Editorial Team
How to Bill Permit Expediting Clients in a Spreadsheet
Invoice permit expediting clients by project — separate service fees from jurisdiction pass-through fees and track outstanding balances.
By
SheetFor Editorial Desk
Spreadsheet Templates & Tools Editorial Team
How to Bill Pest Control Service Agreements in a Spreadsheet
Track pest control plans, visit frequency, renewals, and recurring revenue — keep agreement billing aligned with every scheduled stop.
By
SheetFor Editorial Desk
Spreadsheet Templates & Tools Editorial Team
How to Bill Pool Service Clients in a Spreadsheet
Track pool service monthly fees, paid status, and outstanding balances — recurring route billing without pool service software.
By
SheetFor Editorial Desk
Spreadsheet Templates & Tools Editorial Team
How to Build a Content Calendar in Google Sheets (Editorial Pipeline)
Build a content calendar in Google Sheets that tracks every post from idea to live — one shared editorial pipeline without per-seat scheduling fees.
By
SheetFor Editorial Desk
Spreadsheet Templates & Tools Editorial Team
How to Build a Gantt Chart in Google Sheets (Without PM Software)
Turn a task list into a visual Gantt timeline in Google Sheets — start dates, owners, progress bars, and overdue flags without project management software.
By
SheetFor Editorial Desk
Spreadsheet Templates & Tools Editorial Team