Excel prompts Page 6 of 7
Prompts
-
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.
-
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
Write business day and holiday calendar formulas, such as WORKDAY and NETWORKDAYS, to handle deadlines around weekends.
-
Spill and Dynamic Range Troubleshooting
Fix #SPILL! errors and unstable ranges.
-
Pivot Table Alternatives Using Formulas
Build live summaries without a pivot table using formulas such as SUMIFS, COUNTIFS and UNIQUE, with examples and edge cases.
-
XLOOKUP Instead of VLOOKUP: Convert My Formulas
Convert your VLOOKUP formulas to XLOOKUP in Excel or Google Sheets, with a before and after table and notes on missing values and ranges.
-
XLOOKUP Patterns Cheat Sheet With Real Examples
Build an XLOOKUP cheat sheet for your own data, covering two-way lookups, multiple criteria, wildcard search, and returning whole rows.
-
VLOOKUP to XLOOKUP Migration Audit Checklist for a Workbook
Plan a safe VLOOKUP to XLOOKUP migration across a workbook, with an inventory table, risk ratings, test steps and a roll-back plan.
-
Conditional Formatting by Formula: Highlight Rows That Match
Create conditional formatting formulas to highlight entire rows, overdue dates and duplicates, with rule setup steps for Excel or Google Sheets.
-
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
Build a personal or family home inventory for insurance, listing items, values, receipts and photos in one spreadsheet.
-
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 project tracker in a spreadsheet with a status dashboard, using formulas to summarise progress and overdue tasks.
-
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.