ARTICLE · 1393174
WorkBuddy Excel 数据分析:先把数据弄干净
Excel 的活分两层:一层是把数据弄干净、摆整齐,一层是把数据看出结论。很多人卡在第一层,表格还没理顺,就急着要结论,结果算出来的东西自己都不敢信。
下面按这个顺序走:先合并清洗,再让它算结论,公式单独核一遍,最后是分层分析。16 条提示词都在里面,复制过去,把方括号换成自己的内容就能用。
<a class="wx_topic_link" topic-id="mwooqzvu-mjd9gn" style="color: #576B95 !important;" data-topic="1" data-recommend="">#WorkBuddy</a> <a class="wx_topic_link" topic-id="mwoor3dk-2eoddo" style="color: #576B95 !important;" data-topic="1" data-recommend="">#ai智能体</a> <a class="wx_topic_link" topic-id="mwoor7nr-7wbcm5" style="color: #576B95 !important;" data-topic="1" data-recommend="">#ai</a> <a class="wx_topic_link" topic-id="mwoorb1s-2r05kv" style="color: #576B95 !important;" data-topic="1" data-recommend="">#办公</a> <a class="wx_topic_link" topic-id="mwoordpk-11yz9m" style="color: #576B95 !important;" data-topic="1" data-recommend="">#办公技巧</a> <a class="wx_topic_link" topic-id="mwptbsfa-vtcr8i" style="color: #576B95 !important;" data-topic="1" data-recommend="">#工作台</a> <a class="wx_topic_link" topic-id="mwptbsfa-l0r0j8" style="color: #576B95 !important;" data-topic="1" data-recommend="">#知识库</a> <a class="wx_topic_link" topic-id="mwptbsfa-2eta6e" style="color: #576B95 !important;" data-topic="1" data-recommend="">#网站</a> <a class="wx_topic_link" topic-id="mwptbsfa-k38z7a" style="color: #576B95 !important;" data-topic="1" data-recommend="">#职场</a> <a class="wx_topic_link" topic-id="mwptbsfa-ghtpzt" style="color: #576B95 !important;" data-topic="1" data-recommend="">#工具</a> <a class="wx_topic_link" topic-id="mwptbsfa-ql2qu9" style="color: #576B95 !important;" data-topic="1" data-recommend="">#workbuddy生成网站</a> <a class="wx_topic_link" topic-id="mwptbsfa-ud9bvf" style="color: #576B95 !important;" data-topic="1" data-recommend="">#workbuddy</a> <a class="wx_topic_link" topic-id="mwptbsfa-blahes" style="color: #576B95 !important;" data-topic="1" data-recommend="">#workbuddy教程</a> <a class="wx_topic_link" topic-id="mwptbsfa-mtnwvp" style="color: #576B95 !important;" data-topic="1" data-recommend="">#AI工具</a> <a class="wx_topic_link" topic-id="mwptbsfa-zqhux2" style="color: #576B95 !important;" data-topic="1" data-recommend="">#提升职场技能</a> <a class="wx_topic_link" topic-id="mwptbsfa-8oreg4" style="color: #576B95 !important;" data-topic="1" data-recommend="">#从入门到精通</a> <a class="wx_topic_link" topic-id="mwptbsfa-be3sz7" style="color: #576B95 !important;" data-topic="1" data-recommend="">#新手入门</a> <a class="wx_topic_link" topic-id="mwptbsfa-ftoo63" style="color: #576B95 !important;" data-topic="1" data-recommend="">#ai学习手册</a>















































































