|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-for-finance/
课程评论：没有评论
课程名称：Microsoft Excel for Finance 课程概述：您是否希望学习Excel，但发现面对众多技术术语和概念时感到困难？您是否希望简化生活，让Excel为您服务并节省时间？您在面试中因为Excel技能不足而未能通过吗？不用担心，我们为您准备好了。我们将从初学者的水平开始教您Excel（真的，我们将从Excel的基本概念开始），并一直教授到高级水平。本课程不要求您具备任何先验知识或技能。您将学习从基础知识开始的所有内容。 课程内容包括： 1. **Excel简介**：了解Excel的结构，包括工作表、单元格和选项卡，以及单元格引用的重要性。 2. **Excel运算符**：学习如何在Excel中编写函数，并使用各种运算符，例如逻辑运算符和条件运算符。 3. **Excel数据分析**：学习如何利用数据透视表、VlookUp创建各类图表和仪表板进行数据可视化。 4. **货币的时间价值**：深入探讨财务概念的时间价值，并在Excel中应用该概念。 5. **财务报表分析**：学习创建财务报表，并在Excel中构建三大财务模型。 授课教师：本课程的讲师曾是基金经理、股票研究分析师，并持有CFA证书，拥有丰富的基金管理经验，是Mentor Me Careers的首席培训师。拥有11年以上的基金管理、产品管理和创业经验，已培训3000多名优秀学生，并担任顶级MBA院校的客座教授。 课程收获： - 设计良好的内容，聚焦于概念解释和技能构建 - 大量练习题库和案例研究 - 可下载的课程材料 - 定期更新课程内容 - 快速解决疑问的论坛支持 课程收益：完成本课程后，您将能够： - 精通Excel以应对日常工作 - 制定个人财务计划 - 从财务报表中分析公司财务状况 - 构建三大财务模型并预测财务数据 关于课程：本课程提供30天退款保证，确保学生能够探索课程并做出明智选择。您将获得24小时不间断的疑问解答服务，所有概念均涵盖实际应用。我们始终将学生的学习体验放在首位，也欢迎任何改进学习体验的建议。
Are you looking to learn Excel, but finding it very difficult with all the technical jargons and concepts been thrown around?Are you looking to make your life easier and make Excel work for you and save time?Are you giving interviews but are not able to clear because of your Excel skills?Don't worry, we have got you covered here. We will teach you Excel right from beginners level, (Really, we will start right from what is Excel), and go on all the way till advance level.This course does not require you to have any pre-requisite knowledge or skills. This course will teach everything from beginning. This course has got you covered for everything.In this course, you will learn the following:Excel Introduction: Here you will learn how excel is structured. You will learn about Excel Worksheets, cells, and tabs. You will learn about Cell Referencing and its importance.Excel Operators: In this section, how to write a function in Excel and make use of different functions and operators, such as logical operators and conditional operators, which are available in Excel.Excel Data Analysis: Excel is widely used to analyse data and build models. Here you will learn how you can analyse data using Pivot, VlookUp and create various charts and dashboards for Data Visualization.Time Value of Money: Here we will delve into Finance concept of Time Value of Money. We will learn its importance and we will apply it in Excel.Financial Statement Analysis: Finally, in this section we will learn about Financial Statements, and we will create these financial statements and build a 3-statement Financial Model in Excel.Learn from the best:The Trainer of this course is an Ex-fund manager, Equity research analyst and CFA charter holder· Extensive experience with fund management in alternative investments· Lead Trainer at - Mentor Me Careers· Vast 11 Years of Experience in Fund Management, Product Management & Entrepreneurship.· Trained 3000+ students in premier institutions· Renowned Visiting Faculty in top tier 1 MBA colleges· Ex-Partner- Ennovate Research Investment and Capital, Hedge FundWhat do you get:· Well-designed focussed content on explaining concepts and building skills· Extensive question bank and case studies for practice· Downloadable course materials· Regular course updates· Forum doubt-solving answers quicklyAfter this course, you will be able to:· Master Microsoft Excel for daily work· Make your own personal Financial Plan· Analyse Finances of a company from their Financial Statements· Build 3 statements Financial Model and forecast valuesAbout this Course· This course has 30-day Money Back guarantee. We believe in providing value to the student. So, you get to explore the course and make an informed choice.· You will get 24x7 doubt solving access.· All concepts covered with practical applicationWe always strive to put student's learning experience over everything else. So, we do look-out for your feedback on how we can improve our course and give our students a better learning experience. So, any suggestions for improving the learning experience is always welcomed.
