|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/creating-calculations-in-lists-with-excel-functions/
课程评论:没有评论
## SharePoint 365 Spotlight - 列表中的计算 - Excel 函数 课程总结 本课程专为希望将在 Excel 中积累的公式创建和使用知识运用到 SharePoint 列表中的 Excel 用户设计。课程涵盖了多种 Excel 风格的函数,并详细讲解了函数的功能和语法。如果您想学习如何在 SharePoint 列表中使用 SUM、AVERAGE 等函数,本课程将是您的理想选择。 **课程主要内容包括:** * **区分电子表格和列表的适用场景:** 了解何时使用电子表格,何时使用 SharePoint 列表。 * **掌握正确的公式语法:** 学习构建有效公式的基础。 * **进行基本计算:** 掌握在 SharePoint 列表中执行数值计算的方法。 * **使用数字函数:** 学习利用 Excel 函数进行数字处理和分析。 * **使用文本函数:** 掌握文本数据的处理和操作。 * **使用日期函数:** 学习日期的计算和管理。 * **运用条件函数:** 学习创建基于条件的计算和逻辑。 Intellezy 提供近 10,000 个涵盖桌面应用、技术概念和商业技能的培训视频,旨在帮助您和您的团队保持竞争力,提升技能。我们的视频内容引人入胜,并配有评估,可用于课程前后进行知识水平测试。为确保内容的实时性,我们的培训内容会根据软件更新进行频繁刷新。由于视频开发完全由公司内部完成,我们能够快速响应变化并创建定制内容,以支持各种软件和计算机系统的落地。
This course covers a number of Excel-style functions. The course is designed to assist Excel users who need to leverage what they already know about formula creation and use it in a SharePoint list. Functions and their syntax are covered here. Users wanting to use functions like SUM and AVERAGE should take this course.In this course you will learn more about the following topics:Knowing when to use spreadsheets versus listsReview proper formula syntaxStarting basic calculationsUsing Number functionsUsing Text functionsUsing Date functionsWorking with Conditional functionsWith nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs.