Excel prompts Page 5 of 7
Prompts
-
Accounts Payable and Cash Planning Tracker
Plan bill payments around cash availability.
-
Variance Analysis Template: Budget vs Actual vs Forecast
Track three versions of the numbers.
-
Subscription Revenue Metrics Tracker (MRR and Churn)
Track recurring revenue health.
-
Expense Report and Reimbursement Tracker
Standardize employee expense reporting.
-
Tax Estimate and Quarterly Set-Aside Planner
Plan tax payments with a simple model (not tax advice).
-
Loan Amortization Schedule in Excel or Google Sheets
Create a loan amortization schedule in a spreadsheet, with PMT, interest and principal columns, extra payments and a zero-balance check.
-
Mortgage Payoff Spreadsheet With Extra Payment Scenarios
Model extra mortgage payments in a spreadsheet and compare payoff dates and total interest across scenarios, with a clear comparison table.
-
Amortization Schedule Check: Find Errors in My Loan Sheet
Review your amortization spreadsheet for formula mistakes, rounding drift and rate errors, with a findings table and corrected formulas.
-
Restaurant Food Cost Percentage Formulas
Calculate plate cost, theoretical and actual food cost.
-
Payroll Hours and Overtime Calculations From Time Clock Exports
Turn raw punches into paid hours with transparent rules.
-
Rental Property Cash Flow Formulas
Model rent, costs and returns line by line.
-
Exam Item Analysis Formulas for Teachers
Find which questions were too easy, too hard or confusing.
-
League Standings and Tiebreaker Formulas
Rank teams automatically with clear tiebreak rules.
-
Strength Training Log Formulas
Track volume, estimated maximums and weekly progress.
-
Project Burn-Down and Remaining Work Formulas
Show progress and forecast completion from task data.
-
Subscription Revenue, Churn and Retention Formulas
Compute recurring revenue metrics from a customer list.
-
Shift Coverage Check Formulas
Highlight understaffed hours before the week starts.
-
Loan Amortisation Schedule Built by Formulas
Understand how payments split between interest and principal.
-
Wedding or Party Budget Tracker Formulas
Track estimates, deposits and balances with variance.
-
ABC Inventory Classification Formulas
Group items by value to focus attention.
-
Likert Survey Summary Formulas
Summarise rating questions clearly and reversibly.
-
Vehicle Mileage and Running Cost Formulas
Track fuel efficiency and cost per distance.
-
Recipe Scaling and Unit Conversion Formulas
Resize recipes without arithmetic mistakes.
-
Appointment Slot Availability Formulas
Show open slots from a booking list for a small salon or clinic.
-
Event Ticket Sales Tracking and Pace Formulas
Compare ticket sales with a target pace.
-
Donor Retention and Giving Analysis Formulas
Measure repeat giving from a donation list.
-
Lease Expiry and Rent Roll Alert Formulas
Flag leases and rent changes that need action.
-
Cohort Retention Table Formulas
Build a month-by-month retention triangle.
-
Keyword List Cleaning and Grouping Formulas
Prepare SEO keyword data for planning.
-
Ecommerce Margin After Fees and Shipping
Calculate real profit per product and order.
-
Time Zone Meeting Planner Formulas
Find overlapping working hours across locations.
-
Bank Statement Categorisation Rules by Formula
Categorise transactions consistently with an editable rules table.
-
Weighted Scoring Matrix for Decisions
Compare options transparently with editable weights.
-
XLOOKUP Formula Builder With Worked Examples
Write lookup formulas that survive real data.
-
INDEX MATCH Two-Way Lookup Builder
Build an INDEX MATCH two-way lookup in Excel or Google Sheets to find a value where a row and a column meet, with an explanation.
-
SUMIFS and COUNTIFS Multi-Criteria Formula Writer
Total and count by several conditions.
-
Dynamic Array Formulas: FILTER, SORT, UNIQUE
Replace manual filtering with live formulas.
-
Text Cleaning Formulas for Messy Data
Fix spaces, case, characters, and formats.
-
Splitting and Joining Text Formulas
Combine and separate fields reliably.
-
Date Calculation Formulas That Handle Real Cases
Compute ages, deadlines, and durations correctly.
-
Conditional Formatting Rule Writer
Highlight what matters with custom rules.
-
Data Validation and Dependent Dropdowns
Control inputs and chain dropdown lists.
-
IFERROR and Error-Proofing Formulas
Handle errors without hiding real problems.
-
Nested IF to IFS and SWITCH Simplifier
Rewrite tangled logic into readable formulas.
-
Running Totals and Moving Averages
Track cumulative values and trends.
-
Ranking and Percentile Formulas
Rank items fairly and handle ties.
-
Return All Matches Lookup Formulas
Pull every row that matches, not just the first.
-
Partial Text and Approximate Matching
Match names that are not exactly the same.