{"id":110,"date":"2026-02-20T17:32:08","date_gmt":"2026-02-20T09:32:08","guid":{"rendered":"https:\/\/spacehk.com\/?p=59"},"modified":"2026-02-20T17:42:35","modified_gmt":"2026-02-20T09:42:35","slug":"ai-excel","status":"publish","type":"post","link":"http:\/\/www.spacehk.com\/?p=110","title":{"rendered":"AI\u5e6b\u4f60\u505aExcel\uff5c\u5514\u8b58\u516c\u5f0f\u90fd\u8b58\u7528\uff0cExcel\u65b0\u624b\u6551\u661f"},"content":{"rendered":"<p>Excel\u597d\u96e3\u5b78\uff1f\u5481\u591a\u516c\u5f0f\u8a18\u5514\u5230\uff1fAI\u53ef\u4ee5\u5e6b\u4f60\uff01\u53ea\u8981\u4f60\u8b1b\u4f4e\u60f3\u505a\u54a9\uff0cAI\u5c31\u4ffe\u689d\u516c\u5f0f\u4f60\uff0c\u8907\u88fd\u8cbc\u4e0a\u5c31\u5f97\uff0cExcel\u65b0\u624b\u90fd\u8b58\u7528\uff01<\/p>\n<h2>\u3010\u65b9\u6cd51\uff1a\u554fAI\u8981\u516c\u5f0f\u3011<\/h2>\n<p>\u6307\u4ee4\uff08\u76f4\u63a5\u8907\u88fd\uff09\uff1a<\/p>\n<blockquote style=\"background:#f5f5f5; padding:15px; border-left:4px solid #0073aa;\">\n<p>\u6211\u5605Excel\u6709A\u540cB\u5169\u6b04\uff0c\u6211\u60f3\u8a08C\u6b04\uff0cC = A * B\uff0c\u61c9\u8a72\u7528\u54a9\u516c\u5f0f\uff1f<\/p>\n<\/blockquote>\n<p>AI\u6703\u7b54\uff1a<br \/>\n\u201c\u4f60\u53ef\u4ee5\u7528 =A1*B1\uff0c\u7136\u5f8c\u5411\u4e0b\u62c9\u5c31ok\u3002\u201d<\/p>\n<h2>\u3010\u5e38\u7528Excel\u4efb\u52d9 &#8211; AI\u6307\u4ee4\u5927\u5168\u3011<\/h2>\n<h3>1. \u52a0\u7e3d<\/h3>\n<p>\u4f60\u554f\uff1a<br \/>\n\u201c\u6211\u60f3\u52a0\u7e3dA1\u5230A10\u5605\u6578\u5b57\uff0c\u7528\u54a9\u516c\u5f0f\uff1f\u201d<br \/>\nAI\u7b54\uff1a<br \/>\n\u201c=SUM(A1:A10)\u201d<\/p>\n<h3>2. \u5e73\u5747\u6578<\/h3>\n<p>\u4f60\u554f\uff1a<br \/>\n\u201c\u6211\u60f3\u8a08A1\u5230A10\u5605\u5e73\u5747\u6578\uff0c\u7528\u54a9\u516c\u5f0f\uff1f\u201d<br \/>\nAI\u7b54\uff1a<br \/>\n\u201c=AVERAGE(A1:A10)\u201d<\/p>\n<h3>3. \u689d\u4ef6\u52a0\u7e3d<\/h3>\n<p>\u4f60\u554f\uff1a<br \/>\n\u201c\u6211A\u6b04\u4fc2\u7522\u54c1\u540d\uff0cB\u6b04\u4fc2\u92b7\u91cf\uff0c\u60f3\u52a0\u7e3d&#8217;\u860b\u679c&#8217;\u5605\u92b7\u91cf\uff0c\u7528\u54a9\u516c\u5f0f\uff1f\u201d<br \/>\nAI\u7b54\uff1a<br \/>\n\u201c=SUMIF(A:A, &#8220;\u860b\u679c&#8221;, B:B)\u201d<\/p>\n<h3>4. \u5c0b\u627e\u8cc7\u6599<\/h3>\n<p>\u4f60\u554f\uff1a<br \/>\n\u201c\u6211A\u6b04\u4fc2\u54e1\u5de5\u7de8\u865f\uff0cB\u6b04\u4fc2\u54e1\u5de5\u540d\uff0cC\u6b04\u4fc2\u90e8\u9580\u3002\u6211\u60f3\u7528\u54e1\u5de5\u7de8\u865f\u6435\u8fd4\u54e1\u5de5\u540d\uff0c\u7528\u54a9\u516c\u5f0f\uff1f\u201d<br \/>\nAI\u7b54\uff1a<br \/>\n\u201c=VLOOKUP(\u8981\u6435\u5605\u7de8\u865f, A:C, 2, FALSE)\u201d<\/p>\n<h3>5. \u8a08\u65e5\u6578<\/h3>\n<p>\u4f60\u554f\uff1a<br \/>\n\u201c\u6211\u60f3\u8a08\u5169\u500b\u65e5\u671f\u4e4b\u9593\u6709\u5e7e\u591a\u65e5\uff0c\u7528\u54a9\u516c\u5f0f\uff1f\u201d<br \/>\nAI\u7b54\uff1a<br \/>\n\u201c=DATEDIF(A1, B1, &#8220;d&#8221;)\u201d<\/p>\n<h2>\u3010\u65b9\u6cd52\uff1a\u4ffe\u8cc7\u6599AI\uff0c\u53eb\u4f62\u5e6b\u4f60\u8a08\u3011<\/h2>\n<p>\u5982\u679c\u4f60\u5514\u60f3\u7528Excel\uff0c\u53ef\u4ee5\u76f4\u63a5\u4ffe\u8cc7\u6599AI\uff0c\u53eb\u4f62\u5e6b\u4f60\u8a08\uff1a<\/p>\n<blockquote style=\"background:#f5f5f5; padding:15px; border-left:4px solid #0073aa;\">\n<p>\u4ee5\u4e0b\u4fc2\u4e00\u6708\u4efd\u5605\u92b7\u552e\u6578\u64da\uff1a<br \/>\n\u860b\u679c\uff1a100\u500b\uff0c\u6bcf\u500b$5<br \/>\n\u6a59\uff1a80\u500b\uff0c\u6bcf\u500b$4<br \/>\n\u9999\u8549\uff1a120\u500b\uff0c\u6bcf\u500b$3<br \/>\n\u8acb\u5e6b\u6211\u8a08\uff1a<br \/>\n1. \u6bcf\u7a2e\u6c34\u679c\u5605\u7e3d\u92b7\u552e\u984d<br \/>\n2. \u5168\u90e8\u6c34\u679c\u5605\u7e3d\u92b7\u552e\u984d<br \/>\n3. \u5e73\u5747\u6bcf\u500b\u6c34\u679c\u5605\u92b7\u552e\u984d<\/p>\n<\/blockquote>\n<p>AI\u6703\u7b54\uff1a<\/p>\n<blockquote style=\"background:#f5f5f5; padding:15px;\">\n<p><strong>\u8a08\u7b97\u7d50\u679c\uff1a<\/strong><\/p>\n<p>1. \u6bcf\u7a2e\u6c34\u679c\u5605\u7e3d\u92b7\u552e\u984d\uff1a<br \/>\n&#8211; \u860b\u679c\uff1a100 \u00d7 $5 = $500<br \/>\n&#8211; \u6a59\uff1a80 \u00d7 $4 = $320<br \/>\n&#8211; \u9999\u8549\uff1a120 \u00d7 $3 = $360<\/p>\n<p>2. \u5168\u90e8\u6c34\u679c\u5605\u7e3d\u92b7\u552e\u984d\uff1a<br \/>\n$500 + $320 + $360 = $1,180<\/p>\n<p>3. \u5e73\u5747\u6bcf\u500b\u6c34\u679c\u5605\u92b7\u552e\u984d\uff1a<br \/>\n$1,180 \u00f7 (100+80+120) = $1,180 \u00f7 300 = $3.93<\/p>\n<\/blockquote>\n<h2>\u3010\u65b9\u6cd53\uff1a\u53ebAI\u89e3\u91cb\u516c\u5f0f\u3011<\/h2>\n<p>\u6307\u4ee4\uff1a<\/p>\n<blockquote style=\"background:#f5f5f5; padding:15px; border-left:4px solid #0073aa;\">\n<p>\u8acb\u89e3\u91cb\u5462\u689dExcel\u516c\u5f0f\u4fc2\u505a\u54a9\uff1a=IF(A1>100, &#8220;\u904e\u95dc&#8221;, &#8220;\u5514\u904e\u95dc&#8221;)<\/p>\n<\/blockquote>\n<p>AI\u6703\u7b54\uff1a<br \/>\n\u201c\u5462\u689d\u4fc2IF\u51fd\u6578\uff0c\u7528\u569f\u505a\u689d\u4ef6\u5224\u65b7\u3002\u5982\u679cA1\u5605\u6578\u503c\u5927\u904e100\uff0c\u5c31\u986f\u793a&#8217;\u904e\u95dc&#8217;\uff0c\u5426\u5247\u986f\u793a&#8217;\u5514\u904e\u95dc&#8217;\u3002\u201d<\/p>\n<h2>\u3010\u65b9\u6cd54\uff1a\u53ebAI\u5e6b\u4f60\u8ad7\u9ede\u505a\u3011<\/h2>\n<p>\u5982\u679c\u4f60\u5514\u8b58\u9ede\u5165\u624b\uff0c\u53ef\u4ee5\u554fAI\uff1a<\/p>\n<blockquote style=\"background:#f5f5f5; padding:15px; border-left:4px solid #0073aa;\">\n<p>\u6211\u6709\u4e00\u4efd\u54e1\u5de5\u8cc7\u6599\uff0c\u6709\u54e1\u5de5\u7de8\u865f\u3001\u59d3\u540d\u3001\u90e8\u9580\u3001\u5165\u8077\u65e5\u671f\u3001\u85aa\u91d1\u3002\u6211\u60f3\u5206\u6790\uff1a<br \/>\n1. \u5404\u90e8\u9580\u5e73\u5747\u85aa\u91d1<br \/>\n2. \u5165\u8077\u8d85\u904e5\u5e74\u5605\u54e1\u5de5<br \/>\n3. \u85aa\u91d1\u6700\u9ad8\u56053\u500b\u54e1\u5de5<br \/>\n\u61c9\u8a72\u9ede\u505a\uff1f\u7528\u54a9\u516c\u5f0f\uff1f<\/p>\n<\/blockquote>\n<p>AI\u6703\u4ffestep by step\u6559\u5b78\uff1a<\/p>\n<blockquote style=\"background:#f5f5f5; padding:15px;\">\n<p><strong>1. \u5404\u90e8\u9580\u5e73\u5747\u85aa\u91d1\uff1a<\/strong><br \/>\n\u53ef\u4ee5\u7528Pivot Table\uff08\u6578\u64da\u900f\u8996\u8868\uff09\u6216\u8005\u7528AVERAGEIF\u516c\u5f0f\u3002<br \/>\n=AVERAGEIF(C:C, &#8220;\u92b7\u552e\u90e8&#8221;, E:E)  \/\/\u5047\u8a2dC\u6b04\u4fc2\u90e8\u9580\uff0cE\u6b04\u4fc2\u85aa\u91d1<\/p>\n<p><strong>2. \u5165\u8077\u8d85\u904e5\u5e74\u5605\u54e1\u5de5\uff1a<\/strong><br \/>\n\u65b0\u589e\u4e00\u6b04F\uff0c\u7528\u516c\u5f0f\u8a08\u5e74\u8cc7\uff1a=DATEDIF(D2, TODAY(), &#8220;y&#8221;)<br \/>\n\u7136\u5f8c\u7528\u7be9\u9078\u63c0F\u6b04\u5927\u904e5\u5605\u54e1\u5de5\u3002<\/p>\n<p><strong>3. \u85aa\u91d1\u6700\u9ad8\u56053\u500b\u54e1\u5de5\uff1a<\/strong><br \/>\n\u7528LARGE\u516c\u5f0f\uff1a=LARGE(E:E, 1)  \/\/\u7b2c1\u9ad8<br \/>\n=LARGE(E:E, 2)  \/\/\u7b2c2\u9ad8<br \/>\n=LARGE(E:E, 3)  \/\/\u7b2c3\u9ad8<br \/>\n\u6216\u8005\u7528\u6392\u5e8f\u529f\u80fd\uff0c\u5c07\u85aa\u91d1\u7531\u9ad8\u81f3\u4f4e\u6392\u3002<\/p>\n<\/blockquote>\n<h2>\u3010\u65b9\u6cd55\uff1a\u53ebAI\u5e6b\u4f60\u6574\u5716\u8868\u3011<\/h2>\n<p>\u6307\u4ee4\uff1a<\/p>\n<blockquote style=\"background:#f5f5f5; padding:15px; border-left:4px solid #0073aa;\">\n<p>\u6211\u6709\u4ee5\u4e0b\u6578\u64da\uff0c\u60f3\u6574\u5713\u5f62\u5716\uff08pie chart\uff09\uff0c\u61c9\u8a72\u9ede\u505a\uff1f<br \/>\n\u860b\u679c\uff1a500<br \/>\n\u6a59\uff1a320<br \/>\n\u9999\u8549\uff1a360<\/p>\n<\/blockquote>\n<p>AI\u6703\u7b54\uff1a<br \/>\n\u201c\u55baExcel\u63c0\u6578\u64da\uff0c\u7136\u5f8c\u9edeInsert > Pie Chart\u5c31ok\u3002\u5982\u679c\u60f3\u55baAI\u6574\uff0c\u4f60\u53ef\u4ee5\u7528\u5462\u5572\u6578\u64da\u751f\u6210\u63cf\u8ff0\uff0c\u6216\u8005\u7528\u5176\u4ed6\u5de5\u5177\u3002\u201d<\/p>\n<h2>\u3010Excel AI\u5de5\u5177\u63a8\u85a6\u3011<\/h2>\n<h3>1. Excel\u672c\u8eab\u5605Ideas\u529f\u80fd<\/h3>\n<p>Excel 365\u6709\u300cIdeas\u300d\u529f\u80fd\uff0c\u53ef\u4ee5\u81ea\u52d5\u5206\u6790\u6578\u64da\uff0c\u4ffe\u5efa\u8b70\u3002<\/p>\n<h3>2. ChatGPT<\/h3>\n<p>\u7528\u81ea\u7136\u8a9e\u8a00\u554f\u554f\u984c\uff0cAI\u5e6b\u4f60\u751f\u6210\u516c\u5f0f\u3002<\/p>\n<h3>3. Google Sheets\u5605Explore\u529f\u80fd<\/h3>\n<p>\u985e\u4f3cExcel Ideas\uff0c\u53ef\u4ee5\u81ea\u52d5\u5206\u6790\u6578\u64da\u3002<\/p>\n<h2>\u3010\u7e3d\u7d50\u3011<\/h2>\n<p>\u7528AI\u5e6b\u4f60\u505aExcel\uff0c\u53ef\u4ee5\uff1a<\/p>\n<ul>\n<li>\u554fAI\u8981\u516c\u5f0f\uff0c\u5514\u4f7f\u81ea\u5df1\u80cc<\/li>\n<li>\u4ffe\u8cc7\u6599AI\u53eb\u4f62\u8a08<\/li>\n<li>\u53ebAI\u89e3\u91cb\u516c\u5f0f\u9ede\u7528<\/li>\n<li>\u53ebAI\u6559\u4f60\u9ede\u5206\u6790\u6578\u64da<\/li>\n<\/ul>\n<p>\u5481\u5c31\u5514\u6015Excel\u96e3\u5b78\u5566\uff01<\/p>\n<p>\u4f60\u6709\u5187\u7528AI\u5e6b\u624b\u505aExcel\uff1f\u7559\u8a00\u5206\u4eab\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel\u597d\u96e3\u5b78\uff1f\u5481\u591a\u516c\u5f0f\u8a18\u5514\u5230\uff1fAI\u53ef\u4ee5\u5e6b\u4f60\uff01\u53ea\u8981\u4f60\u8b1b\u4f4e\u60f3\u505a\u54a9\uff0cAI\u5c31\u4ffe\u689d\u516c\u5f0f\u4f60\uff0c\u8907\u88fd\u8cbc\u4e0a\u5c31\u5f97\uff0cExcel\u65b0 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-110","post","type-post","status-publish","format-standard","hentry","category-ai-lab"],"blocksy_meta":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\r\n<title>AI\u5e6b\u4f60\u505aExcel\uff5c\u5514\u8b58\u516c\u5f0f\u90fd\u8b58\u7528\uff0cExcel\u65b0\u624b\u6551\u661f - \u00a0\u672c\u6e2f\u7a7a\u9593 | \u9999\u6e2f\u65b0\u805e\u3001\u751f\u6d3b\u8cc7\u8a0a\u3001\u79d1\u6280\u52d5\u614b - Spacehk.com\u00a0<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.spacehk.com\/?p=110\" \/>\r\n<meta property=\"og:locale\" content=\"zh_HK\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"AI\u5e6b\u4f60\u505aExcel\uff5c\u5514\u8b58\u516c\u5f0f\u90fd\u8b58\u7528\uff0cExcel\u65b0\u624b\u6551\u661f - \u00a0\u672c\u6e2f\u7a7a\u9593 | \u9999\u6e2f\u65b0\u805e\u3001\u751f\u6d3b\u8cc7\u8a0a\u3001\u79d1\u6280\u52d5\u614b - Spacehk.com\u00a0\" \/>\r\n<meta property=\"og:description\" content=\"Excel\u597d\u96e3\u5b78\uff1f\u5481\u591a\u516c\u5f0f\u8a18\u5514\u5230\uff1fAI\u53ef\u4ee5\u5e6b\u4f60\uff01\u53ea\u8981\u4f60\u8b1b\u4f4e\u60f3\u505a\u54a9\uff0cAI\u5c31\u4ffe\u689d\u516c\u5f0f\u4f60\uff0c\u8907\u88fd\u8cbc\u4e0a\u5c31\u5f97\uff0cExcel\u65b0 [&hellip;]\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.spacehk.com\/?p=110\" \/>\r\n<meta property=\"og:site_name\" content=\"\u00a0\u672c\u6e2f\u7a7a\u9593 | \u9999\u6e2f\u65b0\u805e\u3001\u751f\u6d3b\u8cc7\u8a0a\u3001\u79d1\u6280\u52d5\u614b - Spacehk.com\u00a0\" \/>\r\n<meta property=\"article:published_time\" content=\"2026-02-20T09:32:08+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2026-02-20T09:42:35+00:00\" \/>\r\n<meta name=\"author\" content=\"nic@nicsky.com\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"nic@nicsky.com\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9810\u8a08\u95b1\u8b80\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \u5206\u9418\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.spacehk.com\\\/?p=110#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.spacehk.com\\\/?p=110\"},\"author\":{\"name\":\"nic@nicsky.com\",\"@id\":\"http:\\\/\\\/www.spacehk.com\\\/#\\\/schema\\\/person\\\/e3481097cc8e5bffe2979a8457836ad3\"},\"headline\":\"AI\u5e6b\u4f60\u505aExcel\uff5c\u5514\u8b58\u516c\u5f0f\u90fd\u8b58\u7528\uff0cExcel\u65b0\u624b\u6551\u661f\",\"datePublished\":\"2026-02-20T09:32:08+00:00\",\"dateModified\":\"2026-02-20T09:42:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.spacehk.com\\\/?p=110\"},\"wordCount\":139,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\\\/\\\/www.spacehk.com\\\/#organization\"},\"articleSection\":[\"\u5ee3\u6771\u8a71 AI \u5be6\u9a57\u5ba4\"],\"inLanguage\":\"zh-HK\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.spacehk.com\\\/?p=110#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.spacehk.com\\\/?p=110\",\"url\":\"https:\\\/\\\/www.spacehk.com\\\/?p=110\",\"name\":\"AI\u5e6b\u4f60\u505aExcel\uff5c\u5514\u8b58\u516c\u5f0f\u90fd\u8b58\u7528\uff0cExcel\u65b0\u624b\u6551\u661f - \u00a0\u672c\u6e2f\u7a7a\u9593 | \u9999\u6e2f\u65b0\u805e\u3001\u751f\u6d3b\u8cc7\u8a0a\u3001\u79d1\u6280\u52d5\u614b - Spacehk.com\u00a0\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.spacehk.com\\\/#website\"},\"datePublished\":\"2026-02-20T09:32:08+00:00\",\"dateModified\":\"2026-02-20T09:42:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.spacehk.com\\\/?p=110#breadcrumb\"},\"inLanguage\":\"zh-HK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.spacehk.com\\\/?p=110\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.spacehk.com\\\/?p=110#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9801\",\"item\":\"http:\\\/\\\/www.spacehk.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AI\u5e6b\u4f60\u505aExcel\uff5c\u5514\u8b58\u516c\u5f0f\u90fd\u8b58\u7528\uff0cExcel\u65b0\u624b\u6551\u661f\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/www.spacehk.com\\\/#website\",\"url\":\"http:\\\/\\\/www.spacehk.com\\\/\",\"name\":\"\u00a0\u672c\u6e2f\u7a7a\u9593 | \u9999\u6e2f\u65b0\u805e\u3001\u751f\u6d3b\u8cc7\u8a0a\u3001\u79d1\u6280\u52d5\u614b - Spacehk.com\u00a0\",\"description\":\"\u00a0\u672c\u6e2f\u7a7a\u9593\u63d0\u4f9b\u6700\u5168\u9762\u7684\u9999\u6e2f\u672c\u5730\u65b0\u805e\u3001\u751f\u6d3b\u8cc7\u8a0a\u3001\u79d1\u6280\u52d5\u614b\u3001\u4ea4\u901a\u8a0a\u606f\u53ca\u6559\u80b2\u653f\u7b56\u3002\u5373\u6642\u66f4\u65b0\u591c\u5e02\u3001\u8de8\u5883\u5b78\u7ae5\u3001\u6a13\u5e02\u6578\u64da\u3001\u516c\u5171\u904b\u8f38\u7b49\u9999\u6e2f\u4eba\u95dc\u5fc3\u7684\u8a71\u984c\uff0c\u8b93\u60a8\u638c\u63e1\u6700\u65b0\u672c\u6e2f\u52d5\u5411\u3002\u00a0\",\"publisher\":{\"@id\":\"http:\\\/\\\/www.spacehk.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/www.spacehk.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-HK\"},{\"@type\":\"Organization\",\"@id\":\"http:\\\/\\\/www.spacehk.com\\\/#organization\",\"name\":\"\u00a0\u672c\u6e2f\u7a7a\u9593 | \u9999\u6e2f\u65b0\u805e\u3001\u751f\u6d3b\u8cc7\u8a0a\u3001\u79d1\u6280\u52d5\u614b - Spacehk.com\u00a0\",\"url\":\"http:\\\/\\\/www.spacehk.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-HK\",\"@id\":\"http:\\\/\\\/www.spacehk.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"http:\\\/\\\/www.spacehk.com\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/\u5fae\u4fe1\u56fe\u7247_2026-02-08_092041_050.jpg\",\"contentUrl\":\"http:\\\/\\\/www.spacehk.com\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/\u5fae\u4fe1\u56fe\u7247_2026-02-08_092041_050.jpg\",\"width\":251,\"height\":251,\"caption\":\"\u00a0\u672c\u6e2f\u7a7a\u9593 | \u9999\u6e2f\u65b0\u805e\u3001\u751f\u6d3b\u8cc7\u8a0a\u3001\u79d1\u6280\u52d5\u614b - Spacehk.com\u00a0\"},\"image\":{\"@id\":\"http:\\\/\\\/www.spacehk.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.spacehk.com\\\/#\\\/schema\\\/person\\\/e3481097cc8e5bffe2979a8457836ad3\",\"name\":\"nic@nicsky.com\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-HK\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/271d4eaab48e299e4fce771a8c43c537be3ac77a3115cc7de802a6c8b692d971?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/271d4eaab48e299e4fce771a8c43c537be3ac77a3115cc7de802a6c8b692d971?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/271d4eaab48e299e4fce771a8c43c537be3ac77a3115cc7de802a6c8b692d971?s=96&d=mm&r=g\",\"caption\":\"nic@nicsky.com\"},\"sameAs\":[\"http:\\\/\\\/www.spacehk.com\"],\"url\":\"http:\\\/\\\/www.spacehk.com\\\/?author=1\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AI\u5e6b\u4f60\u505aExcel\uff5c\u5514\u8b58\u516c\u5f0f\u90fd\u8b58\u7528\uff0cExcel\u65b0\u624b\u6551\u661f - \u00a0\u672c\u6e2f\u7a7a\u9593 | \u9999\u6e2f\u65b0\u805e\u3001\u751f\u6d3b\u8cc7\u8a0a\u3001\u79d1\u6280\u52d5\u614b - Spacehk.com\u00a0","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.spacehk.com\/?p=110","og_locale":"zh_HK","og_type":"article","og_title":"AI\u5e6b\u4f60\u505aExcel\uff5c\u5514\u8b58\u516c\u5f0f\u90fd\u8b58\u7528\uff0cExcel\u65b0\u624b\u6551\u661f - \u00a0\u672c\u6e2f\u7a7a\u9593 | \u9999\u6e2f\u65b0\u805e\u3001\u751f\u6d3b\u8cc7\u8a0a\u3001\u79d1\u6280\u52d5\u614b - Spacehk.com\u00a0","og_description":"Excel\u597d\u96e3\u5b78\uff1f\u5481\u591a\u516c\u5f0f\u8a18\u5514\u5230\uff1fAI\u53ef\u4ee5\u5e6b\u4f60\uff01\u53ea\u8981\u4f60\u8b1b\u4f4e\u60f3\u505a\u54a9\uff0cAI\u5c31\u4ffe\u689d\u516c\u5f0f\u4f60\uff0c\u8907\u88fd\u8cbc\u4e0a\u5c31\u5f97\uff0cExcel\u65b0 [&hellip;]","og_url":"https:\/\/www.spacehk.com\/?p=110","og_site_name":"\u00a0\u672c\u6e2f\u7a7a\u9593 | \u9999\u6e2f\u65b0\u805e\u3001\u751f\u6d3b\u8cc7\u8a0a\u3001\u79d1\u6280\u52d5\u614b - Spacehk.com\u00a0","article_published_time":"2026-02-20T09:32:08+00:00","article_modified_time":"2026-02-20T09:42:35+00:00","author":"nic@nicsky.com","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"nic@nicsky.com","\u9810\u8a08\u95b1\u8b80\u6642\u9593":"1 \u5206\u9418"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.spacehk.com\/?p=110#article","isPartOf":{"@id":"https:\/\/www.spacehk.com\/?p=110"},"author":{"name":"nic@nicsky.com","@id":"http:\/\/www.spacehk.com\/#\/schema\/person\/e3481097cc8e5bffe2979a8457836ad3"},"headline":"AI\u5e6b\u4f60\u505aExcel\uff5c\u5514\u8b58\u516c\u5f0f\u90fd\u8b58\u7528\uff0cExcel\u65b0\u624b\u6551\u661f","datePublished":"2026-02-20T09:32:08+00:00","dateModified":"2026-02-20T09:42:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.spacehk.com\/?p=110"},"wordCount":139,"commentCount":0,"publisher":{"@id":"http:\/\/www.spacehk.com\/#organization"},"articleSection":["\u5ee3\u6771\u8a71 AI \u5be6\u9a57\u5ba4"],"inLanguage":"zh-HK","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.spacehk.com\/?p=110#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.spacehk.com\/?p=110","url":"https:\/\/www.spacehk.com\/?p=110","name":"AI\u5e6b\u4f60\u505aExcel\uff5c\u5514\u8b58\u516c\u5f0f\u90fd\u8b58\u7528\uff0cExcel\u65b0\u624b\u6551\u661f - \u00a0\u672c\u6e2f\u7a7a\u9593 | \u9999\u6e2f\u65b0\u805e\u3001\u751f\u6d3b\u8cc7\u8a0a\u3001\u79d1\u6280\u52d5\u614b - Spacehk.com\u00a0","isPartOf":{"@id":"http:\/\/www.spacehk.com\/#website"},"datePublished":"2026-02-20T09:32:08+00:00","dateModified":"2026-02-20T09:42:35+00:00","breadcrumb":{"@id":"https:\/\/www.spacehk.com\/?p=110#breadcrumb"},"inLanguage":"zh-HK","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.spacehk.com\/?p=110"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.spacehk.com\/?p=110#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9801","item":"http:\/\/www.spacehk.com\/"},{"@type":"ListItem","position":2,"name":"AI\u5e6b\u4f60\u505aExcel\uff5c\u5514\u8b58\u516c\u5f0f\u90fd\u8b58\u7528\uff0cExcel\u65b0\u624b\u6551\u661f"}]},{"@type":"WebSite","@id":"http:\/\/www.spacehk.com\/#website","url":"http:\/\/www.spacehk.com\/","name":"\u00a0\u672c\u6e2f\u7a7a\u9593 | \u9999\u6e2f\u65b0\u805e\u3001\u751f\u6d3b\u8cc7\u8a0a\u3001\u79d1\u6280\u52d5\u614b - Spacehk.com\u00a0","description":"\u00a0\u672c\u6e2f\u7a7a\u9593\u63d0\u4f9b\u6700\u5168\u9762\u7684\u9999\u6e2f\u672c\u5730\u65b0\u805e\u3001\u751f\u6d3b\u8cc7\u8a0a\u3001\u79d1\u6280\u52d5\u614b\u3001\u4ea4\u901a\u8a0a\u606f\u53ca\u6559\u80b2\u653f\u7b56\u3002\u5373\u6642\u66f4\u65b0\u591c\u5e02\u3001\u8de8\u5883\u5b78\u7ae5\u3001\u6a13\u5e02\u6578\u64da\u3001\u516c\u5171\u904b\u8f38\u7b49\u9999\u6e2f\u4eba\u95dc\u5fc3\u7684\u8a71\u984c\uff0c\u8b93\u60a8\u638c\u63e1\u6700\u65b0\u672c\u6e2f\u52d5\u5411\u3002\u00a0","publisher":{"@id":"http:\/\/www.spacehk.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.spacehk.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-HK"},{"@type":"Organization","@id":"http:\/\/www.spacehk.com\/#organization","name":"\u00a0\u672c\u6e2f\u7a7a\u9593 | \u9999\u6e2f\u65b0\u805e\u3001\u751f\u6d3b\u8cc7\u8a0a\u3001\u79d1\u6280\u52d5\u614b - Spacehk.com\u00a0","url":"http:\/\/www.spacehk.com\/","logo":{"@type":"ImageObject","inLanguage":"zh-HK","@id":"http:\/\/www.spacehk.com\/#\/schema\/logo\/image\/","url":"http:\/\/www.spacehk.com\/wp-content\/uploads\/2026\/02\/\u5fae\u4fe1\u56fe\u7247_2026-02-08_092041_050.jpg","contentUrl":"http:\/\/www.spacehk.com\/wp-content\/uploads\/2026\/02\/\u5fae\u4fe1\u56fe\u7247_2026-02-08_092041_050.jpg","width":251,"height":251,"caption":"\u00a0\u672c\u6e2f\u7a7a\u9593 | \u9999\u6e2f\u65b0\u805e\u3001\u751f\u6d3b\u8cc7\u8a0a\u3001\u79d1\u6280\u52d5\u614b - Spacehk.com\u00a0"},"image":{"@id":"http:\/\/www.spacehk.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"http:\/\/www.spacehk.com\/#\/schema\/person\/e3481097cc8e5bffe2979a8457836ad3","name":"nic@nicsky.com","image":{"@type":"ImageObject","inLanguage":"zh-HK","@id":"https:\/\/secure.gravatar.com\/avatar\/271d4eaab48e299e4fce771a8c43c537be3ac77a3115cc7de802a6c8b692d971?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/271d4eaab48e299e4fce771a8c43c537be3ac77a3115cc7de802a6c8b692d971?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/271d4eaab48e299e4fce771a8c43c537be3ac77a3115cc7de802a6c8b692d971?s=96&d=mm&r=g","caption":"nic@nicsky.com"},"sameAs":["http:\/\/www.spacehk.com"],"url":"http:\/\/www.spacehk.com\/?author=1"}]}},"_links":{"self":[{"href":"http:\/\/www.spacehk.com\/index.php?rest_route=\/wp\/v2\/posts\/110","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.spacehk.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.spacehk.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.spacehk.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.spacehk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=110"}],"version-history":[{"count":1,"href":"http:\/\/www.spacehk.com\/index.php?rest_route=\/wp\/v2\/posts\/110\/revisions"}],"predecessor-version":[{"id":123,"href":"http:\/\/www.spacehk.com\/index.php?rest_route=\/wp\/v2\/posts\/110\/revisions\/123"}],"wp:attachment":[{"href":"http:\/\/www.spacehk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.spacehk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=110"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.spacehk.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}