中文版:请帮我制作一份月度预算管理Excel表格,用于比较预算金额、实际支出和预算差异。
建立“预算计划”“实际支出”“预算对比”“部门预算”和“预算分析”工作表。
预算表包含月份、部门、费用类别、预算金额、实际金额、差异金额和差异率。
自动计算预算执行率、预算剩余金额、超预算金额和预算差异率。
当实际支出超过预算时,通过条件格式自动突出显示,并按照差异金额从高到低进行排序。
增加月度预算趋势、部门预算执行情况和费用类别分析。
请设计可持续更新的表格结构,并保证新增月份后不会破坏公式。
英文版:Create a monthly budget management Excel workbook to compare planned budgets, actual spending, and budget variances.
Create worksheets for budget planning, actual expenses, budget comparison, departmental budgets, and budget analysis.
Include month, department, expense category, budget amount, actual amount, variance amount, and variance percentage.
Automatically calculate budget utilization, remaining budget, overspending, and variance percentage.
Use conditional formatting to highlight expenses that exceed the budget and sort major variances from highest to lowest.
Add monthly budget trends, departmental budget performance, and expense-category analysis.
Design the workbook so new months can be added without breaking formulas or summary calculations.
该提示词已在以下工具中验证有效:ChatGPT、Claude、Gemini、Copilot

◯ 评论 0