论坛 › 黑龙江 › Excel表格制作教程：明明看到1了，为么查询不到？

nykek5i 发表于 2024-10-1 18:31:25

Excel表格制作教程：明明看到1了，为么查询不到？

    <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;"><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>数据1<span style="color: black;">是由于</span>公式得来时，<span style="color: black;">咱们</span>要<span style="color: black;">查询</span>肉眼看到的数据1，就<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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">01</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>与替换</strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">非常多</span>小伙伴习惯了不<span style="color: black;">选取</span>区域直接进行<span style="color: black;">查询</span>和替换操作。但有时，这个习惯会<span style="color: black;">引起</span>失误。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">为何</span>呢？下面给<span style="color: black;">大众</span>演示一下，<span style="color: black;">倘若</span><span style="color: black;">无</span>先选中区域，会是什么结果。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">如下图所示的表格中有两个表格区域，<span style="color: black;">咱们</span>需要将区域1中所有的“<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/k6kCsib3eJMxlf01OX3DuNfmGVetzHcSnGl20YFqRiavgpHibiaKUcKArKB89ibcgBGLXG2fATf4rx17k9mck3H6cMg/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;">此时，<span style="color: black;">若<span style="color: black;">咱们</span><span style="color: black;">无</span>先选定区域</span><span style="color: black;">1 </span>，而是直接按替换命令快捷键Ctrl+H，弹出对话框。在“<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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRywUww7z3TEv6faN3waFibqju57sxjr3nFicZBusJgqNic6mgGPd9InbTDLYXQfEwjPsHHAroKEBCg/640?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;"><span style="color: black;"><span style="color: black;">咱们</span><span style="color: black;">能够</span>看到如下图所示结果，区域1和区域2中的“<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>先选中区域1，<span style="color: black;">因此</span>excel很智能地对<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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRywUww7z3TEv6faN3waFibLvtAfzO3VMwjZpKfvRMc4fgPTdYYtZCRlh5MLiaxWOLlyNEamK8WBSQ/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p><span style="color: black;"><span style="color: black;">因此</span>，<span style="color: black;">倘若</span>不是针对<span style="color: black;">全部</span>文档进行<span style="color: black;">查询</span>和替换，<span style="color: black;"><span style="color: black;">必定</span>要先选中需要进行该操作的区域</span>。</span>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">02</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">“单元格匹配”</strong></p><span style="color: black;">在<span style="color: black;">实质</span>的工作中，表格<span style="color: black;">常常</span><span style="color: black;">繁杂</span>多样，在进行<span style="color: black;">选取</span>替换时会遇到<span style="color: black;">各样</span>各样的问题。</span>
    <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 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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRywUww7z3TEv6faN3waFib10TMYBiaOtgOcz659zGwFetA94ZffKXiakpNjgfJKiciapTQsB4knQ8L3A/640?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;"><span style="color: black;">按替换快捷键Ctrl+H，在弹出的对话框中，“<span style="color: black;">查询</span>内容”后面输入“<span style="color: black;">营销</span>”，“替换为”后面输入“<span style="color: black;">营销</span>部”，设置好后点击<span style="color: black;">所有</span>替换。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRywUww7z3TEv6faN3waFibQxj27Lm5CHDrhvHiaImJagv5fU5zODf4CyylqEqnbzYEAa5IVqKSx4w/640?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;"><span style="color: black;"><span style="color: black;">咱们</span><span style="color: black;">能够</span>看到结果，表格中“<span style="color: black;">营销</span>”变<span style="color: black;">成为了</span>“<span style="color: black;">营销</span>部”，但本<span style="color: black;">便是</span>“<span style="color: black;">营销</span>部”的单元格变<span 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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRywUww7z3TEv6faN3waFibkqtiaGMNQ6Qotib9LYIQNvNHsY8gcgMfyeZxh7IrEVUrcH1zb5CiasibWA/640?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;"><span style="color: black;">怎么办？<span style="color: black;">咱们</span>需要回到前一<span style="color: black;">过程</span>，在“替换”对话框中，点击“选项”，<span style="color: black;">而后</span>在<span style="color: black;">表示</span>的各选项内容中勾选“单元格匹配”。单元格匹配指的只<span style="color: black;">查询</span>单元格的值等于<span style="color: black;">查询</span>内容的单元格，属于绝对匹配。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRywUww7z3TEv6faN3waFib5zYjicoQ5cIb59Cudc0nHNQbabI8DMpTjOplibAzbY7wBq3JgQNhK0VA/640?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;"><span style="color: black;">此时<span style="color: black;">咱们</span>再点击“<span style="color: black;">所有</span>替换”，就<span style="color: black;">能够</span>得到正确的结果。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRywUww7z3TEv6faN3waFibrLmU6HNsCLstHk5Y8AkYoqf3tFwbUxeDnlYSQbdCgllypfJqV5N0mA/640?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;"><span style="color: black;">这个单元格匹配的问题，在<span style="color: black;">咱们</span>处理数字的时候更加需要<span style="color: black;">重视</span>。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">如下图所示的区域4中，我想将单元格中的数字5替换为10。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRywUww7z3TEv6faN3waFibRo09EDf1wlHjZAZaD9g1Fvib4ynFu7uOVb1FbO5sCYzTMDL3m4kQ44A/640?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;"><span style="color: black;">按替换快捷键Ctrl+H，在弹出的对话框中，“<span style="color: black;">查询</span>内容”后面输入5，“替换为”后面输入10，设置好后点击<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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRywUww7z3TEv6faN3waFibGIgwlFnk9fsQW4dhmpkDXpoY7MJVMVksG6pWbibbKxibAxs3qwVQkLCA/640?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;"><span style="color: black;">此时所有的数字“5”都会被替换为10。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRywUww7z3TEv6faN3waFibDHdr1ictt7WODzEuJfyeGvzsAxzhDR8XIATJb1KUdbeyd3LvCZalHjA/640?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;"><span style="color: black;"><span style="color: black;">咱们</span>要<span style="color: black;">处理</span>这个问题，和前面<span style="color: black;">同样</span>，勾选“单元格匹配”就<span style="color: black;">能够</span>了。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">03</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>范围</strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">除了上面两种<span style="color: black;">大众</span>可能遇到的问题，还有一种<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>到数字1。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRywUww7z3TEv6faN3waFibOOnewd6icxdLf4fvQ9bmCia106CTbfNxOHp42G9249Ubxp9ATtgmpr0A/640?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;"><span style="color: black;">按<span style="color: black;">查询</span>快捷键“Ctrl+F”，在弹出的对话框中，输入<span style="color: black;">查询</span>内容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;">此时弹出了对话框，提示“<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>的区域5中，明明有两个单元格都是数字1。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRywUww7z3TEv6faN3waFibeGWWDygcicZDg7pvZ9zukLbNH6MLcjf0lk80EQNruMqZuYXW68omiaFQ/640?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;"><span style="color: black;">答案还是在选项里。单击“选项”按钮，<span style="color: black;">能够</span>看到默认的<span style="color: black;">查询</span>范围是“公式”。<span style="color: black;">咱们</span>上面的操作<span style="color: black;">包括</span>了两个<span style="color: black;">要求</span>：<span style="color: black;">第1</span>，<span style="color: black;">全部</span>单元格的值<span style="color: black;">便是</span>“1”（勾选“单元格匹配”的结果）；第二，这个“1”必须在公式中<span style="color: black;">显现</span>过（查找范围“公式”的结果）。<span style="color: black;">咱们</span>点击单元格，在编辑栏<span style="color: black;">能够</span>看到区域5的两个“1”都是公式运算后的值，但公式中并<span style="color: black;">无</span>“1”，<span style="color: black;">亦</span><span style="color: black;">便是</span>说只满足了<span style="color: black;">第1</span>个<span style="color: black;">要求</span>。这<span style="color: black;">便是</span><span style="color: black;">咱们</span>看到了1但找不到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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRywUww7z3TEv6faN3waFibdy76iaSnAmtDcQbElJ1sfRnicxVxFYXYe4EticClvw9FNibxgSMLodibKfg/640?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;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRywUww7z3TEv6faN3waFibAjGDR47NLgbdaTiaMVGrIwlzrhlpVtw8nIvoUWMnhibnicAMI73dzH0IA/640?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;"><span style="color: black;"><span style="color: black;">此时</span>，<span style="color: black;">咱们</span>将“<span style="color: black;">查询</span>范围”修改为“值”，并勾选“单元格匹配”。单击“<span style="color: black;">查询</span><span style="color: black;">所有</span>”<span style="color: black;">就可</span><span style="color: black;">查询</span>到了<span style="color: black;">咱们</span>需要的数字1（单元格C33和C34）。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRywUww7z3TEv6faN3waFibwuA6En5HLO4W3khevVxgQ9kTmjqg5xgiapP8krWPUCrU8Esul3LQcWw/640?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;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRywUww7z3TEv6faN3waFibgMfZ93p9N2llVOWjXnAW5DmPGKVicpAD1Pfw7jR7LicnxlJXxUjnov8Q/640?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;"><span style="color: black;">好了，今天的分享就到<span style="color: black;">这儿</span>。</span></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>，助你从零<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>单元格快捷键&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="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;">财务表格复制粘贴<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="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;">财务表格复制粘贴<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="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;">财务表格中的<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="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. 认识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. 效率小贴士：快速对区域小计汇总金额</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 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="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;">第十二章：财务人员必会函数之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>

nykek5i 发表于 2024-10-30 02:12:39

你的见解真是独到，让我受益匪浅。

查看完整版本: Excel表格制作教程：明明看到1了，为么查询不到？