|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learning-microsoft-excel-introduction-to-mastery/
课程评论：没有评论
课程名称：Excel中的函数、数据分析、演示与金融 课程概述：本课程教授Microsoft Excel、Power Pivot和Power BI，从基础知识入手，逐步深入到VBA编程。Excel是一个功能强大的工具，可以用来理解、分析和展示数据。它可以用于构建金融模型、进行数据科学分析等，是一个融合分析与演示的全能工具（通过数据透视表和数据模型实现）。课程内容涵盖按钮、图表、数据验证和条件格式等功能，以及所有常规函数。我们将从基础开始，详细回顾每个工具。课程结构包括许多实践例子，学生可以通过PDF文档或视频进行跟随学习。课程以“多练习”的方式为主线，每个部分都有视频和文字说明，以提升学生的技能。课程开始时有大约12个不同的“作业”部分，接下来进入大学水平的教学，之后有两个部分提供整合练习，通过“工作表”和“每日一课”的结构进行巩固。课程还讨论了如Monte Carlo在各种定价模型中的应用等主题，特别强调金融模型，因为业务应用在Excel中至关重要。此外，还有许多章节讲解VBA（视觉基础应用程序），以增强学生的理解并发展更高级的方法。
This course teaches Microsoft Excel, Power Pivot and Power BI. It starts from the beginning and goes all the way through to (and including) VBA. Excel is an extremely powerful tool, one which we will see can be used to understand, analyze, and present data. It can be used to build financial models, do data analysis via data science, and much more. It is an all-encompassing tool that blends analysis with presentation (using pivot tables and the data model). We will go through buttons, charts, data validation and conditional formatting, as well as all the regular functions. We cover every tool in Excel, starting from the basics, and review each many times. The general structure of the course includes many practice examples that allow a student to either follow along with a PDF or to follow along with a video. The concepts are put together to show full ideas, giving students the chance to integrate various different meta-analysis tools to build models and explore data.It is based on a well-worn approach of practice, practice, and more practice. Each section has videos and written instructions to hone students' skills. The beginning of the course includes about twelve different "homework" sections, then the course goes on to a college level instruction, followed by two sections that give consolidated practice via "worksheets" and "a lesson a day" type structure. After this, various topic are discussed such as Monte Carlo as used in various pricing models, etc. There is particular focus on financial models since business applications are very important in Excel. There are also many sections that work through VBA - visual basic for applications to enhance the students understanding and develop further advanced methods.
