|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-2019-level-1-beginner-excel-2019/
课程评论：没有评论
**Microsoft Excel 2019 Level 1 - 初学者精通指南** 本课程旨在帮助您快速建立对Microsoft Excel 2019基础知识的全面掌握，为您后续的学习奠定坚实的基础。通过循序渐渐的指导，您将轻松学会公式和函数的基本操作，并迅速掌握Excel的核心技能，为进入中高级领域做好准备。 **课程重点包括：** * **Excel基础:** 建立对Microsoft Excel基础工作的扎实理解。 * **公式与计算:** 掌握编写公式和进行各种计算，以及常用的SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, TRANSPOSE函数。 * **打印与格式:** 学会插入页眉页脚、调整页边距、设置打印行/列标题，并利用条件格式对数据进行颜色编码。 * **格式应用与复制:** 掌握利用快捷方式将格式应用到其他单元格，以及通过绝对引用和混合引用准确复制公式。 * **数据输入:** 学习使用自动填充（AutoFill）和快填（FlashFill）功能提高数据输入的效率。 * **视图与管理:** 掌握拆分工作表、冻结窗格（Freeze Panes）和创建多个视图。 * **Excel 2019新功能:** 探索Excel 2019新增的语音反馈、一键修复辅助功能、翻译等实用功能。 完成本课程后，您将熟练掌握最常用的Excel基础工具，并具备高效、轻松完成日常Excel任务的信心和能力。
Quickly Get a Solid Foundation on Excel 2019 Basics During this Microsoft Excel Level 1 - Beginner course you will gain a solid foundation on which you will build the rest of your Excel experience on. Enroll now and I'll guide you step-by-step, through the basics of working with the basics on formulas and functions. In very little time you will master the basics of Excel that'll provide a sure foundation for more intermediate to advanced Excel techniques. At completion of this course you will have mastered the most popular Excel basic tools and have the foundational skills with a sureness to complete many daily Excel tasks with efficiency and ease. Below are just a few of the topics that you will master: Build a solid understanding on the basics of Microsoft ExcelWriting formulas and performing calculationsSUM, AVERAGE, MIN, MAX, COUNT, COUNTA, TRANSPOSE functionsInserting headers and footers, and adjusting marginsPrint row and, or column page titlesColor code data that meet certain criteria with Conditional FormattingSave time applying formatting to other cells with shortcutsCopy formulas about with accuracy by applying Absolute and, or Mixed ReferencesSave time entering data using the AutoFill and FlashFill featuresSplit Worksheet, Freeze Panes and add Multiple ViewsNew to Excel 2019! Sound Feedback, Check Accessibility one click fix, Translate and more!
