|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-in-30-minutes-calculations/
课程评论：没有评论
**课程名称：** Excel：30分钟掌握计算 **课程概述：** 本课程是“Excel：30分钟系列”中的一门，旨在帮助您在30分钟内掌握Excel 2019或Excel 365中的基础计算技巧，并解决常见的公式错误。通过本课程的学习，您将能够高效利用Excel这一重要的商业工具，提升工作效率，促进个人发展。 **课程内容：** * 创建基础公式 * 插入常用函数 * 使用自动求和 (AutoSum) 和自动填充 (AutoFill) * 理解并应用绝对引用，解决常见公式问题 **课程目标：** 学完本课程后，您将能够熟练运用公式和函数在Excel中执行基本计算。 **学习目标：** * 创建简单公式，并理解Excel公式中的运算顺序。 * 通过多种方法在公式中插入基础函数。 * 通过复制公式来重用计算。 * 通过添加绝对引用和修复常见错误来解决公式问题。 **目标学员：** 具备Microsoft® Windows®基础知识，希望学习Excel 2019或Excel 365入门技能，以便创建和修改电子表格的用户。 **备注：** 本课程是“Bigger Brains Mastering Excel 2019 - Basics”系列的第三部分。完成整个系列课程将使您获得该大师级Excel基础课程的完整学习成果。课程采用“Bigger Brains”独特的教学风格，提供高质量高清内容。
Learn to perform basic calculations in Excel 2019 or Excel 365 and fix common formula errors-all in under 30 minutes!When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. Most businesses rely on Microsoft Excel, so increasing your knowledge is a boon to both business productivity and personal development. Our "Excel in 30 Minutes" series can help you get started.This course is one in a series of ten 30-minute courses.Topics covered include:Creating basic formulasInserting functionsUsing AutoSum and AutoFillAddressing common formula issues by adding absolute references and fixing common errorsTake the full series and you will have completed our "Bigger Brains Mastering Excel 2019 - Basics" course.High-quality HD content in the "Uniquely Engaging"TM Bigger Brains Teacher-Learner style!SubHead: 3 of 10 in our Excel Basics SeriesTarget Audience: People who have a basic knowledge of Microsoft® Windows® and want to learn beginner Excel 2019 or Excel 365 skills to create and modify spreadsheets.Course Goal: By the end of this course, you will be able to use formulas and functions to perform basic calculations in Excel.Objectives. Create simple formulas and describe how order of operations is important in Excel formulasInsert basic functions into your formulas using multiple methodsReuse formulas by copying them into different cellsAddress common formula issues by adding absolute references and fixing common errors
