All prompts
1446 prompts, 48 per page. Want to filter? Use search.
Prompts
-
Partial Text and Approximate Matching
Match names that are not exactly the same.
-
Formula Debugging Interview
Find why a formula returns the wrong answer.
-
Formula Explainer: Break It Down Step by Step
Understand a complicated formula you inherited.
-
LET and LAMBDA for Readable Formulas
Name intermediate values and build reusable functions.
-
Cross-Sheet Consolidation Formulas
Combine data from several sheets or files.
-
Financial Functions Walkthrough: PMT, NPV, IRR
Use finance formulas correctly with examples.
-
Statistical Functions for Beginners
Describe data with the right measures.
-
Inventory and Reorder Formulas
Calculate stock, reorder points, and order quantities.
-
Attendance and Schedule Formulas
Track hours, shifts, and absences.
-
Gradebook Formulas for Teachers
Calculate weighted grades and flag students.
-
Commission and Tiered Pricing Formulas
Calculate bonuses and bracketed rates correctly.
-
Currency and Unit Conversion Formulas
Convert reliably and keep rates auditable.
-
Regular Expression Formulas in Google Sheets
Extract and validate text patterns.
-
IMPORTRANGE and Data Import Setup
Pull data from other files safely.
-
KPI Dashboard Formulas
Compute the numbers that drive a dashboard.
-
Duplicate Detection and Removal Formulas
Find, flag, and handle repeated records.
-
Excel to Google Sheets Formula Translation Table
Move formulas between apps without surprises.
-
Array Formula Performance Review
Speed up slow workbooks.
-
Named Ranges and Structured References Setup
Make formulas readable and resilient.
-
Checks and Reconciliation Formulas
Build self-checking sheets.
-
Formula Test Case Builder
Create test data that proves a formula works.
-
Business Day and Holiday Calendar Formulas
Handle deadlines around weekends and holidays.
-
Spill and Dynamic Range Troubleshooting
Fix #SPILL! errors and unstable ranges.
-
Pivot Table Alternatives Using Formulas
Build live summaries without a pivot table.
-
Small Business Inventory Tracker
Track stock levels with reorder alerts.
-
Inventory Turnover and ABC Analysis
Classify products and compute turnover.
-
Equipment and Asset Register
Track assets, maintenance, and depreciation.
-
Recipe Costing and Menu Pricing Sheet
Compute plate cost and menu prices.
-
Warehouse and Stock Location Map
Organize locations and pick lists.
-
Supplier Scorecard and Purchase Order Tracker
Compare suppliers and manage orders.
-
Event Equipment and Rental Inventory Sheet
Track availability across bookings.
-
Personal or Family Home Inventory for Insurance
Document belongings and values.
-
Inventory Forecasting and Safety Stock Model
Forecast demand and set reorder levels.
-
Subscription Box or Recurring Order Tracker
Manage recurring customers, shipments, and stock.
-
Consumables and Supplies Usage Tracker
Know what you use and when to reorder.
-
Product Returns and Restocking Log
Track returns through inspection to resale or disposal.
-
Seasonal Inventory Planning Sheet
Plan stock for peaks and troughs.
-
Batch and Expiry Date Tracking Sheet
Manage perishable or batch-tracked stock.
-
Project Tracker With Status Dashboard
Build a task tracker with dashboard formulas.
-
Sprint Backlog and Velocity Tracker
Track agile work with velocity calculations.
-
Risk Register and Issue Log
Create a scored risk register.
-
Client Pipeline and CRM Sheet
Build a lightweight sales pipeline tracker.
-
Gantt Chart in a Spreadsheet
Visualize timelines with formulas.
-
Client Project Time Tracking and Billing
Track hours and generate invoices.
-
OKR and Goal Progress Tracker
Track objectives and key results across a team.
-
Content Production Pipeline Tracker
Track pieces from idea to publication.
-
Issue and Defect Tracker With Metrics
Track issues from report to resolution with trend charts.
-
Budget, Schedule and Scope Health Dashboard for a Project
Combine three key dimensions into a status view.