How to Use ChatGPT to Write Excel Formulas (With Real Examples)

Every Excel workshop I run, someone asks a version of the same question: "Sagnik, I know what result I need — I just don't know which formula to use." That's exactly the problem ChatGPT solves brilliantly. You describe what you want in plain English, and it hands you a formula ready to paste into your spreadsheet.

I've been running Excel and AI integration workshops for teams across India for several years now, and ChatGPT has become one of the most democratising tools I've seen land in the hands of non-technical professionals. It doesn't replace the need to understand Excel — but it dramatically lowers the barrier to doing sophisticated work. In this guide I'll walk you through exactly how to use it effectively, with real prompts, real formulas, and the honest limitations you need to know about.

Follow me on Instagram@sagnikteaches

Why ChatGPT Is a Surprisingly Capable Excel Assistant

ChatGPT has been trained on an enormous volume of technical documentation, Stack Overflow threads, forum discussions, and tutorial content — which means it has absorbed a vast working knowledge of Excel functions, their syntax, their quirks, and common patterns for combining them.

Connect on LinkedInSagnik Bhattacharya

What makes it particularly useful in practice is that it doesn't just regurgitate function signatures. It reasons about your specific problem. Give it context about your spreadsheet layout and it will adapt its answer to your column letters, your data types, and your intended output. Ask a follow-up question and it remembers what you told it earlier in the conversation.

Subscribe on YouTube@sagnikteaches

Here's what ChatGPT genuinely does well for Excel work:

• Formula generation from plain English — describe the outcome, get the formula
• Explaining formulas you inherited — paste in a formula someone else wrote and ask what it does
• Suggesting error handling — wrapping formulas in IFERROR, IFNA, and similar guards
• Writing VBA macros — even if you've never opened the Visual Basic editor
• Data cleaning strategies — step-by-step approaches to restructuring messy imports
• Building on your existing formula — paste what you have, explain what's broken, get a fix

It's not infallible, and I'll cover the pitfalls later. But as a starting point for complex work, it consistently impresses my workshop participants.

The Art of Prompting ChatGPT for Excel

The single biggest factor in getting a useful response from ChatGPT is the quality of your prompt. Vague questions produce vague answers. Specific, structured prompts produce formulas you can use immediately.

Here's the prompting framework I teach in my Excel AI sessions:

"I have an Excel spreadsheet where [describe your columns and what data they contain]. I need a formula in [target cell/column] that [describe exactly what result you want, including any conditions]. I'm using [Excel version or Microsoft 365]."

The version detail matters more than people realise. Functions like XLOOKUP, LET, and LAMBDA are only available in Microsoft 365 and Excel 2021+. If you're on Excel 2016 or 2019, ChatGPT needs to know that so it doesn't hand you a formula your version can't evaluate.

Here are a few prompting techniques that consistently yield better results:

• Paste a sample of your data — even 5 rows of dummy data gives ChatGPT the context it needs to write precise formulas with correct column references
• State what you've already tried — "I tried VLOOKUP but it only returns the first match" tells ChatGPT exactly where to steer you
• Ask for alternatives — follow up with "Can you give me a version that doesn't use an array formula?" or "Is there a simpler approach?"
• Request an explanation — always ask ChatGPT to explain the formula it gives you; this is how you build your own knowledge rather than staying dependent on it

Writing Complex Formulas with ChatGPT

Let's get into real examples. These are the kinds of formula requests that typically take professionals 15–30 minutes of Googling and trial-and-error — and ChatGPT handles them in seconds.

Multi-Condition Summing

Suppose you have a sales report: Column A is the sales rep's name, Column B is the product category, Column C is the region, and Column D is the revenue. You want to sum all revenue where the rep is "Priya" and the region is "West".

Prompt: "Sum all values in column D where column A equals 'Priya' and column C equals 'West'."

=SUMIFS(D:D, A:A, "Priya", C:C, "West")

ChatGPT will also note you can replace the hardcoded strings with cell references, making the formula dynamic — which is exactly what I'd push you toward in a workshop setting.

Extracting Text with Conditions

You have a column of email addresses and need to extract just the domain name (everything after the @ symbol).

Prompt: "Extract the domain from email addresses in column A — everything after the @ symbol."

=MID(A2, FIND("@", A2) + 1, LEN(A2) - FIND("@", A2))

On Microsoft 365, ChatGPT might offer the cleaner TEXTAFTER alternative:

=TEXTAFTER(A2, "@")

This is exactly why specifying your Excel version matters — you might be handed a more powerful function you didn't even know existed. For a full view of which lookup and text functions to use when, the VLOOKUP vs XLOOKUP comparison is worth reading alongside this.

Ranking with Ties Handled Correctly

Standard RANK breaks ties arbitrarily. Ask ChatGPT for a formula that assigns the same rank to tied values and skips the next rank number accordingly, and it will give you RANK.EQ — or walk you through a COUNTIF-based approach for older versions.

=RANK.EQ(B2, $B$2:$B$100, 0)

For a deeper exploration of the formulas that handle these kinds of nuanced professional requirements, see the 15 advanced Excel formulas guide.

Cleaning and Transforming Data with ChatGPT's Help

One of the most time-consuming parts of real-world Excel work isn't the analysis — it's getting the data into a usable shape first. ChatGPT is a genuinely excellent partner for this.

In my workshops, I regularly see data that arrives from legacy systems or third-party exports with problems like: leading and trailing spaces, inconsistent capitalisation, dates stored as text, numbers formatted as text, merged cells that break everything downstream, and columns that need splitting or combining.

For each of these, ChatGPT can generate both formula-based fixes and step-by-step instructions for using Excel's built-in tools like Text to Columns or Flash Fill. Some useful prompts:

• "Remove all leading and trailing spaces from column B and convert it to proper case."
• "Column C has dates stored as text in the format DD-MM-YYYY. Give me a formula to convert them to proper Excel dates."
• "Split a full name in column A into first name and last name in separate columns."
• "Column D has numbers formatted as text — some have commas as thousands separators. Convert them to numeric values."

For the dates-as-text problem, ChatGPT typically gives you something like:

=DATEVALUE(TEXT(A2,"DD-MM-YYYY"))

-- or, more directly for DD-MM-YYYY text strings:
=DATE(RIGHT(A2,4), MID(A2,4,2), LEFT(A2,2))

For a broader strategy on tackling messy imported data, the post on cleaning messy data in Excel fast pairs well with using ChatGPT as your formula generator.

Generating VBA Macros Without Knowing VBA

This is where ChatGPT genuinely levels the playing field. VBA — Excel's built-in automation language — has a steep syntax curve. Most professionals never learn it because the upfront investment feels too high relative to their day-to-day needs. ChatGPT removes that barrier almost entirely.

You describe what you want to automate in plain English, and ChatGPT writes the macro. You paste it into the Visual Basic Editor (Alt + F11, then Insert → Module) and run it. That's it.

Here's an example. Prompt: "Write a VBA macro that loops through all rows in Sheet1, and if the value in column C is less than zero, highlights that entire row in red."

Sub HighlightNegativeRows()
    Dim ws As Worksheet
    Dim lastRow As Long
    Dim i As Long

    Set ws = ThisWorkbook.Sheets("Sheet1")
    lastRow = ws.Cells(ws.Rows.Count, "C").End(xlUp).Row

    For i = 2 To lastRow
        If ws.Cells(i, 3).Value < 0 Then
            ws.Rows(i).Interior.Color = RGB(255, 0, 0)
        Else
            ws.Rows(i).Interior.ColorIndex = xlNone
        End If
    Next i
End Sub

ChatGPT will also explain what each section of the macro does, which is valuable if you need to modify it later or explain it to a colleague. A couple of practical tips for getting good macros out of ChatGPT:

• Always specify your sheet name and which columns or ranges are involved
• Mention whether the macro should run once or be triggered by an event (like opening the file or changing a cell)
• Ask ChatGPT to add error handling so the macro doesn't crash silently on unexpected data
• Test on a copy of your file first — macros that modify data can't be undone with Ctrl+Z

ChatGPT vs Claude vs Microsoft Copilot for Excel

Since my workshops often cover multiple AI tools, I get this comparison question constantly. Here's an honest summary based on my hands-on experience with all three:

My practical advice: if your organisation already has Microsoft 365 Business or Enterprise, Copilot's native integration means you don't have to copy-paste between a chat window and Excel. But for formula generation and macro writing outside of Excel — particularly when you're working on a complex problem and want back-and-forth conversation — ChatGPT and Claude are both outstanding. The right tool depends on your workflow, not a ranking.

Common Pitfalls and How to Avoid Them

I want to be upfront about where ChatGPT can let you down, because I've seen workshop participants run into these and lose confidence in the tool when a few simple habits would have prevented the issue.

1. Formula hallucinations — ChatGPT occasionally invents function names or syntax that doesn't exist in Excel. Always test every formula it gives you before putting it into production use. If you get a #NAME? error, paste the formula back and ask ChatGPT why it's failing.
2. Version mismatches — Functions like XLOOKUP, FILTER, UNIQUE, LET, and LAMBDA are not available in Excel 2016 or 2019. If you don't specify your version, ChatGPT may default to Microsoft 365 syntax. Always state your version upfront.
3. Array formula handling — In older Excel versions, some formulas need to be entered with Ctrl+Shift+Enter to work as array formulas. ChatGPT usually mentions this, but if a formula returns a wrong result, ask specifically: "Does this need to be entered as an array formula?"
4. Regional separator settings — If your Excel uses semicolons instead of commas as argument separators (common in European and some Asian locale settings), tell ChatGPT: "I use semicolons as separators in my Excel." It will adjust accordingly.
5. Blind trust in macros — Always read through a macro before running it, even briefly. ChatGPT-generated macros are generally safe but occasionally contain logic errors, particularly around range assumptions. Test on a copy of your file.
6. Not asking follow-up questions — The biggest waste I see is people taking the first response and walking away. ChatGPT works best as a conversation. Ask it to simplify the formula. Ask it to explain what each argument does. Ask it to handle blank cells. This iterative approach is where the real value is.

Putting It All Together

ChatGPT won't replace knowing Excel — and I'd argue you shouldn't want it to. Understanding why a formula works makes you faster, more adaptable, and more capable when AI tools aren't available or give you a wrong answer. What ChatGPT does is collapse the time between "I know what I need" and "I have a formula that does it."

The professionals I see getting the most value from it are those who use it as a thinking partner: they describe their problem clearly, ask for the formula, ask ChatGPT to explain it, then deliberately try to understand the logic. After a few months of working this way, they've absorbed a working knowledge of functions they'd never have bothered to learn from scratch.

Start simple. Take the formula you hate most — the one you Google every single time — and ask ChatGPT to write it for you and explain it. Build from there. Within a few sessions, you'll have a workflow that makes you meaningfully faster at everything Excel-related.

Related Posts

• How to Use Google Gemini for Excel Formulas and Data
• How to Use Claude AI to Write Excel Formulas Instantly
• Using Claude AI to Generate Excel Macros and VBA
• Excel Copilot for Data Analysis — A Practical Guide
• 60 AI Prompts for Excel That Actually Work (Copy, Paste, Get Results)
• How to Compare Supplier Quotes Side by Side With AI
• How Small Shops Can Use AI to Forecast Stock and Reorder
• AI Menu Engineering: Which Dishes to Promote, Reprice or Drop
• Using AI to Spot Remortgage Opportunities in Your Client Bank
• ChatGPT Prompts for Small Business Owners: 50 Tested Examples — Fifty copy-ready ChatGPT prompts grouped by job, each with what it returns and how to adapt it, plus sample outputs showing the edits they need.
• AI Food Insights Tool: Toast IQ, Square AI or a Spreadsheet? — Compare Toast IQ, Square AI and a spreadsheet with ChatGPT using the same four sales questions, with a scoring sheet and a way to check every answer.
• Channel Manager for a Small Hotel: Cost and What AI Adds — Price a channel manager three ways, work out the break-even for a 12-room hotel and test whether the AI extras are worth paying for.
• How to Price Catering: A Cost-per-Person Sheet With AI — Build a catering cost-per-person sheet with AI: food, labour, equipment hire, overhead and margin, with a full 60-guest worked example and prompts to check it.
• AI Courier Quotes: Reply to Delivery Enquiries From Your Rate Card — A rate-card prompt, surcharge rules and an approval step that turn courier enquiries into quote replies you check before sending.
• AI for Butchers: Christmas Pre-Orders, Cut Lists and Pick-Up Slots — Set weight bands, cap pick-up slots, turn an order export into a cut list and send confirmations with AI, while allergen and label checks stay with you.
• Auto Repair Price Estimate Template: Build One With ChatGPT — ChatGPT writes the layout and formulas; your sheet does the sums and checks them a second way, with plain-English repair lines and per-repair customer approval.
• Bakery Pricing Calculator: Build One With ChatGPT and a Spreadsheet — Four spreadsheet tabs, ChatGPT-written formulas and one loaf worked through, from ingredient and labour costs to wholesale versus retail margins.
• Car Wash Pricing Strategy: Can AI Set Your Tiers and Memberships? — Cost per wash, a three-tier ladder, a membership break-even sheet and price tests, with AI building the sheets and you keeping the final say on every price.
• ChatGPT Prompts for Coffee Shop Owners: 10 for Menus, Posts, Rotas — Ten ChatGPT prompts for a coffee shop, from cost per cup to rotas and posts, each with example inputs and a check before you use it.
• ChatGPT Prompts for Restaurants: 10 for Menus, Rotas and Replies — Ten prompts for menus, rotas and customer replies, with inputs, worked outputs and the checks that catch a wrong total, label or promise.
• Cloud Kitchen Margins per Brand: Costing After Delivery Commission — Cost each virtual brand line by line after platform commission, packaging, promotions and refunds, and see which brand really earns its place in the kitchen.
• Coffee Cart Business Plan: Costs, Pitch and Menu Built With ChatGPT — Plan start-up costs, pitch fees, per-cup margins and break-even cups for a coffee cart in one spreadsheet, with ChatGPT drafting and you checking.
• Food Truck Food Cost: Use ChatGPT Before Paying for Software — A ChatGPT-built food cost sheet for a food truck, one burger costed to the cent, and the break-even sum for paid costing software.
• Food Truck Pricing: Set Menu Prices After Fees, Fuel and Pitch Costs — One Saturday market worked through with numbers: overhead per service day, cost per portion and the menu prices that clear a 12% margin.
• Gym Business Plan: Build the Numbers a Lender Will Ask For With AI — What a lender wants from a gym's financial section: a worked model, stress tests and prompts that make AI build and then attack your own numbers.
• Hair Salon Business Plan: Chairs, Prices and Cash Flow With AI — Plan a salon from your own numbers: employed or rented chairs, a price list tested per chair-hour, break-even and a 12-month cash flow checked line by line.
• Hotel Breakfast Food Waste: Predict Buffet Demand With AI — A worked breakfast-covers forecast from occupancy, with an accuracy test, buffet replenishment rules and a five-minute waste log for a small hotel.
• Hotel Guest Feedback: Turn Post-Stay Surveys Into Fixes With AI — How a hotel can turn a month of post-stay survey comments into a ranked fix list with AI labelling, spreadsheet counts and named owners.
• How Much Should a Personal Trainer Charge? Model Session Packs With AI — A cost-based rate for solo trainers: the hourly maths, what a pack discount really costs, no-show losses, and a spreadsheet built with ChatGPT.
• How Much to Charge for Yoga Classes: Drop-In, Packs and Memberships — A worked model of drop-in, pack and membership prices: cost per class, break-even students, pack breakage and a spreadsheet built with ChatGPT.
• Mini Golf Business Software: Party Bookings and Season Passes — What mini golf software must do on a busy Saturday, with party and season-pass sums worked through, a rain rebooking rule, and where AI helps with the emails.
• How to Use ChatGPT for Market Research on Your Local Customers — A one-week method for local owners: mine competitor reviews, build personas from your records, run demand checks and log every claim ChatGPT makes.
• Pizza Shop Inventory: Plan Dough and Toppings From Weekend Orders — Turn eight weeks of orders into dough balls, cheese and topping quantities for Friday to Sunday, then tune the plan from a simple waste log.
• Recipe Costing Spreadsheet for Restaurants: Build It With ChatGPT — Five tabs, one salmon dish costed line by line, and a ten-minute weekly step that updates every plate cost when an invoice changes.
• Retail Staff Scheduling: Build a Rota From Hourly Till Sales With AI — A single-shop method: export timestamped sales, average them by weekday hour, set heads per hour, draft the rota with AI and check it.
• Salon Commission or Booth Rent? Model Both on Your Numbers With AI — Work out the break-even rent for a salon chair at three occupancy levels, build the sheet with ChatGPT and check employment status first.
• Salon Pricing Calculator: Build One With AI From Your Real Costs — Cost per chair minute, product cost per colour and a margin target, built into a ChatGPT-made spreadsheet you can check line by line.
• Tyre Stock Excel Sheet: Track Sizes and Reorder Points With AI — A tested tyre stock sheet: size-and-brand matrix, reorder-point formulas, seasonal demand, slow-mover and DOT-age flags, plus three jobs for AI.
• Yoga Retreat Business Plan: Budget, Pricing and Break-Even With AI — A worked 12-guest retreat budget: break-even formula, a ChatGPT spreadsheet prompt, a cash timeline and a refund schedule that mirrors your venue's terms.
• Party Supply Store Marketing Ideas: Seasonal Bundles With AI — Eight seasonal peaks, bundles built from whole packs for 8, 12 and 20 guests, margin sums and a countdown of posts that ChatGPT drafts from your sheet.
• AI for Golf Course Management: Can It Plan Staffing Around Weather? — Export past rounds, add the weather, and let ChatGPT or Gemini turn each forecast into a weekly staffing sheet for the pro shop, starter, bar and range.
• Are Ghost Kitchens Still Worth It? A Cash-Flow Test You Run With AI — Break-even orders per day, a six-month cash ramp and a sensitivity table for a ghost kitchen, plus prompts that pull your own rates from payout statements.
• Can AI Help a Convenience Store Drive Sales? Where to Start — A convenience store owner's guide to AI sales tests: find high-margin lines in your till export, run one bundle test first, and read the result honestly.
• Supermarket Pricing Strategy: Can AI Help Test Price Changes? — How a small supermarket tests price changes with a spreadsheet and AI: item roles, a shelf survey, a margin check, a noise check and a decision rule.
• Florist Pricing Formula for Bouquets and Arrangements, Built With AI — One bouquet priced line by line: stems, waste allowance, labour, overhead and profit, plus the prompt that gets AI to build the formula sheet from your costs.
• Angi Leads for Plumbers and HVAC: Worked Cost per Job and AI Follow-Up — Cost per won job and break-even win rate worked through for plumbing and HVAC leads, plus an AI follow-up routine and a dispute file.
• Blinds Quoting Software: Measure-and-Quote Tools and What AI Adds — Five blinds quoting tools compared on price lists, on-site measuring and cost, plus what their AI really does and a 20-cell audit to run before you trust it.
• CIS Monthly Return: Software, Accountant or an AI-Built Sheet? — What you need to file a CIS monthly return, the April 2026 nil-return change, and how software, an accountant and an AI-built sheet compare.
• Cabinet Shop Software: Quotes, Cut Lists and Orders, and What AI Adds — Cabinet shop software for five people or fewer: published prices, quote-to-order flow, hardware ordering, scheduling and a spreadsheet-plus-ChatGPT baseline.
• Cutting List Software vs AI: Which Gives a Carpenter a Reliable Cut List? — Use a panel optimiser for the layout and AI for the parts list. Test both on one finished job with area, count and grain checks.
• HVAC Lead Generation: AI Call Tags Show Which Sources Book Replacements — Tag calls with AI, follow each booked job to its outcome, and compare replacement sales by source, with a worked quarter across four HVAC lead sources.
• How Much Does Estimating Software Cost? Price Bands With and Without AI — Price bands for a small contractor's estimating software, what AI adds plan by plan, and the break-even hours that justify the spend.
• Heating Oil Delivery Software: Route Winter Top-Ups With AI Help — A demo checklist for heating oil delivery software: tank-level estimates, run-out priority, route order and truck load, with worked sums and AI uses that fit.
• Remodelling AI Estimator: Test It Against Your Own Past Jobs — A three-job test that compares an AI estimator, your spreadsheet and ChatGPT with final costs, plus the break-even on a $119 plan.
• CIS Deduction Statement Template: Fill It From Your Payment Sheet With AI — The fields, the 14-day deadline and a payment-sheet method for a CIS deduction statement per subcontractor each month, with AI doing the checking.
• Bill of Quantities Template: A Worked Example Checked With AI — A worked bill of quantities with Excel check formulas and AI prompts for codes, descriptions, units and totals, with measurement left to the QS.
• Cabinet Shop Drawings With AI: Box Sizes, Reveals and Hardware Checks — A pre-cut routine for AI-drafted cabinet drawings: box widths from the site measure, a gap budget for reveals, and hardware clearances read from data sheets.
• ChatGPT for Construction Estimating: Check a Quote, Do Not Write It — A worked check of a small extension quote: arithmetic, scope gaps and omissions found with ChatGPT, every change left to the estimator.
• ChatGPT for Interior Designers: Ten Prompts for Briefs and Schedules — Ten placeholder-based ChatGPT prompts for an interior designer's briefs, product schedules and client updates, plus the checks that keep prices right.
• Construction Cash Flow Forecast: Build One in a Spreadsheet With AI — A 12-week builder's cash flow forecast with stage payments, supplier terms and retention, built from a ledger and checked with Copilot or ChatGPT.
• FF&E Schedule for Interior Designers: Build and Check It With AI — Build and check an interior design FF&E schedule with AI: the columns that matter, a totals audit, price checks against suppliers and a change log.
• Flooring Quote Template: Area, Waste and Underlay Lines Written With AI — A worked 40 square metre quote: area, waste, underlay, thresholds, subfloor exclusions and a moisture-test condition, with AI drafting the wording.
• Handyman Material Markup: Build a Cost-Plus Calculator With AI — A worked cost-plus calculator for handymen: a sliding markup rule, shopping-time charge and small-item allowance, built with ChatGPT or Copilot in Excel.
• How to Bid Concrete Jobs: Quantities, Pump Costs and AI Checks — A concrete bid built line by line: volume, waste, pump, labour, finishing and washout, with AI prompts that recheck your arithmetic and catch missing lines.
• How to Price Drywall Jobs: Per-Sheet and Per-Square-Foot Rates With AI — One basement priced three ways, with finish levels, ceilings and repair pricing, plus an AI back-test of your per-sheet rate against six past jobs.
• How to Price Electrical Jobs: Build a Guide From Your Past Jobs With AI — A seven-task price guide built from nine months of invoices, with a minimum charge, a three-job test and a quarterly refresh routine.
• How to Price Interior Design Services: Compare Fee Models With AI — One three-room project priced hourly, fixed-fee and cost-plus, with margin checks, stress tests and client wording for each model.
• Insulation Quote Template: Material, Thickness and Area Lines With AI — A line-item insulation quote with thickness, area and exclusion wording, plus a prompt that flags missing measurements instead of inventing them.
• Interior Design Project Timeline: Draft Phases and Lead Times With AI — Draft an interior design timeline backwards from the install date, using supplier lead times from your own records, client decision dates and a buffer.
• Joinery AI: Build a Cutting List and Material Order From a Drawing — Extract every part from a joinery drawing into a sheet, audit it against the drawing, add waste by material and turn the totals into a supplier order.
• Kitchen Remodel Estimate Template: Line Items Written With ChatGPT — A kitchen remodel estimate by phase, a two-pass ChatGPT prompt that finds forgotten lines, and a worked estimate with allowances, contingency and totals.
• Markup vs Margin in Construction: A Pricing Sheet Built With AI — Why a 20% margin needs a 25% markup, how overhead fits in, and a pricing sheet built with ChatGPT or Excel Copilot, with tests for the usual formula error.
• Pay Applications for Subcontractors: Schedule of Values With AI — Build the schedule of values, report percent complete, add stored materials and retainage, then use AI to check the package against the contract.
• Price Carpet Cleaning Jobs: Build a Per-Room Calculator With AI — Build a carpet cleaning calculator from your own costs: per-room prices, a minimum charge, add-ons and a margin check, with the spreadsheet formulas.
• Price House Cleaning Jobs: Build a Calculator With ChatGPT — One cost engine, three quote styles: hourly, per-room and flat-rate house cleaning prices, with first-visit uplift, deep cleans and a margin check.
• Solar Panel Cleaning Business: Quote and Route Jobs With AI — A worked pricing sum by panel count and access class, plus where AI helps with quotes, route clustering and recurring-plan reminders.
• Roofing Takeoff With AI: Squares, Waste and Bundles From a Report — A worked 3,240 sq ft example takes report fields to squares, waste and bundles, with four checks before the supplier order.
• Van Stock Management for HVAC and Electrical Vans: Reorder Levels With AI — Set min-max van stock levels for HVAC and electrical vans from your own job history, then run a weekly top-up list and shrinkage check with AI.
• Use of AI in Quantity Surveying: Comparing Subcontractor Quotes — A worked tender comparison for quantity surveyors: five subcontractor returns on one schedule, with omissions, qualifications and price gaps found using AI.
• Can AI Do Construction Bid Levelling? What It Catches and Misses — Put subcontractor quotes into one scope matrix with ChatGPT or Claude, see which exclusions it flags, and what you must still check against the drawings.
• Construction WIP Report: What It Shows and How AI Builds One — What a work-in-progress schedule shows, a three-job worked example of over and under billing, and where AI helps and where it must not.
• Earthworks Estimating: Can AI Calculate Cut and Fill Volumes? — Build a cut and fill sheet with end-area volumes and swell factors, see where AI goes wrong, and check the answer by hand.
• Labour Burden Rate: What Each Employee Really Costs a Trades Firm — Build a labour burden rate per employee from your payroll, with two worked trades examples and the unbillable hours most firms forget.
• Material Price Escalation Clause: What AI Can and Cannot Check — Use AI to summarise an escalation clause and list its triggers, then take a short confirm-list to your solicitor.
• Pay When Paid Clause: A Subcontractor's Check Before Signing — A subcontractor's pre-signing checklist for pay-when-paid clauses, with a cash-flow example and a sample clause review.
• AI Property Development Feasibility: A First-Pass Appraisal — A worked first-pass appraisal for a small developer: inputs, GDV, costs, sensitivity and planning risks, with AI as challenger and a spreadsheet as calculator.
• AI Commercial Real Estate Underwriting: A First-Pass Model — A worked six-suite example: clean the rent roll, reconcile the operating statement, model NOI and challenge the assumptions with AI.
• AI Loan Processing: Catch Missing Documents Before Underwriting — A small-brokerage routine: classify each file's documents, test them against a loan-type checklist, run stale-date formulas and have a processor sign off.
• AI Real Estate Cold Calling: Scripts, Lists and Do-Not-Call Rules — How a real estate agent can use AI for scripts, objection replies and list prep, with the do-not-call checks that stay with a person.
• AI Salary Benchmarking for HR Consultants: Sources, Bands and Checks — A repeatable method for turning survey and job-advert data into pay bands with AI, plus the checks that catch invented figures.
• Freelance Day Rate Calculator: Set Your Rate When AI Speeds Up Delivery — A step-by-step freelance day rate calculation in USD, with billable days, overheads, AI tool costs and four ways to price when AI speeds up delivery.
• AI Tools for Quantity Surveying: Take-Offs, Cost Plans and Checks — A checking-first method for AI take-offs and cost plans: scale calibration, hand samples, Excel BoQ tests and verified vendor pricing.
• AI for Fractional CFOs: Monthly KPI Packs and Client Briefings — How a fractional CFO can run monthly KPI packs for several clients with AI: client templates, export-based data, narrative drafts and a review checklist.
• AI in the Consulting Industry: Package a Fixed-Scope Diagnostic to Sell — Walk through packaging a consultancy's method into a fixed-scope, AI-assisted diagnostic: scope, intake, analysis, review hours and price.
• AI to Find Investment Properties: Searches, Filters and Sanity Checks — Use AI to turn buying criteria into searches and a shortlist table, then run red-flag and arithmetic checks before you book a single viewing.
• Automated Payroll Cost Report: Build a Monthly Summary With AI — Export, redact, summarise and check: a monthly payroll cost report the owner reads in two minutes, with variance flags and a tie-out to the payroll journal.
• Business Broker NDA Process: Qualify Buyers With AI Screening — A four-gate buyer process for brokers: screening questionnaire, NDA step, proof-of-funds checklist and a scorecard, with AI drafting and people deciding.
• ChatGPT Prompts for Financial Advisers: Follow-Ups and Review Prep — Admin and communication prompts for advisers, written around confidentiality: placeholders, no client data, and a compliance check before sending.
• ChatGPT for Accounting With Excel: Seven Tasks, Each With Its Check — Seven Excel accounting tasks for ChatGPT, each with a worked example and the check that proves the answer before you rely on it.
• ChatGPT for Commercial Real Estate: Source-Checked Reports and Comps — A commercial broker's method for ChatGPT market reports, comps summaries and owner emails, with a check on every figure before it reaches a client.
• Credit Repair Software With AI: Dispute Letters and Client Tracking — How a credit repair business can draft dispute letters and track every client case with AI, with the legal limits and a review step on each letter.
• Fake Bank Statements on Rental Applications: A Checklist to Spot AI Fakes — A landlord's checklist for catching AI-made payslips and bank statements: internal consistency, source checks, and why no detector should decide alone.
• AI Tools for Investment Managers: Client Reports and Fact Sheets — How a small investment manager can draft quarterly reports and fact sheets with AI while the numbers stay locked and compliance gets a reviewable packet.
• AI for Tax Advisory: Drafting Client Advice Memos Safely — A memo workflow for tax advisers: anonymise the facts, draft with AI, verify every authority against primary sources, then partner sign-off.
• AI for UK Payroll: RTI, Auto-Enrolment and Holiday Pay Checks — Use AI to spot anomalies before an RTI submission and look up holiday-pay and auto-enrolment rules; keep calculations and filing in payroll software.
• AI for UK Tax Advisers: Research Notes, Client Letters and Checks — Set a safe-use line for each kind of output a UK tax adviser produces: research notes, client letters and computations, with the checks each needs.
• Consulting Utilisation Rate: Track It Weekly and Price Projects With AI — Billable versus available hours, bench time, a weekly AI roll-up from timesheets and a worked project price checked against your rate card.
• HR Analytics and AI: Analyse Staff Turnover From a Spreadsheet Export — A privacy-first spreadsheet method for checking turnover and absence, with a worked rate and practical prompts.
• WIP Report Template for Service Firms: Build One From Timesheets — A WIP report for a service firm built from a timesheet export: ageing buckets, write-offs, roll-forward and lock-up days, with sample figures.
• SEO Services AI: Drafting Monthly Client Reports With ChatGPT or Claude — A monthly report workflow for agency owners: exports in, a verified facts table, plain-English commentary out, and a number check before the client sees it.
• Using AI for Appraisal Work: Comps Prep and Draft Report Checks — Two safe AI jobs for appraisers, preparing comp data and checking a draft, with prompts, sample outputs and a clear line AI never crosses.
• Using AI for HR: Probation, Renewal and Right-to-Work Deadline Checklist — Build one tracker sheet for several client firms, add reminder lead times, and let AI draft the nudges while a person makes every decision.
• Can AI Help Accountants? What It Handles and What You Review — A small-practice split of accounting jobs into AI-reliable, AI-then-review and accountant-only, with a named reviewer and sign-off for each.
• Can AI Read Loss Runs? Carrier PDFs to Remarketing Summaries — Turn carrier loss-run PDFs into a frequency and severity table and a remarketing summary, with the checks that stop wrong totals reaching an underwriter.
• Can AI Select an Audit Sample? Document and Defend It — A small-practice method for AI-assisted audit sampling: a reproducible selection in Excel or Python and the documentation wording a reviewer can test.
• ChatGPT for Property Investment: Can It Calculate Yield Reliably? — A worked yield and cash-flow example with the sums, the arithmetic slips ChatGPT makes, and the spreadsheet formulas that check each one.
• Learning to Use AI for Business: A Four-Week Plan for Owners — A week-by-week plan built around your own tasks: one tool, one workflow and one measure each week, in about 20 minutes a day.
• AI for Physiotherapists: Employer and Workplace Contract Proposals — Write a workplace physio proposal with AI: scope, pricing tiers, reporting and confidentiality, shown with a 40-employee worked example.
• Care Home Rota Template: Cover, Skill Mix and Gap Checks Using AI — A rota sheet with cover rules and a skill-mix check, plus AI prompts that find gaps and draft messages. The manager decides; nothing changes automatically.
• AI Tools for Learning and Development: A Small-Company Shortlist — A job-by-job shortlist for whoever runs training in a small firm: skills matrix, training plan, onboarding and checks, using tools you may already have.
• AI Tools for Nurses Who Run a Team: Rotas, Handover and Audits — A nurse manager's guide to AI for rotas, handover templates and audit write-ups, with a clear list of what must never go into a prompt.
• How Much to Charge for Tutoring: Set Rates and Packages With AI — Work out an hourly tutoring rate from your income target and local listings, then test block-booking packages and a price-rise email with AI.
• Physical Therapy Prior Authorisation: Track Visits With AI — A draft-and-track workflow for PT prior authorisation: a request template, a visit tracker with expiry alerts, and clinician sign-off before anything is sent.
• Associate Dentist Contract Checklist for Practice Owners: AI First Pass — A clause-by-clause checklist for practice owners: pay basis, lab fees, notice and covenants, with an AI first-pass prompt before the solicitor.
• How to Use AI in Business Training: Quizzes That Show What Stuck — Build quizzes from your own course material, analyse feedback forms, and run a two-week retention check, with a worked example of twelve learners.
• How to Use ChatGPT for Data Analysis in a Clinic: No-Show Rates — Strip names, dates of birth and phone numbers, then ask ChatGPT for no-show rates by day, slot and lead time, and check the totals by hand.
• NDIS Invoicing: Checking Claims Against Shift Notes With AI — A pre-claim check: match hours and line items to shift notes, flag the mismatches, and have a person approve, never adjusting to maximise a claim.
• Nurse Licence Verification: A Tracker for Small Care Providers — A simple tracker for nurse registration checks and renewal dates, with alerts, an audit trail and clear limits on what AI should do.
• Ofsted Supported Accommodation: Registration Prep Checklist With AI — A document-by-document prep checklist for registering supported accommodation with Ofsted, with the drafting jobs AI can speed up and what it must not touch.
• School Parent Survey: Can AI Summarise Hundreds of Comments? — Design the survey, strip names, let a chat assistant sort 400 comments into themes, spot-check against the raw text and report to governors.
• Urgent Care Staffing: Forecast Volume and Build Rotas With AI — Turn a year of visit counts into an hourly volume forecast and a draft rota, with the manager's checks that keep it safe.
• Using AI for Medical Billing: Spot Missed Charges From Visit Notes — A weekly reconciliation that finds delivered-but-unbilled services, with the spreadsheet step, the AI step and the owner's review.
• Veterinary Inventory Management: Reorder Points and Expiry Checks With AI — Turn a practice-system stock export into reorder points, an expiry traffic-light and a monthly usage report, with AI building the sheet and staff in control.
• AI for Nursing Homes: What a Small Facility Can Run Without IT Staff — The office jobs a small nursing home can hand to AI with no IT department, which tools suit, and the privacy and vendor questions to settle first.
• Can Psychologists Use AI Beyond Session Notes? Seven Admin Jobs — Seven practice-admin jobs for a psychologist's AI, none touching clinical content, from referrer replies to billing checks and website text.
• ChatGPT for Veterinarians: Admin Uses, Plans and Client-Data Limits — Practice-admin jobs ChatGPT handles well for vet owners and managers, which plan to pick, and what client data stays out.
• Child Care Subsidy Billing: Can AI Match Payments to Attendance? — How a daycare can match subsidy remittances to attendance with AI-built formulas, find shortfalls and write top-up notices without names.
• How Can AI Help an Occupational Therapy Practice? Seven Admin Jobs — Seven admin jobs for an occupational therapy practice, from report drafts to billing checks, with clinical judgement left with the therapist.
• ChatGPT for Chiropractors: What Is Safe Without a BAA? — A clear line for chiropractic clinics: which ChatGPT jobs are safe with no BAA, which involve PHI, and what a HIPAA-ready route looks like.
• Amazon FBA vs FBM Cost: Model Your Own Products With AI — A per-unit spreadsheet model for FBA versus FBM, built with ChatGPT or Claude, with two worked products and the break-even sums.
• Are Etsy Ads Worth It for a Small Shop? Judge Them on Your Stats — Judge Etsy Ads on your own numbers: break-even return per listing, pause thresholds and a daily budget, with ChatGPT or Claude doing the sums.
• Fuel Surcharge Calculator: Set a Weekly Rate for Haulage Quotes — A weekly fuel surcharge policy for haulage and courier quotes: base price, fuel share, step table, spreadsheet formulas and customer clause wording.
• 3PL Billing: AI Reconciles Storage and Pick Fees Against WMS Data — How a small 3PL checks every storage and pick charge against its WMS export before invoicing, and what to do when a client disputes one.
• Best AI Tool for Pricing Wholesale Goods: Chat Assistant or App? — Chat assistant plus a sheet, an inventory-system price list, or pricing software: the right pick depends mostly on how many SKUs you carry.
• Cost per Drop: Work Out Delivery Cost From Route and Fuel Data — A step-by-step cost-per-drop calculation from your own route, fuel and driver-time exports, with a worked van example.
• Cost per Mile for Trucking: Work It Out From Your Own Statements — Build a true cost per mile from your own statements, split into fixed and variable, with a worked one-truck example and AI statement-reading prompts.
• Subscription Box Pricing: Build a Margin Model With AI — A worked margin model for a subscription box: product, packaging, postage, fees, churn and discounts, ending in a break-even subscriber count.
• Triple Whale Moby: Is an AI Analyst Worth It for a Small Brand? — A worth-it test for Triple Whale's Moby: what the plans include, how pricing works, how exports and ChatGPT compare, and a spend threshold.
• AI Tools for Business Analysis: 6 Questions to Ask Your Sales Spreadsheet — Six questions for your sales sheet: top customers, margin, slow movers, seasonality, churn and price changes, each with a check.
• AI Tools for Dairy Farming: Analyse Milk and DHI Records in ChatGPT — Load DHI test-day and bulk tank records into ChatGPT, get a ranked list of cows and trends to check, and learn what your vet must confirm.
• AI Tools for Operations Management: Weekly Exceptions Report From Exports — A worked example with three exports, a review prompt, a sample exceptions list and the checks that catch a wrong join before it misleads you.
• AI for Freight Business Analytics: Margin by Lane From a Spreadsheet — A 200-shipment example shows how to find thin lanes without trusting an unchecked chatbot total.
• Amazon Business Reports: A Weekly Review in ChatGPT or Claude — Download two Business Reports CSVs, run one prompt, check the totals, and decide what to change, in about 30 minutes a week.
• ChatGPT for Startup Analytics: Read Your Metrics Without an Analyst — A founder's Monday routine: export the numbers, strip customer data, have ChatGPT explain what moved, and re-check every figure in a spreadsheet.
• Cycle Count Template: AI Plans Counts by ABC Class — Rank stock into A, B and C classes, set how often each is counted, fix the variance thresholds and let AI produce the weekly count sheet.
• Dairy Farm Budget: Test Milk Price Scenarios With ChatGPT — A per-cow dairy budget with a what-if table for milk price, and a comparison of a full herd against a smaller, lower-labour one.
• Demurrage and Detention: AI Tracks Free Days and Drafts Disputes — A free-day tracker, an evidence checklist and AI-drafted dispute letters for forwarders who are tired of paying demurrage and detention bills unchallenged.
• Ecommerce Fraud Detection for Small Stores: A Review Queue With AI — A points-based review queue for small stores: which signals to score, how to hold and verify, and how to log chargebacks.
• Engineering Change Order Template: Track BOM Changes With AI — A filled-in ECO template, a spreadsheet-plus-AI check of old and new BOMs, and a cut-in rule for stock already on the shelf.
• Etsy Shop Stats With ChatGPT: Best Sellers and Dead Listings — Turn an Etsy stats export into a ranked list: which listings to protect, which to rewrite and which to retire, with rules you can check.
• FOB Price Calculation: An AI-Built Costing Sheet for Exporters — A worked FOB costing sheet for 2,000 units, with margin maths, a currency sensitivity table and prompts that build the spreadsheet for you.
• Free Shipping Threshold: Set It From Your Average Order Value — A worked order-export example: find your average order value, price the shipping you give away, and test two thresholds with ChatGPT or Claude.
• Freight Invoice Audit: AI Checks Carrier Bills Against Quotes — Turn a carrier quote and invoice into two tables, let AI list every difference, sort the accessorial charges and send the dispute from a weekly routine.
• Grain Marketing Plan: Build and Review One With AI — Fill in a standard grain marketing plan, then use AI as a reviewer: arithmetic, storage cost, contract mix, a scenario table and questions for your adviser.
• How AI Can Help Farmers Save Water: Build an Irrigation Log — A spreadsheet irrigation log fed by free weather data, with ChatGPT drafting the weekly schedule and you checking it against local crop advice.
• Kickstarter Campaign Page: Draft the Story and Reward Tiers With AI — Draft the story and video script with AI, then price each reward tier so fees and shipping don't eat the margin.
• Landed Cost Calculator in Excel: Test Tariff Changes With AI — One worked importer example: build the sheet, then test a duty rise and see the price you need to hold your margin.
• Wholesale Nursery Availability List: AI Builds and Emails It Weekly — A weekly routine that turns a grower's stock sheet into a priced availability list, emails it to trade buyers and marks lines as sold.
• OEE Calculator in a Spreadsheet: AI Sorts Downtime From Notes — A spreadsheet OEE calculator with a worked shift, plus a prompt that sorts messy operator notes into downtime categories.
• Operator Licence Compliance: AI Tracks Checks, Audits and Renewals — A diary-and-sheet system for safety inspections, driver checks, maintenance records and change notifications, with AI prompts that keep it current.
• SSCC Pallet Labels: Check Label Data Against the ASN With AI — Reconcile the SSCC list your label software printed against the ASN you sent, so a retailer's dock scanner never finds a mismatch.
• Skincare Replenishment Emails: Time Refill Reminders From Orders — Work out when each skincare product runs out from pack size and order history, then build a tested refill-reminder flow in Klaviyo.
• Snack Business Plan: Unit Costs, Margins and Co-Packer Quotes With AI — Build a packaged-snack unit-cost model, work backwards from the shelf price, and compare two co-packer quotes side by side in one sheet.
• Vendor Rebate Management for Distributors: Can AI Track the Claims? — Turn supplier rebate agreements into a tracker of tiers, deadlines and expected payouts, with AI doing the reading and you doing the checking.
• WIP Tracking for a Job Shop: A Spreadsheet With AI Status Updates — A two-tab spreadsheet for jobs and operations, the formulas that flag late work, and prompts that draft customer updates from the daily export.
• CSA Farm Shares: Sign-Ups, Pickup Reminders and Swaps With AI — From sign-up form to members sheet to weekly pickup reminders, with box notes and skip-week rules that an AI assistant can draft.
• ABC Analysis for a Distributor: Rank SKUs and Customers With AI — Rank a distributor's SKUs and customers into A, B and C classes in a sheet, then attach a service rule to each class.
• Can AI Run a Vending Machine Business? Restocks Yes, Servicing No — Use AI to turn machine sales into par levels, a ranked visit list and a slow-seller review, and keep the physical servicing with a person.
• Can AI Schedule Production for a Small Maker? A Spreadsheet Test — A seven-job test of AI scheduling from a spreadsheet: setups, due dates, a rush order, how to check the result and when software is worth buying.
• Can ChatGPT Read Engineering Drawings? What to Protect and Check — Can ChatGPT read a customer drawing, and is it safe under an NDA? A three-tier decision, redaction steps and a checking routine for tolerances.
• ChatGPT Apps for Logistics: 7 Jobs for a Small Carrier or 3PL — Seven jobs a small carrier or 3PL can give ChatGPT, from quote emails to telematics audits, each with a prompt, a sample and a limit.
• ChatGPT Apps for Manufacturing: 7 Small-Factory Jobs and Limits — Seven jobs a small factory can give ChatGPT, the one test that shows why quoting stays human, and what must never be uploaded.
• Customer Subscription Model: Test a Subscription Offer With AI First — A two-week demand test for a subscription offer, with a margin model, a churn guess and honest sample sizes for a small customer list.
• What Can ChatGPT Do for My Small Business? Jobs to Try First — Ten small-business jobs ranked by effort and risk, with sample prompts and a plain list of what ChatGPT cannot do reliably.
• ChatGPT Business Trial: What to Test Before You Pay — A scored evaluation using actual business tasks, with a keep-or-cancel decision and a seat-count check.
• Is Julius AI Worth Paying For? What the Credits Cover in Practice — Julius AI plans are priced in credits, not analyses. Here is how to measure your cost per answer and decide between Free, Plus and Pro.
• Julius AI vs ChatGPT for Spreadsheet Analysis: Which Fits You? — Both run code on your spreadsheet. Here are their documented limits, what each shows you, and a 45-minute test to run on your own file.

Sources

• Microsoft Copilot in Excel
• OpenAI ChatGPT
• Anthropic Claude