跟小雅学Excel数据透视表系列教程第1节
<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 style="color: black;">运用</span>函数公式容易崩溃,而数据透视表却毫无压力,能够<span style="color: black;">快速</span>对数据进行处理,<span style="color: black;">提高</span>工作效率。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">玩转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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1、源数据之间<span style="color: black;">不可</span>存在空行、空列。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2、<span style="color: black;">不可</span>存在合并单元格。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">3、源表有日期的,必须是规范的日期格式。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">4、源数据必须是一维表,<span style="color: black;">不可</span>是二维表。</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><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></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>进行求和、计数等等计算。而所进行的计算与数据跟数据透视表中的<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>
<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 style="color: black;">分部</span>的<span style="color: black;">营销</span>业绩</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;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMzSryVwmE7n5PyVkj1WDbicGv9AyZwDlAZzM8d0QlThMxoeuxbCylzv18ic5gPDfFDqxsrcSe4SXaqQ/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;">汇总<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>用sumif等函数来求和。</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>你记不住玩不转函数,那用数据透视表是最快的<span style="color: black;">办法</span>,只需几秒钟就能<span style="color: black;">快速</span>统计各<span style="color: black;">分部</span>业绩。</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>:</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1、选中数据中的任意一个单元格,单击菜单栏:<span style="color: black;">插进</span>——数据透视表。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2、将<span style="color: black;">分部</span>拖动到行字段,业绩拖动到值区域,就<span style="color: black;">快速</span>得到各<span style="color: black;">分部</span>的业绩。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMzSryVwmE7n5PyVkj1WDbicGzWZZDspRTmGLav1GBtunicEZvxLMbISMy6u27GCqm0cYwC58B4AUtuA/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;"><span style="color: black;">详细</span>的操作<span style="color: black;">过程</span>,请观看下面的动画演示:</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/k6kCsib3eJMzSryVwmE7n5PyVkj1WDbicGh0iaKUtVgCicfajl8L3K1AfZft1LtFv8LMh8Xk4ibOOqOhAyRTwQCA7Bg/640?tp=webp&wxfrom=5&wx_lazy=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;">知识点讲解:</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>字段分布在行上。列字段<span style="color: black;">便是</span>分布在列上。</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>的区域。<span style="color: black;">例如</span><span style="color: black;">咱们</span>要业绩求和,就要把业绩放在值区域。</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>进行自动计算,字段的<span style="color: black;">增多</span>和减少都只要轻轻一拖就能实现。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">本文配套的练习文件,请到QQ群:623629548下载。</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;">【今日互动】</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>的<span style="color: black;">第1</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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMzSryVwmE7n5PyVkj1WDbicGQ0Ke9ZoGQXt9m1y6WhRKfKp0RVYlcMUtb4YBg0pzftuZk2UdPm7zBw/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><img src="https://mmbiz.qpic.cn/mmbiz_gif/z5dhYNLPCvJqcJ1YYpf2vKQnv2FzjiaEk2WMsntSQfjpo3VNnTFyogI7xHyTdTU9GDEpnnA8qF4nwaFp6XrbAng/640?tp=webp&wxfrom=5&wx_lazy=1" 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;">部落窝教育微课堂</span><strong style="color: blue;"><span style="color: black;">VIP会员</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;">畅学</span></strong></span><span style="color: black;">直播间27个专栏课程</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、Word、PPT</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">PS、AI、CAD、CDR、AE</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>等,</span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">长时间</span>学习</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;">原价</span><span style="color: black;"><strong style="color: blue;">1200</strong></span><span style="color: black;">元</span><span style="color: black;">,</span><span style="color: black;">限时抢购</span><span style="color: black;"><strong style="color: blue;">365</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;"> 扫描下面二维码,参与抢购</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz5PZbEHVfHOFbzhPFNN4xdIMFeGCaxhHdicSMAsnJd5zf93F3mLA4Fewexia6xz9mRgcFChby3fmibA/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;">客服<span style="color: black;">微X</span>:603830039</span></p>
你的见解独到,让我受益匪浅,非常感谢。
页:
[1]