If you’ve ever opened Excel and thought,
“Wait… what was that formula again?”
you’re not alone.

Most people remember the basics — SUM, AVERAGE, maybe IF —
but when you need something like SUMIFS or XLOOKUP, it’s back to Google, StackOverflow, or random blog posts from 2014.

That’s why 6SigmaMind exists — a tiny 1.7B AI model that instantly turns plain English into working Excel formulas.

And the coolest part?
You can try it in your browser right now.

👉 Launch the demo: https://huggingface.co/spaces/benkemp/6SigmaMindv2

Below are 10 real Excel tasks you can solve instantly using 6SigmaMind.
Just copy the prompt → paste it into the demo → done.

1️⃣ Sum values only when a condition is met

Prompt:
“Sum all values in C where B equals ‘Closed’.”

Expected formula:
=SUMIFS(C:C, B:B, "Closed")

Useful for: sales trackers, task lists, invoice tables, workflows.

2️⃣ Return values using XLOOKUP

Prompt:
“Return the price in D for the SKU in A matching H2.”

Expected output:
=XLOOKUP(H2, A:A, D:D)

Works like magic compared to old VLOOKUPs.

3️⃣ Find the last non-empty value in a column

Prompt:
“Give the last non-empty value from column B.”

Formula:
=LOOKUP(2,1/(B:B<>""),B:B)

One of the most useful Excel tricks ever.

4️⃣ Count how many cells meet a numeric condition

Prompt:
“Count how many numbers in A2:A200 are greater than 50.”

Formula:
=COUNTIFS(A2:A200, ">50")

Great for analytics dashboards.

5️⃣ Check if a cell is blank

Prompt:
“Write a formula that checks if B2 is empty.”

Formula:
=IF(B2="", TRUE, FALSE)

Or the short version:

=B2=""

6️⃣ Extract text from the start, middle, or end

Prompt:
“Get the first 3 characters of C2.”

Formula:
=LEFT(C2,3)

Try variations:

“Last 4 characters of D3”
“Extract 5 characters starting at position 2 from B5”

7️⃣ Calculate standard deviation

Prompt:
“Compute the standard deviation of values in B2:B80.”

Formula:
=STDEV.S(B2:B80)

Perfect for data analysis and quality control.

8️⃣ Calculate correlation

Prompt:
“Return the correlation between A and B.”

Formula:
=CORREL(A:A, B:B)

If you’re analyzing trends, this is gold.

9️⃣ Rank values

Prompt:
“Rank the value in B2 within B2:B100, highest = 1.”

Formula:
=RANK.EQ(B2, B2:B100, 0)

Useful for leaderboards, KPIs, scorecards.

🔟 Filter rows that meet conditions

Prompt:
“Filter D2:D100 where B2:B100 equals ‘Active’.”

Formula:
=FILTER(D2:D100, B2:B100="Active")

Try it.
If the model gets this one right, you’ll feel the power of small models.

🚀 Why These Tasks Matter

These 10 examples cover the most common “I need a formula but don’t remember it” moments:

Lookups
Conditional logic
Text extraction
Statistics
Filtering
Summaries
Ranking

With 6SigmaMind, each takes one sentence and a fraction of a second.

That’s the magic of small models:
they’re lightweight, fast, and surprisingly capable — especially when you aim them at one domain.

🎯 Want more challenges?

Try feeding the model:

nested IF formulas
multi-condition SUMIFS
two-way INDEX/MATCH lookups
quartiles, medians, regressions
covariance
date math
dynamic arrays
unusual prompt phrasings

If you break it… great!
Every mistake helps shape the next version.

🧪 Your Turn — Test 6SigmaMind

👉 Click here to try the live demo: https://huggingface.co/spaces/benkemp/6SigmaMindv2
No login. No cost. No waiting.

Just type:

“Sum values in column C where B is ‘Closed’.”

And watch a 1.7B model translate your sentence into a working Excel formula.

Nano Language Models

10 Excel Tasks You Can Solve Instantly with 6SigmaMind