有没学习excel网站举荐?
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">首要</span>说一点，真的不<span style="color: black;">举荐</span>小白直接直接在网站上看<span 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;"><span style="color: black;">一方面是<span style="color: black;">由于</span>这些视频的质量参差不齐，另一方面是<span style="color: black;">由于</span>Excel的<span style="color: black;">非常多</span>技巧还是需要系统的学习一下的。</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 style="color: black;">方向</span>讲解一下Excel<span style="color: black;">怎样</span>学好，<span style="color: black;">把握</span>Excel的<span style="color: black;">各样</span>操作有多方便！</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 style="color: black;">直接能让工作效率<span style="color: black;">提高</span>1000倍，你对Excel<span style="color: black;">晓得</span>的越深，你就会越爱它！</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;">作为一名数据分析师，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>了~</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 style="color: black;">运用</span>Excel的经验整理了出来，分享给有需要的小伙伴，<span style="color: black;">期盼</span><span style="color: black;">能够</span><span style="color: black;">帮忙</span>到<span style="color: black;">大众</span>。</span></span></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 style="color: black;">1、</span>学好Excel需要经过哪几步？</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 style="color: black;">1.全面<span style="color: black;">认识</span>Excel基本操作</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 style="color: black;">起始</span>接触Excel的时候，<span style="color: black;">意见</span>最好是</span></span><span style="color: black;"><span style="color: black;">先把Excel上菜单栏、功能区上的按钮<span style="color: black;">所有</span><span style="color: black;">熟练</span><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;"><span style="color: black;">这个操作<span style="color: black;">能够</span>让自己快速<span style="color: black;">熟练</span>Excel，初步<span style="color: black;">认识</span>Excel具备<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;"><span style="color: black;"><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></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;">因此</span><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;"><span style="color: black;">对按钮属性有所<span style="color: black;">认识</span>之后，下一步<span style="color: black;">便是</span>去</span></span><span style="color: black;"><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></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;">基本</span>的小白最好是不要一上来就看<span style="color: black;">各样</span>教程，那样太累了。<span style="color: black;">况且</span>书上的语言<span style="color: black;">不足</span>简单生动，学习起来比较难<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;"><span style="color: black;"><span style="color: black;">意见</span>最好是</span></span><span style="color: black;"><span style="color: black;">直接看系统讲解Excel的课程，在这个过程里面就<span style="color: black;">能够</span><span style="color: black;">认识</span>到Excel的基本操作<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;"><span style="color: black;">像输入数据、<span style="color: black;">查询</span>替换，设置单元格格式、排序、筛选、重复操作等等<span style="color: black;">基本</span>操作，都能<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;"><span style="color: black;"><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></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;">2.工作常用函数要<span style="color: black;">把握</span>住</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 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></span><span style="color: black;"><span style="color: black;">想要真正学好Excel，还需要学习<span style="color: black;">有些</span><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;"><span style="color: black;">像sum，sumif，mid，left，right，vlookup等函数，<span style="color: black;">把握</span>好了之后就<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;"><span style="color: black;">后面再学习一下做数据透视表，就能做出一张简单的统计表格，再加上个曲线图折线图柱状图上的，这就<span style="color: black;">能够</span><span style="color: black;">处理</span><span style="color: black;">平常</span>80%的工作了。</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;">比较常用的10个函数：</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）SUM函数：对单元格中数据求和</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;">（2）IF函数：<span style="color: black;">要求</span>为真返回一个值，<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;"><span style="color: black;">（3）LOOKUP函数：<span style="color: black;">查询</span>一行或一列数值，并且<span style="color: black;">同期</span><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;"><span style="color: black;">（4）VLOOKUP函数：按行之后表或区域中的内容</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;">（5）MATCH函数：搜索单元中的项，返回该项在区域内的相对位置。</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;">（6）CHOOSE函数：从最多254中的数值中<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;"><span style="color: black;">（7）DATE函数：<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;"><span style="color: black;">（8）DAYS函数：返回两个日<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;"><span style="color: black;">（9）FIND、FINDB函数：返回<span style="color: black;">第1</span>个文本串中<span style="color: black;">初始</span>位置的值，这个数值是从第二个文本串的<span style="color: black;">第1</span>个字符<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;"><span style="color: black;">（10）INDEX函数：返回表格或区域中的值<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;"><span style="color: black;">把这些常用的函数学明白了，<span style="color: black;">平常</span>工作中的大<span style="color: black;">都数</span>问题就都能<span style="color: black;">处理</span>了。</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 style="color: black;">2、</span>有<span style="color: black;">那些</span>好用的Excel教程？</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 style="color: black;">1.亮虎excel课</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;">这是快速掌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>工作。</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 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>级的讲解，让我从Excel小白进阶<span style="color: black;">成为了</span>精通Excel的职场人。</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 style="color: black;">起始</span>工作的时候，做个<span style="color: black;">营销</span>数据分析表都要用上好几个小时。更别说季度末做的动态数据图，常常要花上我大半天<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;"><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></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;">认真把上面的技巧学一遍，彻底把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></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;">2.终身教育平台</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 style="color: black;">这儿</span>面有<span style="color: black;">非常多</span>Excel的免费课程，直接在搜索框里找就能找到。</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 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></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;">尤其是里面的跟着杂志学做Excel图表的部分，是我在跟亮虎系统学完Excel之后经常去听去看的。<span style="color: black;">这儿</span>面有<span style="color: black;">非常多</span>非常精美<span style="color: black;">运用</span>的图表，对我在工作中优化和美化图表有很大<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;"><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>自己在做<span style="color: black;">报告</span>的时候，不仅能<span style="color: black;">经过</span>数据表展现自己的工作能力，还能让其他人看的赏心悦目<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;"><span style="color: black;">每次在模仿这些图表的过程中，我就会主动思考和分析应该<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></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;">3.《竞争力 玩转职场Excel，从此不加班》</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;">真的学了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></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;">因此</span>在跟亮虎学完之后，除了在终身教育平台上找图表进行模仿之外，我还会看这本书。</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 style="color: black;">表现</span>了“二八定律”，里面的内容把Excel在工作中最重要、最常用的20%的知识点讲解清楚了。结合着听亮虎学到的技巧，<span style="color: black;">处理</span>工作中的问题，提<span style="color: black;">有效</span>率不是什么难事。</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 style="color: black;">3、</span>有<span style="color: black;">那些</span>好用的Excel技巧？</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;">1.做</span></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 style="color: black;">爱好</span>用Excel的自带透视图，后台直接开inspinia模板+echart-x。</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;">2.</span></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><strong style="color: blue;"><span style="color: black;"><span style="color: black;">，做<span style="color: black;">商场</span>数据分析</span></span></strong><span style="color: black;"><span style="color: black;"><span style="color: black;">亦</span><span style="color: black;">能够</span>用Tableau，亲测好用~</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;">3.</span></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 style="color: black;">特别有</span>可能会<span style="color: black;">显现</span>感觉什么图都不合适的<span style="color: black;">状况</span>，这个时候<span style="color: black;">能够</span><span style="color: black;">瞧瞧</span>echart上的图例，再回去看数据更加适合<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;"><span style="color: black;">4.图表并不是<span style="color: black;">仅有</span>曲线图、折线图、柱状图、饼图，多去各个平台上看看，多去学习，<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;"><span style="color: black;">5.</span></span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">能<span style="color: black;">不消</span>数据堆叠展示，就<span style="color: black;">不消</span>。</span></span></strong><span style="color: black;"><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></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 style="color: black;">弥补</span>进去。这是为了能让数据表格<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;"><span style="color: black;">7.<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>等工作中弹出“Excel已停止运行”，那可能真的会心梗。</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;">8.</span></span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">需要将表内某个区域的文字颠倒<span style="color: black;">次序</span><span style="color: black;">表示</span>，</span></span></strong><span style="color: black;"><span style="color: black;">那就【复制正常<span style="color: black;">次序</span>对象】，<span style="color: black;">而后</span>【在字体前加@】，接着点击向【下旋转文字】，点击自【动换行】就完<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;"><span style="color: black;">9.</span></span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">尽可能少用<span style="color: black;">乃至</span><span style="color: black;">不消</span>合并单元格。</span></span></strong><span style="color: black;"><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>该Excel存在需要筛选<span style="color: black;">表示</span>的<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;"><span style="color: black;">10.整行整列的填充颜色，是<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>公式确定要设置格式的单元格】-【为符合此公式的值设置格式】-输入=$A2=“【需要填色字段】”-点击【格式】设置颜色。<span style="color: black;">这般</span>操作完成之后，Excel就能智能填充需要填充的单元格了。</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 style="color: black;">这般</span>吧，有问题欢迎大家来提问。</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 style="color: black;">看完觉得不错<span style="color: black;">能够</span>点个赞哈~</span></span></strong></p>
说得好啊！我在外链论坛打滚这么多年，所谓阅人无数，就算没有见过猪走路，也总明白猪肉是啥味道的。 你的见解独到，让我受益匪浅，非常感谢。
页:
[1]