|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-modelling-in-excel-masterclass-excel-formulas/
课程评论：没有评论
课程名称：Excel建模大师班：Excel公式 课程概述：Excel建模的艺术与科学是一门深入探讨如何规划、设计和维护卓越Excel模型的课程。该课程特别适合咨询师、金融分析师、审计员、会计师、经理和寻求深入理解数据建模“艺术与科学”的技术专业人士，以帮助他们做出更好的商业决策。课程伊始，我们将从更宏观、哲学的角度探讨电子表格设计原则，旨在激发学员的批判性思维能力和在竞争日益激烈的就业市场中的自信心。在基于“现实世界”的案例研究中，我们将探索解决商业、金融和会计领域常见问题的创造性解决方案。同时，我们也会提供对数据量不断增加所带来的新挑战的实际指导，这些“庞大”数据正在“推动”Excel的自然处理能力。 该课程专为中级到高级Excel用户及寻求与“Excel专业人士”建立更好合作关系的技术专业人士设计。要顺利完成此课程，建议学员具备扎实的电子表格环境基础知识，尤其是公式构建及结构化引用（正确使用‘$’符号）的概念将尤为有帮助。讲师Szilvia Juhasz是一位Excel图书作者，同时也是Excel TV的常驻共同主持人。
The Art Science of Excel Modeling is an in-depth exploration of how to plan, design, and maintain superior Excel models. Ideal for consultants, financial analysts, auditors, accountants, managers, and technical professionals seeking to gain a deeper understanding of the "art-science" of data modeling and how it can lead to improved business decisions.Kicking off with a bigger-picture, more philosophical view of spreadsheet design principles, our aim is to inspire critical thinking skills and confidence in an increasingly competitive job market. In our "real world based" case studies, we will explore creative solutions to routine business problems in the business, finance, and accounting world. We will also offer practical guidance for newer challenges arising from the ever-increasing volumes of "big" data that seem to be "pushing the boundaries" that Excel is naturally equipped to handle.Designed with the intermediate to advanced level Excel user in mind, as well as technical professionals seeking to build better alliances with "the Excel people." To keep up during this course, we recommend you have a very solid understanding of the basics of the spreadsheet environment. Formula construction and concepts, in particular structured referencing (proper use of the ‘$' signs) is also extremely helpful.The instructor, Szilvia Juhasz, is an Excel book author and a frequent co-host at Excel TV.
