|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-in-30-minutes-working-with-logical-functions/
课程评论：没有评论
**课程名称：** Excel 30分钟精通：逻辑函数应用 **课程概述：** 本课程旨在帮助学员在30分钟内掌握Excel 2019或Excel 365中的逻辑函数及其嵌套应用。学习Excel是现代商业中最实用且有价值的技能之一，大多数企业都依赖Excel。提升Excel技能对提高业务生产力和个人发展都有显著帮助。“Excel 30分钟精通”系列课程将助您入门。 本课程是该系列十一门30分钟课程之一。 **课程主题包括：** * 使用IF函数进行逻辑判断 * 使用AND和OR函数进行多项逻辑判断 * 使用SUMIF、COUNTIF和AVERAGEIF函数根据单一条件汇总数据 * 使用AVERAGEIFS和COUNTIFS函数根据多个条件汇总数据 * 嵌套多个函数 完成整个系列课程后，您将相当于完成了“Bigger Brains 精通Excel 2019 - 进阶”课程。课程采用“独具特色、引人入胜”的Bigger Brains师生教学风格，提供高质量高清内容。 **目标受众：** 拥有Excel 2019或Excel 365基础知识，并希望利用更复杂的函数和功能进行数据分析的人员。 **课程目标：** 完成本课程后，您将能够熟练运用逻辑函数并在单元格中进行函数嵌套。
Learn to use Logical functions and nest functions in a cell in Excel 2019 or Excel 365-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 eleven 30-minute courses.Topics covered include:Using the IF function to perform a logical testUsing AND and OR functions to perform multiple logical testsUsing SUMIF, COUNTIF, and AVERAGEIF to summarize data using a single criterionUsing AVERAGEIFS and COUNTIFS to summarize data using multiple criteriaNesting multiple functionsTake the full series and you will have completed our "Bigger Brains Mastering Excel 2019 - Intermediate" course.High-quality HD content in the "Uniquely Engaging"TM Bigger Brains Teacher-Learner style!Target Audience: People who have a working knowledge of Excel 2019 or Excel 365, but want to use more complex functions and features to analyze data.Course Goal: By the end of this course, you will be able to use Logical functions and nest functions in a cell.
