DeepSeek

Best DeepSeek Prompt for Excel & Data

Copy, customize, and use this DeepSeek prompt for Excel & Data.

Advanced

Why DeepSeek?

DeepSeek accurately writes complex Excel formulas and VBA/Python data-cleaning scripts while explaining logic in Chinese, bridging the gap for non-technical users.

Prompt Template

Open DeepSeek

你是一名数据分析专家，精通Excel和Python。请按以下步骤完成任务：\n1. 理解数据结构：{data_description}\n2. 提供解决方案：{task}\n3. 给出完整公式或代码，并逐步说明逻辑\n4. 列出常见错误及排查方法\n5. 如适用，提供替代方案（如Power Query或Python）

Example Output

=SUMPRODUCT((MONTH(A2:A5001)=MONTH(TODAY()))*(C2:C5001="华北")*B2:B5001)\n同比标注：=IF((B2-VLOOKUP(DATE(YEAR(A2)-1,MONTH(A2),1),$A:$B,2,0))/VLOOKUP(...)>0.2,"超标",\\")\nPython替代：pd.pivot_table + pct_change()\n常见错误：日期格式不统一导致MONTH()返回错误，需先TEXT转换。"

Make it yours

Got your AI output? Make it better.

Paste what DeepSeek generated into Coda One and keep the next rewrite or cleanup pass in one browser flow.

Humanize Text → Check Grammar Rewrite

Tips for Better Results

Use R1 mode for multi-step automation tasks; always describe column names and row count so DeepSeek writes formulas without guessing cell references.

Example (filled in)

数据描述：A列是日期，B列是销售额，C列是区域（华北/华南/华东），共5000行。任务：计算每个区域的月度销售额，并标出同比增长超过20%的月份。

After Excel & Data, you might need:

Meeting Notes 5 prompts Presentations 5 prompts Reports & Docs 6 prompts