为么老外的Excel表格都这么美丽？看这一篇就够了！
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><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 style="color: black;">专题</span>！</span></h1><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><img src="https://mmbiz.qpic.cn/mmbiz_jpg/4jUToJBtQvSNG9J97LiaXKmy3iaKDVfia34gGBMRH8BPaoVLjGsqrb7GRv1x448lrYbvNKvTjrNVRdepd1SZU9QiaA/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/4jUToJBtQvSNG9J97LiaXKmy3iaKDVfia34F93dltCibicqoDHPzR4RWgicCicT46ohxlCjlWzLIkax2rcDpJicN9XD8jw/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&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;"><span style="color: black;">再<span style="color: black;">瞧瞧</span><span style="color: black;">咱们</span><span style="color: black;">平常</span>的表格，难看度瞬间爆表：</span></p><img src="https://mmbiz.qpic.cn/mmbiz_jpg/4jUToJBtQvSNG9J97LiaXKmy3iaKDVfia34DXZNE7YVcdYgwsYjzOs2lUFhEKkSwMqrUoZQ8bK8ZgtzFicSxrpwC3w/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">无论是在企业做财务，还是在四大做审计，有一项共通的技能<span style="color: black;">便是</span>：Excel要6到飞起！正<span style="color: black;">所说</span>Excel玩得好，下班会很早。</span><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 style="color: black;">才可</span>让Excel表格又好看，又实用呢？</span><span style="color: black;"><span style="color: black;">Excel技能千千万，其实说到底，做到精通的话，<strong style="color: blue;">只要学会4+1，4个核心函数为<span style="color: black;">基本</span>篇：</strong></span><strong style="color: blue;"><span style="color: black;">SUM、IF、VLOOKUP、SUMIF，1个数据透视表为进阶篇。</span></strong><span style="color: black;">搞清楚这五个，在工作中需要Excel<span style="color: black;">处理</span>的，基本上问题都不大。</span></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">6大核心资料速速领取！</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">1、</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"> 800个</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">会计最常用Excel表格模板</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">2、 </span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">203个</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">会计工作Excel快捷键大全</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">3、</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"> 168</span></strong><strong style="color: blue;"><span style="color: black;">套</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">财务最高逼格Excel分析图表</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">4、 </span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">153个</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">Excel视频教程，1800分钟，入门到精通</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">5、</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"> 37套</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">会计做账Excel全套表格</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">6、 2019全年工资表Excel工具包，带公式，数据全自动生成</span></strong></span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">无</span><span style="color: black;">招数</span><span style="color: black;">仅有</span>诚意</span></strong><span style="color: black;">让你的工作效率<span style="color: black;">提高</span>10倍</span><strong style="color: blue;"><span style="color: black;">长按识别下方二维码关注</span></strong><span style="color: black;">回复“</span><span style="color: black;"><strong style="color: blue;">0918</strong></span><span style="color: black;">”<span style="color: black;">就可</span></span><span style="color: black;"><strong style="color: blue;">免费领取</strong></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/83OTuUOnEpxFmtJ8MuicI3AZVAMzm5k53Zn81RKDjiahfDtKziaOHIzZwTk0MFXLPMyyfiaKrV362dqqkgyz71XCibg/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;"><strong style="color: blue;"><span style="color: black;">01</span></strong></span><strong style="color: blue;"><span style="color: black;">SUM<strong style="color: blue;">函数</strong>（数学）</span></strong><strong style="color: blue;"><span style="color: black;">重要程度：</span></strong><strong style="color: blue;"><span style="color: black;">★★★★★</span></strong><strong style="color: blue;"><span style="color: black;">学习难度：</span></strong><strong style="color: blue;"><span style="color: black;">★★</span></strong><span style="color: black;">在<span style="color: black;">平常</span>的工作中与学习中，SUM是一款应用极为广泛并且做为入门级的函数来学习的。<span style="color: black;">因此</span>，整体<span style="color: black;">来讲</span>，SUM函数难度不高，应用性却很广泛。<span style="color: black;">然则</span><span style="color: black;">不可</span><span style="color: black;">由于</span>简单就小瞧了SUM，它还有<span style="color: black;">有些</span>不为人知的小技巧！</span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">1、</span><span style="color: black;">累计求和</span></strong></span><span style="color: black;">如下图，是某企业的每一天的<span style="color: black;">营销</span>业绩，<span style="color: black;">需求</span>计算<span style="color: black;">每日</span>的累计金额。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/A51uxxl6GQyAIlfrXqViafr8y88VPMOjbagibjQDPPGOSmQOqrQgrvNzMibrrxO2C2ZMEHCXO3XBo4vWI22nzgCyg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">在D2单元格中输入公式：</span><span style="color: black;">=SUM(C$2:C2)</span><span style="color: black;">，按Enter键完成后向下填充。</span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">重视</span>：</span></strong><span style="color: black;"><span style="color: black;">此时</span>的C$2<span style="color: black;">必定</span>是要锁定行标的，<span style="color: black;">这般</span>在下拉的过程中才会产生从第二行<span style="color: black;">始终</span>到向下的行的一个引用区域。</span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">2、</span>带有合格单元格的求和</span></strong></span><span style="color: black;">合并单元格的求和，<span style="color: black;">始终</span>是一个比较让新手头疼的问题。</span><span style="color: black;">选中D2:D13单元格区域，<span style="color: black;">而后</span>在公式编辑栏里输入公式：</span><span style="color: black;">=SUM(C2:C13)-SUM(D3:D14)</span><span style="color: black;">，<span style="color: black;">而后</span>按<Ctrl+Enter>完成，如下图所示：</span><img src="https://mmbiz.qpic.cn/mmbiz_png/A51uxxl6GQwFB2o0CqKzcc8g8NticrM91ickv8BFrmfGBicsVxEDoKbYbjMIIeJ5mHUW6vXKOVp1yKF1zogwq2PZQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><strong style="color: blue;"><span style="color: black;">注：</span></strong><span style="color: black;"><span style="color: black;">必定</span>要<span style="color: black;">重视</span>第二个SUM函数的区域范围要错位，<span style="color: black;">否则</span>就报错。</span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">3、</span>带有小计的单元格求和</span></strong><span style="color: black;">带有小计的单元格到底怎么样求和？在C9单元格里是输入公式：</span><span style="color: black;">=SUM(C2:C8)/2，</span><span style="color: black;">按Enter键完成。如下图所示：</span><img src="https://mmbiz.qpic.cn/mmbiz_png/A51uxxl6GQwFB2o0CqKzcc8g8NticrM91LnRsBJww80NjOVMhnN6l37wRqn0RImDS9HspHxzw1CCrWUq6Omd03Q/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">重视</span>：</span></strong><span style="color: black;"><span style="color: black;">这儿</span>是自用了小计与求和的过程是重复计算了上面的数据，<span style="color: black;">因此</span>再除以2就<span style="color: black;">能够</span>得到不重复的结果，<span style="color: black;">亦</span>正是想要的结果。</span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">4、</span>文本<span style="color: black;">怎样</span>求和</span></strong><span style="color: black;">在<span style="color: black;">有些</span>比较不规范的表中呢，会有文字与数字的混合的问题，给求和带来了<span style="color: black;">必定</span>了的难度。</span><span style="color: black;">在C12单元格中输入公式：</span><span style="color: black;">=SUM(--SUBSTITUTE(C2:C11,"元",""))</span><span style="color: black;">按组合键<>Ctrl+Shift+Enter>完成。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/A51uxxl6GQyAIlfrXqViafr8y88VPMOjbYFS5vscHK0dM9zwMvo0BE0rlIfhQSsjG3kH4VGUM2sUywqBTcJ5Hxg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">重视</span>：</span></strong><span style="color: black;"><span style="color: black;">这儿</span>的公式两边的花括号不是的手动输入的，而是在按组合键后系统自动添加上去的。</span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">5、</span>多工作表求和</span></strong><span style="color: black;">下表中是4个月的业绩统计，<span style="color: black;">每一个</span>工作表的里面的张成的位置都是<span style="color: black;">同样</span>的，求张成的1-4月的提成统计。</span><span style="color: black;">在F5单元格中输入公式：</span><span style="color: black;">=SUM(1月:4月!C2),</span><span style="color: black;">按Enter键完成填充。如下图所示：</span><img src="https://mmbiz.qpic.cn/mmbiz_png/A51uxxl6GQwFB2o0CqKzcc8g8NticrM91xjbSqgtG3e442zjUuFjhQEF6l2oxWibMYX21xib1tpmyY31b73SJSg1Q/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><span style="color: black;">重视</span>：在Excel中是支持上面的这种引用的，<span style="color: black;">然则</span>在WPS里面貌似不支持。并且要<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><strong style="color: blue;"><span style="color: black;"><span style="color: black;">6、</span>多区域联合计算</span></strong><span style="color: black;">在有些工作表中，<span style="color: black;">咱们</span>并不需要对连续的区域进行求和，可能是对不连续的某几个区域进行求和。</span><span style="color: black;">如下图所示，计算1-2月，3月以及5-6月的合计。</span><span style="color: black;">在H2单元格中输入公式，按Enter键完成后向下填充。</span><span style="color: black;">=SUM(B2:C2,E2,G2)</span><img src="https://mmbiz.qpic.cn/mmbiz_png/A51uxxl6GQyAIlfrXqViafr8y88VPMOjbUNBibVQlR5b0BZ4D9NkKPut09oElf4ZWrJl9K7DRf6gu29hABPptJAw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">重视</span>：</span></strong><span style="color: black;"><span style="color: black;">这儿</span><span style="color: black;">运用</span>逗号将各个不连续的区域连接起来的引用方式叫联合引用。</span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">7、</span><span style="color: black;">要求</span>求和</span></strong><span style="color: black;">除了SUMIF，SUMIFS之外还<span style="color: black;">能够</span><span style="color: black;">运用</span>SUM函数来进行<span style="color: black;">要求</span>求和。</span><span style="color: black;">在G4单元格中输入公式：</span><span style="color: black;">=SUM((B2:B11="日用")*(E2:E11))</span><span style="color: black;">按组合键<Ctrl+Shift+Enter>键完成后向下填充。如下图所示：</span><img src="https://mmbiz.qpic.cn/mmbiz_png/A51uxxl6GQyAIlfrXqViafr8y88VPMOjbnFQnOGy4meibeMmREvLatvytm15vKMlPQ6am63pfnHhvhovH6D85D6A/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">8、</span><span style="color: black;">要求</span>计数</span></strong><span style="color: black;">除了上面的求和之外，SUM函数还<span style="color: black;">能够</span>代替COUNTIFS，COUNIF函数进行计数。</span><span style="color: black;">在G4单元格中输入公式：</span><span style="color: black;">=SUM(1*(B2:B11="日用"))</span><span style="color: black;">按组合键<Ctrl+Shift+Enter>键完成后向下填充。如下图所示：</span><img src="https://mmbiz.qpic.cn/mmbiz_png/A51uxxl6GQyAIlfrXqViafr8y88VPMOjbDAfdiaeAnSMXiaelloWicMuCNvkK4CmkaKo9gULLO8LW8LJaMocFibdP8Q/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><strong style="color: blue;">02</strong></span><span style="color: black;">IF函数（<span style="color: black;">规律</span>）</span><strong style="color: blue;"><span style="color: black;">重要程度：★★★★</span></strong><strong style="color: blue;"><span style="color: black;">学习难度：</span></strong><strong style="color: blue;"><span style="color: black;">★★★</span></strong><span style="color: black;">IF函数是Excel<span style="color: black;">规律</span>家族的扛把子，只要是<span style="color: black;">规律</span>判断就<span style="color: black;">能够</span>说离不开IF函数。IF函数很简单，几乎接触过Excel的人看到都能理解。下面我分享一下财务人员最常用到的IF函数。</span><span style="color: black;"><span style="color: black;">例如</span>：<span style="color: black;">倘若</span>已付清，则为“关账”，<span style="color: black;">倘若</span>未付清且金额大于3000元，则为“立即摧账”，<span style="color: black;">倘若</span>未付清且<span style="color: black;">少于</span>3000元，则为“状态正常”。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/giavc6mpkmic0OZIXzP4DRrFpeziczRtuoEibyp8Rub8LPEjsIXjJ5LPkJGK3rJYS8Enj5mZb5hHp4tV308SgMiaxug/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">在H4单元格中输入公式：</span><span style="color: black;">=IF(E2="否",IF(D2>=3000,"立即催账","状态正常"),"关账")</span><span style="color: black;">，按Enter键完成后向下填充。</span><span style="color: black;"><span style="color: black;">重视</span>：<span style="color: black;">一般</span><span style="color: black;">状况</span>下，IF函数经常与其他的<span style="color: black;">规律</span>函数<span style="color: black;">一块</span><span style="color: black;">运用</span>，<span style="color: black;">例如</span>AND，OR，NOT等函数。该函数在<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;">最后，IF函数<span style="color: black;">协同</span>VLOOKUP函数<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;"><strong style="color: blue;"><span style="color: black;">6大核心资料速速领取！</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">1、</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"> 800个</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">会计最常用Excel表格模板</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">2、 </span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">203个</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">会计工作Excel快捷键大全</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">3、</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"> 168</span></strong><strong style="color: blue;"><span style="color: black;">套</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">财务最高逼格Excel分析图表</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">4、 </span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">153个</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">Excel视频教程，1800分钟，入门到精通</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">5、</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"> 37套</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">会计做账Excel全套表格</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">6、 2019全年工资表Excel工具包，带公式，数据全自动生成</span></strong></span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">无</span><span style="color: black;">招数</span><span style="color: black;">仅有</span>诚意</span></strong><span style="color: black;">让你的工作效率<span style="color: black;">提高</span>10倍</span><strong style="color: blue;"><span style="color: black;">长按识别下方二维码关注</span></strong><span style="color: black;">回复“</span><span style="color: black;"><strong style="color: blue;">0918</strong></span><span style="color: black;">”<span style="color: black;">就可</span></span><span style="color: black;"><strong style="color: blue;">免费领取</strong></span><img src="https://mmbiz.qpic.cn/mmbiz_jpg/83OTuUOnEpxFmtJ8MuicI3AZVAMzm5k53Zn81RKDjiahfDtKziaOHIzZwTk0MFXLPMyyfiaKrV362dqqkgyz71XCibg/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">03</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">VLOOKUP</span></strong></span><strong style="color: blue;">函数（筛选）</strong><strong style="color: blue;"><span style="color: black;">重要程度：</span></strong><strong style="color: blue;"><span style="color: black;">★★★★★</span></strong><strong style="color: blue;"><span style="color: black;">学习难度：</span></strong><strong style="color: blue;"><span style="color: black;">★★★★</span></strong><span style="color: black;">VLOOKUP被<span style="color: black;">叫作</span>为Excel中的效率之王，<span style="color: black;">然则</span>95%的Excel<span style="color: black;">运用</span>者都<span style="color: black;">不可</span>很好<span style="color: black;">运用</span>VLOOKUP。<span style="color: black;">然则</span>，VLOOKUP函数又是Excel中的<span style="color: black;">公众</span>情人。有平台曾经做过“<span style="color: black;">倘若</span>只能<span style="color: black;">选取</span>学习Excel中的一项功能，你会<span style="color: black;">选取</span>哪个”的调查，VLOOKUP函数竟然高居第二位。</span><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><span style="color: black;">这些工作本质上都是匹配调用：</span><strong style="color: blue;"><span style="color: black;">匹配<span style="color: black;">一样</span>的数据，调用出<span style="color: black;">咱们</span>需要的数据。</span></strong><span style="color: black;">要<span style="color: black;">处理</span>这个问题，最常用到的<span style="color: black;">便是</span>VLOOKUP函数。</span><span style="color: black;"><span style="color: black;">那样</span>VLOOKUP函数<span style="color: black;">到底</span><span style="color: black;">怎样</span><span style="color: black;">运用</span>呢？</span><span style="color: black;">VLOOKUP函数语法结构：VLOOKUP(Lookup_value,Table_array,Col_index_number,Range_lookup),即VLOOKUP（<span style="color: black;">查询</span>值，<span style="color: black;">查询</span>范围，返回的数值所在的列数，精确匹配还是模糊匹配）。</span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">1、</span>VLOOKUP函数精确匹配，返回你需要的<span style="color: black;">独一</span>数据</span></strong><span style="color: black;"><span style="color: black;">例如</span><span style="color: black;">按照</span>姓名匹配身份证号信息，<span style="color: black;">针对</span>这种匹配调用<span style="color: black;">独一</span>的数据，就要用到VLOOKUP函数的精确匹配了。</span><span style="color: black;">操作<span style="color: black;">过程</span>：<span style="color: black;">查询</span>范围为绝对引用，可按快捷键F4，精确匹配下参数为0或FALSE。</span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">重视</span>事项：</span></strong><span style="color: black;"><span style="color: black;">查询</span>范围和要返回的数值所在的列数都是要从<span style="color: black;">查询</span>值所在的列<span style="color: black;">起始</span>计算。</span><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;"><span style="color: black;">VLOOKUP<span style="color: black;">查找</span>调用精确匹配</span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">2、</span>VLOOKUP函数模糊匹配，返回你需要的区间数据</span></strong><span style="color: black;"><span style="color: black;">例如</span><span style="color: black;">按照</span>考核等级确定奖金比例，<span style="color: black;">针对</span>这种在区间范围内匹配调用数据，就要用到VLOOKUP函数的模糊匹配了，这个功能完全<span style="color: black;">能够</span>替代掉IF函数的多层嵌套，再<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>范围依然为绝对引用，可按快捷键F4，模糊匹配下参数为1或TRUE。</span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">重视</span>事项：</span></strong><span style="color: black;">等级表的编制要从小到大</span><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;"><span style="color: black;">VLOOKUP<span style="color: black;">查找</span>调用模糊匹配</span><span style="color: black;">说清楚大方向之后，<span style="color: black;">咱们</span>来分享一下VLOOKUP的几个常规操作<span style="color: black;">办法</span>：</span><strong style="color: blue;"><span style="color: black;">1、常规<span style="color: black;">查询</span></span></strong><span style="color: black;"><span style="color: black;">查询</span>姓名对应的<span style="color: black;">营销</span>额。在F3单元格中输入公式</span><span style="color: black;">=VLOOKUP(E3,$A$2:$C$9,3,0)</span><span style="color: black;">，按Enter键完成。如下图所示：</span><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;"><strong style="color: blue;"><span style="color: black;">2、日期<span style="color: black;">查询</span></span></strong><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>TEXT函数<span style="color: black;">才可</span>完成<span style="color: black;">查询</span><span style="color: black;">需要</span>。</span><span style="color: black;">在F3单元格中输入公式</span><span style="color: black;">=TEXT(VLOOKUP(E3,$A$2:$C$9,2,0),"yyyy/m/d")</span><span style="color: black;">，按Enter键完成。如下图所示：</span><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;"><span style="color: black;">注：如返回格式为2018/12/03，则TEXT的第二个参数的格式<span style="color: black;">能够</span>设置为“yyyy/mm/dd”<span style="color: black;">就可</span>。</span><strong style="color: blue;"><span style="color: black;">3、<span style="color: black;">查询</span>的值为空时</span></strong><span style="color: black;">在当<span style="color: black;">查询</span>的值为空时，<span style="color: black;">一般</span><span style="color: black;">状况</span>下会返回结果为0，<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;">在F3单元格中输入公式</span><span style="color: black;">=VLOOKUP(E3,$A$2:$C$9,3,0)&""</span><span style="color: black;">，按Enter键完成。如下图所示：</span><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;"><strong style="color: blue;"><span style="color: black;">4、当<span style="color: black;">查询</span>的<span style="color: black;">目的</span>格式不统一时报错<span style="color: black;">怎样</span><span style="color: black;">处理</span></span></strong><span style="color: black;">（1）<span style="color: black;">倘若</span><span style="color: black;">查询</span>的<span style="color: black;">目的</span>值是文本格式，而数据区域中是数值格式。</span><span style="color: black;">如下图所示，A列中的员工编号为数值格式，而F3单元格中的员工编号为文本格式。</span><span style="color: black;">在G3单元格中输入公式：=VLOOKUP(--F3,$A$2:$D$9,4,0)，按Enter键完成。</span><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;"><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><span style="color: black;">（2）<span style="color: black;">倘若</span><span style="color: black;">查询</span>的<span style="color: black;">目的</span>值是数值格式，而数据区域中是文本格式。</span><span style="color: black;">如下图所示，A列中的员工编号为文本格式，而F3单元格中的员工编号为数值格式。</span><span style="color: black;">在G3单元格中输入公式：=VLOOKUP(F3&"",$A$2:$D$9,4,0)，按Enter键完成。</span><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;"><span style="color: black;">注：&""是强制地把数值格式转换成文本格式。</span><strong style="color: blue;"><span style="color: black;">5、区域<span style="color: black;">查询</span></span></strong><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>提点为多少。在E2单元格中输入公式：</span><span style="color: black;">=VLOOKUP(D2,$H$2:$I$8,2,1)</span><span style="color: black;">，按Enter键完成。</span><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;"><span style="color: black;">注：<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><strong style="color: blue;"><span style="color: black;">6、模糊<span style="color: black;">查询</span></span></strong><span style="color: black;">VLOOKUP函数<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>额，在H3单元格中输入公式：</span><span style="color: black;">=VLOOKUP("*"&G3&"*",$B$2:$D$9,3,0)</span><span style="color: black;">，按Enter键完成。</span><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;"><span style="color: black;">注：<span style="color: black;">倘若</span>要<span style="color: black;">查询</span>以“冰”开头的<span style="color: black;">那样</span>公式的<span style="color: black;">第1</span>参数为："*"&G3; <span style="color: black;">倘若</span><span style="color: black;">查询</span>以“冰”结尾<span style="color: black;">那样</span>公式的<span style="color: black;">第1</span>个参数为：G3&"*".</span><strong style="color: blue;"><span style="color: black;">7、<span style="color: black;">查询</span><span style="color: black;">次序</span>与数据区域中<span style="color: black;">次序</span>一致的多项时</span></strong><span style="color: black;">VLOOKUP函数<span style="color: black;">查询</span><span style="color: black;">次序</span>一致的多项时，<span style="color: black;">能够</span>借助COLUMN函数构建<span style="color: black;">查询</span>序列。</span><span style="color: black;">在H2单元格中输入公式：</span><span style="color: black;">=VLOOKUP($G2,$A$2:$D$9,COLUMN(B1),0)</span><span style="color: black;">，按Enter键后向右填充。</span><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;"><span style="color: black;">注：COLUMN函数是返回列号。<span style="color: black;">第1</span>个参数<span style="color: black;">必定</span>要锁定列号，<span style="color: black;">这般</span><span style="color: black;">才可</span>正确的结果。</span><strong style="color: blue;"><span style="color: black;">8、十字交叉<span style="color: black;">查找</span></span></strong><span style="color: black;">VLOOKUP函数<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>与MATCH函数完成<span style="color: black;">查找</span>。</span><span style="color: black;">在H2单元格中输入公式：</span><span style="color: black;">=VLOOKUP($G2,$A$2:$D$9,MATCH(H$1,$A$1:$D$1,0),0)，</span><span style="color: black;">按Enter键完成后向下向右填充。</span><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;"><span style="color: black;">注：<span style="color: black;">必定</span>要锁定VLOOKUP函数的<span style="color: black;">第1</span>个参数的列号，MATCH函数的<span style="color: black;">第1</span>个参数的行号，<span style="color: black;">这般</span><span style="color: black;">才可</span>得到正确的结果。</span><strong style="color: blue;"><span style="color: black;">9、多<span style="color: black;">要求</span><span style="color: black;">查找</span></span></strong><span style="color: black;">VLOOKUP还能进行多<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;">在I2单元格中输入公式：</span><span style="color: black;">{=VLOOKUP(G2&H2,IF({1,0},$A$2:$A$9&$B$2:$B$9,$D$2:$D$9),2,0)}</span><span style="color: black;">按组合键<Ctrl+Shift+Enter>完成后向下填充。</span><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;"><span style="color: black;">注：公式两边的花括号不是手动输入的，而是按组合键后自动输入的。VLOOKUP的第三个参数为2，第四个参数为0是固定的。</span><span style="color: black;"><strong style="color: blue;">04</strong></span>
<h3 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;"><span style="color: black;">SUMIF函数（<span style="color: black;">要求</span>计数）</span></strong></h3><strong style="color: blue;"><span style="color: black;">重要程度：</span></strong><strong style="color: blue;"><span style="color: black;">★★★<strong style="color: blue;">★</strong></span></strong><strong style="color: blue;"><span style="color: black;">学习难度：</span></strong><strong style="color: blue;"><span style="color: black;">★★★</span></strong><span style="color: black;">SUM的意思是“加和”，再加上“IF”，意思<span style="color: black;">便是</span>对范围中符合指定<span style="color: black;">要求</span>的值求和，<span style="color: black;">即满足相应的<span style="color: black;">要求</span>才进行计算</span>。</span><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><span style="color: black;">要<span style="color: black;">处理</span>这种<span style="color: black;">要求</span>求和问题就要用到SUMIF函数了。</span><span style="color: black;">SUMIF函数结构：=SUMIF(<span style="color: black;">要求</span>范围,<span style="color: black;">要求</span>,求和范围)</span><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;"><span style="color: black;">SUMIF函数有一个强化版本，即多<span style="color: black;">要求</span>版本——<strong style="color: blue;">SUMIFS</strong>。例如，下表是一份应付账款的借款明细表。请按右面的<span style="color: black;">要求</span>进行统计。<span style="color: black;">需求</span>：已付清企业的应付款额大于30万的平均值。</span><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;"><span style="color: black;">在G5单元格中输入公式：</span><span style="color: black;">=AVERAGEIFS(C:C,E:E,"是",C:C,">300000")</span><span style="color: black;">，按Enter键完成。</span><span style="color: black;"><span style="color: black;">重视</span>：该函数是求平均值的函数，<span style="color: black;">倘若</span>除数为0的<span style="color: black;">状况</span>下会返回错误值"#DIV/0!"，即<span style="color: black;">无</span>满足<span style="color: black;">要求</span>的值的时候会报出错误值。</span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">6大核心资料速速领取！</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">1、</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"> 800个</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">会计最常用Excel表格模板</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">2、 </span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">203个</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">会计工作Excel快捷键大全</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">3、</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"> 168</span></strong><strong style="color: blue;"><span style="color: black;">套</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">财务最高逼格Excel分析图表</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">4、 </span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">153个</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">Excel视频教程，1800分钟，入门到精通</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">5、</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"> 37套</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">会计做账Excel全套表格</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">6、 2019全年工资表Excel工具包，带公式，数据全自动生成</span></strong></span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">无</span><span style="color: black;">招数</span><span style="color: black;">仅有</span>诚意</span></strong><span style="color: black;">让你的工作效率<span style="color: black;">提高</span>10倍</span><strong style="color: blue;"><span style="color: black;">长按识别下方二维码关注</span></strong><span style="color: black;">回复“</span><span style="color: black;"><strong style="color: blue;">0918</strong></span><span style="color: black;">”<span style="color: black;">就可</span></span><span style="color: black;"><strong style="color: blue;">免费领取</strong></span><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;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">05</span></strong></span>
<h3 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;"><span style="color: black;">数据透视表</span></strong></h3><strong style="color: blue;"><span style="color: black;">重要程度：</span></strong><strong style="color: blue;"><span style="color: black;">★★★★★</span></strong><strong style="color: blue;"><span style="color: black;">学习难度：</span></strong><strong style="color: blue;"><span style="color: black;">★★★★</span></strong><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><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><strong style="color: blue;"><span style="color: black;"><span style="color: black;">1、</span>拖拖拽拽”，快速制作统计报表，完成数据统计</span></strong><span style="color: black;"><span style="color: black;">按照</span>你需要统计的数据维度和表格结构，“拖拖拽拽”，快速制作出你需要的统计报表，完成相应的数据统计。</span><span style="color: black;">操作<span style="color: black;">过程</span>：</span><strong style="color: blue;"><span style="color: black;">选中原始数据表中的任意单元格—【<span style="color: black;">插进</span>】—【数据透视表】—【数据透视表字段及区间】—<span style="color: black;">按照</span>报表行列呈现需要，在字段列表中选定该字段并按住鼠标左键拖放到下方的矩阵窗口中，数据透视表布局即完成。</span></strong><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;"><span style="color: black;">数据透视表创建</span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">2、</span>多种数值统计方式，<span style="color: black;">容易</span>完成</span></strong><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><strong style="color: blue;"><span style="color: black;">需要几种统计方式就拖入几次计算【值字段设置】—【值<span style="color: black;">表示</span>方式】—【百分比】。</span></strong><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;"><span style="color: black;">数据透视：<span style="color: black;">都数</span>值计算</span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">3、</span><span style="color: black;">按照</span>时间变化创建组，报表多元<span style="color: black;">表示</span></span></strong><span style="color: black;">不只是日期，数据<span style="color: black;">根据</span>月份、季度、年度<span style="color: black;">或</span>它们的组合展示，统统都<span style="color: black;">能够</span>。</span><strong style="color: blue;"><span style="color: black;">操作<span style="color: black;">过程</span>：选中任一日期数据，右键创建组，选中月份，按住CTRL,再选中年，<span style="color: black;">能够</span>随意组合的。这个<span style="color: black;">亦</span><span style="color: black;">能够</span>进行年龄分段统计等问题。</span></strong><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;"><span style="color: black;">数据透视-创建组-时间</span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">4、</span>城市组合成区域，只要手动创建一下</span></strong><span style="color: black;">北京、天津、沈阳，这些城市<span style="color: black;">怎样</span>组合成【华北区】？老板就要的大区级的数据统计，我该怎么办？不要担心，手动创建一下，瞬间完成</span><span style="color: black;">操作<span style="color: black;">过程</span>：</span><strong style="color: blue;"><span style="color: black;">选中要组合的标签（CTRL进行多选）—右键创建组—修改数据标签。</span></strong><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;"><span style="color: black;">数据透视-创建组-区域组合</span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">5、</span>数据透视表下，数据排序依然有效</span></strong><span style="color: black;">在数据透视表下，将数据升序、降序<span style="color: black;">或</span>你自己定义的<span style="color: black;">次序</span>排序？</span><span style="color: black;">操作<span style="color: black;">过程</span>：<strong style="color: blue;">选中要排序的任一一数据—右键<span style="color: black;">选取</span>排序—<span style="color: black;">选取</span>升序<span style="color: black;">或</span>降序。</strong><strong style="color: blue;"><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>降序操作。</strong></span><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;"><span style="color: black;">数据透视表：排序</span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">6、</span>数据<span style="color: black;">亦</span>可筛选，想要什么找出什么</span></strong><span style="color: black;">找出<span style="color: black;">营销</span>量TOP3的明星<span style="color: black;">营销</span>员？筛选一下，<span style="color: black;">便是</span>这么简单</span><span style="color: black;">操作<span style="color: black;">过程</span>：<strong style="color: blue;">选中任一一数据标签—右键筛选—【前10个】—修改为<span style="color: black;">根据</span><span style="color: black;">营销</span>额最大的3个。</strong></span><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;"><span style="color: black;">数据透视表：筛选</span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">7、</span>数据变化了，刷新一下，数据透视表随之而动</span></strong><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><span style="color: black;">操作<span style="color: black;">过程</span>：<strong style="color: blue;">选中数据透视表中任一数据—右键点击刷新。</strong><strong style="color: blue;">这个刷新操作是<span style="color: black;">没法</span>自动完成，手动一下，手动一下就好。</strong></span><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;"><span style="color: black;">数据透视表：手动刷新</span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">8、</span>总表分多表，利用筛选器，告别复制粘贴</span></strong><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><span style="color: black;">操作<span style="color: black;">过程</span>：<strong style="color: blue;">将分表的数据标签拖入数据透视表中的筛选器—数据透视表选项—<span style="color: black;">表示</span>报表筛选页—确定。</strong></span><span style="color: black;">双击各个报表的汇总值，符合<span style="color: black;">需求</span>的原始数据就显现了！</span><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;"><span style="color: black;">数据透视表-筛选器-分页</span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">9、</span>数据<span style="color: black;">根据</span>时间轴滚动，日程表来了</span></strong><span style="color: black;">让重要数据<span style="color: black;">根据</span>时间轴展现？怎么可能实现得了。<span style="color: black;">插进</span>一个日程表，就足够了。</span><span style="color: black;">操作<span style="color: black;">过程</span>：<strong style="color: blue;">选中数据透视表任一单元格—<span style="color: black;">插进</span>日程表，拖拉一下日程表下方的滚动轴，想看哪个月就看哪个月，想看哪几个月就看哪几个月。</strong></span><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;"><span style="color: black;">数据透视表—<span style="color: black;">插进</span>日程表</span><span style="color: black;">数据透视表的功能是不是很强大，<span style="color: black;">倘若</span>再让你完成100张数据统计报表，是不是工作效率瞬间倍增。</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 style="color: black;">仅有</span>一行、数据完整、不要汇总统计、不要合并单元格、数据格式规范。千万要记住！</span><span style="color: black;"><strong style="color: blue;">06</strong></span><strong style="color: blue;"><span style="color: black;">让Excel变得更加商务</span></strong><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 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 style="color: black;">起始</span>的问题，怎么让Excel变得更加商务，像老外的Excel那样<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 style="color: black;">咱们</span>的表格。</span><strong style="color: blue;"><span style="color: black;">第1步：</span></strong><strong style="color: blue;"><span style="color: black;">更换和弱化表格线，<span style="color: black;">明显</span><span style="color: black;">表示</span>数据。</span></strong>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">去掉表格背景网络线</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">除表头和表尾外，数据部分用浅灰色表格线。</span></p><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;"><strong style="color: blue;"><span style="color: black;">第2步：</span></strong><strong style="color: blue;"><span style="color: black;">设置隔行背景色，<span style="color: black;">能够</span>选浅灰或浅蓝色填充</span></strong>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">填允一行后，用格式刷向下刷</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">稍<span style="color: black;">增多</span>行高</span></p><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;"><strong style="color: blue;"><span style="color: black;">第3步：</span></strong><strong style="color: blue;"><span style="color: black;">修改字体类型。</span></strong>
<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;">数字用Arial</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">汉字用微软雅黑</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">合计行字体加粗</span></p><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;"><strong style="color: blue;"><span style="color: black;">第4步：</span></strong><strong style="color: blue;"><span style="color: black;">用条形图<span style="color: black;">增多</span>的年合计的可视性。</span></strong><span style="color: black;"><span style="color: black;">选择</span>G5:G11 - <span style="color: black;">要求</span>格式 - 数据条</span><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;"><span style="color: black;">完工！</span><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 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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">中间用浅色填充，表格线用白色细线</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">表尾灰色背景</span></p><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 style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">或</span></p><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;"><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><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 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><strong style="color: blue;"><span style="color: black;">老外还有3个常用法宝</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;">控件的<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></p><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;"><span style="color: black;">其实Excel<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><span style="color: black;"><strong style="color: blue;"><span style="color: black;">6大核心资料速速领取！</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">1、</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"> 800个</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">会计最常用Excel表格模板</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">2、 </span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">203个</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">会计工作Excel快捷键大全</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">3、</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"> 168</span></strong><strong style="color: blue;"><span style="color: black;">套</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">财务最高逼格Excel分析图表</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">4、 </span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">153个</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">Excel视频教程，1800分钟，入门到精通</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">5、</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"> 37套</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">会计做账Excel全套表格</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">6、 2019全年工资表Excel工具包，带公式，数据全自动生成</span></strong></span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">无</span><span style="color: black;">招数</span><span style="color: black;">仅有</span>诚意</span></strong><span style="color: black;">让你的工作效率<span style="color: black;">提高</span>10倍</span><strong style="color: blue;"><span style="color: black;">长按识别下方二维码关注</span></strong><span style="color: black;">回复“</span><span style="color: black;"><strong style="color: blue;">0918</strong></span><span style="color: black;">”<span style="color: black;">就可</span></span><span style="color: black;"><strong style="color: blue;">免费领取</strong></span><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;"><span style="color: black;"><span style="color: black;">▎</span><span style="color: black;">本文内容<span style="color: black;">源自</span>：24财务excel，Excel不加班，Excel聚焦，<span style="color: black;">Excel精英培训</span>，LinkedIn、注册会计师等。</span></span>
页:
[1]