|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel_formulas_made_easy/
课程评论：没有评论
**课程名称：Excel公式轻松学** **概述：** 本课程将帮助您掌握Excel公式，让您能快速轻松地在Excel中进行计算。您将学习： * 理解Excel公式的原理和“构建模块”。 * 使用鼠标和键盘命令构建公式。 * 使用标准的数学符号和常用的内置函数进行计算。 * 将公式复制到工作表的其他部分。 * 利用括号确保计算按正确的顺序进行。 * 区分相对引用和绝对引用，以及如何使用它们使您的公式始终指向正确的单元格。 * 在公式中引用不同工作表中的单元格，或完全独立的文件中的单元格。 * 学习一些有用的技巧，以节省时间，提高使用Excel的效率。 **课程内容包括：** * 可下载的Excel工作簿进行实践操作。 * 深入的测验，以测试您的理解能力并巩固所学知识。 * 可下载并保存在桌面上的实用参考指南。 **讲师：** Jane Hames，Glide Training首席IT培训师。Jane拥有超过二十年的Excel培训经验，为各级用户和不同背景的人士提供培训。
This course will enable you to get to grips with Excel formulas, allowing you to perform calculations within Excel quickly and easily. You will learn how to: Understand the principles and 'building blocks' of Excel formulas.Use both mouse and keyboard commands to construct a formula.Perform calculations by using both standard mathematical symbols and common built-in functions.Copy formulas to different parts of your worksheet.Make use of brackets to ensure calculations are carried out in the correct order.Differentiate between relative and absolute cell references, and how to use each of these so your formulas always refer to the correct cells on your worksheet.Refer to cells on different worksheets in your formulas, or to cells in completely separate files.Pick up handy tips to save time and make life easier when you use Excel. The course includes: Practical exercises using Excel workbooks that you can download.In-depth quizzes to test your understanding and help to embed your learning.Useful reference guides to download and keep on your desk. This course is presented by Jane Hames, lead IT trainer at Glide Training. Jane has over twenty years' experience in delivering Excel training to users of all levels and from a variety of backgrounds.
