Builds Excel-365 and Google Sheets formulas with pitfalls, validation, and plain-English explanation.
Scanned 9/6/2026
Install to Claude Code
Skills Directorynpx -y skills add conectlens/lenserfight --skill excel-formula-assistant --agent claude-codeInstalls into .claude/skills of the current project.
Are you the author of Excel Formula Assistant?
Add the live security badge to your README — it updates automatically with every re-scan.
[](https://www.skillsdirectory.com/skills/conectlens-excel-formula-assistant)More formats (shields.io, HTML) on the badges page.
---
name: excel-formula-assistant
description: Builds Excel-365 and Google Sheets formulas with pitfalls, validation, and plain-English explanation.
---
# Excel Formula Assistant
You are the Excel Formula Assistant Lens. The user wants to achieve `[[goal]]` over data shaped like `[[columns]]`.
Return:
1. Recommended formula in **Excel-365 syntax** with cell references made concrete.
2. Equivalent **Google Sheets** variant if it differs.
3. A one-line plain-English description of what the formula does.
4. One **common pitfall** (relative vs. absolute references, blank cells, locale-specific separators) and how to avoid it.
5. One **validation step** the user can run to confirm the result.
Prefer `LET` / `LAMBDA` / dynamic-array formulas when they improve clarity.
## Why this exists
Search-engine answers for spreadsheet questions are 80% trash and 20% dialect-mismatched. This lens forces the model to pick Excel-365 or Google Sheets syntax, surface a real pitfall, and recommend a validation step instead of leaving the user to discover bugs in production.
Is this your skill, or is something wrong with this listing? Request removal or report an issue. Author removals are honored within 72 hours.
No comments yet. Be the first to comment!
Ultra-compressed communication mode. Cuts token usage ~75% by speaking like caveman while keeping full technical accuracy. Supports intensity levels: lite, full (default), ultra, wenyan-lite, wenyan-full, wenyan-ultra. Use when user says "caveman mode", "talk like caveman", "use caveman", "less tokens", "be brief", or invokes /caveman. Also auto-triggers when token efficiency is requested.
Adversarial multi-agent planning skill. Self-orchestrates 5 hostile category members (unspecified-low, unspecified-high, deep, ultrabrain, artistry) via team-mode for ruthless cross-critique debate, distills only the defensible insights, then MANDATORILY hands the distilled insight bundle to the `plan` agent for executable plan formalization. Use when planning needs maximum rigor and surfacing of weak assumptions, blind spots, and over-engineering. Triggers: 'hyperplan', 'hpp', '/hyperplan', ...
Routes multi-tool workflows through MCP servers for large datasets and pipelines. Use when Bash tool overhead is limiting throughput on data-heavy tasks.
**Complete production-ready guide for Google Gemini embeddings API** This skill provides comprehensive coverage of the `gemini-embedding-001` model for generating text embeddings, including SDK usage, REST API patterns, batch processing, RAG integration with Cloudflare Vectorize, and advanced use cases like semantic search and document clustering. ---
Recovers prior coding-agent session context by running `catchup <agent> --since-compact`, which extracts a clean summary of a previous Codex, Claude Code, Antigravity, OpenCode, or Pi Agent session. Use when the user says "catch up", "what did the last session do", "get me up to speed", "I switched agents", or asks to recover/summarize a previous session before continuing. Do NOT use for the current conversation, git history, or any non-agent log.
