01-Excel公式与函数教程-基本篇-公式概述
<div style="color: black; text-align: left; margin-bottom: 10px;">
重播
<div style="color: black; text-align: left; margin-bottom: 10px;">暂停</div>
<span style="color: black;">00:00</span>
<span style="color: black;">/</span>
<span style="color: black;">00:00</span>
<span style="color: black;">直播</span>
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;">00:00</div>
</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">进入全屏</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">0</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">点击按住可拖动视频</div>
</div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">简介</h1>
<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>到计算机办公的内容，都会接触到office套件，而excel<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;">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 style="color: black;">得到</span>准确的结果。一个<span style="color: black;">平常</span>的用法是<span style="color: black;">运用</span>SUM函数来计算单元格范围内的总和。</span></p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">excel公式概述</h1>
<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;">是由于</span><span style="color: black;">构成</span>行和列的单个单元格<span style="color: black;">形成</span>的。<span style="color: black;">通常</span>，行用阿拉伯数字<span style="color: black;">暗示</span>，列用ABC字母<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>：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 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中想要输入公式必须先输入“=”符号，这就相当于告诉excel，接下来我输入的内容是公式，你需要计算他，而不是展示字符内容。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">例如，输入“=1+2”然后按enter，该单元格会<span style="color: black;">表示</span>3而不是“=1+2”，那<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></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>数字进行计算。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/bc6a7768e0c74ea9971c79307a8efe1a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727974314&x-signature=Qaw70vZILX8OUKX4BIkKrVUmTMs%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">例如该示例，等于A1加B1，<span style="color: black;">暗示</span>，对A1和B1里的数进行相加，<span style="color: black;">这儿</span>就引用了A1和B1的数据，在引用数据时，并不局限于在同一个工作表或工作簿，意思<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;"><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 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内置超过400个计算命令，这些命令<span style="color: black;">便是</span>函数，函数将会在之后的教程中<span style="color: black;">仔细</span>讲解，<span style="color: black;">这儿</span>就不<span style="color: black;">太多</span>阐述了。</span></p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">基本</span>运算公式</h1>
<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 style="color: black;">就可</span>直接计算。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/88114291391b4100b2d743ffd26a4f33~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727974314&x-signature=0AmOrPg9iwtj8H2RpS0c%2BP0J58A%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>单元格 O3，键入 =，L3，加号，L4，<span style="color: black;">而后</span>按 Enter。</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>单元格 O4，键入 =，L3，减号，L4，<span style="color: black;">而后</span>按 Enter。</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>单元格 O5，键入 =，L3，乘号，L4，<span style="color: black;">而后</span>按 Enter。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">若要相除，选择单元格 O6，键入 =，L3，除号，L4，<span style="color: black;">而后</span>按 Enter。</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>单元格 O6，键入 =，L3，脱字符，L4，<span style="color: black;">而后</span>按 Enter。</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;">链接: </p>https://pan.baidu.com/s/1iyija4KnUNcASOmAsqV6nA?pwd=am<span style="color: black;">公斤</span> 提取码: am<span style="color: black;">公斤</span> 复制这段内容后打开百度网盘手机App，操作更方便哦
<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>内容，祝身体健康，前程似锦。</span></p>
页:
[1]