{"id":92,"date":"2026-08-13T19:32:48","date_gmt":"2026-08-13T11:32:48","guid":{"rendered":"https:\/\/coursenest.zhiliaowp.com\/index.php\/course\/excel-office-productivity\/"},"modified":"2026-08-13T19:32:48","modified_gmt":"2026-08-13T11:32:48","slug":"excel-office-productivity","status":"publish","type":"course","link":"https:\/\/coursenest.zhiliaowp.com\/index.php\/course\/excel-office-productivity\/","title":{"rendered":"Excel \u9ad8\u6548\u529e\u516c\u4e0e\u6570\u636e\u5904\u7406"},"content":{"rendered":"<p>\u5927\u90e8\u5206\u4eba\u7528 Excel \u7684\u65b9\u5f0f\uff0c\u662f\u7528\u300c\u624b\u300d\u5728\u505a\u672c\u8be5\u8ba9\u300c\u516c\u5f0f\u300d\u505a\u7684\u4e8b\u3002\u8fd9\u95e8\u8bfe\u56f4\u7ed5\u804c\u573a\u4e09\u5927\u9ad8\u9891\u573a\u666f\u2014\u2014\u67e5\u6570\u636e\u3001\u6c47\u603b\u6570\u636e\u3001\u505a\u62a5\u8868\u2014\u2014\u628a\u6700\u6709\u7528\u7684 20% \u529f\u80fd\u8bb2\u5230\u80fd\u719f\u7ec3\u5e94\u7528\u3002<\/p>\n<p>\u51fd\u6570\u7bc7\u805a\u7126 XLOOKUP\u3001SUMIFS\u3001IF \u5d4c\u5957\u4e0e\u6587\u672c\u65e5\u671f\u5904\u7406\uff1b\u900f\u89c6\u7bc7\u4ece\u62d6\u62fd\u903b\u8f91\u8bb2\u5230\u5207\u7247\u5668\u8054\u52a8\uff1b\u56fe\u8868\u7bc7\u6559\u4f60\u505a\u51fa\u8001\u677f\u4e00\u773c\u770b\u61c2\u7684\u7ec4\u5408\u56fe\u4e0e\u52a8\u6001\u62a5\u8868\u3002<\/p>\n<p>\u6240\u6709\u6848\u4f8b\u4f7f\u7528\u540c\u4e00\u5957\u6a21\u62df\u516c\u53f8\u6570\u636e\uff0c\u7ec3\u4e60\u6587\u4ef6\u968f\u8bfe\u4e0b\u8f7d\uff0c\u5b66\u5b8c\u5373\u53ef\u76f4\u63a5\u5957\u7528\u5230\u81ea\u5df1\u7684\u5de5\u4f5c\u8868\u683c\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u51fd\u6570\u3001\u900f\u89c6\u8868\u3001\u56fe\u8868\u4e09\u5927\u4ef6\u4e00\u6b21\u8bb2\u900f\uff0c\u628a\u6bcf\u5929\u4e24\u5c0f\u65f6\u7684\u8868\u683c\u5de5\u4f5c\u538b\u7f29\u5230\u4e8c\u5341\u5206\u949f\u3002<\/p>\n","protected":false},"author":1,"featured_media":98,"comment_status":"open","ping_status":"closed","template":"","course_cat":[7],"class_list":["post-92","course","type-course","status-publish","has-post-thumbnail","hentry","course_cat-career"],"_links":{"self":[{"href":"https:\/\/coursenest.zhiliaowp.com\/index.php\/wp-json\/wp\/v2\/course\/92","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/coursenest.zhiliaowp.com\/index.php\/wp-json\/wp\/v2\/course"}],"about":[{"href":"https:\/\/coursenest.zhiliaowp.com\/index.php\/wp-json\/wp\/v2\/types\/course"}],"author":[{"embeddable":true,"href":"https:\/\/coursenest.zhiliaowp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/coursenest.zhiliaowp.com\/index.php\/wp-json\/wp\/v2\/comments?post=92"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/coursenest.zhiliaowp.com\/index.php\/wp-json\/wp\/v2\/media\/98"}],"wp:attachment":[{"href":"https:\/\/coursenest.zhiliaowp.com\/index.php\/wp-json\/wp\/v2\/media?parent=92"}],"wp:term":[{"taxonomy":"course_cat","embeddable":true,"href":"https:\/\/coursenest.zhiliaowp.com\/index.php\/wp-json\/wp\/v2\/course_cat?post=92"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}