|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-financial-modeling-analysis-planning-reporting/
课程评论：没有评论
课程名称：通过9个案例研究成为Excel专家与财务分析师 课程概述：你是否是那7.5亿使用Excel来完成任务的一员？无论你是学生还是职场新手，Excel很可能会成为你在工作中最常用的应用程序。本课程专为各个水平的现有和潜在Excel用户设计，基于经过验证的案例研究方法，解决与数据分析、Excel建模及财务规划与分析相关的实际问题或常见任务。在解决这些案例研究的过程中，你将学习大量的Excel函数和技巧，并掌握将它们应用于各种实际任务的能力。课程的目标是完成任务，而不是单纯学习Excel函数，函数只是帮助我们完成工作的工具，而非最终目标。 通过本课程，你可以期待达到以下成果： - 成为你所在组织的Excel高手 - 创建多个场景进行敏感性分析 - 将原始数据转换为分析报告 - 学习Excel的高级功能 - 提高工作效率，更快速地进行财务建模与分析 - 学习行业最佳实践，搭建财务模型 - 学习复杂的Excel公式和强大的Excel函数 - 自动化报告 - 向拥有多行业经验的财务专家学习最佳技巧 - 学习多种解决问题的方法 - 学习各种Excel快捷键，提高工作效率 本课程的讲师在财务建模方面拥有丰富的经验，经过17年的职场学习，提炼出本课程的精华。课程分为以下几个部分，每个部分基于一个案例研究，在其中你需要解决一个问题或完成一个任务。 课程部分： 案例研究1 - 处理文本的技巧 案例研究2 - 数据库管理艺术 案例研究3 - 简化数据整合 案例研究4 - 超前分析 案例研究5 - 提升团队绩效的简单技巧 案例研究6 - 动态展示成果 案例研究7 - 敏感性分析 案例研究8 - 保密工作技巧 案例研究9 - 待办事项清单 本课程将使你在职业生涯中脱颖而出，加速进步。抓住这个转折点，加入我们吧！
Are you among the 750 million people out there who use excel to carry out their tasks? Even if you are a student and have not been exposed completely to excel, sooner or later, excel is most likely to be your most utilized business application at work. This course if designed for existing and prospective excel users at all proficiency levels. Entire course is based on proven case studies approach to solve real life problems or complete common tasks related to data analysis, excel modeling and financial planning and analysis. While solving these case studies, you will learn loads of excel functions and techniques and above all the ability to apply them in a variety of real life tasks. Learn to achieve the goal (complete the task) instead of learning an excel function. Excel functions are only tools at our disposal to help us through our work, they are not the goals!You may expect the following to achieve through this course:Become an Excel Guru in your organizationCreate multiple scenarios to carry out sensitivity analysisTransform raw data into analytical reportsLearn advanced features of ExcelBecome agile at your work - Carry out financial modeling and analysis tasks faster than beforeLearn industry best practices related to excel modelingBuild financial model from scratchLearn complex excel formulasLearn most powerful excel functionsAutomate reportingLearn best techniques from financial expert with multi-industry experienceLearn to solve the problems in various different waysLearn various excel keyboard shortcuts to increase your speed at workThe instructor for this course has vast experience in excel financial modeling gained through working in various sectors and geographies. The crux of 17 years of on-job learning has been summarized in this courseThe course is divided into following sections. Each section is based on a case study where you have to solve a problem or complete a task.SectionsCase Study 01 - TextophobiaLearn the techniques to deal with texts in ExcelCase Study 02 - Crack the databaseMaster the art of dealing with information to carryout insightful analysisCase Study 03 - Consolidation made easySimplest way to consolidate similar data sets and rearrange them the way you likeCase Study 04 - Ahead of GameUse what-if analysis to stay ahead of gameCase Study 05 - Be like a Boss!Simple but very powerful techniques to drive the performance of teamsCase Study 06 - AutomantiaLearn how to showcase your hard work by presenting in an interactive mannerCase Study 07 - I am sensitiveScenario analysisCase Study 08 - TOP SECRETHow to keep your secret work safe from spying eyesCase Study 09 - To Do ListThis course will enable you to stand out and progress faster in your career. This might be the turning point - go for it!
