{"id":1829,"date":"2026-04-24T09:19:51","date_gmt":"2026-04-24T09:19:51","guid":{"rendered":"https:\/\/yuanstore.tw\/e-learning\/?p=1829"},"modified":"2026-05-01T02:50:48","modified_gmt":"2026-05-01T02:50:48","slug":"tqc-excel-502","status":"publish","type":"post","link":"https:\/\/yuanstore.tw\/e-learning\/tqc-excel-502\/","title":{"rendered":"TQC Excel 502"},"content":{"rendered":"\n<div class=\"wp-block-uagb-advanced-heading uagb-block-d23b3674\"><h3 class=\"uagb-heading-text\">\u571f\u6728\u5de5\u7a0b\u5b78\u6703\u6703\u54e1\u8cc7\u6599<\/h3><\/div>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-c58dcada\"><h4 class=\"uagb-heading-text\">1.\u4f7f\u7528Excel\u958b\u555f\u820a\u6a94<\/h4><\/div>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-4f7c77f9 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/502-1.png\" alt=\"\" class=\"uag-image-1837\" width=\"597\" height=\"499\" title=\"502-1\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-f30dca08\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-e4a3b530\"><h4 class=\"uagb-heading-text\">3-1.\u5c0b\u627e\u53d6\u4ee3<\/h4><\/div>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-7601b5a9 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/502-2.png\" alt=\"\" class=\"uag-image-1838\" width=\"457\" height=\"216\" title=\"502-2\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-15e0a6a2\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-ad0c5988\"><h4 class=\"uagb-heading-text\">3-2.=IF(LEFT([@\u5730\u5740],3)=&#8221;\u65b0\u5317\u5e02&#8221;,REPLACE([@\u5730\u5740],6,1,&#8221;\u5340&#8221;),[@\u5730\u5740])<\/h4><\/div>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-91831eca wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/502-3.png\" alt=\"\" class=\"uag-image-1839\" width=\"595\" height=\"334\" title=\"502-3\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-34a557a8\"><h4 class=\"uagb-heading-text\">4.\u5c0b\u627e\u53d6\u4ee3<\/h4><\/div>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-1f64098a\"><h4 class=\"uagb-heading-text\">5.\u81ea\u8a02\u683c\u5f0f=;;;\uff0c\u5132\u5b58\u683c\u683c\u5f0f\u52fe\u9078\u96b1\u85cf<\/h4><\/div>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-5254ab1f\"><h4 class=\"uagb-heading-text\">8.\u4fdd\u8b77\u5de5\u4f5c\u8868<\/h4><\/div>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-1385cf15 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/502.png\" alt=\"\" class=\"uag-image-1836\" width=\"371\" height=\"289\" title=\"502\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-418a844d\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-cdac28cc\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-8bc12547\"><h4 class=\"uagb-heading-text\">\u53c3\u8003\u89e3\u984c\uff1a<a href=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/502.xlsx\" data-type=\"attachment\" data-id=\"1842\">502<\/a><\/h4><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u571f\u6728\u5de5\u7a0b\u5b78\u6703\u6703\u54e1\u8cc7\u6599<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[43,41],"tags":[],"class_list":["post-1829","post","type-post","status-publish","format-standard","hentry","category-tqc-excel","category-tqc"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"kungba","author_link":"https:\/\/yuanstore.tw\/e-learning\/author\/kungba\/"},"uagb_comment_info":0,"uagb_excerpt":"\u571f\u6728\u5de5\u7a0b\u5b78\u6703\u6703\u54e1\u8cc7\u6599","_links":{"self":[{"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/posts\/1829","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/comments?post=1829"}],"version-history":[{"count":6,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/posts\/1829\/revisions"}],"predecessor-version":[{"id":1989,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/posts\/1829\/revisions\/1989"}],"wp:attachment":[{"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/media?parent=1829"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/categories?post=1829"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/tags?post=1829"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}