Say Goodbye to Manual Work: Use AI to Analyze Excel Data and Write Formulas

2026-06-03·7 min read·OKCodex Editorial

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:

RequirementExample 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:

  1. What is the overall trend?
  2. Which month is abnormal, and what are the possible reasons?
  3. 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

  1. Do not upload sensitive data: Replace customer names, phone numbers, etc. with "Customer A, Customer B" before sending to AI
  2. Verify formula results: Most formulas written by AI are correct, but when critical financial data is involved, verify them manually
  3. 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

Share:Weibo

Subscribe to weekly briefing

Comments

Loading comments…

Leave a comment

0 / 500

Comments appear after review.

Find tools for your next task

Start with scanned documents, code review or research. Get a shortlist with matching evidence; no model is run.

Find tools for my task →
Analyze this topic with two models

DeepSeek and Qwen are preselected with the article topic. You choose when to run them.

Try it →

Keep reading

Explore

Explore published agents