利用数据透视表，多项目杂乱数据快速归类求和
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">刚一上班，老板发来一张庞大又杂乱不堪的表让分别按合同号和合同<span style="color: black;">签定</span>人统计总金额。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">得，今天又得加班了...你<span style="color: black;">懊丧</span>的坐在电脑前想。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">其实<span style="color: black;">基本</span><span style="color: black;">无</span><span style="color: black;">那样</span><span style="color: black;">繁杂</span>，利用数据透视表功能，五分钟教你快速<span style="color: black;">归类</span>求和！</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/b71f0035af004e8c820c99e6c7def2ae~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951659&x-signature=hO5l9YWjlk%2BVqe05PNd8gGajag0%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">第1</span>步：<span style="color: black;">针对</span>对Excel表格不太<span style="color: black;">熟练</span>的小白<span style="color: black;">来讲</span>，求稳是最重要的，<span style="color: black;">因此</span><span style="color: black;">第1</span>步<span style="color: black;">咱们</span>需要把表格按<span style="color: black;">第1</span>行的项目手动<span style="color: black;">调节</span>成精简的几列。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/f8b42a4bb97149d487cc1f967fcb4d31~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951659&x-signature=N1czxEsd0QUKBMryJYUuDYMfskw%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">第1</span>步的实操实例（表格太大仅截取部分）</p>
</div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第二步：找到工具栏【数据】选项卡后，点击数据选项卡中的【数据透视表】功能</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/719eeff13c604c299a9cffd848200f67~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951659&x-signature=gPKTcg9tUA3Emc5zDcavoWu3A2Q%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第二步的实测实例</p>
</div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第三步：在弹出的创建数据透视表选项卡中，点击<span style="color: black;">第1</span>行【请<span style="color: black;">选取</span>单元格区域】右下角的小箭头，仔仔细细的把需要数据透视的单元格区域<span style="color: black;">所有</span>选上。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">这一步的易错点在于：1、<span style="color: black;">必定</span>要把表头即表格<span style="color: black;">第1</span>行的序号、合同号、合同<span style="color: black;">签定</span>人和姓名选项都选上；2、<span style="color: black;">不可</span>多选，<span style="color: black;">不可</span><span style="color: black;">显现</span>空白格和合并单元格（<span style="color: black;">倘若</span>提示有空白格或合并单元格，需要在<span style="color: black;">第1</span>步处理表格格式的时候先处理好）</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/0060e59b90af45a6b4b608736fee3cc3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951659&x-signature=aefm77ez%2BJqJqdbg5xjoxKpji3o%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第三步的实操实例</p>
</div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第四步：最下面的【请<span style="color: black;">选取</span><span style="color: black;">安置</span>数据透视表的位置】中，<span style="color: black;">按照</span>个人习惯<span style="color: black;">选取</span>【新工作表】或【现有工作表】，<span style="color: black;">选取</span>【现有工作表】的话，需要点选右下角的小箭头来<span style="color: black;">选取</span>数据透视表的<span style="color: black;">安置</span>位置。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">设置完毕后，点击【确定】完成数据透视表的创建。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/32db1c6e38b440519a06736baa5e2003~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951659&x-signature=o2cx3dwhTrI359zE2MbhDP3soxA%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第四步的实操实例</p>
</div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第五步：<span style="color: black;">倘若</span>以上操作都正确的<span style="color: black;">状况</span>下，你的表格界面应该变<span style="color: black;">成为了</span>下图所示。在表格右方<span style="color: black;">显现</span>了新的选项卡。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">首要</span>先<span style="color: black;">检测</span>右方新选项卡的字段列表<span style="color: black;">表示</span><span style="color: black;">是不是</span>正确，<span style="color: black;">倘若</span>字段列表<span style="color: black;">表示</span>的表头和<span style="color: black;">实质</span>表头不一致<span style="color: black;">表率</span>上一步创建透视表中<span style="color: black;">选取</span>单元格区域<span style="color: black;">无</span>选对，需返回第四步<span style="color: black;">检测</span>。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/e4c32772bd6c4c6eb4692220c9d321a2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951659&x-signature=Ede7Ygl2TwYdvH88UgEP%2BQ%2BE8e4%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第五步的实操实例</p>
</div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第六步：<span style="color: black;">最终</span>来到了最后一步，接下来是享受成果的时刻！</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">点选右方新选项卡的【合同<span style="color: black;">签定</span>人】选项，<span style="color: black;">保证</span>其出<span style="color: black;">此刻</span>下方的【行】模块中；继续点选右方新选项卡的【金额】选项，<span style="color: black;">保证</span>其出<span style="color: black;">此刻</span>下方的【值】模块中。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">此时<span style="color: black;">咱们</span>的数据透视表就会自动按合同<span style="color: black;">签定</span>人汇总金额。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/0a1e67b1e8834623a2db1be94672a1b4~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951659&x-signature=%2F6TrJCVcQlIEk%2FV6Nab6KtGb7AQ%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第五步的实操实例</p>
</div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">一样</span>的，<span style="color: black;">倘若</span><span style="color: black;">咱们</span>想按合同号汇总金额，只需点选右方新选项卡的【合同号】选项，<span style="color: black;">保证</span>其出<span style="color: black;">此刻</span>下方的【行】模块中；继续点选右方新选项卡的【金额】选项，<span style="color: black;">保证</span>其出<span style="color: black;">此刻</span>下方的【值】模块中。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">此时<span style="color: black;">咱们</span>的数据透视表就会自动按合同号汇总金额。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/f157d0e094c949daa87183ef66441d89~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951659&x-signature=VOZDL38WxTfScdqt6mj0ExiXH84%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第五步的实操实例</p>
</div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">简单的汇总数据透视表教程以上就讲完了，接下来是稍微<span style="color: black;">繁杂</span><span style="color: black;">有些</span>的进阶操作。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第六步：进阶操作1</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">倘若</span>领导又想<span style="color: black;">晓得</span>合同<span style="color: black;">签定</span>人分别签了<span style="color: black;">那些</span>合同，总金额为多少应该怎么操作呢？</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">亦</span>很简单，只需点选右方新选项卡的【合同<span style="color: black;">签定</span>人】选项，<span style="color: black;">保证</span>其出<span style="color: black;">此刻</span>下方的【行】模块中后；再点选右方新选项卡的【合同号】选项，<span style="color: black;">保证</span>其出<span style="color: black;">此刻</span>下方的【行】模块中；最后点选右方新选项卡的【金额】选项，<span style="color: black;">保证</span>其出<span style="color: black;">此刻</span>下方的【值】模块中<span style="color: black;">就可</span>。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/27cb0b71ee4b4a64844ed6cfa5794218~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951659&x-signature=k9GGOdtIFJFbq9BZ9nia0htCkZk%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第六步的实操实例</p>
</div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">这一步容易出错的<span style="color: black;">地区</span>在于，<span style="color: black;">必定</span>要先点选【合同<span style="color: black;">签定</span>人】选项，再点选【合同号】选项，<span style="color: black;">保证</span>【合同<span style="color: black;">签定</span>人】选项在行模块中<span style="color: black;">位置于</span>【合同号】选项上方。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第七步：进阶操作2</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">倘若</span>领导只想<span style="color: black;">晓得</span><span style="color: black;">每一个</span>人签了多少份合同应该<span style="color: black;">怎样</span>操作呢？</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">亦</span>很简单，只需要在【值】模块中，</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">点击【求和项：金额】选项，点击【值字段设置】选项，将值汇总方式从求和改为计数<span style="color: black;">就可</span>。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/2a1e6f6667254d018935e035dd41eeb3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951659&x-signature=mieF%2FMnZD2g1mhAXN9iOpp02gIg%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第七步的实操实例</p>
</div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/4261d427158e40bbb8638e940dbc8a9e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727951659&x-signature=o1VqKyxr41I4qBE1p6tflvAwYQs%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第七步的实操实例</p>
</div>
页:
[1]