|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-for-business-users/
课程评论：没有评论
课程名称：微软Excel在财务、会计与财务分析中的应用 概述：微软Excel提供了数百种函数和公式，用于高效存储、分析和处理数据。然而，实际上，用户并不需要掌握所有功能即可高效工作。在本课程中，您将学习在处理商业数据时，财务和会计用户最常用的关键函数。这些函数包括查找、替换、排序、筛选、汇总和分析数据。此外，您还将学习如何从其他Excel表格中根据特定行参数提取特定数据。 适合人群：本课程适合会计学生、金融学生、会计专业人士、金融专业人士、具备财务知识的企业家和商业拥有者，以及具备财务知识的投资者。 学习Excel在财务和会计中的重要性：本课程将改变您工作方式，节省您在复杂计算上花费的时间。您可以通过编写简短易懂的公式，计算分析和决策所需的值，从而将更多时间花在更重要的任务上。 先决条件：本课程假设您具备Excel、财务和会计的基本知识。具体要求包括：Excel的基本导航和单元格格式、基本数学运算（加、减、乘、除）；会计方面需了解折旧概念及其方法；财务方面需了解货币时间价值、现值与未来值概念、现值与未来值的转换、折现因子与年金的概念、净现值(NPV)的计算及内部收益率(IRR)的计算。 课程内容：使用Excel公式计算折旧、现值(FV)、净现值(NPV)和内部收益率(IRR)。 退款保证：无风险！如果您对课程不满意，可以享受30天退款保证。 教师介绍：注册会计师，拥有12年的工作经验和授课经验，曾担任外聘教师。作为持有英国ACCA资格的注册会计师，我在专业工作和教学方面有12年的经验，授课超过4000名学生，并在Udemy上教授80000+学生。我曾在多家机构实施会计软件和ERP系统，并在财务转型方面拥有专业知识。在过去的四个月中，我一直领导中小型企业的会计实践，并与企业家频繁互动，因此我清楚企业家在管理账务时需要掌握的知识。因此，Microsoft Excel是我工作中最常使用的软件，我热爱这个工具，因为它不仅让我们能够高效处理数据，而且简单易用。
Microsoft Excel has hundreds of functions and formulas to store, analyze, and alter data efficiently. However, no one really needs to know all of them to be able to work effectively on Excel.In this course, you will learn key functions that are required most used by Finance and Accounting users when they are working with their business data. These functions include finding, replacing, sorting, filtering, summarizing, and analyzing data. Additionally, you will also learn how to bring in a particular data against a specific row parameter from other excel sheets. Who should take this course:Accounting studentsFinance studentsAccounting professionals Finance professionalsEntrepreneurs and Business Owners with Finance knowledgeInvestors with Finance knowledge Why you should learn Excel for Finance and Accounting:This course will change the way you work and will save your hours otherwise spent on complex calculations. You will be able to calculate the values you need for analysis and decisions just by writing small and easy formulas. The rest of your time can then be spent on tasks that matter! Prerequisite: This course expects you to have basic knowledge of Excel, Finance, and Accounting. Let me be more precise on what you should know before starting this course. Excel:Basic navigation and cell formattingBasic maths functions like plus, minus, multiply and divide Accounting:Concept of depreciation and methods of depreciation Finance:Concept of Time Value of MoneyPresent Value and Future Value concept Conversion from present value to future value, and from future value to present value Concept of Discount factor and AnnuityConcept and calculation of NPVConcept of calculation of IRRTopics Covered:Calculation of depreciation with Excel formulasCalculation of PV and FV with Excel formulasCalculation of NPV with Excel formulasCalculation of IRR with Excel formulasMoney-Back Guarantee: Nothing to lose! If you will not be satisfied with the course, Udemy offers 30 days money-back guarantee! Introduction to the teacher:Chartered Accountant 12 years of work experience 12 years of teaching experience as visiting facultyI am a Certified Chartered Accountant (ACCA) from the UK with 12 years of professional work and teaching experience and have taught more than 4,000 students in class and 80,000+ students on Udemy! I have implemented accounting software and ERP at various organizations and have expertise in financial transformation. I have been leading accountancy practice for small and medium-sized entities for the last 4 months and have frequent interaction with entrepreneurs. So I know what exactly do entrepreneurs need to know to well manage their books. So, Microsoft Excel is what I use most of my day! I love this software, not just because it enables us to do a lot with data, but also because it is very simple and easy to use.
