{"id":624,"date":"2026-03-02T16:15:53","date_gmt":"2026-03-02T08:15:53","guid":{"rendered":"https:\/\/iweb20wp-b205b.url.tku.edu.tw\/ipc\/?post_type=tkuisotope&p=624"},"modified":"2026-03-02T16:15:53","modified_gmt":"2026-03-02T08:15:53","slug":"%e6%aa%a2%e9%80%81%e3%80%8c%e8%aa%b2%e7%a8%8b%e4%bb%a3%e8%99%9f%ef%bc%9axlsx-103-excel-%e5%a0%b1%e8%a1%a8%e8%ae%8a%e7%b0%a1%e5%96%ae%ef%bc%9a3-%e5%b0%8f%e6%99%82%e5%ad%b8%e6%9c%83%e6%9c%80%e5%bc%b7-2","status":"publish","type":"tkuisotope","link":"\/ipc\/?tkuisotope=%e6%aa%a2%e9%80%81%e3%80%8c%e8%aa%b2%e7%a8%8b%e4%bb%a3%e8%99%9f%ef%bc%9axlsx-103-excel-%e5%a0%b1%e8%a1%a8%e8%ae%8a%e7%b0%a1%e5%96%ae%ef%bc%9a3-%e5%b0%8f%e6%99%82%e5%ad%b8%e6%9c%83%e6%9c%80%e5%bc%b7-2","title":{"rendered":"\u6aa2\u9001\u300c(\u8ab2\u7a0b\u4ee3\u865f\uff1aXLSX-103) Excel \u5831\u8868\u8b8a\u7c21\u55ae\uff1a3 \u5c0f\u6642\u5b78\u6703\u6700\u5f37\u65b0\u51fd\u6578\u300d\u958b\u8ab2\u901a\u77e5\u3002"},"content":{"rendered":"\n

\u8aaa\u660e\uff1a<\/p>\n\n\n\n

\u3000\u4e00\u3001\u8ab2\u7a0b\u7279\u8272\uff1a<\/p>\n\n\n\n

\u3000\u3000\u3000\u7528\u66f4\u76f4\u89ba\u7684\u65b0\u51fd\u6578\uff0c\u53d6\u4ee3\u4ee5\u524d\u8907\u96dc\u7684\u516c\u5f0f\u3002\u4e0d\u7528\u5beb\u9577\u4e32\u908f\u8f2f\uff0c\u5c31\u80fd\u81ea\u52d5\u62c6\u89e3\u6587\u5b57\u3001<\/p>\n\n\n\n

\u3000\u3000\u3000\u5feb\u901f\u6574\u7406\u91cd\u8907\u8cc7\u6599\uff0c\u4e26\u5b8c\u6210\u81ea\u52d5\u5316\u7684\u5831\u8868\u7be9\u9078\u8207\u641c\u5c0b\uff0c\u8b93 Excel \u5e6b\u4f60\u8f15\u9b06\u8655\u7406<\/p>\n\n\n\n

\u3000\u3000\u3000\u96dc\u4e8b\u3002<\/p>\n\n\n\n

\u3000\u4e8c\u3001\u8ab2\u7a0b\u8cc7\u8a0a<\/p>\n\n\n\n

\u3000\u3000\uff08\u4e00\uff09\u5927\u7db1\uff1a<\/p>\n\n\n\n

\u3000\u3000\u3000\u3000\uff11\u3001\u4f7f\u7528 TEXT \u7cfb\u5217\u51fd\u6578\uff0c\u8f15\u9b06\u62c6\u5206\u8207\u63d0\u53d6\u6587\u5b57\u8cc7\u6599\u3002<\/p>\n\n\n\n

\u3000\u3000\u3000\u3000\uff12\u3001\u900f\u904e FILTER \u8207 UNIQUE\uff0c\u81ea\u52d5\u7be9\u9078\u4e26\u5217\u51fa\u4e0d\u91cd\u8907\u540d\u55ae\u3002<\/p>\n\n\n\n

\u3000\u3000\u3000\u3000\uff13\u3001\u5229\u7528 SORT \u7cfb\u5217\u51fd\u6578\uff0c\u8b93\u8cc7\u6599\u6839\u64da\u9700\u6c42\u81ea\u52d5\u5b8c\u6210\u6392\u5e8f\u3002<\/p>\n\n\n\n

\u3000\u3000\u3000\u3000\uff14\u3001\u5b78\u7fd2 XLOOKUP \u842c\u80fd\u67e5\u8a62\uff0c\u5feb\u901f\u627e\u5c0b\u5c0d\u61c9\u7684\u6b63\u78ba\u6578\u503c\u3002<\/p>\n\n\n\n

\u3000\u3000\u3000\u3000\uff15\u3001\u904b\u7528 SEQUENCE \u8207\u96a8\u6a5f\u51fd\u6578\uff0c\u81ea\u52d5\u751f\u6210\u7de8\u865f\u8207\u6e2c\u8a66\u6578\u64da\u3002<\/p>\n\n\n\n

\u3000\u3000\uff08\u4e8c\uff09\u4e0a\u8ab2\u6642\u9593\uff1a115 \u5e74 1 \u6708 8 \u65e5\uff08\u9031\u56db\uff09\u4e0a\u5348 9 \u6642\u81f3\u4e2d\u5348 12 \u6642<\/p>\n\n\n\n

\u3000\u3000\uff08\u4e09\uff09\u4e0a\u8ab2\u5730\u9ede\uff1a\u6de1\u6c34\u6821\u5712\u5546\u7ba1\u5927\u6a13 B206 \u96fb\u8166\u6559\u5ba4<\/p>\n\n\n\n

\u3000\u3000\uff08\u56db\uff09\u5831\u540d\u7db2\u5740\uff1ahttp:\/\/enroll.tku.edu.tw\/course.aspx?cid=XLSX-103-20260108<\/a><\/p>\n\n\n\n

\u3000\u4e09\u3001\u6388\u8ab2\u8001\u5e2b\uff1a\u7d71\u8a08\u8207\u8cc7\u6599\u79d1\u5b78\u5b78\u7cfb\u3000\u5289\u6587\u7407\u8001\u5e2b<\/p>\n\n\n\n

\u3000\u56db\u3001\u4e0a\u8ab2\u5c0d\u8c61\uff1a\u6b61\u8fce\u6709\u8208\u8da3\u4e4b\u6559\u8077\u54e1\u5831\u540d\u53c3\u52a0<\/p>\n\n\n\n

\u3000\u4e94\u3001\u4e0a\u8ab2\u524d\u8acb\u52d9\u5fc5\u78ba\u8a8d o365 \u5e33\u865f\uff08\u4eba\u54e1\u4ee3\u865f@o365.tku.edu.tw<\/a>\uff09 \u53ca\u5bc6\u78bc\u53ef\u767b\u5165<\/p>\n\n\n\n

\u3000\u3000\u3000\u4f7f\u7528\uff0c\u8ab2\u7a0b\u4e2d\u5c07\u4e0d\u518d\u5354\u52a9\u89e3\u6c7a\u5e33\u865f\u5bc6\u78bc\u554f\u984c\uff0c\u5e33\u865f\u82e5\u6709\u554f\u984c\u8acb\u5148\u6d3d\u8cc7\u8a0a\u8655<\/p>\n\n\n\n

\u3000\u3000\u3000\u670d\u52d9\u53f0\uff08\u5206\u6a5f\uff1a2468\uff09\u3002<\/p>\n\n\n\n

\u3000\u516d\u3001\u8acb\u53c3\u52a0\u540c\u4ec1\u651c\u5e36\u624b\u6a5f\u8fa6\u7406 iPass \u5831\u5230\u3002<\/p>\n\n\n\n

\u3000\u4e03\u3001\u672c\u6d3b\u52d5\u8207 SDGs \u9023\u7d50\uff1aSDG4 \u512a\u8cea\u6559\u80b2\u3002<\/p>\n\n\n\n

\u3000\u516b\u3001\u9023\u7d61\u4eba\uff1a\u6559\u5b78\u652f\u63f4\u7d44\u3000\u9673\u9e97\u5a77\uff0c\u5206\u6a5f\uff1a2654\u3002<\/p>\n\n\n\n

\u8cc7\u8a0a\u9577\u3000\u77f3\u3000\u8cb4\u3000\u5e73<\/p>\n","protected":false},"author":4,"template":"wp-custom-template-detail-4-post","meta":{"_uag_custom_page_level_css":""},"categories":[7],"tags":[],"acf":[],"uagb_featured_image_src":[],"uagb_author_info":{"display_name":"\u5f35\u6dd1\u7f8e","author_link":"\/ipc\/?author=4"},"uagb_comment_info":0,"uagb_excerpt":"\u8aaa\u660e\uff1a \u3000\u4e00\u3001\u8ab2\u7a0b\u7279\u8272\uff1a \u3000\u3000\u3000\u7528\u66f4\u76f4\u89ba\u7684\u65b0\u51fd\u6578\uff0c\u53d6\u4ee3\u4ee5\u524d\u8907\u96dc\u7684\u516c\u5f0f\u3002\u4e0d\u7528\u5beb\u9577\u4e32\u908f\u8f2f\uff0c\u5c31\u80fd\u81ea\u52d5\u62c6\u89e3\u6587\u5b57\u3001 \u3000\u3000\u3000\u5feb\u901f\u6574\u7406\u91cd\u8907\u8cc7\u6599\uff0c\u4e26\u5b8c\u6210\u81ea\u52d5\u5316\u7684\u5831\u8868\u7be9\u9078\u8207\u641c\u5c0b\uff0c\u8b93 Excel \u5e6b\u4f60\u8f15\u9b06\u8655\u7406 \u3000\u3000\u3000\u96dc\u4e8b\u3002 \u3000\u4e8c\u3001\u8ab2\u7a0b\u8cc7\u8a0a \u3000\u3000\uff08\u4e00\uff09\u5927\u7db1\uff1a \u3000\u3000\u3000\u3000\uff11\u3001\u4f7f\u7528 TEXT \u7cfb\u5217\u51fd\u6578\uff0c\u8f15\u9b06\u62c6\u5206\u8207\u63d0\u53d6\u6587\u5b57\u8cc7\u6599\u3002 \u3000\u3000\u3000\u3000\uff12\u3001\u900f\u904e FILTER \u8207 UNIQUE\uff0c\u81ea\u52d5\u7be9\u9078\u4e26\u5217\u51fa\u4e0d\u91cd\u8907\u540d\u55ae\u3002 \u3000\u3000\u3000\u3000\uff13\u3001\u5229\u7528 SORT \u7cfb\u5217\u51fd\u6578\uff0c\u8b93\u8cc7\u6599\u6839\u64da\u9700\u6c42\u81ea\u52d5\u5b8c\u6210\u6392\u5e8f\u3002 \u3000\u3000\u3000\u3000\uff14\u3001\u5b78\u7fd2 XLOOKUP \u842c\u80fd\u67e5\u8a62\uff0c\u5feb\u901f\u627e\u5c0b\u5c0d\u61c9\u7684\u6b63\u78ba\u6578\u503c\u3002 \u3000\u3000\u3000\u3000\uff15\u3001\u904b\u7528 SEQUENCE \u8207\u96a8\u6a5f\u51fd\u6578\uff0c\u81ea\u52d5\u751f\u6210\u7de8\u865f\u8207\u6e2c\u8a66\u6578\u64da\u3002 \u3000\u3000\uff08\u4e8c\uff09\u4e0a\u8ab2\u6642\u9593\uff1a115 \u5e74 1 \u6708 8 \u65e5\uff08\u9031\u56db\uff09\u4e0a\u5348 9 \u6642\u81f3\u4e2d\u5348 12 \u6642 \u3000\u3000\uff08\u4e09\uff09\u4e0a\u8ab2\u5730\u9ede\uff1a\u6de1\u6c34\u6821\u5712\u5546\u7ba1\u5927\u6a13 B206 \u96fb\u8166\u6559\u5ba4 \u3000\u3000\uff08\u56db\uff09\u5831\u540d\u7db2\u5740\uff1ahttp:\/\/enroll.tku.edu.tw\/course.aspx?cid=XLSX-103-20260108 \u3000\u4e09\u3001\u6388\u8ab2\u8001\u5e2b\uff1a\u7d71\u8a08\u8207\u8cc7\u6599\u79d1\u5b78\u5b78\u7cfb\u3000\u5289\u6587\u7407\u8001\u5e2b \u3000\u56db\u3001\u4e0a\u8ab2\u5c0d\u8c61\uff1a\u6b61\u8fce\u6709\u8208\u8da3\u4e4b\u6559\u8077\u54e1\u5831\u540d\u53c3\u52a0 \u3000\u4e94\u3001\u4e0a\u8ab2\u524d\u8acb\u52d9\u5fc5\u78ba\u8a8d o365 \u5e33\u865f\uff08\u4eba\u54e1\u4ee3\u865f@o365.tku.edu.tw\uff09 \u53ca\u5bc6\u78bc\u53ef\u767b\u5165 \u3000\u3000\u3000\u4f7f\u7528\uff0c\u8ab2\u7a0b\u4e2d\u5c07\u4e0d\u518d\u5354\u52a9\u89e3\u6c7a\u5e33\u865f\u5bc6\u78bc\u554f\u984c\uff0c\u5e33\u865f\u82e5\u6709\u554f\u984c\u8acb\u5148\u6d3d\u8cc7\u8a0a\u8655 \u3000\u3000\u3000\u670d\u52d9\u53f0\uff08\u5206\u6a5f\uff1a2468\uff09\u3002 \u3000\u516d\u3001\u8acb\u53c3\u52a0\u540c\u4ec1\u651c\u5e36\u624b\u6a5f\u8fa6\u7406 iPass \u5831\u5230\u3002 \u3000\u4e03\u3001\u672c\u6d3b\u52d5\u8207 SDGs \u9023\u7d50\uff1aSDG4 \u512a\u8cea\u6559\u80b2\u3002 \u3000\u516b\u3001\u9023\u7d61\u4eba\uff1a\u6559\u5b78\u652f\u63f4\u7d44\u3000\u9673\u9e97\u5a77\uff0c\u5206\u6a5f\uff1a2654\u3002 \u8cc7\u8a0a\u9577\u3000\u77f3\u3000\u8cb4\u3000\u5e73","_links":{"self":[{"href":"\/ipc\/index.php?rest_route=\/wp\/v2\/tkuisotope\/624"}],"collection":[{"href":"\/ipc\/index.php?rest_route=\/wp\/v2\/tkuisotope"}],"about":[{"href":"\/ipc\/index.php?rest_route=\/wp\/v2\/types\/tkuisotope"}],"author":[{"embeddable":true,"href":"\/ipc\/index.php?rest_route=\/wp\/v2\/users\/4"}],"wp:attachment":[{"href":"\/ipc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=624"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/ipc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=624"},{"taxonomy":"post_tag","embeddable":true,"href":"\/ipc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}