|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-formulas-essential-training/
课程评论：没有评论
**课程名称：** Excel公式基础培训 **课程概述：** 本课程旨在帮助您掌握Microsoft Excel中那些令人望而生畏却又无所不能的公式和函数。课程由经验丰富的讲师Mohamed Rashad主讲，通过精炼的教学技巧，引导您更快速、更高效地运用Excel解决日常工作中的问题。 您将从学习最基础的公式和函数概念入手，例如如何引用其他工作表中的单元格，以及如何将单元格数据与其他字符组合。随后，课程将深入探讨一系列实用的Excel函数，包括： * **COUNTIF：** 学习如何根据特定条件统计满足条件的单元格数量。 * **LEFT 和 RIGHT：** 掌握如何从文本字符串中提取左侧和右侧的字符。 * **INDEX 和 MATCH：** 了解如何组合使用这两个函数来检索特定值。 此外，课程还将覆盖更多强大的Excel函数，助您在数据处理和分析方面更上一层楼。 **核心内容：** * Excel公式和函数的基本概念 * 单元格的程序化引用 * 文本与字符的组合 * COUNTIF函数详解 * LEFT和RIGHT函数详解 * INDEX和MATCH函数详解 * 更多实用Excel函数介绍 **学习目标：** 通过本课程的学习，您将能够： * 自信地运用Excel公式和函数解决实际问题。 * 提高在Excel中的工作效率。 * 掌握数据提取、统计和分析的基本技巧。
The myriad formulas and functions in Excel are, in large part, what makes it such a uniquely powerful program. But for many users, figuring out how to apply these formulas and functions to solve everyday problems can seem overwhelming. In this course, staff instructor Mohamed Rashad demystifies these powerful features, sharing bite-sized tips designed to help you work faster and more efficiently in Excel.Rashad begins by covering the fundamental concepts you need to get started with functions and formulas, such as how to programmatically reference cells located in other worksheets and combine cell data with other characters. She then digs into a variety of useful Excel functions. Learn how to count cells that meet a specific set of criteria using COUNTIF, extract characters with LEFT and RIGHT, use INDEX and MATCH to retrieve a value, and much more.Rashad begins by covering the fundamental concepts you need to get started with functions and formulas, such as how to programmatically reference cells located in other worksheets and combine cell data with other characters. She then digs into a variety of useful Excel functions. Learn how to count cells that meet a specific set of criteria using COUNTIF, extract characters with LEFT and RIGHT, use INDEX and MATCH to retrieve a value, and much more.
