|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/beyondformulas-excel-modeling-for-analysts/
课程评论：没有评论
课程名称：超越公式：完整的 MS Excel 技巧与建模 课程简介：本课程旨在教授您所有重要的 Excel 技能，涵盖模型结构、数据处理、智能查找、聚合与基本统计、表格、数据透视表、图表、VBA 宏和自定义公式等多种内容。与其他培训课程不同的是，本课程将教您如何将这些工具结合使用，以解决实际问题，帮助您在任何分析环境中脱颖而出。 学习后，您可以立即应用所学知识：课程采用小模块逐步进行，您可以一次学会一项技能，并将其整合成一个完整的模型输出。所有技巧和小窍门均来自一年以上的研究和十年的行业经验。我们还将教您如何“向上管理”，以便您作为模型师，不必通宵达旦工作。课程采用案例研究的方法，让您能够在真实问题上进行实践。本课程将提供所有入门材料，让您能够快速上手。重点关注整体模型设计，确保您的模型能够轻松扩展、适应和演变。此外，课程还包括一个用 Excel 编写的键盘快捷键游戏，让您能够快速掌握 Excel 操作。 通过本课程，您将获得全面的 Excel 技巧，成为数据分析领域的专家。
*** This training teaches you:1) All of the crucial excel techniques you should care about: including model structure, data handling, smart lookups, aggregation & basic statistics, tables, pivot tables, charts, VBA macros & custom formulas, and many more.2) Unlike other training, I'll teach you how to combine these tools to solve real world problems, and help you stand out in any analytical environment. *** Learn, then immediately apply your new knowledge: Bite-sized and Step-by-step curriculum, so you can learn one skill at a time, combine it all into a single beautiful model output.The only Excel techniques and tips you'll ever need, from over a year of research, and ten years of experience.Learn to "manage upwards" so that you, the Modeler, don't work all night.Hands-on case study approach, to practice what you learn on a real problem. All starter materials provided for each course so you can get started quickly.Holistic model design focus, so that your models to scale, adapt and evolve easily.Keyboard shortcut game, coded in Excel, so you can get around Excel lightning fast.
