Nano Language Models

10 Excel Tasks You Can Now Do Without Remembering a Single Formula

If you’ve ever paused your work to Google “How does SUMIFS work again?”, you’re not alone. Excel formulas are powerful, but nobody remembers every function, every argument, or every tiny syntax detail.

Now you don’t have to.

With the Excel Formula Assistant, you simply describe what you want — and it writes the formula for you.

Here are 10 real tasks you can complete instantly using plain English, no formula knowledge required.

1. Sum values with a condition

You type:
“Add all sales in column B where region in column A is North.”

AI gives:
=SUMIF(A:A,"North",B:B)

Clear and correct — every time.

2. Count how many rows meet a condition

You type:
“Count how many orders are above 500 in column D.”

AI gives:
=COUNTIF(D:D,">500")

No need to think about quotation marks or comparison symbols.

3. Average values with a filter

You type:
“Average the revenue in C2:C200 where channel in B2:B200 is Online.”

AI gives:
=AVERAGEIF(B2:B200,"Online",C2:C200)

A perfect use of AVERAGEIF — even if you forgot the function exists.

4. Look up a value from another table

You type:
“Find the price from column C that matches the product ID in F2.”

AI gives:
=XLOOKUP(F2,A:A,C:C)

Fast. Modern. Reliable. (And no VLOOKUP left/right limitations.)

5. Combine first and last names

You type:
“Combine A2 and B2 with a space between.”

AI gives:
=A2 & " " & B2

Simple and universally readable.

6. Create an IF statement

You type:
“If E2 is larger than 1000, show Bonus, otherwise show nothing.”

AI gives:
=IF(E2>1000,"Bonus","")

No syntax mistakes. No missing commas.

7. Filter a range using conditions

You type:
“Return all rows in C2:C100 where B2:B100 equals West.”

AI gives:
=FILTER(C2:C100,B2:B100="West")

This is a common formula people rarely remember — now you don’t have to.

8. Extract part of a text value

You type:
“Take the first 5 characters from A2.”

AI gives:
=LEFT(A2,5)

Or:

“Get characters 3 through 7 from D2.”
→ =MID(D2,3,5)

9. Find the most recent date

You type:
“Return the latest date in column A.”

AI gives:
=MAX(A:A)

One of the simplest, yet most forgotten formulas.

10. Count how many cells contain text

You type:
“Count how many cells in B2:B200 contain the text Error.”

AI gives:
=COUNTIF(B2:B200,"Error")

No regex, no wildcards, no hassle.

⭐ Why this changes everything

Instead of thinking about Excel’s syntax, you just think about your task.
This helps:

  • beginners who don’t know formulas yet
  • intermediate users who know the logic but forget syntax
  • advanced users who want to work faster

And it eliminates the biggest Excel pain point:

“I know what I want to do… I just don’t remember the formula.”

Now that problem disappears.

🧪 Try It Yourself

You can test all 10 examples (and any other Excel task) using the live demo:

👉 Live Excel Formula Assistant

Type a plain English sentence.
Get a working formula.
Copy → paste → done.

Continue Learning

Next user-focused guides:

Ben Kemp

Get early access to the fastest way to turn plain language into Excel formulas—sign up for the waitlist.

Latest Articles