Skills excel-formula-wizard

📦

excel-formula-wizard

Name: excel-formula-wizard
Author: Hermes-Sedimentary

v1.0.0 Content revision r1 Safe

Generate Excel Formulas From Plain Language

Spreadsheet work slows down when formulas, macros, and PivotTables are hard to design. This skill turns plain-language Excel needs into formulas, VBA macro plans, and PivotTable guidance for Claude, Codex, and Claude Code users.

Supports: Claude Codex Code(CC)

🥈 80 Silver

This skill is part of a pack

Install the whole pack to get every skill the task needs, in one command.

Monthly Sales Excel Workbook · 3 skills Install whole pack

Install with my Agent

Copy this request to your Agent. It includes the canonical Skill page and manifest.

Agent request

Review the Skillstore skill "excel-formula-wizard" from https://skillstore.io/skills/zhangchenlai-dev-excel-formula-wizard.md and its manifest at https://skillstore.io/api/skills/zhangchenlai-dev-excel-formula-wizard/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.

Your Agent should still show its plan and request any confirmation required by the security policy.

Agent-readable resources

Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.

Markdown detail GET /skills/zhangchenlai-dev-excel-formula-wizard.md Signed manifest GET /api/skills/zhangchenlai-dev-excel-formula-wizard/manifest Signed lockfile GET /api/skills/zhangchenlai-dev-excel-formula-wizard/lockfile

Test it

Using "excel-formula-wizard". Create a monthly sales total by region.

Expected outcome:

Returns a criteria-based formula approach, explains the date and region conditions, and lists checks for source data formatting.

Using "excel-formula-wizard". Summarize revenue by product and month.

Expected outcome:

Recommends a PivotTable layout with months as columns, products as rows, revenue as values, and region as a filter.

Using "excel-formula-wizard". Automate cleanup for a weekly report.

Expected outcome:

Outlines VBA macro steps for backup, blank-row removal, format normalization, PivotTable refresh, and manual review before use.

Security Audit

Safe

v5 • 7/8/2026 Open versioned report

The only static finding was a high-entropy heuristic on SKILL.md. Manual review found normal Markdown front matter and user-facing Chinese content, with no encoded payload, prompt injection, command execution, network access, or secret handling evidence. No semantic security issues were identified.

Files scanned

Lines analyzed

Review items

False positives ignored

No confirmed security findings were detected by the latest completed static and semantic audit. This does not prove the skill has no side effects.

Audited by: codex View Audit History →

Share & cite this report

Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.

Open versioned report

Copy report link

https://skillstore.io/skills/zhangchenlai-dev-excel-formula-wizard/audits/5?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report

Markdown badge

[![Skillstore security assessment](https://skillstore.io/badges/skills/zhangchenlai-dev-excel-formula-wizard/security.svg)](https://skillstore.io/skills/zhangchenlai-dev-excel-formula-wizard?utm_source=security_passport_badge)

HTML badge

<a href="https://skillstore.io/skills/zhangchenlai-dev-excel-formula-wizard?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/zhangchenlai-dev-excel-formula-wizard/security.svg" alt="Skillstore security assessment" loading="lazy"></a>

Embed card

<iframe src="https://skillstore.io/embed/skills/zhangchenlai-dev-excel-formula-wizard.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>

Academic citations (APA · BibTeX · CFF)

APA citation

Hermes-Sedimentary. (2026). excel-formula-wizard security audit report (audit version 5) [Author version 1.0.0]. Skillstore. https://skillstore.io/skills/zhangchenlai-dev-excel-formula-wizard/audits/5

BibTeX citation

@techreport{hermes-sedimentary-zhangchenlai-dev-excel-formula-wizard-2026,
  author = {Hermes-Sedimentary},
  title = {excel-formula-wizard security audit report (audit version 5)},
  institution = {Skillstore},
  year = {2026},
  number = {5},
  url = {https://skillstore.io/skills/zhangchenlai-dev-excel-formula-wizard/audits/5},
  note = {Author version 1.0.0}
}

CITATION.cff

cff-version: 1.2.0
message: "If you use this Skill, cite its author and this versioned security audit report."
title: "excel-formula-wizard security audit report (audit version 5)"
version: "1.0.0"
type: report
authors:
  - name: "Hermes-Sedimentary"
date-released: "2026-07-08"
url: "https://skillstore.io/skills/zhangchenlai-dev-excel-formula-wizard/audits/5"
identifiers:
  - type: other
    value: "skillstore:zhangchenlai-dev-excel-formula-wizard:audit:5"
    description: "Skillstore immutable audit report identifier"

Skillstore Score

Why this score Evidence Confidence: Medium

Architecture

100

Maintainability

Content

Community

Spec Compliance

What You Can Build

Build formulas faster

Convert business rules into Excel formula suggestions with short explanations and test checks.

Automate recurring worksheets

Plan VBA macro steps for cleanup, formatting, and repeated workbook tasks.

Plan spreadsheet reports

Choose PivotTable rows, columns, values, and filters for recurring data summaries.

Try These Prompts

Create a basic formula

I have columns for dates, sales, and region. Create an Excel formula that totals sales for one region in one month.

Troubleshoot an existing formula

Review this Excel formula and explain why it returns an error: [paste formula]. Suggest a corrected version and testing steps.

Design a PivotTable plan

I have sales rows with date, customer, product, region, quantity, and revenue. Recommend a PivotTable layout for monthly revenue and top products.

Plan a VBA automation

Design a VBA macro approach that imports a monthly sheet, cleans blank rows, refreshes PivotTables, and logs errors. Include safety checks before running.

Best Practices

Provide column names, sample rows, expected result, and Excel version when asking for formulas.
Test generated formulas and macros on a copy of the workbook before production use.
Ask for a short explanation so teammates can maintain the spreadsheet later.

Avoid

Do not paste confidential workbook data unless it is required and allowed.
Do not run generated VBA macros without reading and testing them first.
Do not request one formula without explaining edge cases, blanks, and error rules.

Frequently Asked Questions

Can this skill write Excel formulas?

Yes. It converts spreadsheet requirements into formula suggestions and explanations.

Can it help with VBA macros?

Yes. It can outline VBA macros and safety checks, but users should test every macro.

Does it create PivotTable plans?

Yes. It can suggest row, column, value, and filter layouts for PivotTable reports.

Which tools does it support?

The report lists Claude, Codex, and Claude Code as supported tools.

Does it edit workbook files directly?

No. The skill file describes chat-based guidance, not direct workbook editing.

Is this safe for important spreadsheets?

Use it as AI assistance. Review critical outputs and test formulas or macros before relying on them.

Developer Details

Author

Hermes-Sedimentary

License

MIT

Author version

v1.0.0

Skillstore revision

Repository

https://github.com/zhangchenlai-dev/hermes-skill-store/tree/master/excel-formula-wizard

Ref

64ca8af0f54a325752f08bd54e52151061ea659a

Maintenance freshness

7/20/2026

Usage

5 downloads · 1 views

File structure

📄 SKILL.md