自学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;">Excel能够<span style="color: black;">实质</span>应用到工作中，<span style="color: black;">处理</span>80%的工作任务够用<span style="color: black;">就可</span>。不是我凡尔赛，</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 style="color: black;">一月</span>的时间达到这个程度不成问题，下面<span style="color: black;">大众</span><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></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;">20年毕业，大学金融专业，一毕业就在北京某会计事务所实习，<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>是对Excel什么都不懂，但偏偏做的是助理工作，不仅琐碎，<span style="color: black;">况且</span>工作中用到Excel的<span style="color: black;">地区</span>又非常多！<span style="color: black;">例如</span>常用的v lookup，数据透视表，<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>率高达90%，而我<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;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">既然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 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></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>不了，工作效率依然低，<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>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 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></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 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;">1、视频课——亮虎Excel课</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></span><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;"><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><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></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;">2、参考书——Excel应用大全</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">这本书算是我看过的excel最全面的书籍了，里面有<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>。</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><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></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 style="color: black;">大众</span>说一说<span style="color: black;">详细</span>的学习<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;">想要学好Excel技能，必须是<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>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></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></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><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>工作的效率。</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></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></span></strong><span style="color: black;"><span style="color: black;">别看函数有几百个，其实工作场合中常用的<span style="color: black;">基本</span>函数就40多个，把这些函数的底层<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;">基本</span>的函数学起，</span></span></strong><span style="color: black;"><span style="color: black;"><span style="color: black;">包含</span>IF、v lookup、sum if、sum product、text这些函数都是常用的，学了就能<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;">之前我实习的时候带我的senior非常厉害，他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;">那时候年审的时候，我和他工作搭档，工作节奏真的非常快，什么问题都能用函数<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;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">Excel中比较难用的比较多的<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;"><strong style="color: blue;"><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></strong><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;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">有时候领导要表要得非常急，<span style="color: black;">此时</span>候非常考验自己的Excel的功力，</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>要细致细致再细致。</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></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></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>是报告汇总，<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>你会用<span style="color: black;">各样</span>技术<span style="color: black;">例如</span>光学技术，对表格上面的信息进行扫描，再<span style="color: black;">经过</span>软件转化为电子表格，1天时间就可能完成别人几个星期<span style="color: black;">才可</span>完成的工作。而扫描后的<span style="color: black;">归类</span>就<span style="color: black;">更加多</span>的小窍门了，可谓是学号 Excel 省时省力，及其<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 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>报表，别人<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>着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>利用你所学习的知识，做成交互式的图表，<span style="color: black;">能够</span><span style="color: black;">显著</span>地看出各个数据之间的差异，重点<span style="color: black;">明显</span>，不仅能<span style="color: black;">帮忙</span>团队节省时间，还能<span style="color: black;">提高</span>决策的效率。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">3、<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>你能用Excel 快、准、美地整理表格，你就会<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>你能用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></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></span></strong><span style="color: black;"><span style="color: black;">给其他人发送Excel表之前，要<span style="color: black;">按照</span><span style="color: black;">详细</span>业务，</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></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><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;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">3、样式式要<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><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>
页:
[1]