{"id":768,"date":"2026-03-19T03:58:16","date_gmt":"2026-03-19T03:58:16","guid":{"rendered":"https:\/\/yuanstore.tw\/e-learning\/?p=768"},"modified":"2026-04-28T13:36:16","modified_gmt":"2026-04-28T13:36:16","slug":"tqc-excel-308","status":"publish","type":"post","link":"https:\/\/yuanstore.tw\/e-learning\/tqc-excel-308\/","title":{"rendered":"TQC Excel 308"},"content":{"rendered":"\n<div class=\"wp-block-uagb-advanced-heading uagb-block-d23b3674\"><h2 class=\"uagb-heading-text\">\u92b7\u552e\u8a02\u55ae\u7d71\u8a08\u8868<\/h2><\/div>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-754248f9\"><h3 class=\"uagb-heading-text\">1\u3001<\/h3><\/div>\n\n\n\n<ul class=\"wp-block-list has-medium-font-size\">\n<li>\u5efa\u7acb\u540d\u7a31<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-35299840 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\/03\/308-\u5efa\u7acb\u540d\u7a31.png\" alt=\"308-\u5efa\u7acb\u540d\u7a31\" class=\"uag-image-832\" width=\"552\" height=\"432\" title=\"308-\u5efa\u7acb\u540d\u7a31\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list has-medium-font-size\">\n<li class=\"has-medium-font-size\">\u8a02\u55ae\u7de8\u865f = TEXT(\u4ea4\u6613\u65e5\u671f,&#8221;yyyy-mm-&#8220;) &amp; \u6d41\u6c34\u865f<\/li>\n\n\n\n<li>\u6210\u672c = =VLOOKUP(\u54c1\u540d,\u7522\u54c1,3,FALSE)<\/li>\n\n\n\n<li>\u6210\u672c\u7e3d\u503c = SUMIF(\u54c1\u540d,A4,\u6578\u91cf)<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-52315614 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\/03\/308-\u7e3d\u92b7\u552e\u6578\u91cf.png\" alt=\"308-\u7e3d\u92b7\u552e\u6578\u91cf\" class=\"uag-image-843\" width=\"259\" height=\"189\" title=\"308-\u7e3d\u92b7\u552e\u6578\u91cf\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5b50\u6bcd\u5716<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-beef2b21 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\/03\/308-\u7b2c\u4e8c\u5340.png\" alt=\"308-\u7b2c\u4e8c\u5340\" class=\"uag-image-846\" width=\"261\" height=\"387\" title=\"308-\u7b2c\u4e8c\u5340\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-5693c929\"><h3 class=\"uagb-heading-text\">2\u3001\u89e3\u984c\u53c3\u8003\uff1a<a href=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/03\/308.xlsx\" data-type=\"attachment\" data-id=\"849\">308<\/a><\/h3><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u92b7\u552e\u8a02\u55ae\u7d71\u8a08\u8868<\/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-768","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":"\u92b7\u552e\u8a02\u55ae\u7d71\u8a08\u8868","_links":{"self":[{"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/posts\/768","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=768"}],"version-history":[{"count":14,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/posts\/768\/revisions"}],"predecessor-version":[{"id":1978,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/posts\/768\/revisions\/1978"}],"wp:attachment":[{"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/media?parent=768"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/categories?post=768"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/tags?post=768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}