论坛 › 上海 › Excel教程：Excel批量生成表格技巧，赶紧get！

wloe2gf 发表于 2024-10-2 15:50:24

Excel教程：Excel批量生成表格技巧，赶紧get！

    <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><span style="color: black;">这是咱们<span style="color: black;">微X</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>有了这些工作表名<span style="color: black;">叫作</span>，<span style="color: black;">怎样</span>快速生成9张工作表，并且9张工作表的名字分别是：一<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><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMzCbvwliac4QVPtc5wnJ45u3nv2cYR8hRLY6TF1HGlEGhBsfhlXZ0pbicwDGkat4sPzBSMrAUFoWHsg/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">有人可能会说用VBA，但<span style="color: black;">针对</span>我<span style="color: black;">这般</span>不会VBA的小白<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><span style="color: black;"><span style="color: black;">第1</span>步，选中A1:A10单元格区域，执行“<span style="color: black;">插进</span>——数据透视表”，在H1单元格创建数据透视表。</span><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMzCbvwliac4QVPtc5wnJ45u3Uoa60YEel3Azy8kMiciacicBDVkSYAJkYX3aXHJ5sLricCgUhhnxjC7Nvg/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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_jpg/k6kCsib3eJMzCbvwliac4QVPtc5wnJ45u3gcXlXH4dKEOS8s4bjmHM9YNE1vkTS0UdP1re8ibtsg7wicLYGM9JxIzw/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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_jpg/k6kCsib3eJMzCbvwliac4QVPtc5wnJ45u3bNcJf1LlicIWSsIaJbf3IvNUE0Fbgxa81r479v8JG9Q32YMYmNhv8aQ/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">
      <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>直接点击“确定”。</p>
    </span><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMzCbvwliac4QVPtc5wnJ45u3U8Vnjx9w1UemWJZvmK8RgUXVELiaiaYJxplON6jg0pXysMIZ3wp6ibiaug/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"><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><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMzCbvwliac4QVPtc5wnJ45u3RaqF6FnicJqurJOMYnmpuGh5QVOmXibO1ntJNBksd5bn4waIe7wQPic0Q/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">最后再删除表格中的内容。选定所有的工作表，按下CTRL+A，全选，执行“<span style="color: black;">起始</span>——清除——<span style="color: black;">所有</span>清除”，搞定啦！</span><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMzCbvwliac4QVPtc5wnJ45u3PCHLqJn2LUXAKV5yoNGWemJSSib51uCt1icFnjXFNiceEVOdHUrvsib8Qg/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">以上秒秒钟的操作就实现了excel批量生成工作表，你学会了吗？：）</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="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>，助你从零<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. 效率小贴士：快速核对两列数据差异</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>单元格快捷键&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/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 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>行高列宽</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></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函数家族的<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;">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>

j8typz 发表于 2024-10-6 23:30:09

你的见解独到，让我受益匪浅，非常感谢。

4zhvml8 发表于 3 天前

楼主果然英明！不得不赞美你一下！

查看完整版本: Excel教程：Excel批量生成表格技巧，赶紧get！