|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/advanced-excel
课程评论：没有评论
课程名称：使用高级Excel进行数据可视化 课程概述：在本课程中，学员将获得有关高级Excel 2013功能的实践指导。您将学习使用PowerPivot构建数据库和数据模型。课程内容包括不同类型的情景分析和模拟分析，学员将有机会通过利用Excel的一些内置工具（如求解器、数据表、情景管理器和目标寻求）来实践这些技能。在课程的后半部分，将重点讲解如何可视化数据、讲述故事并探索数据，复习数据可视化和仪表盘的核心原则。您将使用Excel构建复杂图表和Power View报告，并将它们合成为动态仪表盘。 注意：学习者需要PowerPivot以完成某些练习。请使用MS Excel 2013版本，如果您拥有其他MS Excel版本或MAC，可能无法完成所有作业。 课程大纲： 1. **准备专业Excel** - 内容：在第一周，您将学习数据模型和数据库的开发。将涵盖数据集的组成部分、关系数据库模型、数据库键、关系和连接。此外，我们将介绍名为PowerPivot的工具，该工具用于导入和准备数据以构建关系模型以及可视化数据。到周末，您将掌握如何开发数据模型的基本知识。 2. **高级情景分析** - 内容：在这一周，我们将探索三种不同的分析方法，用于帮助模型不同的情景并应对变量的不确定性。这些方法包括情景分析、敏感性分析和模拟。我们将详细讨论每一种方法的目的和用法，并在引导演示之后，您将有机会在Excel工作簿中练习并证明您的学习成果。 3. **数据可视化** - 内容：本周重点关注数据可视化，讨论数据可视化的基础知识，概述其理论和概念。同时，探讨如何通过正确选择、创建和展示表格和图表来实现有效的故事讲述。您将学习如何创建详细的图形和图表，来有效地讲述数据背后的故事。 4. **仪表盘制作** - 内容：在本课程的最后一周，您将学习如何创建动态仪表盘。我们将讨论如何建立对受众的深入理解，并收集关键需求，以确定构建何种类型的仪表盘。将讨论一些设计原则和在构建仪表盘时需要考虑的事项。您将有机会通过自己在Excel中创建功能性仪表盘来实践本周所学的所有内容。
Name:Preparing a Professional Excel
Description:During this first week, you are going to learn about the development of data models and databases. We will cover the components of data sets and the relational database models, database keys, relationships, and joins. We will also look at a tool called PowerPivot that is used to import and prepare data to build relational models, as well as visualize data. By the end of the week, you will have a working knowledge of how to develop a data model. Be sure to complete lessons in the order in which they are sequenced in the course.
Name:Advanced Scenario Analysis
Description:This week, we are going to explore three different analytical methods used to help model different scenarios and deal with variable uncertainty. These methods are scenario analysis, sensitivity analysis and simulation. We’ll look at what each method is and then go deeper into why and how you use each. Following some guided demonstration, you’ll be given a chance to practice in an Excel workbook and demonstrate what you’ve learned.
Name:Data Visualization
Description:This week we are going to focus on data visualization. We will start off by discussing data visualization basics, outlining the theory and concepts behind data visualization. We will also discuss how to enable effective story telling through the correct selection, creation, and presentation of tables and charts. You’ll get a chance to learn how to create detailed graphs and charts to effectively tell a story about your data.
Name:Dashboarding
Description:In the final week of this course, you are going to learn how to create a dynamic dashboard. We are going to discuss how to establish a good understanding of your audience and how to collect key requirements in order to determine what type of dashboard to build. We will talk about some guiding design principles and things to consider when building a dashboard. You’ll have a chance to practice everything you learn this week by creating your own functional dashboard in Excel.
In this course, you will get hands-on instruction of advanced Excel 2013 functions. You’ll learn to use PowerPivot to build databases and data models. We’ll show you how to perform different types of scenario and simulation analysis and you’ll have an opportunity to practice these skills by leveraging some of Excel's built in tools including, solver, data tables, scenario manager and goal seek. In the second half of the course, will cover how to visualize data, tell a story and explore data by reviewing core principles of data visualization and dashboarding. You’ll use Excel to build complex graphs and Power View reports and then start to combine them into dynamic dashboards. Note: Learners will need PowerPivot to complete some of the exercises. Please use MS Excel 2013 version. If you have other MS Excel versions or a MAC you might not be able to complete all assignments. This course was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.
