为么意见你用数据透视表？这是我见过最好的答案！【Excel教程】
<span style="color: black;"><strong style="color: blue;">回复[</strong><strong style="color: blue;">目录</strong><strong style="color: blue;">]学习113篇Excel教程</strong></span><p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyNDmBGzGRtxMH3iaH2Y4ymrult7ic3Qxz8fZib5LJF78otFT256MRPNwoSMUx1E4frA4Lsiaj2P6XwSA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">全套Excel视频教程，<span style="color: black;">微X</span>扫码观看</strong></span></p><span style="color: black;">之前瓶子给<span style="color: black;">大众</span>推送了3篇数据透视表的教程，介绍了许<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>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">源数据如下，是某<span style="color: black;">机构</span>登记的一年内物料领取表，总共登记了1000条，<span style="color: black;">这儿</span>为了方便演示，中间部分数据省略。</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz6IfvMLe9ib7wWlehwE4gYzmD96r5MxPcFhOPt1b0KzLTsSE3viasqPVk1Bd2bZKMQItaDj6vIGMMg/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">老板<span style="color: black;">需求</span>了，要查看一年内，领取物料最多的前10个员工的占比。</span><span style="color: black;">制作数据汇总表，需要<span style="color: black;">思虑</span>到，表格数据一目了然并且美观，<span style="color: black;">最后</span>瓶子做出的汇总表如下：</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz6IfvMLe9ib7wWlehwE4gYz3q9juFtEUUibCC4JXO7icW2l6NPzgFVDNkSIHBFevTbaSjR0ibSzDdbwQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">下面瓶子带领<span style="color: black;">大众</span><span style="color: black;">一块</span>来做一下。</span>
<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;">数据透视表的三板斧 </p><span style="color: black;">选中数据，点击【<span style="color: black;">插进</span>】-【数据透视表】，将姓名拖到行标签下，领取数量和金额拖到数值下。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz6IfvMLe9ib7wWlehwE4gYz0viaJrv03bksUR3tYym6rd67NMRNCia8l5F1Eyon2RwN0oLTCQY7icf2Q/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><span style="color: black;">创立</span>好数据透视表后，用下面的三板斧，让透视表变成<span style="color: black;">咱们</span>常规的样式。</span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">第1</span>板斧</span></strong><span style="color: black;">，点中透视表，在工具栏<span style="color: black;">显现</span>浮动选项卡，点击【选项】-【+/-按钮】，<span style="color: black;">就可</span>关闭透视表里的组合按钮。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz6IfvMLe9ib7wWlehwE4gYzvKVuia99s9YsADXh3cyianicxIUcGyvf6skxj19llxt5VkjHkI4aJ7rMg/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">当然了，<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><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz6IfvMLe9ib7wWlehwE4gYzA980sMYKoyZhic4Av7Xe3h1hNKBkVuCevL2wY04dErZoO5ahpBHpicKg/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><strong style="color: blue;"><span style="color: black;">第二板斧</span></strong><span style="color: black;">，在【设计】选项卡中，点击【<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><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz6IfvMLe9ib7wWlehwE4gYzRdcZMJhcp7wk7rHhRBe8yibicsf5Z1xibCDicUEgNhq7ODzbclrFXh4nxQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><strong style="color: blue;"><span style="color: black;">第三板斧</span></strong><span style="color: black;">，点击【设计】-【报表布局】-【以表格形式<span style="color: black;">表示</span>】，将透视表的样式转换成<span style="color: black;">咱们</span>熟知的表格形式。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz6IfvMLe9ib7wWlehwE4gYz0tt6UbkAeuR1YGqbkmTqm6Coze1jecdaJpiafnv4ZMkYlJ4w6ThKJpQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<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;">值筛选和排序 </p><span style="color: black;">下面<span style="color: black;">咱们</span>来对数据进行排序，点击名字后方的下拉按钮，<span style="color: black;">选取</span>【值筛选】-【10个最大的值】。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz6IfvMLe9ib7wWlehwE4gYznTSTczwCsic6fW5k7pHepUHhK0kVYeXYvw7KMHBicLUadCcv3N92ibEvg/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">在弹出的对话框中，<span style="color: black;">选取</span>最大10项，排序的依据，看<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><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz6IfvMLe9ib7wWlehwE4gYz1bcjZVHBW0hKTJR3LEr6dt3tEdBSyd46l4t9lUkViagBnZSFibjh06icQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">再点击名字后方的下拉按钮，<span style="color: black;">选取</span>【其他排序选项】。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz6IfvMLe9ib7wWlehwE4gYzKiaICvzvmBcGbJVcphY0Q6b6EialKcUD5aBnw38xK4EboFzjbibWck6PA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">在弹出的对话框中，<span style="color: black;">选取</span><span style="color: black;">根据</span>金额降序<span style="color: black;">摆列</span>。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz6IfvMLe9ib7wWlehwE4gYzItxcFzUavsjdCNicQhp0z673OKhdDWEcBzTorWJlUoT9E6sh2JpW9oQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">点击确定后结果如下，金额是降序<span style="color: black;">摆列</span>，数量却不是了，<span style="color: black;">例如</span>静香领取的数量比大头少，<span style="color: black;">然则</span>金额却更高，说明静香领取的物料种类价格更贵。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz6IfvMLe9ib7wWlehwE4gYzdzDElTduWiciaVRib75SgE14F21t4OwCOAwL3huRDO3ekZj5yGlqLDCAA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">下面<span style="color: black;">咱们</span>生成名次列。将【金额】二次拖入数值下。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz6IfvMLe9ib7wWlehwE4gYziayaMvyJaL98u0NC3acUwYGrw9DibyG1oIjE4cicOLQU3l9Qlj7wP6SkQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">双击【求和项:金额2】，在对话框中将名<span style="color: black;">叫作</span>改为【名次】，值<span style="color: black;">表示</span>方式设置为【降序<span style="color: black;">摆列</span>】。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz6IfvMLe9ib7wWlehwE4gYzdDHZHhqxBK4sa0iaicYO9gZumdicSG0tcL00xQJcGWS4KJ8dfA3CicicVUQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">点击确定后，<span style="color: black;">能够</span>看到生成名次列。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz6IfvMLe9ib7wWlehwE4gYzs4evhkhQoURhCFs3UQ29eAeE4icfAop2Vjapd6aHmQqKCpfQnBQEVLA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">3</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">组合数据</p><span style="color: black;">选中【求和项：金额】，单击右键，在下拉菜单中<span style="color: black;">选取</span>【值<span style="color: black;">表示</span>方式】-【总计的半分比】。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz6IfvMLe9ib7wWlehwE4gYzay7nBa36E7oe7ahSjnck4RfSP78L47SGJ1aQvl8eNm02K1oc0SRicVQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">结果如下，但需要<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><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz6IfvMLe9ib7wWlehwE4gYzOGvWyLRb9jzuf5fgic1gsUxtYLfKEvM4qV1LCTHwW7JtWkK1Zg0jLoA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">点击名字的下拉菜单中，<span style="color: black;">选取</span>【从“名字”中清除筛选】，<span style="color: black;">就可</span>取消筛选。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz6IfvMLe9ib7wWlehwE4gYz0S7iaaibDZBNRicSA22OPoejAUzIGr1fBXKavv0gNjk98wyDbzmGah0jQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">此时，<span style="color: black;">咱们</span><span style="color: black;">能够</span>看到<span style="color: black;">每一个</span>人金额占所有人的百分比。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz6IfvMLe9ib7wWlehwE4gYzBz9PngW2iclw7NwDZICy5XZurhQWvJQawzhYicuIvlxf6ela2dfaibX7g/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><span style="color: black;">咱们</span>需要<span style="color: black;">保存</span>上方的占比，又想要只<span style="color: black;">表示</span>前十个人的数据，<span style="color: black;">能够</span>选中除了前10名的其他人员，单击右键，<span style="color: black;">选取</span>“创建组”。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz6IfvMLe9ib7wWlehwE4gYzgK5GFYxGYTdicLsJWllIvuxiaUbjz1GicpGxsOgORcoDOviaZ38EibMCCpw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">此时会看到透视表中多出来一列【名字2】，并且将除了前十名的其他人都归纳为了【数据组1】。（<span style="color: black;">这儿</span>为了方便演示，瓶子将领取数量和名次列移除了）</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz6IfvMLe9ib7wWlehwE4gYzDGo8anolvQ4hpB7O8GTmk602P9n74zGTVic0IibaQzPiap2Vpibl19Y1vQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">取消勾选【名字】，<span style="color: black;">就可</span>删除原先的名字列。</span><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">和前面的<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><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">选中数据组1，在编辑栏将其改名为其他。</span><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">4</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">手动排序 </p><span style="color: black;"><span style="color: black;">因为</span>老板只需要看前十名的占比，为了美观和方便查看，<span style="color: black;">咱们</span><span style="color: black;">能够</span>把【其他】拖动到表格的末尾。</span><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">将其颜色设置为灰色，斜体。</span><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">而此时会<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>的，而移动之后，又恢复到excel默认状态下<span style="color: black;">根据</span>名字列首字母<span style="color: black;">摆列</span>。</span><span style="color: black;">此刻需要将所有数据都手动<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><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">这时只需要<span style="color: black;">根据</span>数据条的长短，选中数据，将鼠标移至边框线上，拖动数据到合适的位置。</span><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">为了让老板看到的数据更加直观，<span style="color: black;">咱们</span><span style="color: black;">能够</span>把金额二次拖入到数值下方。</span><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">选中A1、B1和C1单元格，在编辑栏将其改名为名字、占比和金额，<span style="color: black;">这儿</span>需要加<span style="color: black;">重视</span>的是，名字和金额前方需要加一个空格，避免和字段列表重名。</span><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><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><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><span style="color: black;">大众</span>学会了吗？在<span style="color: black;">实质</span>工作中，<span style="color: black;">咱们</span>需要综合运用excel中的各个工具，多次调试，<span style="color: black;">才可</span>将excel发挥到极致，<span style="color: black;">有效</span>又高质量的完成工作！</span>扫一扫添加老师<span style="color: black;">微X</span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">在线咨询Excel课程</span></p><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">Excel教程<span style="color: black;">关联</span><span style="color: black;">举荐</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;">比VLOOKUP好用10倍，学会它后，碰上合并单元</span></a>格，再<span style="color: black;">亦</span>不怂了！</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;">函数界<span style="color: black;">亦</span>搞裁员？<span style="color: black;">咱们</span>恐将告别IF函数！【excel教程】</span></a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;">被老板嫌弃报表数据太丑？6招，给你的Excel数据做个“微整形”！</span></a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">想要跟随滴答老师全面系统学习Excel，不妨关注《<span style="color: black;">1星期</span>Excel直通车》视频课<span style="color: black;">或</span>《Excel极速贯通班》。</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">《<span style="color: black;">1星期</span>Excel直通车》</strong></span>视频课</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">包括</span>Excel技巧、函数公式、</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>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">最实用接地气的Excel视频课</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">《<span style="color: black;">1星期</span>Excel直通车》</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">风趣易懂，快速<span style="color: black;">有效</span>，</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">带您7天学会Excel</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">38 </strong></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;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">（已更新完毕，可永久学习）</span></strong></span></strong></span></strong></span></strong></span></strong></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;"><strong style="color: blue;"><span style="color: black;">主讲老师： 滴答</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">Excel技术大神，资深培训师；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">课程粉丝100万+；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">研发</span>有《Excel小白脱白系列课》</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"> 《Excel极速贯通班》。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">原价299元</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 style="color: black;"><strong style="color: blue;"><span style="color: black;">99</span></strong></span></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 style="color: black;">一辈子</span>的Excel职场技能！</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"> 长按下面二维码立即购买学习</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">购课后，加客服<span style="color: black;">微X</span>：blwjymx3领取练习课件</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">让工作提速百倍的「Excel极速贯通班」</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">↓ 点击<span style="color: black;"><strong style="color: blue;"><span style="color: black;">阅读原文</span></strong></span>，可直接购买。</span></p>
感谢楼主分享，祝愿外链论坛越办越好！
页:
[1]