wrjc1hod 发表于 2024-10-1 09:42:03

跟小雅学Excel数据透视表系列教程第四节


    <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></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 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/k6kCsib3eJMxVibbHsZmHf0vFmKia03Oek3BG6ia7PCda0ibSbc4yFrvIO8JtxA6JPOwFaoGyQj4Q75sd1Uhx9kezTQ/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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;"><span style="color: black;">知识点1：年、季度、月组合</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 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_gif/k6kCsib3eJMxVibbHsZmHf0vFmKia03Oek3TuXslxeMpqrtqNxWianeqXcYEUGfzH9ia0icvFKJawFyUrrjWK1tyQa3Q/640?tp=webp&amp;wxfrom=5&amp;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;"><strong style="color: blue;"><span style="color: black;">知识点2：按天组合</span></strong></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>要统计每10天的<span style="color: black;">营销</span>额，先取消月、季度、年组合，<span style="color: black;">而后</span>勾选日，再设置天数为10 <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/k6kCsib3eJMxVibbHsZmHf0vFmKia03Oek3hv0C44HZt2WEP2jiaOZ4JaWgF83K64E1VTG1piaK0lAMCNNoLhjVlkCA/640?tp=webp&amp;wxfrom=5&amp;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;"><strong style="color: blue;"><span style="color: black;">本文配套的数据源，请到QQ群：316492581下载。长按下面二维码加入QQ群。</span></strong></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/k6kCsib3eJMxVibbHsZmHf0vFmKia03Oek3mt8gVr6s8B8E2eXOt8CQX40GZRCtcJfqwE6s2qFCuMl67B80Q9WBBg/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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;">想要跟随小雅和滴答老师全面系统学习Excel，不妨关注</span><strong style="color: blue;"><span style="color: black;">《<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;"><strong style="color: blue;">《<span style="color: black;">1星期</span>Excel直通车》全套</strong><strong style="color: blue;">视频教程</strong>：<span style="color: black;"><span style="color: black;">包括</span>Excel技巧、函数公式、</span><span style="color: black;">透视表、图表</span><span style="color: black;">。</span><span style="color: black;"><strong style="color: blue;">38&nbsp;</strong></span><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;"><strong style="color: blue;"><span style="color: black;">主讲老师： 滴答</span></strong></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/k6kCsib3eJMw9HqsFgNibg3wrgklctzmiaton0P5Rr0efiaGAzyScpqGmtKMTX4m2HhJh3Kalv4BqrRgmDsZGzLcWw/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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;">原价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;">&nbsp; 长按下面二维码立即购买学习</span></strong></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/k6kCsib3eJMyRk1dLib9MF8ibkrib22RUuZYPKJUibQRoiaNz30Ktvd2ia94SYvwMqp4ZlY4OTSk5FSEQ7xP3aeo5P93Q/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">领取练习课件</span></p>




页: [1]
查看完整版本: 跟小雅学Excel数据透视表系列教程第四节