4lqedz 发表于 2024-10-1 19:11:09

Excel教程：这个小技巧，秒杀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><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 style="color: black;">隐匿</span>。</span><span style="color: black;">除了<span style="color: black;">隐匿</span>之外，伙伴们还<span style="color: black;">能够</span>试试“分级<span style="color: black;">表示</span>”功能。</span><span style="color: black;">将不需要的列<span style="color: black;">同期</span>选中，执行“数据——创建组”，<span style="color: black;">就可</span>折叠起来。</span><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_gif/k6kCsib3eJMztP8qRJKKDMicJ2KPzKr1VKFiaGIZ42vHXocD95nlpN31PLibSKe8jKvN174T4sIpMEZIWLXSdeZ0Xw/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=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>身份证号码中，将重复的身份证号码标识出来。</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/k6kCsib3eJMztP8qRJKKDMicJ2KPzKr1VKwgiamFg3hTKWBlFalf28kicibmqc1RZnmqgXgrejXO25PTia1fNxGKwU6w/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;">B2单元格公式为：</span><span style="color: black;">=IF(COUNTIF(A:A,A2<span style="color: black;">&amp;"*"</span>)&gt;1,"重复","")，下拉<span style="color: black;">就可</span>将重复的标识出来。</span><span style="color: black;">可能有些小伙伴会问，<span style="color: black;">这般</span>写公式怎么不对：</span><span style="color: black;">=IF(COUNTIF(A:A,A2)&gt;1,"重复","")</span><span style="color: black;"><span style="color: black;">原由</span>在于excel表中只能<span style="color: black;">保存</span>15位有效数字，超过15位后的数字<span style="color: black;">所有</span><span style="color: black;">表示</span>为0；</span><span style="color: black;">即使是文本格式，COUNTIF函数在运算时，将文本型数字当作数值来处理；</span><span style="color: black;"><span style="color: black;">因此</span><span style="color: black;">咱们</span>为了精确无误就需要连接通配符&amp;"*"，让Excel强行识别为文本进行统计。</span><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. 效率小贴士：不得不服的快手技巧</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>单元格快捷键&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>行高列宽&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函数家族的<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="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMwTm7iaETZB8ziaxEBfQy2zUOhBqXIYYxyTrdfK9qMhjVpOwC7QonUZI8jqR0ialr3oHDg86iabgI5Qqw/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. <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="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;">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="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMwTm7iaETZB8ziaxEBfQy2zUOS5aic3DBmP5LY8B16Ey9CBWlk1pkPwiae78ZPjcpRbyT9vBwMXdSj6icg/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;">《财务人的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="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMw9RcMLORrsxosXDRadKYOvRUecubrXTG6F6WZE89FM6BVOp2btk1L23EjeqjYaYEF2X3CsvVICicg/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;">订阅须知</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>




4zhvml8 发表于 2024-10-15 21:33:14

你的见解真是独到，让我受益良多。

1fy07h 发表于 2024-11-2 14:43:19

真情实感，其含义为认真了、走心了的意思，是如今的饭圈常用语。
页: [1]
查看完整版本: Excel教程：这个小技巧，秒杀Excel隐匿功能！