|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-novice-exploring-and-creating-formulas/
课程评论：没有评论
**Coursera 课程总结：Excel 新手 - 公式探索与创建** 本课程旨在帮助学员掌握 Excel 中常用的基础公式，以提高工作效率，特别是在财务领域。通过学习，学员将能够： * **构建公式：** * 了解 Excel 内置的公式库。 * 熟练运用相对引用和绝对引用。 * 掌握 Excel 中的数学运算符。 * 学会有效地复制公式。 * **复习和管理公式：** * 学习如何查看和分析现有公式。 * **利用智能填充（Flash Fill）：** * 掌握 Excel 2013 及以上版本中的智能填充功能。 * **应用财务公式：** * 学习 SUM, SUBTOTAL, MAX, MIN, PMT, IPMT, NPV, IRR, FV, PV 等常用财务函数，并了解它们在实际工作中的应用。 通过本课程的学习，您将能够自信地使用 Excel 公式来自动化日常任务，优化工作流程，并在财务分析和其他业务场景中提升您的效率和竞争力。
NOVICE - EXPLORING AND CREATING FORMULASUsing Excel for business has almost no limits for applications. Here are some examples:When planning a team outing to a baseball game, you can use Excel to track the RSVP list and costs.Excel creates revenue growth models for new products based on new customer forecasts.When planning an editorial calendar for a website, you can list out dates and topics in a spreadsheet.When creating a budget for a small product, you can list expense categories in a spreadsheet, update it monthly and create a chart to show how close the product is to budget across each category.You can calculate customer discounts based on monthly purchase volume by product.Users can summarize customer revenue by product to find areas where to build a stronger customer relationships.Use complex calculation methods, like Sharpe ratios.Excel has powerful formula functionality. The goal of formulas is to automate processes that would require manual execution. Formulas are used to save you time and give you the edge when completing daily tasks. Join us as explore basic formulas and attempt to increase your efficiency with helpful formulas that you will need daily in an office space.The objective of this session is to enable delegates to become comfortable with formulas that are typically used to increase efficiency in a finance environment. During this session we will look at:· Building formulaso Exploring available library of formulae within Excelo Cell referencing within formulas i.e. relative and absolute referenceso Mathematical operators within Excelo Duplicating (dragging) formulas without retyping· Reviewing formulas· Flash fill (Excel 2013 and later only)· Financial formulas i.e. SUM, SUBTOTAL, MAX, MIN, PMT, IPMT, NPV, IRR, FV and PV.
