{"id":1334,"date":"2026-03-12T16:26:05","date_gmt":"2026-03-12T08:26:05","guid":{"rendered":"https:\/\/iweb20wp-b205b.url.tku.edu.tw\/ipc\/?post_type=tkuisotope&p=1334"},"modified":"2026-03-12T16:26:06","modified_gmt":"2026-03-12T08:26:06","slug":"%e6%aa%a2%e9%80%81%e3%80%8c%ef%bc%88%e8%aa%b2%e7%a8%8b%e4%bb%a3%e8%99%9f%ef%bc%9axlsx-102%ef%bc%89excel%e8%aa%b2%e7%a8%8b-power-query%e3%80%8d%e9%96%8b%e8%aa%b2%e9%80%9a%e7%9f%a5","status":"publish","type":"tkuisotope","link":"\/ipc\/?tkuisotope=%e6%aa%a2%e9%80%81%e3%80%8c%ef%bc%88%e8%aa%b2%e7%a8%8b%e4%bb%a3%e8%99%9f%ef%bc%9axlsx-102%ef%bc%89excel%e8%aa%b2%e7%a8%8b-power-query%e3%80%8d%e9%96%8b%e8%aa%b2%e9%80%9a%e7%9f%a5","title":{"rendered":"\u6aa2\u9001\u300c\uff08\u8ab2\u7a0b\u4ee3\u865f\uff1aXLSX-102\uff09Excel\u8ab2\u7a0b\u2014Power Query\u300d\u958b\u8ab2\u901a\u77e5"},"content":{"rendered":"\n

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

\u3000\u4e00\u3001Excel \u88e1\u8d85\u5be6\u7528\u7684 Power Query \u5de5\u5177\uff0c\u5f9e\u6e05\u9664\u91cd\u8907\u503c\u3001\u8655\u7406\u7a7a\u767d\u6b04\u4f4d\uff0c\u5230\u7d71\u4e00<\/p>\n\n\n\n

\u3000\u3000\u3000\u683c\u5f0f\u3001\u8f49\u63db\u6b04\u4f4d\u540d\u7a31\uff0c\u5168\u90fd\u53ef\u4ee5\u4e00\u6b21\u8a2d\u5b9a\u3001\u81ea\u52d5\u5b8c\u6210\u3002\u518d\u4e5f\u4e0d\u7528\u4e00\u5f35\u8868\u4e00\u5f35\u8868\u5730<\/p>\n\n\n\n

\u3000\u3000\u3000\u6162\u6162\u6bd4\u5c0d\u8cc7\u6599\uff0cPower Query \u80fd\u5e6b\u4f60\u5f48\u6027\u6574\u5408\u591a\u5f35\u8cc7\u6599\u8868\uff0c\u4e0d\u8ad6\u662f\u5408\u4f75\u4e0d\u540c\u4f86\u6e90\uff0c<\/p>\n\n\n\n

\u3000\u3000\u3000\u9084\u662f\u5f59\u6574\u7d50\u69cb\u76f8\u540c\u7684\u5831\u8868\uff0c\u90fd\u80fd\u8f15\u9b06\u641e\u5b9a\uff0c\u6548\u7387\u5927\u63d0\u5347\uff01<\/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\u3001Power Query \u4ecb\u7d39\u8207\u64cd\u4f5c\u4ecb\u9762<\/p>\n\n\n\n

\u3000\u3000\u3000\u3000\uff12\u3001\u8cc7\u6599\u6e05\u7406\u6280\u5de7\uff1a\u7be9\u9078\u3001\u683c\u5f0f\u8f49\u63db\u3001\u6b04\u4f4d\u62c6\u5206\u8207\u5408\u4f75<\/p>\n\n\n\n

\u3000\u3000\u3000\u3000\uff13\u3001\u5408\u4f75\u67e5\u8a62\uff1a\u505a\u8cc7\u6599\u4e4b\u9593\u7684\u4ea4\u96c6\u3001\u806f\u96c6\u3001\u5dee\u96c6\u7684\u6bd4\u5c0d2\u5f35\u8868\u683c\u8cc7\u6599<\/p>\n\n\n\n

\u3000\u3000\u3000\u3000\uff14\u3001\u9644\u52a0\u67e5\u8a62\uff1a\u591a\u5f35\u7d50\u69cb\u76f8\u540c\u8868\u683c\u7684\u8cc7\u6599\u5f59\u6574<\/p>\n\n\n\n

\u3000\u3000\uff08\u4e8c\uff09\u4e0a\u8ab2\u6642\u9593\uff1a114 \u5e74 5 \u6708 14 \u65e5\uff08\u9031\u4e09\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=FKQX20250514<\/a><\/p>\n\n\n\n

\u3000\u4e09\u3001\u6388\u8ab2\u8001\u5e2b\uff1a\u7d71\u8a08\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\u53c3\u52a0\uff0c\u5efa\u8b70\u5177\u5099Excel\u521d\u968e\u80fd\u529b\u8005\u70ba\u4f73\u3002<\/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":6,"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":"\u9673\u9e97\u5a77","author_link":"\/ipc\/?author=6"},"uagb_comment_info":0,"uagb_excerpt":"\u8aaa\u660e\uff1a \u3000\u4e00\u3001Excel \u88e1\u8d85\u5be6\u7528\u7684 Power Query \u5de5\u5177\uff0c\u5f9e\u6e05\u9664\u91cd\u8907\u503c\u3001\u8655\u7406\u7a7a\u767d\u6b04\u4f4d\uff0c\u5230\u7d71\u4e00 \u3000\u3000\u3000\u683c\u5f0f\u3001\u8f49\u63db\u6b04\u4f4d\u540d\u7a31\uff0c\u5168\u90fd\u53ef\u4ee5\u4e00\u6b21\u8a2d\u5b9a\u3001\u81ea\u52d5\u5b8c\u6210\u3002\u518d\u4e5f\u4e0d\u7528\u4e00\u5f35\u8868\u4e00\u5f35\u8868\u5730 \u3000\u3000\u3000\u6162\u6162\u6bd4\u5c0d\u8cc7\u6599\uff0cPower Query \u80fd\u5e6b\u4f60\u5f48\u6027\u6574\u5408\u591a\u5f35\u8cc7\u6599\u8868\uff0c\u4e0d\u8ad6\u662f\u5408\u4f75\u4e0d\u540c\u4f86\u6e90\uff0c \u3000\u3000\u3000\u9084\u662f\u5f59\u6574\u7d50\u69cb\u76f8\u540c\u7684\u5831\u8868\uff0c\u90fd\u80fd\u8f15\u9b06\u641e\u5b9a\uff0c\u6548\u7387\u5927\u63d0\u5347\uff01 \u3000\u4e8c\u3001\u8ab2\u7a0b\u8cc7\u8a0a \u3000\u3000\uff08\u4e00\uff09\u5927\u7db1\uff1a \u3000\u3000\u3000\u3000\uff11\u3001Power Query \u4ecb\u7d39\u8207\u64cd\u4f5c\u4ecb\u9762 \u3000\u3000\u3000\u3000\uff12\u3001\u8cc7\u6599\u6e05\u7406\u6280\u5de7\uff1a\u7be9\u9078\u3001\u683c\u5f0f\u8f49\u63db\u3001\u6b04\u4f4d\u62c6\u5206\u8207\u5408\u4f75 \u3000\u3000\u3000\u3000\uff13\u3001\u5408\u4f75\u67e5\u8a62\uff1a\u505a\u8cc7\u6599\u4e4b\u9593\u7684\u4ea4\u96c6\u3001\u806f\u96c6\u3001\u5dee\u96c6\u7684\u6bd4\u5c0d2\u5f35\u8868\u683c\u8cc7\u6599 \u3000\u3000\u3000\u3000\uff14\u3001\u9644\u52a0\u67e5\u8a62\uff1a\u591a\u5f35\u7d50\u69cb\u76f8\u540c\u8868\u683c\u7684\u8cc7\u6599\u5f59\u6574 \u3000\u3000\uff08\u4e8c\uff09\u4e0a\u8ab2\u6642\u9593\uff1a114 \u5e74 5 \u6708 14 \u65e5\uff08\u9031\u4e09\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=FKQX20250514 \u3000\u4e09\u3001\u6388\u8ab2\u8001\u5e2b\uff1a\u7d71\u8a08\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\u53c3\u52a0\uff0c\u5efa\u8b70\u5177\u5099Excel\u521d\u968e\u80fd\u529b\u8005\u70ba\u4f73\u3002 \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\/1334"}],"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\/6"}],"wp:attachment":[{"href":"\/ipc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/ipc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1334"},{"taxonomy":"post_tag","embeddable":true,"href":"\/ipc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}