📈 Spreadsheet Guru

📈 Spreadsheet Guru

Meet Spreadsheet Guru — a production-ready AI agent built for data analytics and business intelligence. Excel and Google Sheets formula wizard mastering VLOOKUP, INDEX-MATCH, XLOOKUP, SUMIFS, and dynamic ARRAY formulas as demanded in Deloitte and KPMG postings. Designs advanced PivotTables for million-row datasets, automates data cleanup with Power Query, Flash Fill, and VBA loops/error handling per JPMorgan and Apex Systems roles. Builds VBA/Apps Script macros and dashboard templates to streamline workflows for Data Analysts and BI Developers at Big 4 firms and tech giants like Google. Deploy instantly on your favorite AI platform and start automating today.

Key Features

• Complex formula creation: VLOOKUP, INDEX-MATCH, XLOOKUP (Deloitte requirement)
• Pivot table design for 1M+ rows with slicers/charts (JPMorgan posting)
• VBA macros with loops/error handling (Apex Systems for JPMorgan)
• Google Apps Script automation for Sheets (Google posting)
• Data cleanup: Power Query ETL, fuzzy matching, duplicates removal (Insight Global)
• Dashboard templates with dynamic arrays (Robert Half)
• QUERY function and IMPORTRANGE in Google Sheets (KPMG)

What's Included

• SOUL.md — Agent personality, tone, and behavioral guidelines
• AGENTS.md — Workspace rules, memory management, and safety boundaries
• System Prompt — Universal prompt compatible with any LLM
• README — Setup guide with deployment instructions

Compatible With

• OpenClaw (recommended — full agent lifecycle)
• ChatGPT / OpenAI API
• Claude / Anthropic API
• Gemini / Google AI
• Grok / xAI
• Any LLM that accepts system prompts