excel表格制作教程入门，及常用公式
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Excel是常用的办公软件，<span style="color: black;">能够</span>大幅<span style="color: black;">提高</span><span style="color: black;">咱们</span>的工作效率；下面就为<span style="color: black;">大众</span>介绍：excel表格制作教程入门，及常用公式！</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">01</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">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 style="color: black;">咱们</span>先用鼠标选中</span><span style="color: black;">A1：E9单元格区域，并单击工具栏【边框】按钮下拉三角，<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;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_gif/clgd93mAFLED6lZM4JL8iaibhkVrFMqElZ80BZOic7RFaVoDtm2VIHJhIGicicO63XQpXCYMuRwoQTOG5P99XsZaZ3Q/640?wx_fmt=gif&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;">excel表格制作教程入门</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">02<span style="color: black;">e</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></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>A<span style="color: black;">类到</span><span style="color: black;">E</span><span style="color: black;">列单元格区域，分别点击工具栏：【垂直居中】和</span></span><span style="color: black;"> <span style="color: black;">【水平居中】按钮，就<span style="color: black;">能够</span>居中对齐，</span><span style="color: black;">excel</span><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;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_gif/clgd93mAFLED6lZM4JL8iaibhkVrFMqElZRqVy55OGYwHRicGDXjzebReTWuGaXCJZvda28Yzqe1pIUsdo6ZgkZJA/640?wx_fmt=gif&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;">excel表格制作教程入门</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">03</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">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 style="color: black;">咱们</span>先选中</span><span style="color: black;">A1：E9单元格区域，<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;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_gif/clgd93mAFLED6lZM4JL8iaibhkVrFMqElZyichfCNkD06icvpnWHGNS5oDzgTe6QticEC4TMlE33NVod0yFKIIvV0ibA/640?wx_fmt=gif&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;">excel表格制作教程入门</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">04</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">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;">A10单元格，并输入：excel表格制作教程入门；<span style="color: black;">而后</span>选中A10：E10单元格区域，单击工具栏【合并居中】按钮，<span style="color: black;">就可</span>将一行单元格合并居中；</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/sz_mmbiz_gif/clgd93mAFLED6lZM4JL8iaibhkVrFMqElZCJH8Jkeka6X0FzCL6W1RMJbibkpTQrbqVoS7icw9YFatU5dibcGUgqZIQ/640?wx_fmt=gif&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;">excel表格制作教程入门</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">05</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">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 style="color: black;">咱们</span>选中</span><span style="color: black;">A10单元格，先点击工具栏【填充颜色】按钮，并<span style="color: black;">选取</span>合适的颜色；<span style="color: black;">而后</span>点击工具栏【字体颜色】按钮，并<span style="color: black;">选取</span>白色，最后按Excel快捷键【Ctrl+B】，加粗字体；<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;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_gif/clgd93mAFLED6lZM4JL8iaibhkVrFMqElZvGzTgIHXnkIq2OribEPRpftkZYUtRJIN7qDOJo1JqIxLGhJ4YUr0qpw/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">excel表格制作教程入门</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">06</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">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 style="color: black;">咱们</span>用鼠标选中</span><span style="color: black;">C列单元格，单击工具栏【自动筛选】按钮，并点击【性别】单元格下拉三角，<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;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_gif/clgd93mAFLED6lZM4JL8iaibhkVrFMqElZqu2JxNic6TY3haiab24Zrlq1WaVcEVMZn6yHcUVf16D5gtzAKMcLM3bA/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">表格制作excel教程</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">07</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">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 style="color: black;">咱们</span>先选中</span><span style="color: black;">E列单元格区域，<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;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_gif/clgd93mAFLED6lZM4JL8iaibhkVrFMqElZ2NicGKZDlqe7XRPlnNSxvt5FMW0ts9TvCLsKyIPj3dwia8J1dbt4FwEA/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">表格制作excel教程</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">08</span><span style="color: black;">excel表格：高亮重复项</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">咱们</span>用鼠标选中D列单元格区域，单击工具栏【重复项按钮】；<span style="color: black;">而后</span>选中【设置高亮重复项】，弹出【高亮<span style="color: black;">表示</span>重复值】；最后按【确定】结束确认；<span style="color: black;">就可</span>将excel表格，重复数据高亮<span style="color: black;">表示</span>；</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_gif/clgd93mAFLED6lZM4JL8iaibhkVrFMqElZKb7VCJdkyMjQHiaicW1pL0fA855phGNqTNDtTwxOSFzqXyIibnFArG0NQ/640?wx_fmt=gif&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;">表格制作excel教程</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">09</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">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 style="color: black;">咱们</span>先选中</span><span style="color: black;">B列单元格区域，单击工具栏【重复项】按钮，选中【删除重复项】；弹出【删除重复项警告】对话框，并点击【删除重复项】按钮，弹出【删除重复项】对话框；紧接着，单选【姓名】，按回车键结束确认；<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;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_gif/clgd93mAFLED6lZM4JL8iaibhkVrFMqElZbSxPmw9gAerITnj3gGQibopiaaEdCyULvN9WjffgaMTF6NJiaS8WiagXkQ/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">表格制作excel教程</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">10从</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><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;">SUM函数公式：</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;">G2单元格，并在编辑栏输入函数公式：=SUM（）；<span style="color: black;">而后</span>输入函数参数：用鼠标选中E2：E9单元格区域；最后按回车键结束确认，<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;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_gif/clgd93mAFLED6lZM4JL8iaibhkVrFMqElZYz5uvicl5aEeZRR2OsjPBzpBSwJRFhRY5O39DCX4ZmIw5HVSibypVciaA/640?wx_fmt=gif&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;">表格制作excel教程</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">SUMIF函数公式：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">双击G2单元格，并在编辑栏输入函数公式：=SUMIF（）；<span style="color: black;">而后</span>输入函数第1个参数：用鼠标选中D列单元格区域；第2个参数：单击D2单元格；第3个参数：用鼠标选中E列单元格区域；最后按回车键结束确认，<span style="color: black;">就可</span>计算出excel表格，魏国所有人员的总销量；</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_gif/clgd93mAFLED6lZM4JL8iaibhkVrFMqElZBGaejSwxPd5IaXLKXicpRN5DElmCGtNrh9QprjcHqPa7MagiaR0W3bvw/640?wx_fmt=gif&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;">表格制作excel教程</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">SUMIFS函数公式：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">双击G2单元格，并在编辑栏输入函数公式：=SUMIFS（）；<span style="color: black;">而后</span>输入第1个参数：用鼠标选中E列单元格区域；第2组参数：D：D，D2；第3组参数：C：C，C2；最后按回车键结束确认，<span style="color: black;">就可</span>计算出excel表格，魏国所有男性的总销量；</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_gif/clgd93mAFLED6lZM4JL8iaibhkVrFMqElZPnmD4rbyAibJ5Qy8zQMwCWib3VBkJbVTx1icJvTW7eXk9vmBbZYP7BgYw/640?wx_fmt=gif&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;">表格制作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></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;">不要用1年的工作经验去工作5年。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">CPPM课程体系是美国采购管理协会高端课程体系，讲师都是世界500强强企业名师授课。服务的企业都是中海油 国航 通信等等等单位。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">CPPM证书是美国采购协会与国家人力资源和社会<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></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;">授课老师是APS的授权讲师及世界500强企业的采购高级管理人员联袂执教，都有过海外工作经验，具备较强的采购理论知识和采购实战能力！</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>6大模块，实操性最强、最经典、<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/32R9pdgIGVB787iczuVTXMLl9BgM4cr3QCcibbKpYh4wTkI1zbJWnbrynAAiacGCTyMuFR7icUVlsiawciaJKsWXz3aw/640?wx_fmt=jpeg&wxfrom=5&wx_lazy=1&wx_co=1&tp=webp" style="width: 50%; margin-bottom: 20px;"></p>
同意、说得对、没错、我也是这么想的等。 谷歌外贸网站优化技术。 你的见解独到，让我受益匪浅，非常感谢。
页:
[1]