想从Excel小白变成数据分析能手?这4个Excel免费学习网站赶紧保藏起来！
<img src="https://mmbiz.qpic.cn/mmbiz_png/b9E1qkRwUOREGxRz29ZtURUdagvnaX2ialV9FzQTt0qiaDBpMnfH0yI0x0gaClapflmyxSYbQy9sTOGPcEyH650Q/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><span style="color: black;"><strong style="color: blue;">“看了就会，一上手全废！”</strong></span></span><p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">做完这些习题才<span style="color: black;">能够</span>让你从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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1、</span><span style="color: black;">全国计算机二级考试MS Office题库</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2、</span><span style="color: black;">中国大学MOOC—Excel进阶教程</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">3、</span><span style="color: black;">ExcelHOME</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">4、</span><span style="color: black;">哔哩哔哩—王佩丰excel<span style="color: black;">基本</span>教程24讲</span></p><img src="https://mmbiz.qpic.cn/mmbiz_gif/3liazHKOvrTAnBicHXic3Z2ibibfCHszJ4qMEx2CeL9VZjn4DJHiat0bg9azc6xWsJ3P3fQuWKjvkbfO4m96RVcD2Mgw/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1、全国计算机二级考试MS Office题库</p><img src="https://mmbiz.qpic.cn/mmbiz_gif/jzsKmORWKbSlWmDoI6UtGSaF79dLRmyCIHx0iboJCDeV9iaxDNpTc0RvJkv0e1Nib5MEvZOTe8AtMRMBtZeTm8Vpg/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">适用人群：</span></strong><span style="color: black;">Excel入门学者</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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（1）30多套完整的excel操作题：<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;"><span style="color: black;">（2）节省精力：实操<span style="color: black;">触及</span>的素材文件都<span style="color: black;">供给</span>，<span style="color: black;">不消</span>再花费时间去找题。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（3）系统评分：练习完成后，系统会自动给分，还会提示操作中间<span style="color: black;">显现</span>的错误。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（4）习题讲解：练完之后<span style="color: black;">能够</span>跟着老师的<span style="color: black;">过程</span>纠正自己的错误。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（5）题目系统完整，操作知识覆盖面广。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">怎么<span style="color: black;">无</span>人<span style="color: black;">说到</span>这个，看到提问者说练习excel的习题太少，<span style="color: black;">第1</span>个就想到，考试题库里面有30多套题，每套都有一个非常完整的excel实操题，从最<span style="color: black;">基本</span>的表格设置、函数计算、到可视化图表的训练，虽然是考试用的，但Excel入门拿这个练题真的好用。</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/JNfe5NcuJictAUnv8UE2ebUZqRQhqCQQSS5fC4lrvOtCNbXfWmBIZyKLk5wbSbesB38RaM7kNTMCDCMogj26kQA/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&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 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>再费劲去找，完整练完30套题之后，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></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="https://mmbiz.qpic.cn/mmbiz_jpg/JNfe5NcuJictAUnv8UE2ebUZqRQhqCQQS0UjII4aic2fSwYQ52ZicQrfDMpWWEgibibjpDj32V8rEqJ3RictAvWiaIa2w/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><img src="https://mmbiz.qpic.cn/mmbiz_gif/3liazHKOvrTAnBicHXic3Z2ibibfCHszJ4qMEx2CeL9VZjn4DJHiat0bg9azc6xWsJ3P3fQuWKjvkbfO4m96RVcD2Mgw/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2、中国大学MOOC—Excel进阶教程</p><img src="https://mmbiz.qpic.cn/mmbiz_gif/jzsKmORWKbSlWmDoI6UtGSaF79dLRmyCIHx0iboJCDeV9iaxDNpTc0RvJkv0e1Nib5MEvZOTe8AtMRMBtZeTm8Vpg/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">适用人群：</span></strong><span style="color: black;">Excel进阶学者</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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（1）课程系统：分为<span style="color: black;">基本</span>篇和进阶篇</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（2）习题配套：完全够用的Excel实操习题</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（3）互动讨论：有老师答疑</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">这堂课是高校开设的国家精品课程，完全免费，非常系统，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>和进阶课程涵盖5个部分：</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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">包括</span>数据转换、排序、筛选、<span style="color: black;">归类</span>汇总与合并计算、图表、数据透视表和数据透视图</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">【项目三】公函数</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">公式、常用各类函数、数据验证等</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">【项目四】VBA与宏</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">VBA应用、宏应用</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">【项目五 】分析与预测</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span 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="https://mmbiz.qpic.cn/mmbiz_jpg/JNfe5NcuJictAUnv8UE2ebUZqRQhqCQQSDYoiaW7Iia4RNat2CNbHgMSJMgWIndiczmLDJwXwRQMpibOxB2rC4NpxnA/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;">每节课都有随堂测试</span><span style="color: black;">、<span style="color: black;">供给</span>操作题和素材，用电脑版打开，<span style="color: black;">能够</span>直接下载。</span><span style="color: black;">互动区有老师在，有不会的<span style="color: black;">地区</span><span style="color: black;">大众</span><span style="color: black;">一块</span>讨论，老师<span style="color: black;">亦</span>会解答。</span><img src="https://mmbiz.qpic.cn/mmbiz_jpg/JNfe5NcuJictAUnv8UE2ebUZqRQhqCQQS3NpzYicPKJBw9swnovHCExlFJgmUeSrcLib2DtHQCAq140875UKZRR6A/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">习题的素材、<span style="color: black;">需求</span>、效果图都有给出，对照练习就<span style="color: black;">能够</span>。</span><img src="https://mmbiz.qpic.cn/mmbiz_jpg/JNfe5NcuJictAUnv8UE2ebUZqRQhqCQQSZAdUPLeiaxpNu2Ch0Xl2jia7lyKCj0vdmicMRRXIviaxJ3EkjDNZCHCialA/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/3liazHKOvrTAnBicHXic3Z2ibibfCHszJ4qMEx2CeL9VZjn4DJHiat0bg9azc6xWsJ3P3fQuWKjvkbfO4m96RVcD2Mgw/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">3、ExcelHOME</p><img src="https://mmbiz.qpic.cn/mmbiz_gif/jzsKmORWKbSlWmDoI6UtGSaF79dLRmyCIHx0iboJCDeV9iaxDNpTc0RvJkv0e1Nib5MEvZOTe8AtMRMBtZeTm8Vpg/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"><strong style="color: blue;"><span style="color: black;">适用人群：</span></strong><span style="color: black;">Excel入门学者</span><strong style="color: blue;"><span style="color: black;">优点：</span></strong><span style="color: black;">（1）习题知识点配套，<span style="color: black;">能够</span>跟着练</span><span style="color: black;">（2）解析细致：<span style="color: black;">每一个</span><span style="color: black;">过程</span>的做法都有图文解析。</span><span style="color: black;">缺点：内容<span style="color: black;">不足</span>系统，适合练习部分操作技巧</span><span style="color: black;">ExcelHOME是Microsoft技术社区联盟成员，<span style="color: black;">非常多</span>人用它学Excel，里面有教程配套的实操练习，<span style="color: black;">通常</span>在最下方<span style="color: black;">供给</span>下载链接，<span style="color: black;">能够</span><span style="color: black;">做为</span>习题练习。</span><span style="color: black;"><span style="color: black;">例如</span>：提取不重复的名单（下图为<span style="color: black;">供给</span>素材）</span><img src="https://mmbiz.qpic.cn/mmbiz_jpg/JNfe5NcuJictAUnv8UE2ebUZqRQhqCQQSa0VR2ibcvsMhIAWdnHj5Bqy0xvOIq0RqsKqib2D3QEve5VhSvCQSrgHw/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><span style="color: black;">例如</span>：快速拆分单元格中的关键词（下图为<span style="color: black;">供给</span>素材）</span><img src="https://mmbiz.qpic.cn/mmbiz_jpg/JNfe5NcuJictAUnv8UE2ebUZqRQhqCQQSobjPNAPZZOUBFCw48atibBAjyVbicTEOTuvDvMjoyiauNhN7BWtQqOdiaw/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/3liazHKOvrTAnBicHXic3Z2ibibfCHszJ4qMEx2CeL9VZjn4DJHiat0bg9azc6xWsJ3P3fQuWKjvkbfO4m96RVcD2Mgw/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">4、哔哩哔哩—王佩丰excel<span style="color: black;">基本</span>教程24讲</p><img src="https://mmbiz.qpic.cn/mmbiz_gif/jzsKmORWKbSlWmDoI6UtGSaF79dLRmyCIHx0iboJCDeV9iaxDNpTc0RvJkv0e1Nib5MEvZOTe8AtMRMBtZeTm8Vpg/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"><strong style="color: blue;"><span style="color: black;">适用人群：</span></strong><span style="color: black;">Excel入门学者</span><strong style="color: blue;"><span style="color: black;">优点：</span></strong><span style="color: black;">（1）函数习题丰富：课程<span style="color: black;">重点</span>围绕函数展开。</span><span style="color: black;">（2）视频教程搭配实操训练</span><span style="color: black;">想要多多练习excel函数习题的话<span style="color: black;">能够</span>用，B站搜索王佩丰excel<span style="color: black;">基本</span>教程24讲，播放量最高的那个<span style="color: black;">便是</span>，内容简介里有百度云链接，<span style="color: black;">能够</span>把每一讲的素材下载下来。</span><img src="https://mmbiz.qpic.cn/mmbiz_jpg/JNfe5NcuJictAUnv8UE2ebUZqRQhqCQQSIHmHLice5Tntwp3F2QmzUH2fsWWUp7cvXd0cvUJqxIvPqYgiaK1szXew/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">END</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">————</p><strong style="color: blue;"><span style="color: black;">2021年最新整理的数据分析资料来了！</span></strong><span style="color: black;"><span style="color: black;">点击下方名片进入公众号后台，回复关键字“</span><span style="color: black;"><strong style="color: blue;">2021</strong></span><span style="color: black;">”领取！</span></span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/JNfe5NcuJicvrweicnsVNWcshC0cJ0UgzV60wJTTgIibEo6gHg3K0QDRRq0icoySQhPLKERNjVg3EWPLfKLHicV8Qlw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&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;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/JNfe5NcuJictbG6mSB12fSmNSwVVKfeTwMy9Foc0M2nLiax9PzPEWqURT71YOJJwlELxN3b0wBVx64Z9CxRdSABg/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">扫描上方二维码关注我</span></strong></p><img src="https://mmbiz.qpic.cn/mmbiz_png/b9E1qkRwUOQfQK8TSViakYWDC2essKmj5C2xOMgWIzR3rvOY0fgb9qbwacZrNUBeicHK9fbrfNjkBDBdSficxfqjg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/JNfe5NcuJicv85Z9r4dKP4RL9fKjo8dn8FyQItuZOkzK6OvX2VsATAzoWhpMce1T0qgVy7UE4Ru3HgDRwJns0MA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
seo常来的论坛，希望我的网站快点收录。
页:
[1]