中文版：请帮我制作一套专业的销售业绩Excel管理表。

表格至少包含：销售人员、区域、客户名称、客户类型、产品名称、销售金额、销售数量、订单数量、销售日期、销售目标、实际完成额、完成率、回款金额和回款率。

请建立“销售明细”“销售人员汇总”“客户分析”“产品分析”“区域分析”“目标完成情况”和“销售看板”多个工作表。

自动计算销售额、订单数、客单价、目标完成率、同比增长率、环比增长率、回款率等指标。

使用条件格式突出高业绩、低业绩、未完成目标和异常数据。

销售看板中显示总销售额、目标完成率、TOP销售人员、TOP客户、TOP产品和月度销售趋势。

请给出每个核心指标的Excel公式，并确保表格可以通过新增数据持续更新。

英文版：Create a professional Excel sales performance management workbook.

Include fields such as salesperson, region, customer name, customer type, product, sales amount, quantity sold, order count, sales date, sales target, actual sales, achievement rate, payment collected, and collection rate.

Create separate worksheets for sales details, salesperson summary, customer analysis, product analysis, regional analysis, target achievement, and a sales dashboard.

Automatically calculate total sales, order volume, average order value, target achievement rate, year-over-year growth, month-over-month growth, and collection rate.

Use conditional formatting to highlight high performers, low performers, missed targets, and abnormal data.

The dashboard should display total sales, target achievement, top salespeople, top customers, top products, and monthly sales trends.

Provide Excel formulas for all key metrics and make the workbook easy to update when new data is added.

该提示词已在以下工具中验证有效：ChatGPT、Claude、Gemini、Copilot、WPS AI