|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-financial-modelling-in-ms-excel/
课程评论：没有评论
课程名称：MS Excel中的财务建模 课程概述： 财务建模是会计与金融专业人士必备的重要技能，在就业市场上需求量大，雇主也对此高度重视。本课程为期16小时，通过实践练习将学员从基础提升至专业水平。课程内容40%专注于提高学员的MS Excel技能，60%则侧重于在会计和金融领域的应用。 详细内容包括： 1. Excel基础介绍 2. Excel工作中的实用技巧与工具 3. Excel快捷键 4. Excel关键功能与功能简化 5. 更新内容：SUMIFS 6. Excel中的财务函数 7. Excel的数据透视表 8. 完整利润表构建案例 9. Excel图表介绍 10. 利润和损失案例 11. 财务状况表案例 12. 现金流量表案例 13. 财务建模基础 14. 公司估值和并购介绍 15. 学习如何在Excel中构建贴现现金流模型（NPV和IRR） 16. 投资评估案例 17. 商业估值案例 18. 资本预算理论 19. 资本预算案例 20. 利率和汇率对净现值的影响 21. 资本预算中的敏感性分析 先决条件： 1. 参与者需具备一年以上的Excel使用经验。 2. 需掌握基本的财务会计知识。 3. 计算机上需安装Microsoft Office 2013或更高版本。 讲师介绍： 讲师是一位合格的会计与金融专业人士，拥有超过二十年的丰富经验，工作领域涉及审计、大规模制造及石油和天然气等多种行业。讲师曾担任跨国公司石油和天然气行业的CFO，并在2011至2018年间担任世界银行和欧盟的咨询顾问，主要涉及IFRS和财务管理项目。讲师持有MBA、ACCA和CIMA等三项专业资格，教授IFRS、财务报告、财务管理和绩效管理超过十五年，专注于ACCA和CIMA资格的教学。
Course OverviewFinancial Modelling is an essential skill for accounting and finance professional. It is very much in demand in the job market and is highly valued by employers.Our Financial Modelling training takes you from basics to professional level. This sixteen-hour training is based on practical exercises. The course focuses 40% on honing the participants MS Excel skills and 60% focus on application of MS Excel in Accounting and Finance.Detailed Content1. Introduction to Excel2. Useful tips and tools for your work in Excel3. Keyboard shortcuts in Excel4. Excel's key functions and functionalities made easy5. Update! SUMIFS6. Financial functions in Excel7. Microsoft Excel's Pivot Tables8. Building a complete P & L in Excel - Case Study9. Introduction to Excel charts10. Profit and Loss - Case Study11. Statement of Financial Position - Case Study12. Statement of Cash Flows - Case Study13. Financial modeling fundamentals14. Introduction to Company Valuation and Introduction to Mergers & Acquisitions15. Learn how to build a Discounted Cash Flow model in Excel - NPV and IRR16. Investment Appraisal - Case Study17. Business Valuation - Case Study18. Capital Budgeting - The theory19. Capital Budgeting - Case Study20. Impact of interest rates and exchange rates on NPV21. Sensitivity Analysis in Capital BudgetingPrerequisites1. Participants are expected to have basic knowledge of MS Excel. This could be measured as an MS Excel user for more than one year.2. Basic knowledge of financial accounting. 3. Microsoft Office 2013 or later installed on your computer.About the InstructorA qualified accounting and finance professional with over twenty years of extensive experience in diversified industry sectors such as auditing, large scale manufacturing and oil and gas.Like most accounting and finance professionals, I started my career as finance executive and then over the years rose to the position of CFO in a multinational company in oil and gas industry.I have also worked as a consultant with the World Bank and European Union on different projects in Middle East, Eastern Europe and CIS countries during 2011 to 2018 as a principal consultant for IFRS and Financial Management.I am qualified professional with three professional qualifications MBA, ACCA and CIMA UK. I have been teaching IFRS, Financial Reporting, Financial Management and Performance Management for over fifteen years and my focus areas are ACCA and CIMA qualifications.
