- Home
- Skills
- Workflow Automation
- Excel & Sheets Formulas: Fix, Explain & Build Models
Works with the AI Agents you already use
Excel & Sheets Formulas: Fix, Explain & Build Models
Write, fix, and optimize Excel and Google Sheets formulas with full support for regional locales and versions.
Free
Excel & Sheets Formulas: Fix, Explain & Build Models
Example session with this skill installed
I have an Excel sheet with product IDs in A and prices in B. I need to find the price for ID 'X-100' but I'm getting an #N/A. I'm using Excel 365 in the UK.
- Read your context and instructions
- Compiled the excel & sheets
I have analyzed the lookup error. In Excel 365, #N/A usually indicates the ID is missing or there is a data type mismatch (e.g., text vs number). I will use XLOOKUP with a TRIM wrapper to account for hidden spaces.
Spreadsheet Formula Fix
| Step | Instruction |
|---|---|
| Formula | =XLOOKUP("X-100", TRIM(A:A), B:B, "Not Found", 0) |
| Location | Paste into any empty cell where you need the result. |
| Explanation | TRIM(A:A) removes leading/trailing spaces in your IDs; 0 ensures an exact match; "Not Found" handles missing IDs gracefully. |
Debugging Notes
Leading Spaces: If your IDs are imported from a CRM, they often contain non-breaking spaces that VLOOKUP misses. TRIM fixes this.
2.
Text vs Number: If 'X-100' is stored as a number but the lookup value is text, use VALUE() or change cell formatting.
3. Locale: Confirmed UK locale uses commas (,) as function separators.
Next steps
- Copy the formula above into your sheet.
- If it still fails, check if column A has a green triangle warning (Text-stored-as-number).
- Use
CTRL + Fto verify 'X-100' actually exists in the source range.
Connects securely to your tools. The creator never sees your data.
About this skill
Spreadsheet tasks often fail because of simple syntax errors, regional locale differences, or outdated function use. This skill provides precise Excel and Google Sheets formulas, debugging, and financial model architecture tailored to your specific version and language.
What it does
- Formula generation creates ready-to-paste logic for complex lookups, filtering, and conditional calculations.
- Error debugging diagnoses and fixes
#N/A,#REF!, and#SPILL!errors by analyzing data types and separators. - Data cleaning automates text normalization, date standardization, and outlier flagging to prep messy CSVs.
- Model building architectures financial tools like ROI calculators and budgets with proper input-calc-output separation.
- Version optimization selects between modern dynamic arrays like
XLOOKUPor legacyINDEX/MATCHfallbacks.
How it works
- Context check identifies your application, version, and locale to ensure correct comma or semicolon separators.
- Data inspection analyzes headers and sample rows to understand the spreadsheet layout.
- Formula delivery provides the code, placement instructions, and a breakdown of the logic.
- Validation checks for edge cases like blanks or text-formatted numbers before suggesting a final fix.
Frameworks & tools
The skill supports Excel (365, 2019, Mac), Google Sheets, and LibreOffice. It handles English and localized function names, utilizing openpyxl or pandas when processing uploaded files.
Why this beats prompting it yourself
Generic prompts often return formulas with the wrong regional separators or functions your version of Excel doesn't support. This skill enforces strict locale awareness and uses professional modeling standards, like keeping formulas live instead of flattening them to values.
Use cases
- Convert complex nested
IFstatements into readableIFSorSWITCHlogic. - Repair broken
VLOOKUPcalls caused by trailing spaces or mismatched data types. - Build a multi-scenario financial forecast with a dynamic base/low/high switch.
- Clean and merge messy exports from different CRM systems into a single format.
Known limitations
Does not support VBA/Apps Script generation or complex Power Pivot DAX measures. Limited to formula-based solutions and standard financial modeling.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Workflow Automation.
Does not support VBA/Apps Script or complex Power Pivot DAX. Limited to formula-based solutions and standard financial modeling. Requires locale context for non-US users.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
1 use
Times used to date
Free to use
No account required to browse
Trust & safety
Security scan
Security scan passed 1 day ago
- Free with an Agensi account
Permissions
No special permissions declared or detected