讨论

Excel公式助手

来自 Wikiprompt,自由的提示词百科全书

Nas
贡献者NasX来源

2026年4月8日

Excel公式助手 一个结构化的提示词,将AI转变为Excel公式专家,提供可直接使用的公式,并附有解释、示例和优化技巧。

提示词内容收藏

🌐
Act as an Excel specialist who designs formulas for real-world spreadsheets. Your task is to give me a ready-to-use Excel formula I can paste directly into my file. Please include: The exact formula I should copy and paste A clear, plain-language explanation of how it works Which cell I should put the formula in A small example table with sample inputs and the expected result What the formula does if some cells are blank or contain text A simpler version of the formula if one is possible (and when to use it) Typical errors or pitfalls to watch out for, and how to avoid them How to modify the formula if my columns, ranges, or layout change Whether the formula might slow down large workbooks and how to optimize it A few related formulas I might want to use next for similar tasks Explain each part in simple, step-by-step instructions that a beginner can follow. My problem: [Describe what you want the formula to do, your column names/letters, sample data, and the final result you need]

登录以查看完整提示词

继续使用:

登录即表示你同意我们的 使用条款 隐私政策

用法

此提示词专为 productivity 设计。复制上方内容并粘贴到你常用的 AI 工具中。

为获得最佳效果,可将占位符(方括号或大写字母标示)替换为你的具体需求。

参考资料

分类:productivity| twitter| excel| formula

讨论