Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Excel & Sheets Formulas: Fix, Explain & Build Models

    1

    Write, fix, and optimize Excel and Google Sheets formulas with full support for regional locales and versions.

    Free

    1 useSecurity scanned
    Excel & Sheets Formulas: Fix, Explain & Build Models

    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

    StepInstruction
    Formula=XLOOKUP("X-100", TRIM(A:A), B:B, "Not Found", 0)
    LocationPaste into any empty cell where you need the result.
    ExplanationTRIM(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 + F to 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 XLOOKUP or legacy INDEX/MATCH fallbacks.

    How it works

    1. Context check identifies your application, version, and locale to ensure correct comma or semicolon separators.
    2. Data inspection analyzes headers and sample rows to understand the spreadsheet layout.
    3. Formula delivery provides the code, placement instructions, and a breakdown of the logic.
    4. 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 IF statements into readable IFS or SWITCH logic.
    • Repair broken VLOOKUP calls 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. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 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

    Listed1 day ago

    What's inside

    Frequently Asked Questions

    The skill automatically detects your regional settings to ensure formulas use the correct separators, such as commas for US/UK locales or semicolons for many European regions, preventing immediate syntax errors.

    Yes, the skill adapts its logic based on your specific software version, utilizing modern functions like XLOOKUP and LET for Microsoft 365 users while providing robust INDEX/MATCH fallbacks for legacy versions.

    While it can diagnose and fix standard #REF! or #VALUE! errors, this skill is limited to formula-based logic; it does not write or debug VBA macros, Google Apps Script, or Power Pivot DAX measures.

    By analyzing your data headers and sample rows, the skill suggests the most efficient formula placement and logic to ensure your sheet remains performant and easy to audit.

    The skill is designed to integrate with major AI assistant frameworks that support file analysis or text-based prompting, allowing it to act as a dedicated spreadsheet specialist within your existing workflow.

    The skill provides the precise formula syntax, a step-by-step breakdown of how the logic works, and specific instructions on which cell or range the formula should be applied to.

    New in Workflow Automation

    Free