论坛 › 虚假举报 › 工作常用电子表格Excel经典公式大全

m5k1umn 发表于 2024-10-2 17:29:04

工作常用电子表格Excel经典公式大全

    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/0S7RG0ZTWVZJAgw4OGvHsibXUGwQqdDDicn09kicOAWbQrzuyfdiaXW5xOoVNq8bia5nlx2Ga9VwZgjg15SWd3xvFsQ/640?wx_fmt=gif&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=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 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;">本文总结整理了工作常用电子表格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;">全文干货较多，一时记不全的<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;">1、<span style="color: black;">查询</span>重复的姓名</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">=IF(COUNTIF(A:A,A2)&gt;1,"重复","")</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/0S7RG0ZTWVb9t8ADXDNibybBNtzicEeafqlia0wf8ib5epDIBCNjXE1XlHm9UhEmyTH7HYhbdBLGzKv3SegeXOOxJg/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;">2、<span style="color: black;">查询</span>重复的身份证号码</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">=IF(COUNTIF(A:A,A2&amp;"*")&gt;1,"重复","")</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/0S7RG0ZTWVb9t8ADXDNibybBNtzicEeafqfpTNGUEnqYxZHNr77mVhLN285vITWtFd9o3iaqcQd2UCzh68ZSaQDuQ/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;">3、<span style="color: black;">按照</span>出生日期计算年龄</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">=DATEDIF(A2,TODAY(),"y")</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/0S7RG0ZTWVb9t8ADXDNibybBNtzicEeafqsufHprHnnwqqxlDGOKbMcpicib3lKm3tupdehbViauWmEmsmtXtxoziccw/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;">4、<span style="color: black;">按照</span>身份证号码计算出生日期</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">=--TEXT(MID(A2,7,8),"0-00-00")</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/0S7RG0ZTWVb9t8ADXDNibybBNtzicEeafqzMic5ib9UeX3NUHuAx3OWHAMUl70JTfHneMUtWegFhZWQl8jOhnxl7Rw/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;">5、<span style="color: black;">按照</span>身份证号码自动判断性别</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">=IF(MOD(MID(A2,17,1),2),"男","女")</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/0S7RG0ZTWVb9t8ADXDNibybBNtzicEeafqqh4e4GbXV7IcwNN22zDPTXkAZs51YBgbzqWKaicB5yrbkAYb1BzUecw/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;">6、自动计算<span style="color: black;">离休</span>日期</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">=DATE(MID(A2,7,4)+55+MOD(MID(A2,17,1),2)*5,MID(A2,11,2),MID(A2,13,2))</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/0S7RG0ZTWVb9t8ADXDNibybBNtzicEeafqEjubatsMnxRwtbZBbfUZ4Gadp2mFKN3azgyWJibCWs5YqscS4mmkWkg/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;">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;">=LOOKUP(--MID(A2,11,4),{101,"摩羯座";121,"水瓶座";219,"双鱼座";321,"白羊座";421,"金牛座";522,"双子座";622,"巨蟹座";723,"狮子座";823,"处女座";923,"天秤座";1024,"天蝎座";1123,"射手座";1222,"摩羯座"})</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/0S7RG0ZTWVb9t8ADXDNibybBNtzicEeafqmx6rNmbstRPzXryC68iajia8zDtjsMcH2JN7IRBNMecwlSOgpxjesmicQ/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;">8、<span style="color: black;">按照</span>身份证号码自动计算生肖属相</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">=MID("猴鸡狗猪鼠牛虎兔龙蛇马羊",MOD(MID(A2,7,4),12)+1,1)</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/0S7RG0ZTWVb9t8ADXDNibybBNtzicEeafqeACQPRFVrtiaXprLibW2xUsgicbavvE7cibpnM7koicZwTd4gWRQoibtuHPQ/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;"><strong style="color: blue;">9、单<span style="color: black;">要求</span>求和</strong></span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">=SUMIF(B:B,"<span style="color: black;">营销</span>3部",C:C)</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/0S7RG0ZTWVb9t8ADXDNibybBNtzicEeafqrJreIFKgPEyxBHGLB8BSkC6sxWIEbAzEByY8E9ZibgtwJSSxdUsq8HA/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>计算薪酬，社保费等等的时候，这个功能直接<span style="color: black;">能够</span>用)</span></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;">=SUMIFS(C:C,B:B,"<span style="color: black;">营销</span>3部",A:A,"李晓峰")</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/0S7RG0ZTWVb9t8ADXDNibybBNtzicEeafqVtiaZYUbCTqxFqia7qSD7pmR9Jah5bY7TZHuXic4notmzHgx9vJImFJEw/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;">11、忽略错误值统计</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">=SUMIF(C2:C14,"&lt;9e307")</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/0S7RG0ZTWVb9t8ADXDNibybBNtzicEeafqJGCico0JHej9JABaVOXBFW5MVsfiaINHwh2ZHgEbG23DibPvrQthiasiaLQ/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;">12、多<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;">=SUMPRODUCT((MONTH($A$2:$A$14)=8)*($B$2:$B$14=F3),$C$2:$C$14)</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/0S7RG0ZTWVb9t8ADXDNibybBNtzicEeafqGoDUM51k7lh04qpRm1wCiayr2ZZfrIND2GDK2cpO7GtKDVtxodcM2VQ/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>计算薪酬，社保费等等的时候</span><span style="color: black;">，这个功能直接可</span><span style="color: black;">以用</span><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;"><span style="color: black;">12个简单公式，是不是<span style="color: black;">能够</span>帮你减轻<span style="color: black;">非常多</span>工作量啦？</span></strong></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 style="color: black;">Excel核心技能中，这只是冰山一角。</span></span></span><span style="color: black;">与其瞎摸索，</span><span style="color: black;">真</span><span style="color: black;">的不如系</span><span style="color: black;">统地学习一次Ex</span><span style="color: black;">cel，彻底<span style="color: black;">处理</span>问题。</span><span style="color: black;">怎么破？</span></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 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;"><strong style="color: blue;"><span style="color: black;">咱们</span>筛选了<span style="color: black;">非常多</span>老师，才找到Excel界妥妥的大神</strong></span><span style="color: black;">——</span><span style="color: black;"><strong style="color: blue;">微软<span style="color: black;">全世界</span>最有价值专家MVP</strong></span><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;">又磨了3个月嘴皮，才说服李锐老师和<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;">李锐老师经过<span style="color: black;">长时间</span>筹备，又</span><strong style="color: blue;"><span style="color: black;">历时一年时间，</span></strong><span style="color: black;">把他</span><strong style="color: blue;"><span style="color: black;">20年的Excel<span style="color: black;">运用</span>技术+10年Excel培训经验</span></strong><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><strong style="color: blue;"><span style="color: black;">最高性价比</span></strong><span style="color: black;">，<span style="color: black;">咱们</span>又再次说服李锐老师把</span><strong style="color: blue;"><span style="color: black;">如此高含金量的课程定为白菜价</span></strong><span style="color: black;">（</span><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></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><span style="color: black;"><strong style="color: blue;">纯小白一枚，零<span style="color: black;">基本</span>，</strong></span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">亦</span>能<span style="color: black;">容易</span>学习这</span></strong><strong style="color: blue;"><span style="color: black;">72节课</span></strong><strong style="color: blue;"><span style="color: black;">，一次性<span style="color: black;">把握</span>Excel，完全无压力。</span></strong></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_gif/xe0iaNyVIPCTjzeEsPj0XkOQpE9dqNVLu1FV0azzDz6lgDD0OepaKdOqfb8axtpUqY0xtbdrRbjHNafNhsqZTog/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=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;"><strong style="color: blue;">72节</strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">Excel系统</span></strong></span><strong style="color: blue;"><span style="color: black;">超清</span></strong><strong style="color: blue;"><span style="color: black;">视<strong style="color: blue;"><span style="color: black;">频课</span></strong></span></strong></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;">提高</span><span style="color: black;">以上</span><span style="color: black;">各样</span><span style="color: black;">必须</span>技能</strong></span></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;"><strong style="color: blue;"><span style="color: black;">手机、ipad、电脑都<span style="color: black;">能够</span>随时听课</span></strong></span></strong></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;"><strong style="color: blue;">（原价</strong></span><span style="color: black;"><span style="color: black;"><strong style="color: blue;">：</strong></span><span style="color: black;"><strong style="color: blue;">500</strong></span></span><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;"><strong style="color: blue;"><span style="color: black;">此刻</span>仅需</strong></span><span style="color: black;"><strong style="color: blue;">99.99&nbsp;</strong><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;"><strong style="color: blue;">每节课仅需1.3元，限量特价名额</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;">持有</span>超值课程</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;">▼</span></strong></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_png/0S7RG0ZTWVb3NFXbdUibdM53vsr7fvpfM9RdlN8zBzMztvfbLicsWx3Fu7OYNk2KxsCjpMPwzE28ib8jLRzGnCW9A/640?wx_fmt=png&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;">第1</span>节为试听）</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 style="color: blue;">“课程有什么内容”</strong></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;">全面覆盖Excel全知识<span style="color: black;">行业</span></strong>！</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><strong style="color: blue;"><span style="color: black;">批量导入</span></strong><strong style="color: blue;"><span style="color: black;">、一键大法、函数公式、动态图表、微图表、透视表、透视图、高级图表、数据可视化、多表联动、多表合并、数据分析、Power&nbsp;BI等<span style="color: black;">各样</span><span style="color: black;">行业</span>......</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><strong style="color: blue;"><span style="color: black;">分为</span></strong><span style="color: black;"><strong style="color: blue;"><span style="color: black;">18</span></strong></span><strong style="color: blue;"><span style="color: black;">大板块</span></strong><span style="color: black;"><strong style="color: blue;"><span style="color: black;">72</span></strong></span><strong style="color: blue;"><span style="color: black;">节课程<span style="color: black;">仔细</span>讲解</span></strong><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><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></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 style="color: blue;">课程大纲</strong></strong></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_png/QhrwhO5yJrHkIjZsibzTw2vUjPPHF0tbouXXV22hU9z6skh79jicDrt01AGx22zAoUicwK9rQ65QuoE4IVLL18u9A/640?wx_fmt=png&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;"><strong style="color: blue;">72节</strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">Excel系统</span></strong></span><strong style="color: blue;"><span style="color: black;">超清</span></strong><strong style="color: blue;"><span style="color: black;">视<strong style="color: blue;"><span style="color: black;">频课</span></strong></span></strong></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;">提高</span><span style="color: black;">以上</span><span style="color: black;">各样</span><span style="color: black;">必须</span>技能</strong></span></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;"><strong style="color: blue;"><span style="color: black;">手机、ipad、电脑都<span style="color: black;">能够</span>随时听课</span></strong></span></strong></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;"><strong style="color: blue;">（原价</strong></span><span style="color: black;"><span style="color: black;"><strong style="color: blue;">：</strong></span><span style="color: black;"><strong style="color: blue;">500</strong></span></span><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;"><strong style="color: blue;"><span style="color: black;">此刻</span>仅需</strong></span><span style="color: black;"><strong style="color: blue;">99.99&nbsp;</strong><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;"><strong style="color: blue;">每节课仅需1.3元，限量特价名额</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;">扫码，永久学习，超值课程</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;">▼</span></strong></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;">第1</span>节为试听</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;"><strong style="color: blue;"><strong style="color: blue;">“课程有什么<span style="color: black;">特殊</span>”</strong></strong></span></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 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;">市面上大<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;">李锐老师为了<span style="color: black;">提高</span><span style="color: black;">大众</span>学习的效率，每节课都亲自写逐字稿，<strong style="color: blue;">全程干货，讲到关键要点时会降低语速、<span style="color: black;">加强</span>音量重点强调</strong>。</span></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;">每节课在20分钟内，</span></strong><strong style="color: blue;"><span style="color: black;">有思路架构、有<span style="color: black;">办法</span>解析、有原理说明、有扩展应用</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></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><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;">采用<strong style="color: blue;">1920*1080超清视频讲解</strong>+<strong style="color: blue;">同步操作演示</strong>授课，李锐老师操作过程中<span style="color: black;">运用</span>的快捷键，在</span><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;"><strong style="color: blue;"><span style="color: black;">况且</span>课程支持手机、ipad、电脑等多种设备全屏播放。</strong></span></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;">课程<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>可看不到哦！</span></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;"><span style="color: black;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">(此案例在</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">第46课</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">供给</span>视频讲解和模板下载)</span></strong></span></span></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;">光讲理论不讲案例都是耍流氓，在李锐老师的这套精品课程<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></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;"><span style="color: black;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">(此案例在</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">第65课</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">供给</span>视频讲解和模板下载)</span></strong></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;"><span style="color: black;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">(此案例在</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">第66课</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">供给</span>视频讲解和模板下载)</span></strong></span></span></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;">每节课</span><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></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;"><span style="color: black;"><strong style="color: blue;">72节</strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">Excel系统</span></strong></span><strong style="color: blue;"><span style="color: black;">超清</span></strong><strong style="color: blue;"><span style="color: black;">视<strong style="color: blue;"><span style="color: black;">频课</span></strong></span></strong></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;">提高</span><span style="color: black;">以上</span><span style="color: black;">各样</span><span style="color: black;">必须</span>技能</strong></span></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;"><strong style="color: blue;"><span style="color: black;">手机、ipad、电脑都<span style="color: black;">能够</span>随时听课</span></strong></span></strong></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;"><strong style="color: blue;">（原价</strong></span><span style="color: black;"><span style="color: black;"><strong style="color: blue;">：</strong></span><span style="color: black;"><strong style="color: blue;">500</strong></span></span><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;"><strong style="color: blue;"><span style="color: black;">此刻</span>仅需</strong></span><span style="color: black;"><strong style="color: blue;">99.99&nbsp;</strong><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;"><strong style="color: blue;">每节课仅需1.3元，限量特价名额</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;">下扫码，永久学，超值课程</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;">▼</span></strong></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;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">（长按识别</span><span style="color: black;">二维码，目录<span style="color: black;">第1</span>节为试听</span><span style="color: black;">）</span></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;"><strong style="color: blue;">“适合人群”</strong></strong></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;"><span style="color: black;"><strong style="color: blue;"><strong style="color: blue;">“学员<span style="color: black;">评估</span>”</strong></strong></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>
    <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;"><span style="color: black;">（点击<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;"><strong style="color: blue;"><strong style="color: blue;">“你将<span style="color: black;">得到</span>”</strong></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;"><span style="color: black;">有效</span>工作的一键大法</span></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;"><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;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">(此案例在</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;"><span style="color: black;">供给</span>视频讲解和模板下载)</span></strong></span></span></strong></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;"><strong style="color: blue;">表格不规范，3秒<span style="color: black;">容易</span>智能填充</strong></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;"><strong style="color: blue;"><span style="color: black;">▼</span></strong></span></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;"><span style="color: black;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">(此案例在</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">第17课</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">供给</span>视频讲解和模板下载)</span></strong></span></span></strong></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;"><strong style="color: blue;">三下五除二就搞定</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><strong style="color: blue;"><span style="color: black;">▼</span></strong></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;"></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;"><strong style="color: blue;"><span style="color: black;">(此案例在</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">第18课</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">供给</span>视频讲解和模板下载)</span></strong></span></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;"><strong style="color: blue;"><strong style="color: blue;"><span style="color: black;">▼</span></strong></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 style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">(此案例在</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">第23课</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">供给</span>视频讲解和模板下载)</span></strong></span></span></strong></span></strong></strong></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;"><strong style="color: blue;">教你做出高颜值交互动态图表</strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><strong style="color: blue;"><strong style="color: blue;">▼</strong></strong></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 style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">(此案例在</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">第41课</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">供给</span>视频讲解和模板下载)</span></strong></span></span></strong></span></strong></strong></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;"><strong style="color: blue;">交互展示<span style="color: black;">目的</span>数据</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><strong style="color: blue;"><strong style="color: blue;"><strong style="color: blue;">▼</strong></strong></strong></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;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">(此案例在</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">第32课</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">供给</span>视频讲解和模板下载)</span></strong></span></span></strong></span></strong></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;"><strong style="color: blue;">专业、大气的数据分析</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><strong style="color: blue;"><strong style="color: blue;"><strong style="color: blue;">▼</strong></strong></strong></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;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">(此案例在</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">第67课</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">供给</span>视频讲解和模板下载)</span></strong></span></span></strong></span></strong></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;">72节</strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">Excel系统</span></strong></span><strong style="color: blue;"><span style="color: black;">超清</span></strong><strong style="color: blue;"><span style="color: black;">视<strong style="color: blue;"><span style="color: black;">频课</span></strong></span></strong></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;">提高</span><span style="color: black;">以上</span><span style="color: black;">各样</span><span style="color: black;">必须</span>技能</strong></span></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;"><strong style="color: blue;"><span style="color: black;">手机、ipad、电脑都<span style="color: black;">能够</span>随时听课</span></strong></span></strong></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;"><strong style="color: blue;">（原价</strong></span><span style="color: black;"><span style="color: black;"><strong style="color: blue;">：</strong></span><span style="color: black;"><strong style="color: blue;">500</strong></span></span><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;"><strong style="color: blue;"><span style="color: black;">此刻</span>仅需</strong></span><span style="color: black;"><strong style="color: blue;">99.99&nbsp;</strong><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;"><strong style="color: blue;">每节课仅需1.3元，限量特价名额</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;">下方扫码，永久学，超值课程</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;">▼</span></strong></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;"><span style="color: black;">（长按识别</span><span style="color: black;">二维码，目录<span style="color: black;">第1</span>节为试听</span><span style="color: black;">）</span></p>

b1gc8v 发表于 2024-10-2 19:01:25

i免费外链发布平台 http://www.fok120.com/

nykek5i 发表于 2024-10-19 08:23:15

同意、说得对、没错、我也是这么想的等。

查看完整版本: 工作常用电子表格Excel经典公式大全