|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-2016-for-mac-3-pivot-tables-intro-masterclass/
课程评论：没有评论
**Coursera 课程总结：Excel for Mac 3: 数据透视表入门与精通** 本课程旨在帮助Mac版Microsoft Excel用户掌握数据透视表这一功能强大但听起来令人望而却步的工具。课程强调，数据透视表尽管听起来复杂，但只需几个点击即可完成。 **课程亮点：** * **快速入门：** 课程将在几分钟内展示如何创建第一个数据透视表，并添加相关的图表，让你迅速超越不了解此功能的用户。 * **深入讲解：** 课程将详细介绍数据透视表的设置，包括数据准备以及可用的各种选项。 * **高级技巧：** 探索大多数用户未曾了解但极其实用的高级功能，包括： * 条件格式 * 切片器和时间线，用于创建仪表板 * 高级计算，如“总计百分比”、“累计总计”以及“计算字段和计算项” * **数据透视表与图表结合：** 学习数据透视表与其相关图表（Pivot Charts）之间的联系。 * **专家级掌握：** 课程结束后，学员将成为数据透视表的专家，能够快速创建可靠、可深入分析的数据报表，并能协助他人进行数据分析。 **重要提示：** 本课程未获得Microsoft的官方认可、赞助或支持。
This course covers one of the most useful, but scariest-sounding, functions in Microsoft Excel; PIVOT TABLES.Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.It sounds difficult, but in fact can be done in just a few clicks. We'll do our first one in a couple of minutes - that's all it takes. We'll also add a chart as well in that time.After only these first few minutes, you will be streets ahead of anyone who doesn't know anything about Pivot Tables - it is really that important.After this introduction, we'll go into some detail into how to set up your Pivot Table - the initial data, and the various options that are available to you. We will go into advanced options that most people don't even know about, but which are very useful. This includes using conditional formatting, adding slicers and timelines so that you can create dashboards, and advanced calculations, such as Percentage of total, Cumulative totals, and calculated fields and items. We'll also have a look at Pivot Charts and their relationship to Pivot Tables.By the end, you will be an Expert user of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly, and you'll be able to help others with their data analysis.
