|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/financial-modelling-in-ms-excel/
课程评论：没有评论
课程名称：Excel中的财务建模 课程概述：财务建模是会计和金融专业人士的一项重要技能，市场需求大，受到雇主高度重视。本课程为期16小时，通过实际练习帮助学员从基础提升到专业水平。课程内容中，40%专注于提升学员的Excel技能，60%则强调Excel在会计和金融中的应用。 学习内容： 1. 学习Excel的多种高级功能 2. 成为团队中熟练的Excel用户 3. 更高效地完成日常任务 4. 构建利润表、财务状况表和现金流量表 5. 从零开始构建估值模型 6. 从零开始构建净现值模型 7. 学习制作整洁专业的图表和图形 详细内容： 1. Excel简介 2. Excel工作的实用技巧与工具 3. Excel的快捷键 4. 轻松掌握Excel的关键功能和特性 5. SUMIFS 更新 - 练习 6. Excel中的财务函数 7. Excel的数据透视表 8. 案例研究：在Excel中构建完整的利润表 9. Excel图表简介 10. 利润表案例研究继续 - 制作专业美观的图表 11. 财务建模基础 12. 公司估值与并购简介 13. 学习如何在Excel中构建折现现金流模型 14. 商业估值：完整实践练习 15. 资本预算：理论部分 16. 资本预算：完整案例研究 17. 利率和汇率对净现值的影响 18. 资本预算中的敏感性分析 先决条件： 1. 预期学员有基本的Excel知识，使用时间超过一年为宜。 2. 有基本的财务会计知识。 3. 电脑上需安装Microsoft Office 2013或更高版本。 讲师介绍： 本课程讲师是一位合格的会计和金融专业人士，拥有超过20年的丰富经验，涵盖审计、大型制造和油气等多个行业。讲师的职业生涯始于财务执行，后来在一家跨国公司任首席财务官。此外，讲师曾为世界银行和欧盟在中东、东欧和独联体国家的多个项目提供咨询，专注于国际财务报告准则及财务管理。讲师拥有MBA、ACCA和CIMA等三项专业资格，并在ACCA和CIMA资格认证教学方面有超过15年的经验。
OverviewFinancial modelling is an essential skill for accounting and finance rofessionals. 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 exercisesThe course focuses 40% on honing the participants MS Excel skills and 60% on application of MS Excel in Accounting and FinanceWhat You Will Learn1. Learn many of MS Excel's advanced features2. Become proficient user of Excel within your team3. Carry out regular tasks faster than ever before4. Build Profit and Loss, Statement of Financial Position and Cash Flow statements5. Build valuation models from scratch6. Build Net Present Value model from scratch7. Learn how to make neat and professional-looking charts and graphsDetailed 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! SUMIFS - Exercise6. Financial functions in Excel7. Microsoft Excel's Pivot Tables8. Case study: Building a complete P & L in Excel9. Introduction to Excel charts10. Profit and Loss Case Study continued-with great-looking professional charts11. Financial modeling fundamentals12. Introduction to Company Valuation and Introduction to Mergers & Acquisitions13. Learn how to build a Discounted Cash Flow model in Excel14. Business Valuation: Complete practical exercise15. Capital Budgeting: The theory16. Capital Budgeting: A Complete Case study17. Impact of interest rates and exchange rates on NPV18. Sensitivity Analysis in Capital BudgetingPre-Requisites1. We expect participants to have a basic understanding of MS Excel. One could measure this by considering someone who has been using MS Excel for more than a 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.
