|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-complete-excel-crash-course-for-data-analysis/
课程评论：没有评论
课程名称：精通Excel分析：BCG顾问的秘密 课程概述：你想在团队中成为公认的“超级明星分析师”吗？希望快速提供分析和见解，但对各种公式感到不知所措？还在凌乱的Excel工作簿中缓慢点击？精通Excel是一项前期投资，它将在你整个职业生涯中为你节省数千小时的时间。这是我曾经做过的最佳个人投资之一，而在BCG顾问和亚马逊产品经理的经历中更是得到了提升。我希望将我的关键学习传授给你。顾问、商业分析师、数据分析师和商业智能工程师都以快速提供美观、动态和结构化的分析而自豪。如果你在这个领域工作，掌握Excel是必不可少的。 经过这个速成课程后，你将准确知道如何做到这一点。我们将通过示例讲解所有超级分析师需要了解的重要公式，以及一些鲜为人知的快捷方式，让你比其他人更快完成任务。 课程结束时，你将能够： - 精通Excel中所有重要的公式，而不会被不重要的细节所淹没 - 理解咨询和科技商业分析中使用的最佳实践 - 知道何时以及如何使用每个公式，让你的工作簿不仅准确，而且美观且富有洞察力 注意：本课程不包括VBA、统计分析或与其他程序（例如Python、SQL）的数据链接。
Do you want to become known as the 'Superstar Analyst' on your team? Want to deliver rapid analysis and insights, but unsure where to start with the various formulas? Still slowly clicking around in messy Excel workbooks? Excel mastery is an upfront investment that will save you thousands of hours throughout your career. This was one of the best personal investments I ever made which was further honed as a BCG consultant and Amazon PM. I would like to pass on my key learnings.Consultants, Business Analysts, Data Analysts, and Business Intelligence Engineers pride themselves on rapidly delivering beautiful, dynamic, and structured analysis. If you work in this field, mastering Excel is essential.After this crash course, you will know exactly how to do that. We will walk through examples of all the important formulas a superstar analyst needs to know, and the little-known shortcuts to do it faster than anyone else.By the end of this course, you will:Master all the important formulas in Excel that matter, without getting overwhelmed by less important detailsKnow the best-practices used in consulting and tech business analysis Understand when and how to use each formula - you will shine in delivering workbooks that are beautiful and insightful, not just correctNote: This course does not include VBA, Statistical Analysis, or data links to other programs (e.g., Python, SQL)
