{"id":864,"date":"2026-08-07T09:52:45","date_gmt":"2026-08-07T12:52:45","guid":{"rendered":"https:\/\/prompteiro.com\/zh\/prompt\/ma-shang-neng-yong-de-biao-ge-gong-shi\/"},"modified":"2026-08-07T11:35:53","modified_gmt":"2026-08-07T14:35:53","slug":"ma-shang-neng-yong-de-biao-ge-gong-shi","status":"publish","type":"prompt","link":"https:\/\/prompteiro.com\/zh\/prompt\/ma-shang-neng-yong-de-biao-ge-gong-shi\/","title":{"rendered":"\u9a6c\u4e0a\u80fd\u7528\u7684\u8868\u683c\u516c\u5f0f"},"featured_media":938,"template":"","meta":{"_titulo_seo":"\u7528 AI \u62ff\u5230\u4f60\u9700\u8981\u7684\u8868\u683c\u516c\u5f0f","_prompt_text":"\u8bf7\u626e\u6f14\u4e00\u4f4d Excel \u548c Google Sheets \u4e13\u5bb6\uff0c\u628a\u65e5\u5e38\u8bed\u8a00\u7ffb\u8bd1\u6210\u516c\u5f0f\u3002\u8bf7\u7ed9\u6211\u9700\u8981\u7684\u90a3\u6761\u516c\u5f0f\uff0c\u53ef\u4ee5\u76f4\u63a5\u7528\uff0c\u8003\u8651\u4ee5\u4e0b\u6761\u4ef6\uff1a\n\n- \u6211\u60f3\u505a\u7684\u4e8b\uff1a[\u7528\u5927\u767d\u8bdd\u5199\u3002\u4f8b\uff1a\u53ea\u6709\u5f53 B \u5217\u662f\u300c\u5df2\u4ed8\u6b3e\u300d\u65f6\uff0c\u624d\u628a C \u5217\u7684\u503c\u52a0\u8d77\u6765]\n- \u8f6f\u4ef6\uff1a[Excel \u8fd8\u662f Google Sheets]\n- \u6211\u7684\u6570\u636e\u5728\u54ea\uff1a[\u4f8b\uff1a\u503c\u5728 C2:C100\uff0c\u72b6\u6001\u5728 B2:B100]\n- \u8f6f\u4ef6\u8bed\u8a00\uff1a[\u4e2d\u6587\u7248\u8fd8\u662f\u82f1\u6587\u7248\u2014\u2014\u51fd\u6570\u540d\u53ef\u80fd\u4e0d\u4e00\u6837]\n\n\u89c4\u5219\uff1a\n1. \u7ed9\u51fa\u53ef\u4ee5\u76f4\u63a5\u7c98\u8d34\u7684\u516c\u5f0f\uff0c\u628a\u6211\u8bf4\u7684\u5355\u5143\u683c\u5df2\u7ecf\u586b\u8fdb\u53bb\u3002\n2. \u7528\u4e00\u4e24\u884c\u89e3\u91ca\u6bcf\u4e2a\u90e8\u5206\u5728\u505a\u4ec0\u4e48\uff0c\u597d\u8ba9\u6211\u5b66\u4f1a\u4e3e\u4e00\u53cd\u4e09\u3002\n3. \u5982\u679c\u6709\u66f4\u597d\u6216\u66f4\u65b0\u7684\u505a\u6cd5\uff0c\u544a\u8bc9\u6211\uff08\u4f8b\uff1aSUMIF \u548c SUMIFS\u3001XLOOKUP \u548c VLOOKUP\uff09\u3002\n4. \u63d0\u524d\u6321\u6389\u4e00\u4e2a\u5e38\u89c1\u9519\u8bef\uff08\u4f8b\uff1a\u5206\u9694\u7b26\u7528\u5206\u53f7\u8fd8\u662f\u9017\u53f7\u3001\u7528 $ \u9501\u5b9a\u7684\u5f15\u7528\uff09\uff0c\u5e76\u8bf4\u660e\u600e\u4e48\u907f\u5f00\u3002\n\n\u56de\u7b54\u683c\u5f0f\uff1a\u628a\u516c\u5f0f\u7a81\u51fa\u663e\u793a\uff0c\u52a0\u7b80\u77ed\u89e3\u91ca\u3001\u53ef\u9009\u7684\u66ff\u4ee3\u7248\u672c\uff0c\u4ee5\u53ca\u5173\u4e8e\u90a3\u4e2a\u5e38\u89c1\u9519\u8bef\u7684\u63d0\u9192\u3002","_como_usar":"\u590d\u5236\u63d0\u793a\u8bcd\uff0c\u7c98\u8d34\u5230 ChatGPT\u3001Claude \u6216 Gemini\uff0c\u7528\u5927\u767d\u8bdd\u5199\u6e05\u4f60\u60f3\u8ba9\u8868\u683c\u505a\u4ec0\u4e48\uff0c\u518d\u8bf4\u660e\u6570\u636e\u5728\u54ea\u3002\u51fa\u6765\u7684\u662f\u53ef\u4ee5\u76f4\u63a5\u7c98\u8d34\u7684\u516c\u5f0f\uff0c\u5916\u52a0\u6bcf\u4e2a\u90e8\u5206\u7684\u7b80\u77ed\u89e3\u91ca\u2014\u2014\u6b63\u662f\u8fd9\u4e2a\u89e3\u91ca\uff0c\u8ba9\u4f60\u4e0b\u6b21\u4e0d\u7528\u518d\u95ee\u5c31\u80fd\u81ea\u5df1\u6539\u3002\n\n\u5982\u679c\u62a5\u9519\u4e86\uff0c\u5c31\u628a\u62a5\u9519\u539f\u6837\u8d34\u56de\u540c\u4e00\u4e2a\u5bf9\u8bdd\uff1aAI \u901a\u5e38\u80fd\u63ea\u51fa\u5206\u9694\u7b26\u3001\u9501\u5b9a\u7684\u5f15\u7528\u6216\u8005\u9009\u9519\u7684\u533a\u57df\u3002\u4e24\u4e2a\u8f6f\u4ef6\u90fd\u7528\u7684\u8bdd\uff0c\u5c31\u8981\u4e00\u4efd Excel \u7248\u548c\u4e00\u4efd Google Sheets \u7248\u3002","_views":59,"_likes":0,"_nota_sum":0,"_nota_count":0,"_nota_avg":0,"_nota_weight":0,"_i18n_grupo":391},"macro":[3],"subcategoria":[9],"prompt_tag":[940,945,943,955],"ferramenta":[13,14,15],"class_list":["post-864","prompt","type-prompt","status-publish","has-post-thumbnail","hentry","macro-wen-ben","subcategoria-xiao-lv","prompt_tag-excel","prompt_tag-google-sheets","prompt_tag-gong-shi","prompt_tag-dian-zi-biao-ge","ferramenta-chatgpt","ferramenta-claude","ferramenta-gemini"],"_links":{"self":[{"href":"https:\/\/prompteiro.com\/zh\/wp-json\/wp\/v2\/prompt\/864","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prompteiro.com\/zh\/wp-json\/wp\/v2\/prompt"}],"about":[{"href":"https:\/\/prompteiro.com\/zh\/wp-json\/wp\/v2\/types\/prompt"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prompteiro.com\/zh\/wp-json\/wp\/v2\/media\/938"}],"wp:attachment":[{"href":"https:\/\/prompteiro.com\/zh\/wp-json\/wp\/v2\/media?parent=864"}],"wp:term":[{"taxonomy":"macro","embeddable":true,"href":"https:\/\/prompteiro.com\/zh\/wp-json\/wp\/v2\/macro?post=864"},{"taxonomy":"subcategoria","embeddable":true,"href":"https:\/\/prompteiro.com\/zh\/wp-json\/wp\/v2\/subcategoria?post=864"},{"taxonomy":"prompt_tag","embeddable":true,"href":"https:\/\/prompteiro.com\/zh\/wp-json\/wp\/v2\/prompt_tag?post=864"},{"taxonomy":"ferramenta","embeddable":true,"href":"https:\/\/prompteiro.com\/zh\/wp-json\/wp\/v2\/ferramenta?post=864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}