The Excel-AI Combination
Excel / Google Sheets work can be greatly accelerated with AI. Use it in 3 areas: function generation, data analysis, automation.
1. Function Generation
Write "what you want to do in plain language" and have AI make the function.
Example
"Column A has names, column B numbers; I want to get the matching name's email from list D:E on another sheet"
→ AI generates a VLOOKUP / XLOOKUP / INDEX-MATCH formula
Selective Use of Common Functions
- VLOOKUP: left-to-right lookup (old, high compatibility)
- XLOOKUP: bidirectional, with error handling (recommended)
- INDEX/MATCH: flexible, multi-condition lookup
- SUMIFS / COUNTIFS: aggregate by multiple conditions
- FILTER / UNIQUE: dynamic arrays (new Excel)
- QUERY (Sheets): SQL-like extraction
2. Data Analysis
Julius AI
Upload CSV / Excel → analyze data in natural language. Auto-generates Python/SQL code, with visualization. Core $20/mo.
