Excel & Google Sheets Users Pack
6 prompts and 2 skills for excel & google sheets users — each one a real job from the week, with the steps, rules and output an expert would ask for. Fill in the blanks and paste them into ChatGPT, Claude or Gemini, or tailor any of them to your brand in the Studio.
What’s in the pack
- Explain a Formula Someone Else Built in Your SpreadsheetBreaks down an inherited Excel or Google Sheets formula piece by piece, tests it against edge cases, and offers a simpler rewrite you can maintain yourself.Plan
- Clean a Messy Export Before It Breaks Your TotalsPlans a repeatable cleanup of a CSV export from a bank, shop or CRM — text dates, duplicates, stray spaces, numbers stored as text — so next month's file takes minutes.Plan
- Set Up a Pivot Table That Answers Your Real QuestionTurns a business question into an exact pivot table layout — rows, columns, values, grouping, filters — and flags the source-data problems that would make the answer wrong.Plan
- Build a One-Page Dashboard From Your Sales SpreadsheetDesigns a one-page Excel or Google Sheets dashboard for a small business — which five numbers, which charts, a month selector and traffic-light rules — on tabs you can refresh.Plan
- Fix #N/A, #REF! and #SPILL! Errors in a SpreadsheetDiagnoses why a formula shows #N/A, #REF!, #VALUE!, #DIV/0! or #SPILL!, finds the real cause in your data, and gives a fix that does not simply hide the error.Plan
- Lock Down a Shared Team Spreadsheet Without Blocking WorkSets sharing permissions, protected ranges, dropdown validation and version recovery on a spreadsheet many people edit, and flags personal data that should not live there at all.Plan
- Spreadsheet Formula and Cleanup DeskA standing Excel and Google Sheets specialist that writes, explains and tests formulas against your real columns and keeps your workbook conventions consistent from one request to the next.Plan
- Apps Script and Excel Macro Helper for Non-CodersA standing automation helper that writes small Google Apps Script, Office Scripts or VBA routines for repetitive spreadsheet chores, with backups, dry runs and plain-language explanations of every block.Plan
Titles and descriptions are public. The full texts, the .zip download and Agent Skill exports are on the Library and Pro plans. See the plans. More for data analysis & excel · productivity · small business.
More packs · everyday tech, data & ai at work
AI Agents for Small Business Tasks Pack7 prompts · 1 skillAmazon Marketplace Sellers Pack7 prompts · 1 skillBuilding Custom GPTs / Claude Projects / Gems Pack7 prompts · 1 skillEtsy Sellers Pack7 prompts · 1 skillHome Cybersecurity Pack7 prompts · 1 skillNo-Code Automation Pack6 prompts · 2 skillsNotion & Airtable Workspace Builders Pack6 prompts · 2 skillsPersonal Data Privacy Pack7 prompts · 1 skill