\u5f15\u8a00:<\/p>\n\n\n\n
Microsoft Excel\u662f\u6700\u53d7\u6b61\u8fce\u7684\u96fb\u5b50\u8868\u683c\u7a0b\u5f0f\u4e4b\u4e00\uff0c\u5b83\u5f15\u5165\u4e86\u65b0\u7684\u8cc7\u6599\u532f\u7e3d\u529f\u80fd (GROUPBY\u3001PIVOTBY \u548c PERCENTOF)\uff0c\u65e8\u5728\u7c21\u5316\u6536\u96c6\u548c\u6574\u7406\u8cc7\u6599\u7684\u904e\u7a0b\uff0c\u4e26\u5c07\u5176\u6574\u7406\u6210\u7dca\u6e4a\u7684\u6458\u8981\u548c\u8868\u683c\u3002<\/p>\n\n\n\n
Microsoft Excel\u7684\u65b0\u6578\u64da\u5f59\u7e3d\u51fd\u6578\uff1a<\/p>\n\n\n\n
GROUPBY\uff1aGROUPBY\u51fd\u6578\u53ef\u8b93\u60a8\u6839\u64da\u7279\u5b9a\u689d\u4ef6\u5c0d\u8cc7\u6599\u9032\u884c\u5206\u7d44\uff0c\u532f\u7e3d\u9019\u4e9b\u5206\u7d44\u7684\u503c\uff0c\u4e26\u9078\u64c7\u8981\u5957\u7528\u7684\u7e3d\u548c\u51fd\u6578\u3002 \u4f8b\u5982\uff0c\u516c\u5f0f=GROUPBY(tbl[\u985e\u5225], tbl[\u92b7\u552e\u984d],SUM)\u53ef\u7528\u65bc\u6309\u7522\u54c1\u985e\u5225\u532f\u7e3d\u92b7\u552e\u4fe1\u606f\uff0c\u4e26\u986f\u793a\u900f\u904eSUM\u51fd\u6578\u532f\u7e3d\u7684\u92b7\u552e\u6578\u5b57\u3002<\/p>\n\n\n\n
PIVOTBY\uff1a\u8207GROUPBY\u985e\u4f3c\uff0cPIVOTBY\u51fd\u6578\u53ef\u8b93\u60a8\u6839\u64da\u7279\u5b9a\u689d\u4ef6\u7d44\u7e54\u8cc7\u6599\u548c\u57f7\u884c\u805a\u5408\uff1bPIVOTBY\u53ef\u8b93\u60a8\u6839\u64da\u5176\u4ed6\u7dad\u5ea6\u900f\u8996\u8cc7\u6599\u3002 \u4f8b\u5982\uff0c\u516c\u5f0f =PIVOTBY(tbl[Category],tbl[Year],tbl[Sales],MAX)\u53ef\u7528\u65bc\u986f\u793a\u7522\u54c1\u985e\u5225\u548c\u5e74\u4efd\u7684\u6700\u5927\u92b7\u552e\u984d\uff0c\u5305\u62ec\u6bcf\u500b\u985e\u5225\u7684\u7e3d\u92b7\u552e\u984d\u3002<\/p>\n\n\n\n
PERCENTOF\uff1aPERCENTOF\u51fd\u6578\u8207GROUPBY\u548cPIVOTBY\u642d\u914d\u4f7f\u7528\u6642\u7279\u5225\u6709\u7528\u3002 \u53ef\u4ee5\u8f15\u9b06\u8a08\u7b97\u8907\u96dc\u7684\u767e\u5206\u6bd4\u503c\u3002 \u5f9e\u6280\u8853\u4e0a\u8b1b\uff0cPERCENTOF\u7b49\u540c\u65bc\u516c\u5f0f=SUM(data_subset)\/SUM(data_all)\u3002 \u9019\u7c21\u5316\u4e86\u5f9e\u539f\u59cb\u6578\u64da\u4e2d\u7372\u53d6\u767e\u5206\u6bd4\u503c\u7684\u904e\u7a0b\uff0c\u4e26\u70ba\u5206\u6790\u63d0\u4f9b\u4e86\u6709\u50f9\u503c\u7684\u898b\u89e3\u3002<\/p>\n\n\n\n
\u512a\u9ede\u548c\u4f7f\u7528\u6848\u4f8b<\/p>\n\n\n\n
\u7c21\u5316\u8cc7\u6599\u805a\u5408\uff1a\u65b0\u51fd\u6578\u63d0\u4f9b\u4e86\u4e00\u7a2e\u7c21\u55ae\u7684\u8cc7\u6599\u805a\u5408\u65b9\u6cd5\uff0c\u7121\u9700\u8907\u96dc\u7684\u516c\u5f0f\u6216\u624b\u52d5\u8a08\u7b97\u3002<\/p>\n\n\n\n
\u6539\u9032\u8cc7\u6599\u7d44\u7e54\uff1aGROUPBY \u548c PIVOTBY\u53ef\u4ee5\u5c07\u8cc7\u6599\u7d44\u7e54\u6210\u7c21\u660e\u6458\u8981\uff0c\u5f9e\u800c\u66f4\u5bb9\u6613\u5206\u6790\u548c\u5c55\u793a\u8cc7\u8a0a\u3002<\/p>\n\n\n\n
\u6642\u9593\u6548\u7387\uff1a\u900f\u904e\u81ea\u52d5\u88fd\u8868\u6d41\u7a0b\uff0cExcel\u7684\u65b0\u529f\u80fd\u7bc0\u7701\u4e86\u5bf6\u8cb4\u7684\u6642\u9593\uff0c\u8b93\u60a8\u53ef\u4ee5\u5c08\u6ce8\u65bc\u5206\u6790\u7d50\u679c\u548c\u7372\u5f97\u6709\u610f\u7fa9\u7684\u898b\u89e3\u3002<\/p>\n\n\n\n
\u589e\u5f37\u5206\u6790\uff1a\u4f7f\u7528PERCENTOF\u8a08\u7b97\u767e\u5206\u6bd4\u7684\u529f\u80fd\u53ef\u8b93\u4f7f\u7528\u8005\u66f4\u4e86\u89e3\u8cc7\u6599\u95dc\u4fc2\u548c\u8da8\u52e2\u3002<\/p>\n\n\n\n
\u6ce8\u610f\u4e8b\u9805:<\/p>\n\n\n\n
\"\u9700\u8981\u6ce8\u610f\u7684\u662f\uff0c\u9019\u4e9b\u65b0\u529f\u80fd\u76ee\u524d\u53ea\u5728Microsoft 365 Insider\u7248\u672c\u4e2d\u53ef\u7528\uff0c\u4e26\u4e14\u4ecd\u8655\u65bc\u6e2c\u8a66\u968e\u6bb5\u3002\u56e0\u6b64\uff0c\u5efa\u8b70\u5728\u5b83\u5011\u6b63\u5f0f\u5728\u7a69\u5b9a\u7248\u672c\u4e2d\u767c\u5e03\u4e4b\u524d\uff0c\u4e0d\u8981\u5728\u95dc\u9375\u6027\u8a66\u7b97\u8868\u4e2d\u4f7f\u7528\u5b83\u5011\u3002Microsoft\u8a08\u5283\u5c07lambda\u652f\u6301\u64f4\u5c55\u5230\u6240\u6709\u529f\u80fd\uff0c\u9032\u4e00\u6b65\u589e\u5f37\u5b83\u5011\u7684\u53ef\u7528\u6027\u548c\u591a\u529f\u80fd\u6027\u3002\"<\/p>\n\n\n\n
\u7d50\u8ad6\uff1a<\/p>\n\n\n\n
Microsoft Excel\u4e2d\u7684\u65b0\u8cc7\u6599\u532f\u7e3d\u51fd\u6578\uff08\u5305\u62ecGROUPBY\u3001PIVOTBY \u548c PERCENTOF\uff09\u70ba\u4f7f\u7528\u8005\u63d0\u4f9b\u4e86\u7c21\u55ae\u4e14\u6709\u6548\u7387\u7684\u8cc7\u6599\u7d44\u7e54\u548c\u5206\u6790\u65b9\u6cd5\u3002 \u900f\u904e\u5c07\u532f\u7e3d\u6d41\u7a0b\u81ea\u52d5\u5316\uff0cExcel\u4f7f\u7528\u8005\u53ef\u4ee5\u7372\u5f97\u6709\u50f9\u503c\u7684\u898b\u89e3\uff0c\u4e26\u6839\u64da\u8cc7\u6599\u505a\u51fa\u660e\u667a\u7684\u6c7a\u7b56\u3002 \u9019\u4e9b\u529f\u80fd\u5c07\u6301\u7e8c\u767c\u5c55\uff0c\u4e26\u6709\u53ef\u80fd\u589e\u5f37Excel\u7528\u6236\u7684\u8cc7\u6599\u5206\u6790\u80fd\u529b\uff0c\u63d0\u9ad8\u4ed6\u5011\u7684\u6574\u9ad4\u5de5\u4f5c\u6548\u7387\u3002<\/p>\n\n\n\n
\u514d\u8cac\u8072\u660e:<\/p>\n\n\n\n
\u672c\u535a\u5ba2\u7684\u5167\u5bb9\u50c5\u4f9b\u53c3\u8003\u548c\u6559\u80b2\u76ee\u7684\uff0c\u4e26\u4e0d\u69cb\u6210\u5c08\u696d\u5efa\u8b70\u3002\u6211\u5011\u5df2\u7d93\u76e1\u529b\u78ba\u4fdd\u535a\u5ba2\u4e2d\u63d0\u4f9b\u7684\u4fe1\u606f\u6e96\u78ba\u53ef\u9760\uff0c\u4f46\u4e0d\u5c0d\u5176\u5b8c\u6574\u6027\u3001\u6e96\u78ba\u6027\u3001\u53ef\u9760\u6027\u6216\u9069\u7528\u6027\u4f5c\u51fa\u4efb\u4f55\u660e\u793a\u6216\u6697\u793a\u7684\u4fdd\u8b49\u3002\n\u4efb\u4f55\u4f9d\u8cf4\u672c\u535a\u5ba2\u63d0\u4f9b\u7684\u4fe1\u606f\u6240\u5f15\u8d77\u7684\u884c\u52d5\u90fd\u662f\u60a8\u500b\u4eba\u7684\u8cac\u4efb\u3002\u5728\u63a1\u53d6\u4efb\u4f55\u884c\u52d5\u4e4b\u524d\uff0c\u8acb\u8aee\u8a62\u76f8\u95dc\u5c08\u696d\u4eba\u58eb\u6216\u5c0b\u6c42\u9069\u7576\u7684\u5efa\u8b70\u3002\n\u6211\u5011\u5c0d\u65bc\u56e0\u4f7f\u7528\u6216\u4f9d\u8cf4\u672c\u535a\u5ba2\u7684\u5167\u5bb9\u800c\u5c0e\u81f4\u7684\u4efb\u4f55\u76f4\u63a5\u6216\u9593\u63a5\u640d\u5931\u6216\u640d\u5bb3\uff0c\u6982\u4e0d\u627f\u64d4\u4efb\u4f55\u8cac\u4efb\u3002\n\u672c\u535a\u5ba2\u7684\u5167\u5bb9\u53ef\u80fd\u6839\u64da\u6642\u9593\u7684\u63a8\u79fb\u800c\u8b8a\u5316\uff0c\u6211\u5011\u4fdd\u7559\u96a8\u6642\u4fee\u6539\u3001\u66f4\u65b0\u6216\u522a\u9664\u5167\u5bb9\u7684\u6b0a\u5229\u3002\n\u8acb\u6ce8\u610f\uff0c\u672c\u535a\u5ba2\u4e2d\u7684\u89c0\u9ede\u548c\u610f\u898b\u50c5\u4ee3\u8868\u4f5c\u8005\u672c\u4eba\uff0c\u4e26\u4e0d\u4ee3\u8868\u6211\u5011\u7684\u89c0\u9ede\u6216\u7acb\u5834\u3002\n\u6700\u5f8c\uff0c\u6211\u5011\u5f37\u70c8\u5efa\u8b70\u60a8\u81ea\u884c\u6838\u5be6\u548c\u78ba\u8a8d\u4efb\u4f55\u5728\u672c\u535a\u5ba2\u4e2d\u63d0\u4f9b\u7684\u4fe1\u606f\uff0c\u4e26\u6839\u64da\u81ea\u5df1\u7684\u5224\u65b7\u548c\u98a8\u96aa\u627f\u53d7\u80fd\u529b\u63a1\u53d6\u884c\u52d5\u3002\n\u5982\u6709\u4efb\u4f55\u7591\u554f\u6216\u7591\u616e\uff0c\u8acb\u806f\u7e6b\u76f8\u95dc\u5c08\u696d\u4eba\u58eb\u6216\u5c0b\u6c42\u9069\u7576\u7684\u5efa\u8b70\u3002<\/p>\n\n\n\n
#Excel\u8cc7\u6599\u7e3d\u7d50 #Excel\u51fd\u6578 #\u8cc7\u6599\u7d44\u7e54 #MicrosoftExcel #\u8cc7\u6599\u5206\u6790 #\u751f\u7522\u529b\u5de5\u5177 #\u96fb\u5b50\u8868\u683c\u51fd\u6578 #\u8cc7\u6599\u6d1e\u5bdf #Excel\u6280\u5de7 #Microsoft365 #\u8cc7\u6599\u7ba1\u7406<\/p>","protected":false},"excerpt":{"rendered":"
Microsoft Excel\u662f\u6700\u53d7\u6b61\u8fce\u7684\u96fb\u5b50\u8868\u683c\u7a0b\u5f0f\u4e4b\u4e00\uff0c\u5b83\u5f15\u5165\u4e86\u65b0\u7684\u8cc7\u6599\u532f\u7e3d\u529f\u80fd (GROUPBY\u3001PIVOTBY \u548c PERCENTOF)\uff0c\u65e8\u5728\u7c21\u5316\u6536\u96c6\u548c\u6574\u7406\u8cc7\u6599\u7684\u904e\u7a0b\uff0c\u4e26\u5c07\u5176\u6574\u7406\u6210\u7dca\u6e4a\u7684\u6458\u8981\u548c\u8868\u683c\u3002<\/p>","protected":false},"author":3,"featured_media":1692,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[52],"tags":[],"acf":[],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/first-unity.com.hk\/wp-content\/uploads\/2024\/04\/Screenshot-2024-04-14-230432.png","jetpack-related-posts":[{"id":1805,"url":"https:\/\/first-unity.com.hk\/zh\/exploring-excel-2016-features-tips-and-troubleshooting\/","url_meta":{"origin":1691,"position":0},"title":"Exploring Excel 2016: Features, Tips, and Troubleshooting","author":"Dr. Ken","date":"8 6 \u6708, 2024","format":false,"excerpt":"Introduction: Excel 2016 is a powerful spreadsheet application within the Microsoft Office suite, offering numerous features and tools to help users manipulate data, analyze information, and create professional-grade reports. In this blog post, we will delve into Excel 2016, sharing its features, tips, and troubleshooting methods. Features and Highlights: Excel\u2026","rel":"","context":"\u5728\u300cDr. Ken's Tech Course\u300d\u4e2d","block_context":{"text":"Dr. Ken's Tech Course","link":"https:\/\/first-unity.com.hk\/zh\/category\/dr-kens-tech-course\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/first-unity.com.hk\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-08-132804.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1785,"url":"https:\/\/first-unity.com.hk\/zh\/microsofts-38tb-leak-how-it-leaders-should-respond\/","url_meta":{"origin":1691,"position":1},"title":"Microsoft’s 38TB Leak: How IT Leaders Should Respond","author":"Harry Spira","date":"5 6 \u6708, 2024","format":false,"excerpt":"Introduction: In today's digital landscape, cybersecurity breaches continue to pose significant challenges for organizations worldwide. One notable incident that caught the attention of IT leaders and cybersecurity professionals was Microsoft's 38TB leak. This massive data breach raised concerns about cloud security and the importance of robust cybersecurity measures. In this\u2026","rel":"","context":"\u5728\u300cCyber Security\u300d\u4e2d","block_context":{"text":"Cyber Security","link":"https:\/\/first-unity.com.hk\/zh\/category\/cyber-security\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/first-unity.com.hk\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-08-151844.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/first-unity.com.hk\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-08-151844.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/first-unity.com.hk\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-08-151844.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":1793,"url":"https:\/\/first-unity.com.hk\/zh\/microsoft-data-breach-employees-credentials-and-passwords-leaked-on-the-internet\/","url_meta":{"origin":1691,"position":2},"title":"Microsoft Data Breach: Employees’ Credentials and Passwords Leaked on the Internet","author":"Randy Yip","date":"5 6 \u6708, 2024","format":false,"excerpt":"Introduction: In a shocking revelation, Microsoft, one of the world's largest technology companies, has reportedly experienced a significant data breach that has exposed employees' credentials and internal company files to the internet. Security researchers recently discovered an open and public storage server hosted on Microsoft's Azure cloud service, which was\u2026","rel":"","context":"\u5728\u300cCyber Security\u300d\u4e2d","block_context":{"text":"Cyber Security","link":"https:\/\/first-unity.com.hk\/zh\/category\/cyber-security\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/first-unity.com.hk\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-08-152436.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/first-unity.com.hk\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-08-152436.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/first-unity.com.hk\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-08-152436.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":1817,"url":"https:\/\/first-unity.com.hk\/zh\/microsoft-365-roadmap-regularly-new-copilot-capabilities-are-coming-to-word-excel-and-more\/","url_meta":{"origin":1691,"position":3},"title":"Microsoft 365 Roadmap Regularly: New Copilot capabilities are coming to Word, Excel, and more!","author":"Steve Parker","date":"8 6 \u6708, 2024","format":false,"excerpt":"Introduction: Microsoft 365 continues to innovate and enhance its suite of productivity tools, and this week's roadmap update brings exciting news for users. The Copilot AI feature is set to receive significant improvements, empowering users to accomplish tasks more efficiently in popular applications like Word, Excel, and more. In this\u2026","rel":"","context":"\u5728\u300cTechnology Update\u300d\u4e2d","block_context":{"text":"Technology Update","link":"https:\/\/first-unity.com.hk\/zh\/category\/technology-update\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/first-unity.com.hk\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-08-143627.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1822,"url":"https:\/\/first-unity.com.hk\/zh\/troubleshooting-remote-desktop-black-screen-issues-on-windows-10\/","url_meta":{"origin":1691,"position":4},"title":"Troubleshooting Remote Desktop Black Screen Issues on Windows 10","author":"Dr. Ken","date":"8 6 \u6708, 2024","format":false,"excerpt":"Introduction: The Remote Desktop feature in Windows 10 allows users to connect to their computers remotely, providing convenience and flexibility. However, some users have encountered a frustrating issue where they are faced with a black screen when attempting to use Remote Desktop after updating to the Windows 10 May update.\u2026","rel":"","context":"\u5728\u300cDr. Ken's Tech Course\u300d\u4e2d","block_context":{"text":"Dr. Ken's Tech Course","link":"https:\/\/first-unity.com.hk\/zh\/category\/dr-kens-tech-course\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/first-unity.com.hk\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-08-143627.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1543,"url":"https:\/\/first-unity.com.hk\/zh\/the-incredible-world-of-big-data\/","url_meta":{"origin":1691,"position":5},"title":"The Incredible World of Big Data","author":"Harry Spira","date":"4 1 \u6708, 2024","format":false,"excerpt":"https:\/\/youtu.be\/5b_8joVfA_o?si=Swy8k26u8F0Rf2kf Prepare to be Amazed Welcome my friends to the incredible world of Big Data! Get ready to have your mind blown by the endless possibilities of Big Data. In this blog, we will explore the power of information and how it is changing the way we see the world.\u2026","rel":"","context":"\u5728\u300cTechnology Update\u300d\u4e2d","block_context":{"text":"Technology Update","link":"https:\/\/first-unity.com.hk\/zh\/category\/technology-update\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/5b_8joVfA_o\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/first-unity.com.hk\/zh\/wp-json\/wp\/v2\/posts\/1691"}],"collection":[{"href":"https:\/\/first-unity.com.hk\/zh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/first-unity.com.hk\/zh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/first-unity.com.hk\/zh\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/first-unity.com.hk\/zh\/wp-json\/wp\/v2\/comments?post=1691"}],"version-history":[{"count":0,"href":"https:\/\/first-unity.com.hk\/zh\/wp-json\/wp\/v2\/posts\/1691\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/first-unity.com.hk\/zh\/wp-json\/wp\/v2\/media\/1692"}],"wp:attachment":[{"href":"https:\/\/first-unity.com.hk\/zh\/wp-json\/wp\/v2\/media?parent=1691"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/first-unity.com.hk\/zh\/wp-json\/wp\/v2\/categories?post=1691"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/first-unity.com.hk\/zh\/wp-json\/wp\/v2\/tags?post=1691"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}