|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-for-financial-analysts/
课程评论：没有评论
课程名称：微软Excel对于公司财务分析师 课程概述：本课程旨在帮助学员从Excel初学者成长为高手，掌握必要的公式、最佳实践和建模技术。课程将逐步讲解每一个知识点，并在最后整合所学，构建一个动态模型，以分析在不同财务场景下的销售表现。学习本课程所获得的技能能够直接应用于职场，具有很强的实用性，学员可立即在工作中应用所学知识。 本课程特别适合大学生，希望提升Excel技能以争取第一份财务分析师工作或实习的学生，以及希望提升Excel技能、在职场中脱颖而出的初级财务分析师。 课程内容包括： - 提高工作效率：学习使用快捷键以提高生产力的重要性。 - Excel基本操作：有效导航Excel，锁定单元格引用，创建数据透视表等。 - 格式化最佳实践：适当的格式化对于构建受信任的分析至关重要；学习如何使Excel表格看起来专业、美观。 - 核心Excel公式：掌握核心公式，尽管Excel中公式众多，但掌握这一部分就能提升为高手。 - 文本函数：学习如何清理 messy 数据，通过多个列的值组合、从较长的文本字符串中提取单词等。 - 财务分析师必备计算：理解如何计算加权平均值、同比增长率和复合年增长率，这些是财务分析师必须熟练掌握的关键计算。 - 构建动态模型：将上述公式和技能结合，利用简单的销售数据CSV文件构建动态模型，允许用户进行情景分析，这将使你在同行中脱颖而出。
Learn the essential formulas, best practices, and modeling techniques that will take you from Microsoft Excel novice to power-user. We'll break everything down step-by-step, then put all the pieces together at the end to build a dynamic model to analyze sales performance under various financial scenarios. The skills learned in this course will translate directly to the workplace; this course is practical, and students can immediately apply their knowledge on the job.This course is best suited for either college students looking to bolster their Excel skills and land their first financial analyst job / internship, or early career corporate financial analysts who want to take their Excel skills to the next level to stand out among their peers and get promoted.What we'll cover:· Improving Productivity: Learn the importance of using keyboard shortcuts to boost productivity.· Basic Excel Operations: Learn how to navigate through Excel efficiently, lock cell references, create pivot tables, and more.· Formatting Best Practices: Proper formatting is key to building credible analyses that leadership will trust; learn how to make your Excel tables look polished and presentable.· The Core Excel Formulas: Excel can feel overwhelming due to the sheer number of formulas, but by mastering just this portion of the formulas you can become a power-user.· Text Functions: Learn to clean messy data by combining values in multiple columns, extracting single words from larger strings of text, and more.· Essential Calculations for Corporate Financial Analysts: Understand how to calculate weighted averages, year-over-year growth rates, and compound annual growth rates, three key calculations for any financial analyst to be comfortable with.· Building a Dynamic Model: Combine the formulas and skills above to take a simple CSV file with sales data and turn it into a dynamic model that allows users to perform scenario analysis, a skill that will make you stand out among your peers.
