esc0rp 发表于 2024-10-1 19:20:02

Excel教程：按月求和，一看就会！


    <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 style="color: black;">微X</span>扫码观看《财务人的Excel速成视频》</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_png/k6kCsib3eJMySq3RV8kgfHv7ATM9bFWeuPdP5W7p0pVTrTa2Qd4BggS0a0VIbdWlcicezmEoIPHZrnyYkIh7hXCQ/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMySq3RV8kgfHv7ATM9bFWeuPdP5W7p0pVTrTa2Qd4BggS0a0VIbdWlcicezmEoIPHZrnyYkIh7hXCQ/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMySq3RV8kgfHv7ATM9bFWeuPdP5W7p0pVTrTa2Qd4BggS0a0VIbdWlcicezmEoIPHZrnyYkIh7hXCQ/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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/k6kCsib3eJMzdicfftiadYh7CDVXl0gwYwaXz7KRRgwF7ayk5h5NOmpXrfGlrIicxte2X29QQ5AhwqVmTrsR1QV7lA/640?wx_fmt=jpeg&amp;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;">&nbsp;<a style="color: black;">财务人的Excel速成课，春节超级福利！</a></span></p>1<span style="color: black;">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>工作中用Excel按月求和案例。</span><span style="color: black;">A、B列是<span style="color: black;">区别</span>月份的<span style="color: black;">营销</span>明细，<span style="color: black;">此刻</span>需要<span style="color: black;">根据</span>A列的日期按月求和汇总，分别汇总出3-9月份的<span style="color: black;">营销</span>额。</span>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMxy4LLFNx8KtBkvWX2b9yiaOibVY6e7nHeCmQq4sbbrx6jApS7I6BXJHWfcgogj8UaMvSaIHTmu4jlA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;">excel按月求和函数公式，<span style="color: black;">重点</span>用到了SUM+IF+MONTH嵌套<span style="color: black;">运用</span>。</span><span style="color: black;">E3单元格输入公式：</span><span style="color: black;">=SUM(IF(MONTH(A2:A31)=D2,B2:B31))，<span style="color: black;">而后</span>记得<span style="color: black;">同期</span>按下shift、ctrl 、enter键结束公式，<span style="color: black;">由于</span>这是数组公式！</span><span style="color: black;">再接着下拉就<span style="color: black;">能够</span>得到其他月份的总<span style="color: black;">营销</span>额。</span><span style="color: black;">2</span><span style="color: black;">在右边，是<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><span style="color: black;"><span style="color: black;">第1</span>步，<span style="color: black;">插进</span>——数据透视表。</span>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMxy4LLFNx8KtBkvWX2b9yiaOkK8iaufdgXfA1v5mibdtkt5fPEV7wC6s5fKIKXlP3abRQTN49qoAf1Ng/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;">第二步，弹出的创建数据透视表中，<span style="color: black;">咱们</span>设置区域为A1:B31单元格区域，<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>当前工作表的J1单元格区域。&nbsp;</span>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMxy4LLFNx8KtBkvWX2b9yiaOOCTyZPyIXibOVA74t6QJO9sQZibvcrK6FriaKWskRoXDibhOzfooibK6vtQ/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;">第三步，将 “日期”拖动到行，将“<span style="color: black;">营销</span>额”拖动到值。</span>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMxy4LLFNx8KtBkvWX2b9yiaOq3orh4CCgle1kAiaj6YRtn0UoJ0yOBFQg8wpribermhHibMTZ7Bl7aycA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;">第四步，任意日期单元格鼠标右键<span style="color: black;">选取</span>“创建组”。</span>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMxy4LLFNx8KtBkvWX2b9yiaOfKtNlGhInm8iaHBribbX25Vmj5xbuN8syvmgCkBK9tVggVoOuDC4Q6fg/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;">第五步，在“组合”面板，<span style="color: black;">咱们</span><span style="color: black;">选取</span>按月汇总<span style="color: black;">就可</span>实现让excel按月求和。</span>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMxy4LLFNx8KtBkvWX2b9yiaOTv2ZoRcsFzESXiaGZJL6PjictQfdabnb9atHKdVmYgiaCMJe7TRx2Yk6A/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>扫一扫添加老师<span style="color: black;">微X</span>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMz29ibCptW68SVvcH9rzSICcXPldEqgfiaUkWzUzunVc3JDGf6e52kZ7eicfESEVpAvtWIwmKSEIEyfw/640?wx_fmt=jpeg&amp;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></p><img src="https://mmbiz.qpic.cn/mmbiz_png/b96CibCt70iabwjyojLhA03PtxUnkNPREnYMIXQoTgtW6libdMibQVNic3eZhU08VyWfSQWdI82zIYSzSTq4Y3YV9nQ/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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;"><strong style="color: blue;">财务人的Excel速成课<span style="color: black;">教育</span>目录</strong></p>课程<span style="color: black;">目的</span>：<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">你将对Excel知识体系有全面的认识，将财务常用到的Excel技巧、函数，数据透视表等知识一网打尽。</span></p>适用人群：<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">财务、会计、HR、税务、审计、<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 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><span style="color: black;">10年财务工作经验，注重授课内容的可操作性和实用性。</span></p>课程<span style="color: black;">特殊</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>应对财务工作<span style="color: black;">需要</span>，助你从零基础进阶到Excel老手。</span></p><strong style="color: blue;">课程简介：</strong>&nbsp;<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 style="color: black;">第1</span>章：</span><span style="color: black;">财务人的<span style="color: black;">各样</span>花式填充</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1. 发票登记表的序号填充</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2. 批量添加发票填表人</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 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;">5. 好用到让你尖叫的金额提取妙招</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">6. 效率小贴士：不得不服的快手技巧&nbsp;</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/k6kCsib3eJMwTm7iaETZB8ziaxEBfQy2zUOr1UwkFMILvdnBSTib9jx40kabTUVIco36z2InuLPaFnFRIA673xOCJA/640?wx_fmt=jpeg&amp;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;"><strong style="color: blue;"><span style="color: black;">第二章：</span><span style="color: black;">财务人规范和<span style="color: black;">有效</span>的录入技巧</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1. 规范录入现金日记账</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2. 效率翻倍的下拉菜单制作技巧</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">3. Excel数据个性化录入提示设置</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">4. 快速准确录入客户档案信息表</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">5. 效率小贴士：自动填充发票收到时间&nbsp;</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/k6kCsib3eJMwTm7iaETZB8ziaxEBfQy2zUOPdJ2icFToyv4zf6IibUSVuMRYkf9EL35ulIb6jiciaobyqzqQMQz43mmXA/640?wx_fmt=jpeg&amp;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;"><strong style="color: blue;"><span style="color: black;">第三章：</span><span style="color: black;">Excel<span style="color: black;">要求</span>格式让您的报表多姿多彩</span></strong></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 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></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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">5. 效率小贴士：快速核对两列数据差异&nbsp;</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/k6kCsib3eJMwTm7iaETZB8ziaxEBfQy2zUOjdib4PHA1xgaDyvvOwsMLnWNIMwBibdMVibY3YbzraFIDrsnnGoYcFQug/640?wx_fmt=jpeg&amp;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;"><strong style="color: blue;"><span style="color: black;">第四章：</span><span style="color: black;">玩转数据筛选，<span style="color: black;">容易</span>应对报表</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1. 筛选常用快捷方式设置技巧</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></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;">5. <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;">6. 高级筛选快速提取不重复数据</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">7. 效率小贴士：不为人知的横向筛选小妙招&nbsp;</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/k6kCsib3eJMwTm7iaETZB8ziaxEBfQy2zUO4hCCB5wKjDKTpoCCicQ2oD5HpSqmviaibjDvB4jwJPHOxGFfqCIjTXXibA/640?wx_fmt=jpeg&amp;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;"><strong style="color: blue;"><span style="color: black;">第五章：</span><span style="color: black;">应对领导的<span style="color: black;">各样</span>数据排序问题</span></strong></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 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;">4. <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;">5. 对颜色<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;">6. <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;">7.&nbsp;横向排序以及排序<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;">8. 效率小贴士：超好用的4大<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/k6kCsib3eJMwTm7iaETZB8ziaxEBfQy2zUOHictEny3MvIZu1TfW5uYwrLARLM5whwxhMwBotQenoqASkN2Ne3FcVQ/640?wx_fmt=jpeg&amp;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;"><strong style="color: blue;"><span style="color: black;">第六章：</span><span style="color: black;"><span style="color: black;">查询</span>和替换的另类用法</span></strong></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 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 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;">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;">5. <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;">6. 单元格<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;">7. <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;">8. <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;">9. <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;">10. 效率小贴士：巧妙<span style="color: black;">运用</span><span style="color: black;">查询</span>进行数据转置排版&nbsp;</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/k6kCsib3eJMwTm7iaETZB8ziaxEBfQy2zUOlLduq9ktNJWlgMqvhcZOrGwI08e5F6ricJiauo9b85bQgvp6TXC6vFlg/640?wx_fmt=jpeg&amp;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;"><strong style="color: blue;"><span style="color: black;">第七章：</span><span style="color: black;">财务表格复制粘贴<span style="color: black;">哪些</span>事(一)</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1. 必会技巧之格式刷讲解</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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">5. 巧妙<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;">6. 效率小贴士：<span style="color: black;">快速</span><span style="color: black;">调节</span>行高列宽&nbsp;</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/k6kCsib3eJMwTm7iaETZB8ziaxEBfQy2zUOJB4k78UZXeJtS04jSZUxicUBUn1QhP1gOMAfwMfIH6KPtCqibyLibxMcw/640?wx_fmt=jpeg&amp;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;"><strong style="color: blue;"><span style="color: black;">第八章：</span><span style="color: black;">财务表格复制粘贴<span style="color: black;">哪些</span>事(二)</span></strong></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>工资的3种<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;">5. 让数值以万为单位<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;">6. 快速核对两张表的差异</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">7. 快速设置和原表相同的列宽</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">8. 效率小贴士：快速<span style="color: black;">插进</span>随单元格<span style="color: black;">体积</span>而变动的<span style="color: black;">照片</span>&nbsp;</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/k6kCsib3eJMwTm7iaETZB8ziaxEBfQy2zUOopvdlJNwADIa3qxgehzglWJaaLYymUZibAHArVLEjqvFnPquCTAmV5Q/640?wx_fmt=jpeg&amp;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;"><strong style="color: blue;"><span style="color: black;">第九章：</span><span style="color: black;">财务表格中的<span style="color: black;">奥妙</span>格式</span></strong></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 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;">4. 巧用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;">5. 员工身份证中快速提取出生日期</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">6. 利用分列功能快速校正<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;">7. <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;">8. 文本和数字格式互换技巧（对应的Excel课件是空白）</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">9. 效率小贴士：利用SHIFT对<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/k6kCsib3eJMwTm7iaETZB8ziaxEBfQy2zUOITW2rEfwSx39BIEK9vsUIq8NRYvW8a6foybzSLcS3rab1FO662hvAg/640?wx_fmt=jpeg&amp;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;"><strong style="color: blue;"><span style="color: black;">第十章：</span><span style="color: black;">开启EXCEL财务应用的函数之旅</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1. 认识Excel函数</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2. SUM函数讲解：工资表的各项数据汇总</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">3. MAX和MIN函数统计当月员工最高和最低工资</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">4. SUBTOTAL函数及毛利表数据汇总</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">5. 一键对多行多列求和</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">6. 效率小贴士：快速对区域小计汇总金额&nbsp;</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/k6kCsib3eJMwTm7iaETZB8ziaxEBfQy2zUOgaIDXcHS4dr7F31Mw7KSBicAQx7EKD1pjCibBgUJJPxLTMpiclRNhcnIg/640?wx_fmt=jpeg&amp;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;"><strong style="color: blue;"><span style="color: black;">第十一章：财务人员必会函数之<span style="color: black;">规律</span>判断函数</span></strong></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. IF函数多层嵌套<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. 利用IF函数进行区间判断<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;">4. IF函数家族的另外一个函数：SUMIF函数</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">5. <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;">6. SUMIF函数典型的3类财务案例讲解</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">7. SUMIF函数的多列错位求和</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">8. 在SUMIF函数中<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;">9. 效率小贴士：ROW函数自动编制行序号</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/k6kCsib3eJMwTm7iaETZB8ziaxEBfQy2zUOWHIvOteo9ficsjysspoUIEeF7IcE318qkXv26iaC7R8MFh0neGjcxrkA/640?wx_fmt=jpeg&amp;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;"><strong style="color: blue;"><span style="color: black;">第十二章：财务人员必会函数之VLOOKUP函数</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1. VLOOKUP函数：<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;">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. VLOOKUP函数<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;">4. <span style="color: black;">引起</span>VLOOKUP函数出错的<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;">5. 固定资产折旧计算表：ROUND函数月折旧额计算</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">6. 把多列多行打印在一页的设置<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;">7. 效率小贴士：在每页开头打印标题的<span style="color: black;">办法</span>&nbsp;</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;"><strong style="color: blue;"><span style="color: black;">第十三章：</span><span style="color: black;">EXCEL中的战斗机——数据透视表(一)</span></strong></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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">3. 利用字段拖拽进行<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;">4. 数据透视表字段的筛选</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">5. 字段排序的3种<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;">6. 数据透视表字段的组合应用</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">7. 效率小贴士：批量快速新建规定名<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="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;"><strong style="color: blue;"><span style="color: black;">第十四章：</span><span style="color: black;">EXCEL中的战斗机——数据透视表(二)</span></strong></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 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 style="color: black;">平常</span>问题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;">4. 透视表<span style="color: black;">平常</span>问题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;"><span style="color: black;">5. 数据源更新的<span style="color: black;">处理</span><span style="color: black;">方法</span>&nbsp;</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">6. 发送数据透视表的<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;">7. 效率小贴士：多行多列提取不重复值</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;"><strong style="color: blue;"><span style="color: black;">《财务人的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;">更新完毕，永久学习</span></strong></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;">春节福利</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;">29元</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;">&nbsp;99&nbsp;</span>元&nbsp;）</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">长按二维码购买</strong></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;"><strong style="color: blue;">订阅须知</strong></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 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;">微X</span>：yangli952-</span></p>




1fy07h 发表于 2024-10-10 20:30:17

对于这个问题，我有不同的看法...

nykek5i 发表于 2024-10-14 19:56:31

感谢楼主的分享！我学到了很多。
页: [1]
查看完整版本: Excel教程：按月求和，一看就会！