The Problem and the Fix
Without a skill
- You spend 20 minutes looking up the syntax for a formula you've used 50 times because you can never remember the exact argument order.
- You have raw data in a spreadsheet but no time to build the pivot tables and charts that would make it useful to stakeholders.
- You know AI can help with Excel but you've tried asking ChatGPT for formulas and they sometimes don't work on the first try.
With aidowith.me
- A guide to the 3 best AI tools for Excel, formula writing, data analysis, and automation, with honest trade-offs.
- A prompt structure that produces working Excel formulas on the first try, not the third.
- A 10-step route that builds a complete table and analysis document using AI in about 1 hour.
Who Builds This With AI
Marketers
Content, campaigns, and briefs done in hours instead of days.
Sales & BizDev
Prep calls, draft outreach, research prospects in minutes.
Managers & Leads
Reports, presentations, and team comms handled faster.
How It Works
Describe What Your Formula Needs to Do
Write a plain-language description of your formula goal, including which columns are involved and what the output should look like. Paste it into ChatGPT or Claude and ask for the Excel formula. Test immediately and paste any error back for a fix.
Upload Your Data for AI Analysis
If you need summary stats or pattern detection, upload your spreadsheet to ChatGPT with Code Interpreter. Ask 3 specific questions about your data and get structured answers in under 5 minutes.
Build a Formatted Table for Stakeholders
Use the route's table structure template to turn your raw data into a clean, formatted spreadsheet with headers, conditional formatting, and a summary row, ready to share.
Stop Googling Formulas
Follow the 10-step Tables, Plans, and Checklists route and build your first AI-assisted spreadsheet in about 1 hour.
Start This Skill →What You Walk Away With
Describe What Your Formula Needs to Do
Upload Your Data for AI Analysis
Build a Formatted Table for Stakeholders
A 10-step route that builds a complete table and analysis document using AI in about 1 hour.
"I stopped Googling Excel formulas. I describe what I need in plain English and paste the formula in. It works 95% of the time on the first try."- Financial analyst, mid-size company
Questions
ChatGPT and Claude both write accurate Excel formulas from descriptions, just tell them which columns you're working with and what the output should be. Microsoft Copilot in Excel does this natively if you have Microsoft 365, which is worth it if you're already paying for it. The aidowith.me Tables, Plans, and Checklists route shows you how to use these tools to build spreadsheets without memorizing formulas. The route takes about 1 hour.
Yes, ChatGPT and Claude write VBA macros from plain-language descriptions. Describe the automation you want ('highlight all rows where column C is blank'), paste the macro into the Excel VBA editor, and run it. Most simple macros work on the first try. For complex automations, expect 2-3 rounds of revision to get it right.
If you're already on Microsoft 365, Copilot adds real value for Excel users, it handles formula writing, pivot table creation, and data summaries without leaving the spreadsheet. If you're not on 365, ChatGPT covers most of the same formula and analysis tasks for free. The aidowith.me route works with either option.