cc-skill:excel-formulas

Claude Code skill · anthropic · active

last 30 days

0 calls

0 of 30 days active

explain like I am new to this

what it does

This skill helps you write, fix, and understand Excel formulas. It covers modern functions like XLOOKUP and FILTER, explains when to use Tables, and shows you how to handle lookups and dynamic calculations in Excel 365 and newer versions.

who it is for

Anyone who uses Excel to analyze data, look up information, or build calculations, especially those on newer versions of Excel.

when it fires

When you mention Excel formulas, ask about XLOOKUP, FILTER, dynamic arrays, Power Query, Excel Tables, or say you need help fixing a formula.

say something like

"How do I write an XLOOKUP formula to find customer email addresses?"
"My VLOOKUP is broken. Can you help?"
"I want to filter my sales data to show only orders over 5000 dollars."

what you might get back

Instead of using VLOOKUP (which is old), use XLOOKUP like this: =XLOOKUP(A2, tblCustomers[ID], tblCustomers[Email], "Not found"). This looks up the ID in cell A2, searches the customer ID column, and returns the matching email. If no match exists, it shows "Not found" instead of an error.

how to know it worked

You'll know it worked because you get a specific formula you can paste into your spreadsheet, or clear advice on why your current formula isn't working and how to fix it.

is this skill working for me

never used

cloud runs

0 deployments

local fires

Claude Code (optional)

posts published

from drafts

attributed

$0.00

signups + revenue

Deploy this skill as a cloud automation to put it to work — runs on a schedule, dispatches output to Telegram or email, and logs every result here.

Deploy this skill

no laptop required

Run this skill on a schedule in the cloud. Pipe output to Telegram, email, or any webhook. Every run is logged here with full output, cost, and thumbs feedback.

How this performs

Cloud-automation runs, real outputs, and feedback.

No cloud runs yet for this skill.

Once you deploy it (above), every run will show up here with the actual output, exact cost, and a thumbs button so you can rate quality over time.

what this is

Claude Code skill at /Users/olanrewajukareem/.claude/skills/excel-formulas/SKILL.md. Auto-triggered by description matching when you type in Claude Code, OR embedded into agent system prompts (LeadFlow framework skills are wired this way). Auto-synced from disk every 6h via launchd.

Use this skill when writing or debugging Microsoft Excel formulas, including XLOOKUP, INDEX/MATCH, dynamic arrays (FILTER, SORT, UNIQUE), Power Query basics, and Tables. Triggers on "Excel formula", "XLOOKUP", "Excel function", "Excel help", "dynamic

Local Claude Code use (optional)

Install the SKILL.md file locally so this skill is available the next time you open Claude Code on your Mac. Most users skip this and just use cloud deployments above.

Install on your machine

Save this skill to ~/.claude/skills/excel-formulas/SKILL.md so Claude Code auto-loads it whenever its description matches your prompt.

30-day activity

never used

2026-04-03today

cost model

unitincluded

capabilities

{
  "source": "global",
  "description": "Use this skill when writing or debugging Microsoft Excel formulas, including XLOOKUP, INDEX/MATCH, dynamic arrays (FILTER, SORT, UNIQUE), Power Query basics, and Tables. Triggers on \"Excel formula\", \"XLOOKUP\", \"Excel function\", \"Excel help\", \"dynamic array\", \"Power Query\", \"Excel table\". Different from google-sheets-formulas (covers Sheets-specific functions like ARRAYFORMULA, QUERY, IMPORTRANGE)."
}

how it gets called

{
  "method": "embed_in_prompt",
  "skill_path": "/Users/olanrewajukareem/.claude/skills/excel-formulas/SKILL.md"
}

This tool has never been called in the last 30 days.

That means either: (a) the system has not had a task that matched its strengths, (b) a more cost-effective alternative was picked by the router, or (c) the related automation is toggled OFF on /automations. The Recommender reviews idle tools weekly and may suggest killing it.