Say Goodbye to Manual Work: Use AI to Analyze Excel Data and Write Formulas
Say Goodbye to Manual Work: Use AI to Analyze Excel Data and Write Formulas
AI Practical Handbook Part 4
Excel Is the Most Commonly Used Data Tool for SMEs
For many companies, "data analysis" is just an Excel spreadsheet. But they can't write complex formulas, and they get lost once the data volume grows—this is a common pain point.
AI can help you solve these two problems.
Use Case 1: Let AI Write Excel Formulas
Just describe in Chinese what you want to do, and AI can provide the formula.
Example conversation:
I have a table. Column A is employee name, Column B is department, and Column C is this month's sales. I want to look up the corresponding sales amount in Column E based on the name in Column D. What formula should I use?
AI answer: excel =VLOOKUP(D2, A:C, 3, 0)
It will also explain the meaning of each parameter.
Common Formula Scenarios:
| Requirement | Example Question |
|---|---|
| Cross-sheet lookup | "Match Column A in Sheet1 with Column B in Sheet2, and take the value from Column C" |
| Conditional sum | "Calculate the total order amount for South China with sales greater than 10,000" |
| Distinct count | "Count the number of unique customers in Column A" |
| Date calculation | "Calculate years of service from hire date to today, in years" |
Tip: If the formula returns an error, describe the error screenshot to AI and let it help you troubleshoot.
Use Case 2: Paste Data to AI for Analysis
You don't need to know how to make charts. Paste the data directly into the chat box and let AI interpret it.
Example:
Below is our sales data from January to June (unit: ten thousand yuan): Jan:45, Feb:32, Mar:58, Apr:61, May:55, Jun:72
Please analyze:
- What is the overall trend?
- Which month is abnormal, and what are the possible reasons?
- What is the expected trend for the second half of the year?
AI will provide a structured analysis, including patterns you may not have noticed.
Use Case 3: Let AI Design the Structure of a Data Dashboard
If you want to build a management dashboard but don't know which metrics to display, you can ask AI:
I run a 20-person sales company, and the main metrics are: number of leads, conversion rate, average order value, and renewal rate. Help me design a monthly management dashboard. What charts and data comparisons should it include?
AI will provide a clear dashboard design plan, and then you can implement it according to this framework in Excel or 飞书多维表.
Notes
- Do not upload sensitive data: Replace customer names, phone numbers, etc. with "Customer A, Customer B" before sending to AI
- Verify formula results: Most formulas written by AI are correct, but when critical financial data is involved, verify them manually
- Keep formula explanations: Have AI explain the meaning of formulas, save them in team documents, and you won't need to ask again next time
好码未来 · AI Practical Handbook Part 4 | Next: Using AI for Competitive Analysis
Subscribe to weekly briefing