skills.rest
360org
360orgCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

excel-formula

Generates Excel and Google Sheets formulas from plain-language calculation descriptions.

1|Updated Jul 10, 2026
Search Tags:#spreadsheet#excel#calculation#google sheets#formula#sumifs#xlookup
One-click install
npx skills add https://github.com/360org/vuaassistant --skill excel-formula-360org
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: excel-formula
Source: https://github.com/360org/vuaassistant/tree/main/skills/excel-formula
Command: npx skills add https://github.com/360org/vuaassistant --skill excel-formula-360org

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Writing spreadsheet formulas requires knowing exact function syntax, cell references, and platform differences between Excel and Google Sheets. This Skill converts a plain-language description of a calculation into a ready-to-paste formula with a clear explanation. ## Core Features & Use Cases - Formula Generation: Produces working formulas using modern functions like XLOOKUP, FILTER, SUMIFS, and LET, with classic fallbacks like VLOOKUP for older Excel versions. - Platform Awareness: Handles differences between Excel and Google Sheets, including ARRAYFORMULA and QUERY, and notes version-specific behavior. - Explanation and Adaptation: States the assumed data layout, explains each formula part briefly, and warns about text-vs-number pitfalls. - Use Case: A sales analyst needs to sum revenue by region from a raw export. Describe the columns and the goal, and receive a SUMIFS formula ready to paste, plus a fallback for older Excel. ## Quick Start Ask the assistant to write an Excel formula that sums column C where column A equals a specific region, describing your sheet layout in one sentence.

Frequently Asked Questions about excel-formula

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I write an Excel formula from a plain-language description?▼

Describe the calculation you want and mention which columns hold your data. The Skill restates the assumed layout, then returns a paste-ready formula in a code block with a short explanation of each part.

What is the difference between XLOOKUP and VLOOKUP in Excel?▼

XLOOKUP is the modern lookup function that searches in any direction and defaults to exact match, while VLOOKUP only searches left-to-right. The Skill prefers XLOOKUP but provides the VLOOKUP fallback for older Excel versions.

Does this work with Google Sheets formulas like ARRAYFORMULA and QUERY?▼

Yes, the Skill handles Google Sheets-specific functions such as ARRAYFORMULA and QUERY. It gives the version for the platform you name and briefly notes the difference from Excel.

Why does my Excel formula return wrong results with numbers stored as text?▼

Formulas like SUMIFS and lookups fail when values are stored as text instead of numbers. The Skill warns when a formula depends on consistent data types so you can convert the data first.

When should I use a helper column instead of one complex formula?▼

For multi-step transformations, a single mega-formula becomes unreadable and hard to maintain. The Skill suggests the simplest helper-column approach in those cases, breaking the logic into understandable steps.

Related Skills

Explore More Data & Analytics Skills→
AllBeingsFutureAllBeingsFuture
9

allbeingsfuture/skills@xlsx

Open, clean, format, and convert spreadsheet files across xlsx, xlsm, csv, and tsv formats.

Community
Intermediate
hmzainjamilhmzainjamil
1

report-generator

Generate formatted reports with charts, tables, and metric summaries from structured data.

Community
Intermediate
zocomputerzocomputer
45

xlsx

Create and edit XLSX, XLSM, CSV, and TSV spreadsheets with formulas and formatting.

Official
Advanced
Pixel-Process-UGPixel-Process-UG
1

xlsx-processing

Read, write, and format Excel files with openpyxl and pandas.

Official
Advanced