Excel 数据透视表的用法远不止某些人以为的哪些，逆向操作学一下-外链论坛

6hz7vif 发表于 2024-10-2 14:33:03

Excel 数据透视表的用法远不止某些人以为的哪些，逆向操作学一下

<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>会觉得 Excel 单个案例讲解有些碎片化，初学者未必能完全理解和<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>，一步步由简入繁、从入门到精通，系统化地讲解 Excel 的各个知识点。</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> Excel 的操作技巧、快捷键大全、函数公式、数据透视表、图表、打印技巧等……学完全本，你<span style="color: black;">亦</span>能<span style="color: black;">作为</span> Excel <span style="color: black;">能手</span>。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;">
   <div style="color: black; text-align: left; margin-bottom: 10px;">
         <div style="color: black; text-align: left; margin-bottom: 10px;">
            <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/24ef7e0323e644b387c35536970b3ff4~noop.image?x-expires=2012479580&x-signature=tpFm5pCL0bgqvHi%2F5WS9ZsOZSuI%3D" style="width: 50%; margin-bottom: 20px;">
               <div style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">专栏</span></div>
            </div>
            <div style="color: black; text-align: left; margin-bottom: 10px;">
               <div style="color: black; text-align: left; margin-bottom: 10px;">Excel从入门到精通</div>
               <div style="color: black; text-align: left; margin-bottom: 10px;">作者：Excel学习世界</div>
               <div style="color: black; text-align: left; margin-bottom: 10px;">
                     <div style="color: black; text-align: left; margin-bottom: 10px;">99币</div>
                     <div style="color: black; text-align: left; margin-bottom: 10px;">81人已购</div>
               </div>
               <div style="color: black; text-align: left; margin-bottom: 10px;">查看</div>
            </div>
         </div>
   </div>
</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>是二维表，<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>要看完。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">案例：</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">将下图 1 中的姓名合并成一列，效果如下图 2 所示。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/a1c82191280548a797a55608ef4afb31~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977568&x-signature=8XxLGOpfxNEO5GtYoZI8d0HKo9M%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/96a6a39bac0d459e9a6abd91a95fd919~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977568&x-signature=l%2FgBFNy7fzicy14ALplCbKqtBH4%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">处理</span><span style="color: black;">方法</span>：</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1. 按 Alt+D+P --> 在弹出的对话框中<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/d986133b29454a3da725d15dafba90de~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977568&x-signature=GNqyHmZ4nEnavhbaEtf896UyawE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2. <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/ac89c888a18d493c9cabc9aaef36167c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977568&x-signature=T9klZ7aXNHS0Hvs0ivtNuxWLSSQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">3. 选中数据表的 A、B 列 --> 点击“添加”按钮</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/2e0df32602f64be0823b6f30cc44f452~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977568&x-signature=CxE%2FJJfl2djLJbABEQoGnyzHqlU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">4. 选中 B、C 列 --> 点击“添加”按钮</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/290102ee7ab3471392182b64f6199faf~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977568&x-signature=PuBJ5FrdL7rtpbLSg99%2F5Y9zHZI%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">5. 选中数据表的 C 列及 D 列的同等空白行 --> 再次点击“添加”按钮</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/0d6e41e962434d538784448e4ebbd4fb~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977568&x-signature=kUUZ9BgSqDq6KRIrof2WpZ5ZJCA%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">6. 点击“下一步”。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/e88d2a456a524059823d13fc85703ad4~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977568&x-signature=q8AK%2FGITjcbv0NtyiZ5fV0CwHEw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">7. 在弹出的对话框中<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/afcb1293102442c7b7d88aac4339bde3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977568&x-signature=t44uqvzvmvdh7pUpbs71mIB4V6Q%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/a946248ec10241dda089d6ca2e72afb2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977568&x-signature=%2Fm5cQBvApKB526w%2FM%2B2yhtFBOpE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">8. 复制数据透视表中的连续姓名区域 --> 在空白区域粘贴为值</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/24ddb6683c1e4841b8dfd2a939c5f973~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977568&x-signature=T717RxH7xTfZ%2FoEJjfljJjIHwl4%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">9. 删除数据透视表，添加标题及框线。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/3d175229b93d418b9dcd8ab4184bd8bc~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727977568&x-signature=5%2BV9zxBbKTGNw1RBi2MEXD3MxMI%3D" style="width: 50%; margin-bottom: 20px;"></div>

1fy07h 发表于 2024-10-14 21:58:31

期待你更多的精彩评论，一起交流学习。

1fy07h 发表于 5 天前

外贸论坛是我们的，责任是我们的，荣誉是我们的，成就是我们的，辉煌是我们的。

页: [1]

外链论坛's Archiver

Excel 数据透视表的用法远不止某些人以为的哪些，逆向操作学一下